Hello!
Module i18n installs a hook on db_rewrite_sql, which manipulates the query and adds a join with the i18n table. This creates a problem with the following query:

Column 'nid' in field list is ambiguous query: SELECT COUNT(nid) FROM node n INNER JOIN acidfree ON acidfree.aid = n.nid INNER JOIN acidfree_hierarchy ON child = aid LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='ia' OR i18n.language ='' OR i18n.language IS NULL) AND (n.moderate = 0 AND n.status = 1) AND class <> 'album' AND parent=54 AND CONCAT(LPAD(5555 + acidfree.weight, 4, '0'), LPAD(acidfree.aid, 10, '0')) < '55550000000055'

To solve this, I changed the line 2048 of acidfree.module by using "SELECT COUNT (n.nid)". Please apply this fix.

Comments

vhmauery’s picture

vhmauery commented
Status: Needs review » Fixed

Okay, I can fix this, but be aware that Acidfree is not really compatible with the i18n module. Translating Acidfree items doesn't work very well iirc.

I have committed a patch to fix this. It should be repackaged in about 12 hours. Or, you can get revision 1.62.2.46 from CVS.

vhmauery’s picture

vhmauery commented
Status: Fixed » Closed (fixed)