[drupal-support] User registration issue

[Tim Altman]

On Wed, 22 Jun 2005 13:54:45 +0200, Tib <tib at tigerknight.org> wrote:

> On Wed, 22 Jun 2005, Tim Altman wrote:
>
>> On Wed, 22 Jun 2005 00:42:13 +0200, Tib <tib at tigerknight.org> wrote:
>
>> The first time I registered an account outside the admin one through the
>> web pages (for anonymous users) it worked fine. But now every time after
>> I
>> am getting the following error and I'm not sure what to do. The UID
>> number
>> is incrementing, but because of the 'duplicate' error, the accounts  
>> never
>> get created. What's going on?
>>
>> user error: Duplicate entry '' for key 2
>> query: INSERT INTO tib_users (pass, created, changed, uid) VALUES
>> ('8ea960a46ddefee8f7c895deb6d089a2', '1119393043', '1119393043', '8') in
>> /home/tib/public_html/includes/database.mysql.inc on line 66.
>
> 	Have you added a prefix to the sequences table?  This error and the
> previous one you posted could be explained if that table wasn't being
> updated correctly.
>
> I had gone through and re-prefixed all the tables associated with this
> site by hand earlier in the day. I did it again a few hours later and
> things seemed back to normal. What sort of marker is the 'created' field?
> Seconds, date hash, etc. Was I just trying too often and it didn't move  
> on to the next number? The contents of the table itself look normal.

	I think I may have been wrong after looking at this a bit more.  The  
created field should be a UNIX timestamp.  I don't know why you're getting  
that error.

-- 
Tim Altman