Getting the following message when saving my settings on the captcha admin page, no matter what settings I use. I see the permission links for captcha under "access control", but the captcha itself is not working / not displayed or used on any of the captcha points I specified when saving the settings which gave me this 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', 'Duplicate entry 'user_login_block_fully_authenticated_user_captch' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('user_login_block_fully_authenticated_user_captcha', 'i:0;') in /home/mysite/public_html/includes/database.mysql.inc on line 120.', 2, '', 'http://www.mysite.org/admin/settings/captcha', 'http://www.mysite.org/admin/settings/captcha', '66.36.139.16', 1153152315) in /home/mysite/public_html/includes/database.mysql.inc on line 120

Comments

wundo’s picture

wundo commented
Assigned: Unassigned » wundo
Priority: Critical » Normal

Steven, could you please discribe better your problem and your environment?
What drupal version are you using?
Any special module?

phoolish’s picture

phoolish commented

Steven,

Try changing the character length of the role fully_authenticated_user to something like full_user. I had the same problem and changed the char length and now it works great.

lucky a’s picture

lucky a commented

I had the same error. Using Drupal 4.7.3 with the cvs captcha. Would Get the above mentioned error every time I hit "save settings" in admin->settings.

After changing the name of the full admin role from Администратор то Админ (my site is in russian) as suggested above, the error went away. However, the solution seems too empirical even for my experimental physicist's taste :) , so a more systematic solution would be appreciated :)

mj2308’s picture

mj2308 commented

Also had the same problem and changing the name of the role did solve the problem, so this does seem like the source of the bug

wundo’s picture

wundo commented
Status: Active » Fixed

Seens to be solved in the last version...

wundo’s picture

wundo commented
Status: Fixed » Closed (fixed)
desm0n’s picture

desm0n commented

Not for me it wasn't :(
Still the same errors. although the Captcha activates and works perfectly.

wundo’s picture

wundo commented
Status: Closed (fixed) » Postponed (maintainer needs more info)
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 old issue is not applicable to the now recommended 5.x-3.x and 6.x-1.x branches.