Report abuse

user warning: 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 'JO IN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.statu' at line 1 query: CREATE TEMPORARY TABLE temp_search_sids Engine=HEAP SELECT i.type, i.sid, SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JO IN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND (i.word = 'node') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in /Users/joon/Sites/projects/DRUPAL-HEAD/modules/search/search.module on line 882.
user warning: Table 'drupalhead.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /Users/joon/Sites/projects/DRUPAL-HEAD/modules/search/search.module on line 885.