Hi,
if i want to view the vote standings of a specific content type such "Competition Entry" i get always the following error (only when the i18n module is enabled):
# 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 ' (SELECT field_competition_entry_comp_nid FROM content_type_competition_entry L' at line 1 query: pager_query SELECT count( DISTINCT(node.nid)) FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.status = '1') AND (node.type = 'competition_entry') AND ((SELECT IF((SELECT field_competition_entry_comp_nid FROM content_type_competition_entry LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = node.nid), (SELECT field_competition_entry_comp_nid FROM content_type_competition_entry LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = node.nid), (SELECT field_competition_entry_comp_nid FROM content_type_competition_entry LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = (SELECT parent_nid FROM relativity LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = node.nid)))) = 140) ) in /www/htdocs/w0sdf09ffa5c76/includes/database.mysql.inc on line 172.
# 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 'AS versus_votes FROM node node INNER JOIN users users ON node.uid = users.uid ' at line 1 query: pager_query SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, (SELECT COUNT(value) AS votes FROM votingapi_vote LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( value = node.nid) AS versus_votes FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.status = '1') AND (node.type = 'competition_entry') AND ((SELECT IF((SELECT field_competition_entry_comp_nid FROM content_type_competition_entry LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = node.nid), (SELECT field_competition_entry_comp_nid FROM content_type_competition_entry LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = node.nid), (SELECT field_competition_entry_comp_nid FROM content_type_competition_entry LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = (SELECT parent_nid FROM relativity LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = node.nid)))) = 140) ) ORDER BY versus_votes DESC LIMIT 0, 100 in /www/htdocs/w0sdf09ffa5c76/includes/database.mysql.inc on line 172.
Any idea?
Thanks
Comments
Comment #1
EliteMonk commentedThis need test on 6.x with latest i18n. If tou can reproduse, then need you i18n settings.