Icy Phoenix :: View topic - DB

Documentation And How To - DB - Fulltext Key

DWho [ Mon 24 Dec, 2007 15:51 ]
Post subject: DB - Fulltext Key

When installing IP on my wamp server I always run into this problem when installing the database...The used table type doesn't support FULLTEXT indexes

After spending a great deal of time to figure out a quick and easy solution I finally found this one...

Basically MySQL 5 on Windows servers are setting default table types to innodb instead of myisam, and as innodb doesn't support fulltext, it causes this problem

Locate your my.ini and find:

Code: [Hide] [Select]

default-table-type=innodd

and replace with this

Code: [Hide] [Select]

default-table-type=myisam

I hope that helps someone...

novice programmer [ Tue 25 Dec, 2007 23:32 ]
Post subject: Re: Fulltext Key

DWho, many people can´t access that file.

Just go to this tutorial

DWho [ Wed 26 Dec, 2007 09:03 ]
Post subject: Re: Fulltext Key

i appreciate that many cannot access that file on hosted sites....

Sorry I didn't make that clear... but I was referring to local sites for anyone installing WAMP...

novice programmer [ Wed 26 Dec, 2007 12:10 ]
Post subject: Re: Fulltext Key

Thank you for pointing that out.

Moving to docs section...