'ee_accessory' LOCK FAILED with 1.5 beta

[King_Photo]

I have followed the instructions for installation, but keep receiving this error. Any ideas?

[Pekka]

King_Photo wrote:
I have followed the instructions for installation, but keep receiving this error. Any ideas?



If MySQL gives this error it means you do not have privileges to do table locks. Usually locks are daily bread in database handling, so not having this privilege is a bit odd. Contact your server admin and ask if they could change privileges of your mysql username.

I think most system admins forget that there is a new separate privilege setting for lock command, when they update to MySQL v.3 to v.4:

"To use LOCK TABLES in MySQL 4.0.2 you need the global LOCK TABLES privilege and a SELECT privilege on the involved tables. In MySQL 3.23 you need to have SELECT, insert, DELETE and UPDATE privileges for the tables. "
http://www.mysql.com/doc/en/LOCK_TABLES.html

[King_Photo]

Thanks. My SYS ADMIN took care of it.

Royce