Error using groups

[brittney]

Exhibit Engine MySQL error!
ERROR FROM QUERY lock_groups in page 'exhibition_group_editor':

------------------------------
Access denied for user: 'du00007876@%' to database 'db00000876'
------------------------------

If you encounter this error with unmodified EE source code please mail this error to EE developers with version number, detailed circumstances when it happened and preferably with a database backup dump. All reports helps improving EE to your satisfaction. Thank You.

This is an error i get when i tried assigning a exhibition to a group. the @% should not be in the username.

Cheers
Bri

[Pekka]

You need LOCK TABLES privileges for mysql. Ask your system admin to grant them for you (lock privilege should be basic one, but most admins mess it up when updating mysql server).
Read also http://photography-on-the.net/forum/showthread.php?t=76923 and if you have new installation: http://photography-on-the.net/forum/showthread.php?t=177875

[segal3]

Does this need to be per database user, or is it a general server setting?

[Pekka]

It is a per user setting.

[segal3]

Assuming for the moment that my host would not grant user permissions for LOCK TABLES - is there any safe way to get past the error? (in some manner of removing the LOCK/UNLOCK coding?)

[Pekka]

Delete

$lock_groups = mysql_query(
"
LOCK TABLES
ee_exhibition_to_group WRITE
"
);
ee_error ($lock_groups,"lock_groups",$currentpage);

and

$unlock_grooups = mysql_query(
"
UNLOCK TABLES
"
);
ee_error ($unlock_grooups,"unlock_grooups",$currentpage);

But I would suggest to change ISP if they refuse to grant lock privileges:
- lock privileges are basic tool in database integrity protection and security, there is no reason NOT to grant them
- EE 2.0 requires lock privileges

[segal3]

Granted - appreciate the additional motivation that EE2 would require the permissions :)