MySQL ACL error

RT Users
1

I am using the most current stable version of Mysql and have gotten all
the plugins for rt in place. I am trying to build and install Rt-2-0-8_02
on SUn Solaris. The problem is that when I run make install, It creates
the databases but gets an error with the acl.mysql file. It claims “Error
1175: You are using safe update mode and you tried to update a table
wiothout WHERE that uses a KEY column”. The first line of my acl.mysql
file is this “DELETE FROM user WHERE user LIKE 'rt_user”". Any advice
would be greatly appreciated. Thanks.

	Sincerely,					
		-James Adam Sigler-

James Adam Sigler
College of Computing
Georgia Tech
Phone: 404-385-0391
Office: CoC 211
Email: hollow1@cc.gatech.edu

2

Define “the most current stable version”?On Thu, Nov 01, 2001 at 03:15:15PM -0500, James Adam Sigler wrote:

I am using the most current stable version of Mysql and have gotten all
the plugins for rt in place. I am trying to build and install Rt-2-0-8_02
on SUn Solaris. The problem is that when I run make install, It creates
the databases but gets an error with the acl.mysql file. It claims “Error
1175: You are using safe update mode and you tried to update a table
wiothout WHERE that uses a KEY column”. The first line of my acl.mysql
file is this “DELETE FROM user WHERE user LIKE 'rt_user”". Any advice
would be greatly appreciated. Thanks.

–

  Sincerely,					
  	-James Adam Sigler-

James Adam Sigler
College of Computing
Georgia Tech
Phone: 404-385-0391
Office: CoC 211
Email: hollow1@cc.gatech.edu

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

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

3

Define “the most current stable version”?

I am using the most current stable version of Mysql and have gotten all
the plugins for rt in place. I am trying to build and install Rt-2-0-8_02
on SUn Solaris. The problem is that when I run make install, It creates
the databases but gets an error with the acl.mysql file. It claims “Error
1175: You are using safe update mode and you tried to update a table
wiothout WHERE that uses a KEY column”. The first line of my acl.mysql
file is this “DELETE FROM user WHERE user LIKE 'rt_user”". Any advice
would be greatly appreciated. Thanks.

–

  Sincerely,					
  	-James Adam Sigler-

James Adam Sigler
College of Computing
Georgia Tech
Phone: 404-385-0391
Office: CoC 211
Email: hollow1@cc.gatech.edu

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

3.23.43

	Sincerely,					
		-James Adam Sigler-

James Adam Sigler
College of Computing
Georgia Tech
Phone: 404-385-0391
Office: CoC 211
Email: hollow1@cc.gatech.edu