Search Bug

QL Team:

There's a problem with searching on multiple keywords eg: 'salary range'

Got user warnings as below:

* user warning: Got error 127 from storage engine query: CREATE TEMPORARY TABLE temp_search_sids 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 JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND (i.word = 'salary' OR i.word = 'range') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 2 in /home/qatarliv/public_html/includes/database.mysql.inc on line 120.
* user warning: Table 'qatarliv_drpl1.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /home/qatarliv/public_html/includes/database.mysql.inc on line 120.

Regards