Conflict with the i18n module
risou - January 8, 2009 - 19:10
| Project: | Versus |
| Version: | 5.x-1.0-rc1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Description
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