mysql error: Not unique table/alias: 'n'
jsr47 - February 2, 2009 - 01:19
| Project: | Notify |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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.
#1
Followup: I think the problem is a conflict between the alias "n" from the INNER JOIN and the LEFT JOIN.