23455 Posts in 18904 Topics by 2877 members
|Go to End|
13 April 2012 at 3:15am
I'm having trouble with a table that wants to be updated, even though it's not necessary when using the \dev\build command.
[User Error] Couldn't run query: ALTER TABLE "NivoSliderPage" CHANGE "captionOpacity" "captionOpacity" decimal(2,1) not null default 0,8 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '8' at line 1
The nivo slider already has a column captionOpacity with the type decimal(2.1), can't be null and it already has a default of 0.8.
I'm using SS 2.4.6 and MySql 5.1.57-community on Microsoft-IIS/7.5
MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $
When I renamed the table trying to re-create it, it gave the same sort of error.
Could there be an error in the automatic update system?
15 April 2012 at 4:04am
Besides the question if it should try to change the field all the time (some fields, like enums, seem to behave that way), I think the error might lay in the default value 1,8 - maybe try 1.8 instead (comma -> dot)
|Go to Top|