Jump to:

22977 Posts in 11806 Topics by 2826 members

General Questions

SilverStripe Forums » General Questions » Trouble unnecessary updating a table

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

Page: 1
Go to End
Author Topic: 377 Views
  • Ronaldo71
    Avatar
    Community Member
    9 Posts

    Trouble unnecessary updating a table Link to this post

    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
    Avatar
    Forum Moderator
    1037 Posts

    Re: Trouble unnecessary updating a table Link to this post

    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)

    377 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.