Active
Project:
Search All
Version:
5.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
26 May 2008 at 12:36 UTC
Updated:
26 Aug 2008 at 12:00 UTC
Hi
When i use this module with taxonomy_search, i get theses errors when searching:
* user warning: Table 'temp_search_sids' already exists query: CREATE TEMPORARY TABLE temp_search_sids (..)
* user warning: Table 'temp_search_results' already exists query: CREATE TEMPORARY TABLE temp_search_results (..)I think that the do_search function creates these temporary tables, so I've added these lines at each iteration of foreach in search_all_view() function
$sql = "DROP TABLE IF EXISTS {temp_search_sids}";
db_query($sql);
$sql = "DROP TABLE IF EXISTS {temp_search_results}";
db_query($sql);
Hope it's correct
Pedro
Comments
Comment #1
OwnSourcing commentedthat solution seems to work for me, too. Thanks pcambra, for posting a solution!
for those implementing it, paste it in at line 88.