We are integrating a basic multi-language ca/es/en version. At the moment all is right but today installing Acidfree as photogallery appears this user warning:

Column: 'nid' in field list is ambiguous query: SELECT COUNT(nid) FROM ca_node n INNER JOIN ca_acidfree ON ca_acidfree.aid = n.nid INNER JOIN ca_acidfree_hierarchy ON child = aid LEFT JOIN ca_i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='ca' OR i18n.language ='' OR i18n.language IS NULL) AND class <> 'album' AND parent=7 AND CONCAT(LPAD(CONVERT(5555555555 + ca_acidfree.weight, CHAR), 10, '0'), LPAD(CONVERT(9999999999 - ca_acidfree.aid, CHAR), 10, '0')) < '55555555559999999991' in /home/ca/public_html/ca/includes/database.mysql.inc on line 120.

For this reason, we will be very grateful if anybody can confiorm the compatibility i18n with acidfree.
thanks in advance,
Ferran

Comments

al_form’s picture

It is an acidfree issue.
I corrected the same problem by replacing nid with n.nid in three lines of acidfree.module (lines 405, 521 and 1948).
Cheers,
Alessandro

---
You can't have everything: where would you put it?

CREAT0R’s picture

I have the same problem.
Please write for me some details because i dont find the "nid" word in the 405, 521 and 1948 lines. (i have a lot of in another lines)
Thanks. GY.