Captcha has been working perfectly in text math question for sometime but now, if i add or take away anything from the anonnymous role points system i get the following mysql errors

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', 'Duplicate entry 'user_login_block_Awaiting_email_confirmation_cap' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('user_login_block_Awaiting_email_confirmation_captcha', 'i:0;') in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121.', 2, '', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', '82.14.201.41', 1167173866) in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121

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', 'Duplicate entry 'user_register_Awaiting_email_confirmation_captch' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('user_register_Awaiting_email_confirmation_captcha', 'i:0;') in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121.', 2, '', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', '82.14.201.41', 1167173866) in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121

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', 'Duplicate entry 'contact_mail_user_Awaiting_email_confirmation_ca' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('contact_mail_user_Awaiting_email_confirmation_captcha', 'i:0;') in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121.', 2, '', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', '82.14.201.41', 1167173866) in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121

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', 'Duplicate entry 'contact_mail_page_Awaiting_email_confirmation_ca' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('contact_mail_page_Awaiting_email_confirmation_captcha', 'i:0;') in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121.', 2, '', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', 'http://www.porttalbotchat.co.uk/admin/settings/captcha', '82.14.201.41', 1167173866) in /home/weplycom/public_html/porttalbotchat-co-uk/includes/database.mysql.inc on line 121

I've never had this before so have no idea why it happens. Oddly enough the captcha's work fine and there are no problems encountered when i try and use them. But everytime i change an option in Caption from off to on or vice versa i now get this.

Any ideas ?

Comments

Oreps’s picture

Oreps commented

I have the same problem when posting to my blog

andrewfn’s picture

andrewfn commented

I got exactly the same thing for the first time today, but I wasn't using captcha. I am using the Dec 25th version of HEAD / Drupal 5.x

andrewfn’s picture

andrewfn commented

I have resolved the problem--it was to do with an access problem to the hosting company's MySQL database. It was not Drupal's fault.

heine’s picture

heine commented
Category: bug » support
Status: Active » Fixed

This problem even has its own entry in the Troubleshooting FAQ.

desm0n’s picture

desm0n commented
Category: support » bug
Priority: Critical » Normal
Status: Fixed » Postponed (maintainer needs more info)

Troubleshooting FAQ ? For this module ? Wheres that then ?
My issue remains open ...

heine’s picture

heine commented

I see now. Captcha should use shorter names for variable_set.

As a temporary workaround, change the size of the name column for the variable table so the variable fits:

ALTER TABLE variable CHANGE name name varchar(128) NOT NULL default '';
desm0n’s picture

desm0n commented

Thanks Heine. I haven't done the sql yet but would this have any knockon effects to other modules or future upgrades ? If so i'd sooner leave it as is than alter a table for one module.

As i say its functioning perfectly well regardless of the sql error, i have no idea what the module does to that particularly field.

soxofaan’s picture

soxofaan commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Closing this issue:

  • Maintenance and support for the CAPTCHA module for drupal 4.7 are already a long time inexistent. Considering that the Drupal 4.7 branch is now officially unmaintained due to the recent Drupal 6.0 release, it is very unlikely this will change.
  • The issue is not applicable to the now recommended 5.x-3.x and 6.x-1.x branches.