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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Beverley PortlockCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.