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


Reply


2 Posts   490 Views

Avatar
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

Avatar
martimiz

Forum Moderator, 1107 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)