Hi, I'm a faceted-search newbie. I configuered one environmet, then I configuered an searchblock and on the searchpape I got following warnings:
* 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 '***CURRENT_USER*** or ***ADMINISTER_NODES*** = 1) AND (term_data.vid in ('8', '5' at line 16 query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1234194472) * 6.43e-8) AS score FROM node AS n LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid WHERE ((n.status = 1) AND (n.type IN ('stelle_gewerb','stelle_kaufm','stelle_techn'))) AND n.nid IN (SELECT DISTINCT(node.nid) AS nid, node_data_field_stellenbeschr_gewerb.field_stellenbeschr_gewerb_value AS node_data_field_stellenbeschr_gewerb_field_stellenbeschr_gewerb_value, node_data_field_stellenbeschr_gewerb.field_stellenbeschr_gewerb_format AS node_data_field_stellenbeschr_gewerb_field_stellenbeschr_gewerb_format, node_data_field_stellenbeschr_gewerb.nid AS node_data_field_stellenbeschr_gewerb_nid, node.type AS node_type, node_data_field_stellenbeschr_gewerb.field_ort_region_gewerb_value AS node_data_field_stellenbeschr_gewerb_field_ort_region_gewerb_value, node_data_field_stellenbeschr_gewerb.field_ort_region_gewerb_format AS node_data_field_stellenbeschr_gewerb_field_ort_region_gewerb_format, node_data_field_stellenbeschr_gewerb.field_sonstiges_gewerb_value AS node_data_field_stellenbeschr_gewerb_field_sonstiges_gewerb_value, node_data_field_stellenbeschr_gewerb.field_sonstiges_gewerb_format AS node_data_field_stellenbeschr_gewerb_field_sonstiges_gewerb_format, node.sticky AS node_sticky, node.created AS node_created FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN content_type_stelle_gewerb node_data_field_stellenbeschr_gewerb ON node.vid = node_data_field_stellenbeschr_gewerb.vid WHERE (node.status <> 0 OR node.uid = ***CURRENT_USER*** or ***ADMINISTER_NODES*** = 1) AND (term_data.vid in ('8', '5')) ORDER BY node_sticky DESC, node_created DESC ) GROUP BY n.nid ASC ORDER BY score DESC in /Applications/MAMP/htdocs/accu01_drupal/sites/all/modules/faceted_search/faceted_search.inc on line 1174.
* user warning: Table 'db76930027.temp_faceted_search_results_1' doesn't exist query: SELECT COUNT(*) FROM temp_faceted_search_results_1 in /Applications/MAMP/htdocs/accu01_drupal/sites/all/modules/faceted_search/faceted_search.inc on line 1175.
What can I do?
Do you need more Info.
I'm using a local installation on my mac (MAMP).
And: yes, at the MySQL I entered the following command:
GRANT LOCK TABLES, CREATE TEMPORARY TABLES
ON db76930027.*
TO 'root'@'localhost';
What can I do?
Please help.
Comments
Comment #1
David Lesieur commentedI am unable to reproduce this bug with the current dev version. You might want to try it... Then if it still have this issue, could you export your view and post it here? (given the query you got, I'm assuming that you are using a view to display your search results).
Comment #2
David Lesieur commentedComment #3
David Lesieur commentedI now realize that this is the same issue as #428750: Views placeholders not being replaced, for which a fix has just been committed.