Closed (fixed)
Project:
ICanLocalize Translator
Version:
6.x-1.9-beta2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
13 Oct 2009 at 09:39 UTC
Updated:
28 Oct 2009 at 14:00 UTC
This is the error message:
#
# 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 ') UNION SELECT DISTINCT(b.delta), b.title, 'icl_block_marker', 'en', 'visible', ' at line 22 query: SELECT COUNT(*) FROM (SELECT n.nid, n.title, n.type, n.language, n.status, n.tnid FROM node n WHERE (n.nid not in (select nid from icl_content_status)) and n.tnid = 0 and language = 'en' UNION SELECT n.nid, n.title, n.type, n.language, n.status, n.tnid FROM node n INNER JOIN icl_content_status cs ON n.nid = cs.nid INNER JOIN icl_core_status c ON c.rid = cs.rid INNER JOIN icl_node md ON md.nid = n.nid WHERE n.type IN ('country_contact', 'faq', 'companydirect', 'page', 'service', 'story') AND n.language = 'en' AND md.md5 <> cs.md5 AND c.status = 6 AND c.rid IN() UNION SELECT DISTINCT(b.delta), b.title, 'icl_block_marker', 'en', 'visible', '0' FROM i18n_blocks i18b join blocks b INNER JOIN icl_block_status bs ON b.delta = bs.bid INNER JOIN icl_core_status c ON c.rid = bs.rid INNER JOIN icl_block md ON md.bid = b.delta where i18b.language = '' and b.delta = i18b.delta and b.module = 'block' and b.theme = 'garland' AND md.md5 <> bs.md5 AND c.status = 6 AND c.rid IN() UNION SELECT DISTINCT(b.delta), b.title, 'icl_block_marker', 'en', 'visible', '0' FROM i18n_blocks i18b JOIN blocks b WHERE i18b.language = '' and b.delta = i18b.delta and b.module = 'block' AND (b.delta not in (select bid from icl_block_status))) tblDerived in /Users/MyUserName/Sites/testsite.dev/sites/all/modules/icanlocalize/icl_content/icl_content.dashboard.inc on line 392.
# 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 ') UNION SELECT DISTINCT(b.delta), b.title, 'icl_block_marker', 'en', 'visible', ' at line 22 query: SELECT n.nid, n.title, n.type, n.language, n.status, n.tnid FROM node n WHERE (n.nid not in (select nid from icl_content_status)) and n.tnid = 0 and language = 'en' UNION SELECT n.nid, n.title, n.type, n.language, n.status, n.tnid FROM node n INNER JOIN icl_content_status cs ON n.nid = cs.nid INNER JOIN icl_core_status c ON c.rid = cs.rid INNER JOIN icl_node md ON md.nid = n.nid WHERE n.type IN ('country_contact', 'faq', 'companydirect', 'page', 'service', 'story') AND n.language = 'en' AND md.md5 <> cs.md5 AND c.status = 6 AND c.rid IN() UNION SELECT DISTINCT(b.delta), b.title, 'icl_block_marker', 'en', 'visible', '0' FROM i18n_blocks i18b join blocks b INNER JOIN icl_block_status bs ON b.delta = bs.bid INNER JOIN icl_core_status c ON c.rid = bs.rid INNER JOIN icl_block md ON md.bid = b.delta where i18b.language = '' and b.delta = i18b.delta and b.module = 'block' and b.theme = 'garland' AND md.md5 <> bs.md5 AND c.status = 6 AND c.rid IN() UNION SELECT DISTINCT(b.delta), b.title, 'icl_block_marker', 'en', 'visible', '0' FROM i18n_blocks i18b JOIN blocks b WHERE i18b.language = '' and b.delta = i18b.delta and b.module = 'block' AND (b.delta not in (select bid from icl_block_status)) LIMIT 0, 30 in /Users/MyUserName/Sites/testsite.dev/sites/all/modules/icanlocalize/icl_content/icl_content.dashboard.inc on line 392.
Comments
Comment #1
brucepearson commentedThanks for reporting this error.
This error would only occur if you haven't sent any content for translation. The SQL call is now fixed in 6.x-1.9-beta3.
Comment #2
brucepearson commentedComment #3
perandre commentedGood job!