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

brucepearson’s picture

Thanks 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.

brucepearson’s picture

Status: Active » Fixed
perandre’s picture

Good job!

Status: Fixed » Closed (fixed)

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