View Issue Details

IDProjectCategoryView StatusLast Update
0000278Usermanagement[Adventure PHP Framework] Bugpublic2015-12-03 08:16
ReporterChristianAchatzAssigned ToChristianAchatz 
PriorityimmediateSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version[Adventure PHP Framework] 3.0.2 
Target Version[Adventure PHP Framework] 3.0.3Fixed in Version[Adventure PHP Framework] 3.0.3 
Summary0000278: CLONE - Aufruf der Funktion getUserByDisplayName wirft einen MySQL Fehler.
DescriptionFehler beim Aufruf der Funktion da die Spalte "DisplayName" sowohl im User als auch in der Application existiert. Daher ist es notwendig in der Where Klausel explizit auf die ent_user Tabelle zu verweisen.
Steps To ReproduceEinfacher Aufruf der Funktion.
Additional InformationVorhanden:
$select = 'SELECT * FROM `ent_user`
                 INNER JOIN cmp_application2user ON ent_user.UserID = cmp_application2user.Target_UserID
                 INNER JOIN ent_application ON cmp_application2user.Source_ApplicationID = ent_application.ApplicationID
                 WHERE
                     ent_application.ApplicationID = \'' . $this->applicationId . '\'
                     AND `DisplayName` = \'' . $displayName . '\';';

Korregiert:
$select = 'SELECT * FROM `ent_user`
                 INNER JOIN cmp_application2user ON ent_user.UserID = cmp_application2user.Target_UserID
                 INNER JOIN ent_application ON cmp_application2user.Source_ApplicationID = ent_application.ApplicationID
                 WHERE
                     ent_application.ApplicationID = \'' . $this->applicationId . '\'
                     AND ent_user.DisplayName = \'' . $displayName . '\';';
TagsNo tags attached.
Codereferenz: ([Datei]:[Zeile])

Relationships

related to 0000272 resolvedChristianAchatz Aufruf der Funktion getUserByDisplayName wirft einen MySQL Fehler. 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-12-03 08:16 ChristianAchatz New Issue
2015-12-03 08:16 ChristianAchatz Status new => assigned
2015-12-03 08:16 ChristianAchatz Assigned To => ChristianAchatz
2015-12-03 08:16 ChristianAchatz Issue generated from: 0000272
2015-12-03 08:16 ChristianAchatz Relationship added related to 0000272
2015-12-03 08:16 ChristianAchatz Status assigned => resolved
2015-12-03 08:16 ChristianAchatz Fixed in Version => 3.0.3
2015-12-03 08:16 ChristianAchatz Resolution open => fixed