Posted by jsr47 on February 2, 2009 at 1:19am
Jump to:
| Project: | Notify |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | matt2000 |
| Status: | postponed (maintainer needs more info) |
Issue Summary
When running cron.php, the following errors appear in the log: one for each user.
Here is the message:
Not unique table/alias: 'n' query: SELECT 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 WHERE ((n.moderate != 1 OR n.uid = 63)) AND ( c.status = 0 AND c.timestamp > 1233532807 AND c.timestamp <= 1233536412 AND (n.type = 'story') )ORDER BY c.nid, c.timestamp in /docroot/drupal/sites/all/modules/notify/notify.module on line 433.
Comments
#1
Followup: I think the problem is a conflict between the alias "n" from the INNER JOIN and the LEFT JOIN.
#2
Hi
Did you get a fix for this as I have the same problem
Thanks
#3
This is probably a conflict with an access-control/moderation module. The new dev release will hopefully avoid this. Please test.
#4
New release will use an alternate alias, but I'm hoping jsr47 can confirm the issue is resolved.