[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