Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Ciao,
I am using acidfree version 4.7.0 and i18n version 4.7.0. When I access "create content" > "acidfree media" I get a warning:
user warning: Column: 'status' in where clause is ambiguous query: SELECT n.nid, child FROM node n INNER JOIN acidfree ON n.nid = acidfree.aid INNER JOIN acidfree_hierarchy ON acidfree_hierarchy.child = acidfree.aid LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='it') AND (moderate = 0 AND status = 1) AND parent = 40 AND class='album' ORDER BY weight ASC, aid DESC in d:\documenti e impostazioni\htdocs\drupal_au\includes\database.mysql.inc on line 120.
In fact, the column 'status' exists both in node table and in i18n_node.
I attach a simple patch which should fix this ambiguity.
Regards,
Riccardo
| Comment | File | Size | Author |
|---|---|---|---|
| acidfree_0.diff | 3 KB | riccardoR |
Comments
Comment #1
vhmauery commentedFixed in cvs version 1.62.2.34.
However, please note that Acidfree is NOT fully compatible with the i18n module. I have talked with the i18n module maintainer and we have not yet figured out how to make it work. While some features of it may work, it is not fully supported (and likely never will be).
But thank you for the patch anyway. I do like to see support from the community.
Comment #2
vhmauery commented