Thread

I went to back up a client’s installation and found that of a 489Mb mySQL db, 410 of it was in the table ‘exp_captcha’.

Can this table be emptied without disrupting EE’s operations?

Thanks,

Greg

Greg,

Yes I believe it can. But make a backup first to be on the safe side.

I emptied my exp_captcha table three days ago. It now has 19,000 records (on a site with quite moderate traffic). The IP addresses in the table seem to be mostly bots (legitimate ones—Google etc.). As far as I know I have CAPTCHAs turned off at every point in the preferences for my site. Any ideas about where this could be coming from, or a comprehensive list of all the places that CAPTCHAs might be invoked?

Thanks in advance—

Andy

Andy,

Any ideas about where this could be coming from, or a comprehensive list of all the places that CAPTCHAs might be invoked?

Admin > System Preferences > Captcha Preferences
Admin > Email Configuration
Members > Member Preferences

and lastly in the individual Channel Preferences themselves under commenting

Thanks, John. This is the odd thing: none of my channels (=weblog in 1.x right?) have commenting enabled, and all had CAPTCHAs turned off anyway.

Also, a number of the entries in the exp_captcha table from the past several days have my own computer’s IP address, but I have never been presented with a CAPTCHA image in anything I’ve done on the site.

Any further ideas? This is not a critical issue, so I can probably live with it and just empty the table periodically. But I’d rather solve it if possible.

Andy

Perhaps you have turned on CAPTCHAS for other parts of your site, particularly member signup? Have you checked you web server log, how much incoming traffic is there?