Uhm... Install problem - error in SQL syntax

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

You’ve attempted to install one of the development snapshots of RT 2.1
on mysql 3.23.x. RT 2.1 requires mysql 4. And you REALLY don’t want to
be running RT 2.1 in production yet. Also, development releases are really
best discussed on rt-devel@lists.fsck.com.

Best,
JesseOn Tue, Jun 11, 2002 at 12:22:06PM +0200, Banze, Andreas wrote:

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


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.