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, biapar, Willr, Ingo, swaiba, simon_w

Trouble unnecessary updating a table


2 Posts   458 Views


13 April 2012 at 3:15am Community Member, 10 Posts

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?



15 April 2012 at 4:04am Forum Moderator, 1095 Posts

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)