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

Joe Malik’s picture

Same problem here. Is there any chance to see this problem solved?