This is a great module.

Unfortunately, when I upgraded to 5.x-0.6 today, I received the following errors within my Drupal log:

Error #1
---------------
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 'DISTINCT(n.nid), SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM n' at line 1 query: _execute_search_query CREATE TEMPORARY TABLE temp_faceted_search_nids SELECT node.nid AS DISTINCT(n.nid), SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM node AS node INNER JOIN search_index AS i ON node.nid = i.sid INNER JOIN search_total AS t ON i.word = t.word WHERE ((node.status = 1) AND (i.word = 'metasearch') AND (i.type = 'node')) GROUP BY nid ASC HAVING ((COUNT(*) >= 1)) in /path-to-drupal/includes/database.mysql.inc on line 172.
---------------

Error #2
---------------
Table 'intranetdb_production.temp_faceted_search_nids' doesn't exist query: _execute_search_query SELECT MAX(relevance) FROM temp_faceted_search_nids in /path-to-drupal/includes/database.mysql.inc on line 172.
---------------

Comments

peregrine’s picture

peregrine commented

Drupal 5.3 / php 4.4.4 / mysql 4.1.22
I also upgraded today to 5.x-0.6 and also have 8 warnings, the first is included below.

user warning: 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 'DISTINCT(n.nid), COUNT(node.nid) AS count, node_type.type AS node_type_type, nod' at line 1 query: SELECT node.nid AS DISTINCT(n.nid), COUNT(node.nid) AS count, node_type.type AS node_type_type, node_type.name AS node_type_name FROM node AS node INNER JOIN node_type AS node_type ON node.type = node_type.type WHERE ((node.status = 1) AND (node_type.type IN ('phone', 'plans')) AND (node.type NOT IN ('accessories','docs','event','faq','image','locations','map','media','options','page','pagers','pager_overview','pagerplan','promo','story','tips','webform'))) GROUP BY node_type_type ASC ORDER BY count DESC, node_type_name ASC LIMIT 0, 11 in /home/username/domains/website/public_html/drupal/includes/database.mysql.inc on line 172.

David Lesieur’s picture

David Lesieur commented
Status: Active » Fixed

I just made a new release that fixes this. Last release was not using 'n' as the alias for the node table in queries. That was a problem since other modules rely on it in their implementation of hook_db_rewrite_sql().

Sorry for the inconvenience!

peregrine’s picture

peregrine commented

Thank you for getting this resolved so quickly.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.