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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

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   897 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, 1391 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)