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
Comment #1
matt2000 commentedThis 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?
Comment #2
gisleNot new info in three years. Unable to reproduce.