Error combined with taxonomy search
pcambra - May 26, 2008 - 12:36
| Project: | Search All |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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
#1
that solution seems to work for me, too. Thanks pcambra, for posting a solution!
for those implementing it, paste it in at line 88.