Page 1 of 1

Search not working

Posted: Fri Jan 27, 2006 10:44 am
by aacircle
It's been a while since I last used the Quick Search function on our blog. It used to work, but now doesn't.

Please see for yourself the problem at www.aacircle.com.au/blog
The Quick Search field is in the top right of the page.

A caption of the message sent back to the user is:
This may happen because of missing index keys in your database. On MySQL systems your database user account needs to be privileged to execute this query

Re: Search not working

Posted: Fri Jan 27, 2006 12:04 pm
by garvinhicking
Actually the error message tells it all: Your database has no "FULLTEXT" privilege set, which it requires. The SQL query to add the index is given on the error page, you'll need to execute it.

You can "loose" your fulltext privilege if you backed up your database and restored it at some point, or if your provider made changes.

Best Regards,
Garvin

Posted: Fri Jan 27, 2006 12:14 pm
by aacircle
Thanks Garvin. Just emailed our host provider and await their response. We never did any changes to our database so am assuming the host provider did.

Cheers!