ERROR 1911 (HY000): Can't find FULLTEXT index matching the column list.
Saturday, May 22, 2010
MySQL MATCH AGAINST Query ERROR 1191
I came across this problem when I ran into a client who needed Boolean search functionality on his site. The previous query he had was using LIKEs to do the searching on 6 columns. I told him about using a new query that used FULLTEXT indexes and continued about the performance benefits and also overhead this might cause as their data changes overtime. Naturally, I gave him a cronjobs script that basically optimizes the table to help him with maintenance. The problem arose when I implemented the query (Match..Against) I kept on getting:
Labels:
Bug,
Database,
MySQL,
Performance,
Web Development
Wednesday, May 12, 2010
Windows Security Fail!!!! lol
Kernal Hook Bypass Engine - Got to love Windows on security issues its like opening a can of worms lmao
Subscribe to:
Posts (Atom)