problem in chapter 13

derrida · July 10th, 2006, 01:02 AM

hi
in chapter 13when i view in the broswer the cmstables.php file i get this message:
The used table type doesn't support FULLTEXT indexes

i tried to see how i fix that but i cannot see how.

can anyone help please?

best regards

ron

derrida · July 12th, 2006, 02:51 AM

hi
can anybody help me please?

wildteen88 · July 16th, 2006, 01:20 PM

Basically the current storage engine, which your table has been setup to use doesnt support FULLTEXT indexes. To solve this you will have delete the table and recreate the table making sure you define the proper storage engine, which would be MyISAM as this engine supports FULLTEXT Indexes.

So what you'll have to do first is delete the cms_articles table, you can do this with phpMyAdmin. Once the table has been deleted. Open up cmstables.php for editing. Now find the following:

Code:

FULLTEXT KEY IdxText (title,body)
)
EOS;

and change it to this:

Code:

FULLTEXT KEY IdxText (title,body)
)
TYPE = myisam;
EOS;

Run cmstables.php again. This should solve the problem.

derrida · July 28th, 2006, 02:31 AM

hi
thanks it works:)