Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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...

   
 



 
DWhoSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Fulltext Key 
 
DWho, many people canĀ“t access that file.

Just go to this tutorial
 



 
novice programmerSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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...

   
 



 
DWhoSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Fulltext Key 
 
Thank you for pointing that out.

Moving to docs section...
 



 
novice programmerSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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


  

 

  cron