CAPTCHA doesn't work: no uid=0 in users table [#293508]

I've tried to get the latest release of the Captcha and Captcha Pack to function, without success.
I'm running v6.3 of Drupal. I've completed removed the Captcha modules and then re-installed with no luck. I've tried the image captcha and it didn't appear. The text captcha and the math captcha both generate "Invalid Captcha Token" when they're used.

The only place I'm using the captcha is for user account creation.

Comments

Comment #1

soxofaan commented 11 August 2008 at 07:53

Status:

Active

» Postponed (maintainer needs more info)

what do you mean with the latest release? The latest "stable" release (6.x-1.0-rc2) or the development version (6.x-1.x-dev)?

Does it work with the basic math CAPTCHA provided by the CAPTCHA module? Your issue is probably not related to CAPTCHA pack, so let's keep it out of the discussion to make things easier.

Does it work on other forms like for example the comment form?

Could you also test the CAPTCHA with an authenticated user (but without the skip CAPTCHA permission)?

Comment #2

Anonymous (not verified) commented 11 August 2008 at 16:27

Status:

Closed (duplicate)

» Postponed (maintainer needs more info)

soxofaan,

thanks for the response. I've tried both releases with the same result.
the math captcha doesn't work either. I see the math question but when I provide an answer I get the "Invalid Captcha" response back.

I haven't tried this on any forms as yet, but I hesitate in doing so. The site I'm having problems with is on-line and I don't want to screw it up.

I'm only using the captcha when a new account is created. I'm not sure how I'd test this with an authenticated user in this situation.

I've also checked to see if I have an entry in the user table of the database in the first field (0) and I do not. I read about this in earlier reports.

On a side note I've installed the Captcha module in a test Drupal 6.3 site and it works. There's obviously something different with the installation that I'm having the problem with but I haven't been able to pin anything down. I'm running the same Drupal core (v6.3) with essentially the same modules (if you need a list let me know).

Comment #3

soxofaan commented 11 August 2008 at 16:25

Status:

Postponed (maintainer needs more info)

» Closed (duplicate)

I've also checked to see if I have an entry in the user table of the database in the first field (0) and I do not.

Then you should add an entry for uid=0 in the users table :)
CAPTCHA won't work for anonymous users if you don't have this entry.

duplicate of
#245451: Image is not visible because of no uid=0 in users table
#243285: Captcha not working when no sessions for anonymous
#179915: Resolved: Captchas don't work on second site (was missing user UID 0 in database)
#204095: Error: 'Cookies should be enabled in your browser for CAPTCHA validation.'

Comment #4

Anonymous (not verified) commented 11 August 2008 at 17:04

Status:

Postponed (maintainer needs more info)

» Closed (duplicate)

Got it. Thanks.
Out of curiosity I would believe that this little problem is bugging lots of people as I've seen in the support reports. How does the "0" UID get there in the first place? does the Captcha module create it?

Comment #5

soxofaan commented 12 August 2008 at 08:11

Title:

Captcha Doesn't Work

» CAPTCHA doesn't work: no uid=0 in users table

The entry should be there by default, it's part of the Drupal's installation procedure:
see line 350-362 of system.install:
http://cvs.drupal.org/viewvc.py/drupal/drupal/modules/system/system.inst...

There are situations where the entry can get lost however, for example in a back/restore situation or a database move, especially with MySQL databases I think.

In http://drupal.org/cvs?commit=116712 (which was after 6.x-1.0-rc2) a check was added that will add an error message on the Drupal status report if there is no uid=0. It could be extended however with a callback that adds an entry for uid=0.