Whenver I create or update a form I get the following warning:

user warning: Access denied for user 'user'@'localhost' to database 'database' query: LOCK TABLES webform_component WRITE in D:\Inetpub\www-drupal\includes\database.mysqli.inc on line 330.

[note: database info altered just in case]

The form works fine, I just get the warning each time. Any suggestions on how to resolve this?

Thanks

Comments

quicksketch’s picture

quicksketch
he/him
commented

It seems like the use you are using to connect to your Drupal database does not have the "LOCK TABLES" permission. I'd try going into phpMyAdmin through your webhost and increase the permissions that your database user has to the Drupal database.

pehedges’s picture

pehedges commented
Status: Active » Closed (fixed)

Sorry for the delay getting back to this. We added LOCK TABLES permissions to the drupal user and that did the trick. No more warnings. Thanks for your help.

Paul

bonobo’s picture

bonobo commented
Component: Code » Documentation
Status: Closed (fixed) » Active

I ran into this error on a vanilla drupal install where I was doing some testing/eval work around webforms.

Adding the LOCK TABLES privilege to the db user made this error go away, but I figured that, seeing as how the LOCK TABLES privilege is no longer required for D6 (and is left out of the list of required privileges in the install.mysql.txt file), if it is required for this module it would be good to document this requirement in the install.txt

I did a quick read through the install docs for webform on this, and didn't see anything, but I was reading quickly, so it's possible I overlooked this.

NoCoolNamesRemain’s picture

NoCoolNamesRemain commented

Is this issue going to be addressed? If D6 no longer require LOCK TABLES should this module be written differently so it also does not require it? I do not like the above workaround of simply giving database users privileges they do not need as a long term solution...

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Closed (fixed)

For the time being, the "Lock tables" permission will remain required. I've updated the requirements list on the project page. Let's consolidate this request with #389282: Webform shouldn't lock the "webform_components" table on insert, use locking framework instead