I updated to Drupal 6.16 and after running cron received the error below repeated about 23 times below each other.

* user warning: Not unique table/alias: 'n' query: SELECT DISTINCT c.nid, c.cid, c.subject, c.name FROM comments c INNER JOIN node n ON c.nid = n.nid LEFT JOIN node n ON c.nid = n.nid INNER JOIN node_access na ON na.nid = c.nid WHERE ((n.moderate != 1 OR n.uid = 17)) AND (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'admin_notification_view') OR (na.gid = 2 AND na.realm = 'forum_access'))) AND ( c.status = 0 AND c.timestamp > 1268431267 AND c.timestamp <= 1268434086 AND (n.type = 'forum' OR n.type = 'job') )ORDER BY c.nid, c.timestamp in /home/floorson/public_html/modules/notify/notify.module on line 433.

Posted the error on the forum then VM suggested that I disable the notify module after which running cron I didnt receive the error anymore.

Comments

matt2000’s picture

Status: Active » Postponed (maintainer needs more info)

This looks like a conflict with forum_access or some other access control module. Can you confirm if this is so, or provide a list of your other enabled modules?

gisle’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Not new info in three years. Unable to reproduce.