On deleting projects, a few queries throw errors. We're using MySQL 4.0.24. An erroneous query:
DELETE issuenote
FROM pt_issuenote AS issuenote
INNER JOIN pt_issue AS issue ON (issue.issueid = issuenote.issueid)
WHERE issue.projectid = 16
The error:
ERROR 1066: Not unique table/alias: 'issuenote'
Quite a few of the DELETE/INNER JOIN queries result in this kind of error. These tables have not been modified.
Any ideas?
DELETE issuenote
FROM pt_issuenote AS issuenote
INNER JOIN pt_issue AS issue ON (issue.issueid = issuenote.issueid)
WHERE issue.projectid = 16
The error:
ERROR 1066: Not unique table/alias: 'issuenote'
Quite a few of the DELETE/INNER JOIN queries result in this kind of error. These tables have not been modified.
Any ideas?
Comment