Active
Project:
Gallery
Version:
5.x-2.2
Component:
Code / API
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
12 Sep 2008 at 14:58 UTC
Updated:
11 Oct 2008 at 12:11 UTC
Hello,
I activate the gallery module on my site. As a result of that every call with the Drupal proves own searching function (without some additional modules) the following two php errors:
Table 'db.temp_search_results' doesn't exist query: SELECT COUNT(*) FROM temp_search_results in /drupal/includes/database.mysql.inc in Zeile 172.
and:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '5957190007896 * i.relevance) + 5 * POW(2, (GREATEST(n.created, query: CREATE TEMPORARY TABLE temp_search_results SELECT i.type, i.sid, 5 * (4,5957190007896 * i.relevance) + 5 * POW(2, (GREATEST(n.created, n.changed, c.last_comment_timestamp) - 1221166666) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + c.comment_count * 1)) AS score FROM temp_search_sids i INNER JOIN drupalsite_search_dataset d ON i.sid = d.sid AND i.type = d.type INNER JOIN drupalsite_node n ON n.nid = i.sid LEFT JOIN drupalsite_node_comment_statistics c ON c.nid = i.sid WHERE (d.data LIKE '% lucienne %') ORDER BY score DESC in /drupal/includes/database.mysql.inc in Zeile 172.
If I deactivate the gallery module again, the search also works again fine.
What goes wrong here?
Thanks and greetings
Frank
Comments
Comment #1
Joe Malik commentedSame problem here. Is there any chance to see this problem solved?