[rt-users] Uhm... Install problem - error in SQL syntax

Banze, Andreas Andreas.Banze at Geodata.de
Tue Jun 11 06:22:06 EDT 2002


I've got an error message I don't understand (my knowledge of mysql is quite
basic).

Any hints where to look at?

[warning]: DBD::mysql::st execute failed: You have an error in your SQL
syntax near 'UNION SELECT ACL.id from ACL, Principals WHERE  (ACL.RightName
= 'AdminGroups' O' at line 7 at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 365.

[warning]: RT::Handle=HASH(0x878dce8) couldn't execute the query '
SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers  WHERE
   (ACL.RightName = 'SuperUser' OR  ACL.RightName = 'AdminGroups') AND
Principals.Id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId =
'1' AND
    (   ACL.ObjectType = 'System'  ) AND
    (
        (  ACL.PrincipalId = Principals.Id and Principals.ObjectId =
Groups.Id AND ACL.PrincipalType = 'Group' AND (Groups.Domain =
'SystemInternal' OR Groups.Domain = 'UserDefined'))
            )  UNION SELECT ACL.id from ACL, Principals WHERE
(ACL.RightName = 'AdminGroups' OR ACL.RightName = 'SuperUser') AND
ACL.PrincipalType = 'User'  AND ( Principals.PrincipalType = 'User' AND
Principals.ObjectId = 1 AND ACL.PrincipalId = Principals.Id ) AND (
(ACL.ObjectType = 'System') )'You have an error in your SQL syntax near
'UNION SELECT ACL.id from ACL, Principals WHERE  (ACL.RightName =
'AdminGroups' O' at line 7

Can't call method "fetchrow" on an undefined value at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 400.
Creating Superuser  ACL...Creating groups...make: *** [insert-baseline-data]
Fehler 255


Thanks
Andreas




More information about the rt-users mailing list