Problem in Installing Silverstripe CMS..,

In the Windows, Mysql, XAMP (php5,mysql5) ... i am trying to install the Silverstripe .. but it gives me the following error, everything is ok (in the front page of install .php page)...
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 'tutorial/_config.php'...
Creating '.htaccess' file...
Building database schema...
Fatal error: DATABASE ERROR: Couldn't run query: CREATE TABLE `Page` ( ID int(11) not null auto_increment, `ParentID` int(11) not null default '0', index `ParentID` (ParentID), 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 D:\Program Files\xampp\htdocs\silverstripe\sapphire\core\model\Database.php on line 397

Open in new window

LVL 36
Loganathan NatarajanLAMP DeveloperAsked:
Who is Participating?
 
Beverley PortlockConnect With a Mentor Commented:
You could try adding the fields like that shown below and just set them to varchar 255, but I would try installing the previous version (2.1) if it is still available and see how that goes, particularly if you try the fix below and it turns out that other tables have this problem.


CREATE TABLE `Page` (
ID int( 11 ) NOT NULL AUTO_INCREMENT ,
`ParentID` int( 11 ) NOT NULL default '0',
Title varchar(255) NOT NULL,
MenuTitle varchar(255) NOT NULL,
Content varchar(255) NOT NULL,
MetaTitle varchar(255) NOT NULL,
MetaDescription varchar(255) NOT NULL,
MetaKeywords varchar(255) NOT NULL,
INDEX `ParentID` ( ParentID ) ,

FULLTEXT `SearchFields` (
Title,
MenuTitle,
Content,
MetaTitle,
MetaDescription,
MetaKeywords
),

FULLTEXT `TitleSearchFields` (
Title
),
PRIMARY KEY ( ID )
) TYPE = MYISAM
0
 
Beverley PortlockCommented:
Folding the query up more neatly gives

 CREATE TABLE `Page` (
ID int( 11 ) NOT NULL AUTO_INCREMENT ,
`ParentID` int( 11 ) NOT NULL default '0',
INDEX `ParentID` ( ParentID ) ,

FULLTEXT `SearchFields` (
Title,
MenuTitle,
Content,
MetaTitle,
MetaDescription,
MetaKeywords
),

FULLTEXT `TitleSearchFields` (
Title
),
PRIMARY KEY ( ID )
) TYPE = MYISAM

As you can see the FULLTEXT makes reference to a field "title" which is not defined in the definitions preceding the FULLTEXT - looks like a buggy definition. You could risk adding it to the code, but your best bet is to look for a bug fix.


A "Good" Fulltext looks like this

CREATE TABLE articles (
    ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    ->   title VARCHAR(200),
    ->   body TEXT,
    ->   FULLTEXT (title,body)
    -> );



More on FULLTEXT here http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html
0
 
Loganathan NatarajanLAMP DeveloperAuthor Commented:
i will try and let u know tomorrow
0
 
Beverley PortlockCommented:
This appears to  be similar to this problem, http://open.silverstripe.com/ticket/2013 but there does not seem to be a resolution posted.

Are you using the latest version of Silverstripe?
0
 
Loganathan NatarajanLAMP DeveloperAuthor Commented:
i am using silverstripe-v2.2.1.tar ... i think it is latest version.,

thanks for replying to the post
0
All Courses

From novice to tech pro — start learning today.