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.

Archive /

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

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

Persistent database error

Go to End



Community Member, 10 Posts

27 February 2008 at 1:28am


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?