Topic: Search mySQL Error
Hi,
Recently the search on our Forums have stopped working;
http://nwcryobank.com/forum/search/?s=sheldon
An error was encountered
Note: For detailed error information (necessary for troubleshooting), enable "DEBUG mode". To enable "DEBUG mode", open up the file config.php in a text editor, add a line that looks like "define('FORUM_DEBUG', 1);" (without the quotation marks), and re-upload the file. Once you've solved the problem, it is recommended that "DEBUG mode" be turned off again (just remove the line from the file and re-upload it).
Turning DEBUG on, I get the following error;
An error was encountered
The error occurred on line 682 in /usr/local/www/htdocs/nwcryobank.com/www/forum/include/search_functions.php
Database reported: Query was empty (Errno: 1065).
function get_search_results($query, &$search_set)
{
global $forum_db, $forum_user, $forum_page, $lang_common;
$return = ($hook = get_hook('sf_fn_get_search_results_start')) ? eval($hook) : null;
if ($return != null)
return $return;
$result = $forum_db->query_build($query) or error(__FILE__, __LINE__); // line 682I have updated to the latest versions, and have rebuilt the index in the administration.
