Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Persistent database error

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1
Go to End
Author Topic: 854 Views
  • bo
    Avatar
    Community Member
    10 Posts

    Persistent database error Link to this post

    Hello,

    I ran into problems (somewhat specified below) and created a new silverstripe directory to start from scratch. The older directory (renamed "silverstripe1") still exists, i.e. there is a "C:\www\silverstripe" folder and a "C:\www\silverstripe1" folder. The following message occurs when running installation:

    Fatal error: DATABASE ERROR: Couldn't run query: ALTER TABLE `SiteTree` CHANGE `ClassName` `ClassName` enum('SiteTree','Page','UserDefinedForm','SubscribeForm','ErrorPage','GhostPage','RedirectorPage','VirtualPage') character set utf8 collate utf8_general_ci default 'SiteTree' | Data truncated for column 'ClassName' at row 22 in C:\www\silverstripe\sapphire\core\model\Database.php on line 397

    The background is this: a similar message (basically the same, only there were additional pages) was displayed at mysite/db/build?flush=1, and undoing changes I had made before it occurred (or at least before I noticed it) didn't do anything to remove it. In my newbie despair I saw no other solution than to start over, but it appears to have been no solution at all–the error haunts me.

    Might this be a problem with MySQL?

    854 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.