Search not working

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
aacircle
Regular
Posts: 50
Joined: Sun Oct 02, 2005 11:04 am
Contact:

Search not working

Post 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
** English Teacher and Student Site **

http://www.aacircle.com.au/blog
ESL Blog It! "Real Stories from Real Teachers!"
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Search not working

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
aacircle
Regular
Posts: 50
Joined: Sun Oct 02, 2005 11:04 am
Contact:

Post 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!
** English Teacher and Student Site **

http://www.aacircle.com.au/blog
ESL Blog It! "Real Stories from Real Teachers!"
Post Reply