Hi
I am using Drupal 5.7 with views fast search 5.x.2.0. I have installed the views subqueries patch.
The search works fine but I get the following sql warning:

user warning: Table 'temp_search_sids' already exists 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 WHERE (i.word = 'hsv') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in
 C:\xampp\htdocs\drupal-testldap\includes\database.mysql.inc on line 172.
 
user warning: Table 'temp_search_results' already exists query: CREATE TEMPORARY TABLE temp_search_results SELECT i.type, i.sid, (2.37851246443 * i.relevance) AS score FROM temp_search_sids i INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type WHERE (d.data LIKE '% hsv %') in C:\xampp\htdocs\drupal-testldap\includes\database.mysql.inc on line 172.

I checked my DB and could not find any temp_search_sid ot temp_search_results tables. I could just disable the warnings but maybe there is a simple explanation for this.

Comments

olafke’s picture

I found the same problem in http://drupal.org/node/102219 but the solution there did not help me much. I guess it just works for the standard search

olafke’s picture

Status: Active » Closed (fixed)

Problem resolved. Was due to a faulty sql query in one of my tpl.php files