I'm getting this when I try to do a search with trip_search:
---------------------------------------
details
Type php
Date Tuesday, June 7, 2005 - 13:15
User testadmin
Location /?q=trip_search
Message You have an error in your SQL syntax near 'BOOLEAN MODE) LIMIT 0, 500' at line 1 query: SELECT DISTINCT(t.tid), t.name, t.description FROM term_data t WHERE MATCH (t.name,t.description) AGAINST ('+biography' IN BOOLEAN MODE) LIMIT 0, 500 in /var/www/html/includes/database.mysql.inc on line 66.
Severity error
Hostname 10.20.1.3
--------------------------------------
I get the same error when I try the query in mysql. It doesn't like the "IN BOOLEAN MODE". Am I on an old version of MYSQL or something?

Thanks,

Vicki

Comments

nedjo’s picture

nedjo
he/him/his
Primary language English
commented

I suggest you change the search type in the module settings page and see if the errors disappear in other search types. You may be right that this is a MySQL version issue. The MySQL reference manual says full text indexing was introduced in MySQL 3.23.23. Can you ascertain what version your server is running?

vprugh’s picture

vprugh commented

Hi Nedjo,

Thanks for the feedback. My version of Mysql is 3.23.58. I think my problem was that I had it set for "Mysql full text", which I guess I don't want, so I set it to Regular Expression and it works GREAT now!

Thanks again for the help!

Vicki