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