DB - Fulltext Key


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: [Download] [Hide] [Select]
default-table-type=innodd


and replace with this

Code: [Download] [Hide] [Select]
default-table-type=myisam


I hope that helps someone...

:mrgreen: :mrgreen:

Subject: Re: Fulltext Key
DWho, many people can“t access that file.

Just go to this tutorial

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

:mrgreen: :mrgreen:

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

Moving to docs section...

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.9594s (PHP: 2% SQL: 98%)
SQL queries: 14 - Debug Off - GZIP Enabled