https://www.icyphoenix.com/viewtopic.php?f=4&t=3313
-----------------------------------
DWho
Mon 24 Dec, 2007 15:51

DB - Fulltext Key
-----------------------------------
When installing IP on my wamp server I always run into this problem when installing the database...[b]The used table type doesn't support FULLTEXT indexes[/b]

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 linenumbers=false]default-table-type=innodd[/code]

and replace with this

[code linenumbers=false]default-table-type=myisam[/code]

I hope that helps someone...

 :mrgreen:  :mrgreen:


-----------------------------------
novice programmer
Tue 25 Dec, 2007 23:32

Re: Fulltext Key
-----------------------------------
[b]DWho[/b], many people can´t access that file.

Just go to [url=http://www.icyphoenix.com/viewtopic.php?f=4&t=2520]this tutorial


-----------------------------------
DWho
Wed 26 Dec, 2007 09:03

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...

 :mrgreen:  :mrgreen:


-----------------------------------
novice programmer
Wed 26 Dec, 2007 12:10

Re: Fulltext Key
-----------------------------------
Thank you for pointing that out.

Moving to docs section...


