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
An acidfree issue, really
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?
n.nid
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.