Closed (fixed)
Project:
Views Fast Search
Version:
5.x-2.0
Component:
Miscellaneous
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
20 Mar 2008 at 11:06 UTC
Updated:
28 Mar 2008 at 09:28 UTC
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
Comment #1
olafke commentedI 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
Comment #2
olafke commentedProblem resolved. Was due to a faulty sql query in one of my tpl.php files