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.
<EOL> Tib
On Wed, 22 Jun 2005, Tim Altman wrote:
On Wed, 22 Jun 2005 00:42:13 +0200, Tib tib@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.