Hi clemens,
thanks for working on this!
Have installed the module but getting following message on a new book page i composed:
* user warning: Column 'nid' in where clause is ambiguous query: SELECT uid FROM node LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid=6) in /....database.mysql.inc on line 172.
* user warning: Column 'nid' in field list is ambiguous query: SELECT uid, nid, visibility, note FROM annotations LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = 6 AND 1=1) in .../database.mysql.inc on line 172.
* user warning: Column 'nid' in where clause is ambiguous query: SELECT uid FROM node LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid=6) in .../database.mysql.inc on line 172.
* user warning: Column 'nid' in field list is ambiguous query: SELECT uid, nid, visibility, note FROM annotations LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( nid = 6 AND 1=1) in .../database.mysql.inc on line 172.
The annotation doesn't show up either.
Cheers!
Jon
Comments
Comment #1
clemens.tolboomThis has probably the same cause as http://drupal.org/node/190339.
I use db_rewrite_sql where it should not be used. My idea was to use it for access control purposes. But I must find a good example now.
I see you use the i18n module, so I start testing with this module. Hope to reproduce this.
Comment #2
clemens.tolboomIs is now confirmed. Installing i18n together with annotate on drupal 5.3 gives the mentioned bug.
Comment #3
clemens.tolboomSolution is to remove all db_rewrite_sql words in the annotate.module.
(this was an upbeat for a real sql join between users, annotations and nodes)
Comment #4
clemens.tolboomComment #5
clemens.tolboom