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

Jesse Vincent jesse at bestpractical.com
Tue Jun 11 09:21:51 EDT 2002


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 at lists.fsck.com.

	Best,
	Jesse

On 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 at 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.




More information about the rt-users mailing list