Email
Share

We Rock Your Web Forum » Content Management Systems » Drupal

Warning: Table 'watchdog' was not locked with LOCK TABLES

(7 posts)

  1. tweeter

    member
    Joined: Oct '09
    Posts: 19

    Reputation:28
     

    I'm running the webform module on a Drupal 5.x installation. Whenever I try and add a form component, I get the following error:

    Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO
watchdog (uid, type, message, severity, link, location, referer, hostname,
timestamp) VALUES (1, 'php', '<em>Unknown column
'form_key' in 'field
list'\nquery: INSERT INTO webform_component (nid, cid, pid,
form_key, name, type, value, extra, mandatory, weight, email) VALUES (3503, 1,
0, 'okok', 'okok',
'textfield', '',
'a:1:{s:8:\\&quot;disabled\\&quot;;i:0;}',
0, 0, 1)</em> in
<em>/home/example/public_html/includes/database.mysql.inc</em>  on
line <em>174</em>.', 2, '',
'http://www.example.com/node/3503/edit/components/new/textfield?name=okok&mandatory=0&email=1&pid=0&weight=0',
'http://www.example.com/node/3503/edit/comp in
/home/example/public_html/includes/database.mysql.inc  on line 174
    Posted 1 year ago #


  2. Posted 1 year ago

  3. Anonymous



    Try repairing the watchdog table in phpMyAdmin via the following SQL command: REPAIR TABLE watchdog USE_FRM

    Posted 1 year ago #

  4. tweeter

    member
    Joined: Oct '09
    Posts: 19

    Reputation:28
     

    Tried that and got the following error message at the end of the repair operation:

    drupal.watchdog | repair | error | Not enough memory for blob at 9688 (need 959917617...)
drupal.watchdog | repair | status | Operation failed

    Furthermore, I now get the following error (in addition to the LOCK TABLES error I'm already getting):

    Warning: Table './drupal/watchdog' is marked as crashed and last
(automatic?) repair failed query: INSERT INTO watchdog (uid, type, message,
severity, link, location, referer, hostname, timestamp) VALUES (1, 'php',
'<em>Cannot modify header information - headers already sent by (output
started at
/home/example/public_html/includes/database.mysql.inc:174)</em> in
<em>/home/example/public_html/includes/common.inc</em> on line
<em>323</em>.', 2, '',
'http://www.example.com/node/3501/edit/components/new/textfield?name=Testing&mandatory=0&email=1&pid=0&weight=0',
'http://www.example.com/node/3501/edit/components/new/textfield?name=Testing&mandatory=0&email=1&pid=0&weight=0',
'174.111.22.165', 1279579695) in
/home/example/public_html/includes/database.mysql.inc on line 174
    Posted 1 year ago #

  5. cwd

    senior admin
    Joined: Jul '09
    Posts: 225

    Reputation:244
     

    Sounds like you need to increase your PHP memory in php.ini. Ask your hosting provider - they should be able to do this for you.

    Posted 1 year ago #

  6. tweeter

    member
    Joined: Oct '09
    Posts: 19

    Reputation:28
     

    Thanks, that did it. Repair operation succeeded. However, now I'm back to getting the LOCK TABLES error. I updated Drupal 5.x core and webform module, still no luck. Any other ideas?

    Posted 1 year ago #

  7. cwd

    senior admin
    Joined: Jul '09
    Posts: 225

    Reputation:244
     

    Try uninstalling and re-installing the webform module (with the latest version), as well as deleting and re-uploading the modules/watchdog folder. And you may want to delete all the webform content as well - backing up info in case you need to re-create them.

    Posted 1 year ago #

  8. tweeter

    member
    Joined: Oct '09
    Posts: 19

    Reputation:28
     

    That did it! Thx CWD

    Completely uninstalling webform and re-installing it fixed the issue. I also increased the name varchar for the variable table from 128 to 255, but that was earlier and didn't seem to affect anything.

    Posted 1 year ago #

RSS feed for this topic

Reply

(required)

Allowed markup: BBcode blockquote code em strong ul ol li font strike center u hr.
You can also put code in between backtick ( ` ) characters.