I am doing a install of silverstripe on ubuntu server and get the following error:

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/cbis/sapphire/core/model/Database.php on line 397

Has anyone a clue. this happens after the installer has successfully already created 13 other tables.

I added a debug_print_backtrace() and the result are in the attached file.

Looking at the code in SilverStripe, The problem seems to be that the UserDefinedForm class does not seem to be adding the fields defined in the base classes, specifically from the SiteTree class.

It looks like the function getCMSfields($cms) should build the $fields static variable with the fields from the parent classes. Maybe this is not happening.

I will need to do more debugging. but this problem seems systemic to breaking the entire database model and I can't understand how any thing works.

I am running
ubuntu server version: Ubuntu 6.06.1 LTS
php 5.1.2
MySql: 5.0.22
Apache: 2.0.55

I had very weird problems with creating the database-structure trying to upgrade to the latest SS version with PHP version 5.1.2.

So if you can , try upgrading PHP to 5.2.

That error was with version 2.2