Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Trouble unnecessary updating a table

Go to End

2 Posts   869 Views


Community Member, 10 Posts

13 April 2012 at 3:15am

Hi all,

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?



Forum Moderator, 1379 Posts

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)