Haestan
31.10.2007, 12:05
Ich wollte mir einen Bericht erstellen der die offenen Todos zweier Mitarbeiter nach der jeweiligen Priorität der Aufgabe sortiert darstellt. Dabei kam es zu einem DB Error der (zumindest bei mir) sich beliebig reproduzieren lässt.
Der Fehler tritt bei mir jedes mal auf wenn ich eine beliebige Suchanfrage starte bei der ich bei der Gruppierung die Auswahl "Zugewiesen an" treffe. Der Datenbankfehler lautet wie folgt:
Datenbankfehler in vBulletin 3.6.8:
Invalid SQL:
SELECT issue.issueid AS id, issueassign.userid AS
groupid
FROM vb3_pt_issue AS issue
INNER JOIN vb3_pt_issueassign AS issueassign ON
(issueassign.issueid = issue.issueid AND issueassign.userid IN (248))
INNER JOIN vb3_pt_issueassign AS issueassign ON (issueassign.issueid =
issue.issueid)
WHERE 1=1
AND ((issue.projectid = 2 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))) OR (issue.projectid = 3 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))) OR (issue.projectid = 4 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))) OR (issue.projectid = 5 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))))
GROUP BY issueassign.userid, issue.issueid
ORDER BY IF(issue.priority = 0, 11, issue.priority)
asc;
MySQL-Fehler : Not unique table/alias: 'issueassign'
Fehler-Nr. : 1066
Datum : Wednesday, October 31st 2007 @ 10:13:31 AM
Skript :
http://forum.gamesports.net/network/projectsearch.php?do=dosearch
Referrer :
http://forum.gamesports.net/network/projectsearch.php?do=search
IP-Adresse : 86.59.104.100
Benutzername : Khaldor
Klassenname : vb_databaseMfg Haestan
Der Fehler tritt bei mir jedes mal auf wenn ich eine beliebige Suchanfrage starte bei der ich bei der Gruppierung die Auswahl "Zugewiesen an" treffe. Der Datenbankfehler lautet wie folgt:
Datenbankfehler in vBulletin 3.6.8:
Invalid SQL:
SELECT issue.issueid AS id, issueassign.userid AS
groupid
FROM vb3_pt_issue AS issue
INNER JOIN vb3_pt_issueassign AS issueassign ON
(issueassign.issueid = issue.issueid AND issueassign.userid IN (248))
INNER JOIN vb3_pt_issueassign AS issueassign ON (issueassign.issueid =
issue.issueid)
WHERE 1=1
AND ((issue.projectid = 2 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))) OR (issue.projectid = 3 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))) OR (issue.projectid = 4 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))) OR (issue.projectid = 5 AND
((issue.issuetypeid = 'bug' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'feature' AND (issue.visible IN
('visible','private','moderation','deleted'))) OR (issue.issuetypeid =
'task' AND (issue.visible IN
('visible','private','moderation','deleted'))))))
GROUP BY issueassign.userid, issue.issueid
ORDER BY IF(issue.priority = 0, 11, issue.priority)
asc;
MySQL-Fehler : Not unique table/alias: 'issueassign'
Fehler-Nr. : 1066
Datum : Wednesday, October 31st 2007 @ 10:13:31 AM
Skript :
http://forum.gamesports.net/network/projectsearch.php?do=dosearch
Referrer :
http://forum.gamesports.net/network/projectsearch.php?do=search
IP-Adresse : 86.59.104.100
Benutzername : Khaldor
Klassenname : vb_databaseMfg Haestan