The captcha module stores its data in the variables table. The name field of this table is only 48 characters wide (by default?), while captcha tries to store a name like 'guestbook_form_entry_form_authenticated_user_captcha' in my setting (captcha+form store+form collect). This gets trunctated (by mysql I guess) to 'guestbook_form_entry_form_authenticated_user_cap', which is basicly equivalent to ... err ... not storing it at all. Moreover, it results in 'duplicate entries'-error messages like this:

"""
user warning: Duplicate entry 'guestbook_form_entry_form_authenticated_user_cap' for key 1 query: INSERT INTO variable (name, value) VALUES ('guestbook_form_entry_form_authenticated_user_captcha', 's:12:\"captcha/Math\";') in ...../includes/database.mysql.inc on line 172.
"""

Shouldn't the captcha module use a table of its own for storing its settings?

Comments

soxofaan’s picture

soxofaan commented
Status: Active » Closed (fixed)

I rewrote the captcha module myself to use a table for the captcha_points: see thread http://drupal.org/node/153395 .
Closed this issue.