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:
ERROR 1911 (HY000): Can't find FULLTEXT index matching the column list.

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