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, biapar, Willr, Ingo, simon_w

DATABASE ERROR on install


Reply


751 Views

Avatar
jussi

Community Member, 1 Post

8 December 2007 at 1:16am

I am trying to make a fresh 2.2.0 install but I get the error you can find at the bottom of this post. My system is as follows:

Ubuntu 6.06 Kernel 2.6.15-29-386
Apache 2.0.55
PHP 5.1.2
MySQL Server 5.0.22

Trying to install with the php installer. All requirements check OK. The installer creates a database SS_mysite with 13 tables that do not have data (Email_BlackList ... ... SiteTree_versions).

Thanks for your help.

----------------

Installing SilverStripe...

I am now running through the installation steps (this should take about 30 seconds)

If you receive a fatal error, refresh this page to continue the installation
# Creating 'mysite/_config.php'...
# Creating '.htaccess' file...
# Building database schema...

Fatal error: DATABASE ERROR: Couldn't run query: CREATE TABLE `UserDefinedForm` ( ID int(11) not null auto_increment, `EmailTo` varchar(50) character set utf8 collate utf8_general_ci, `EmailOnSubmit` tinyint(1) unsigned not null default '0', `SubmitButtonText` varchar(50) character set utf8 collate utf8_general_ci, `OnCompleteMessage` mediumtext character set utf8 collate utf8_general_ci, fulltext `SearchFields` (Title,MenuTitle,Content,MetaTitle,MetaDescription,MetaKeywords), fulltext `TitleSearchFields` (Title), primary key (ID) ) TYPE=MyISAM | Key column 'Title' doesn't exist in table in /var/www/silverstripe/sapphire/core/model/Database.php on line 397