[CMS] LOCK TABLES cms_node

[murdof]

Hi - i would appreciate an answer on:

http://www.vbulletin.com/forum/showthread.php?326874-Help&p=1886145#post1886145

The problem occurs on my installation as well - with final version.
No answer was given for the beta version.

Since it is a problems issue maybe you should also move it here and delete this thread.

[pretke]

same

[murdof]

OK here is the solution to the problem.

I have been using an old version of SQLyog to manage the permissions on the tables.
The old version didn't include the permission for LOCK TABLES hence it was not updated.
Although you thought you had set permissions for everything on the database - that wasn't true.

I updated to latest community version of sqlyog and then i saw that there were 5-6 more permissions - including LOCK TABLES.
I updated the user with those permissions as well and now it works.

[rughis]

I've installed CMS 4.0.8 from scratch on a Linux system and I receive the same error.

I have not understood the solution, can you help me?

Thank you in advance

[Wayne Luke]

You need to give your database user permissions to lock tables. Your hosting provider can assist with assigning permissions on MySQL if you're not using CPanel or a similar control panel.

[rughis]

You need to give your database user permissions to lock tables. Your hosting provider can assist with assigning permissions on MySQL if you're not using CPanel or a similar control panel.

Hi Wayne thank you for your support.

Can I give my database user permissions to lock table with phpmyadmin?

Thank you again.

[Wayne Luke]

Only if you can log in with a user capable of assigning permissions like a root user. Usually phpMyAdmin is restricted.

[rughis]

Only if you can log in with a user capable of assigning permissions like a root user. Usually phpMyAdmin is restricted.

OK

The problem has been fixed with the help of my hosting provider

[biancolaw]

I am using 4.1.1 and having this same error and when I check permissions, my db user HAS lock table permissions?