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

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

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

2 Posts 1359 Views

Ronaldo71

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?

TIA,
Ronald

martimiz

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)

Return to top