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

clemens.tolboom’s picture

Assigned: Unassigned » clemens.tolboom

This 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.

clemens.tolboom’s picture

Is is now confirmed. Installing i18n together with annotate on drupal 5.3 gives the mentioned bug.

clemens.tolboom’s picture

Solution 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)

clemens.tolboom’s picture

Version: 5.x-1.0-beta2 » 5.x-1.0-beta3
Component: Miscellaneous » Code
Priority: Normal » Critical
Status: Active » Fixed
clemens.tolboom’s picture

Status: Fixed » Closed (fixed)