Search - Database Error

[peterstannard]

Database Error
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4
File: /home/lfc1892/public_html/forum/Sources/Search.php
Line: 699

how should i fix this?

[peterstannard]

ok i've just downloaded SMF 1.0.1 and uploaded a copy of Search.php and this appears to have fixed it.

Any ideas what could have caused the above error?

[[Unknown]]

I'm not sure.  Do you have temporary tables enabled?

-[Unknown]

[peterstannard]

despite uploading a new copy of Search.php the problem has returned!

Disable temporary tables: ticked

what's going on?

[[Unknown]]

http://www.simplemachines.org/community/index.php?topic=24459.60

-[Unknown]