I've had a number of user profiles with their custom profile fields over written recently.

I think I've tracked this down to having users_uid in the sequences table out of sync with my users table (I imported them from another site and wasn't aware of the users_uid counter)

My MySQL Log shows the following:
INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'D
uplicate entry '9' for key 1\nquery: INSERT INTO users (name, mail, pass, init, status, uid, created) VALUES ('Berrytuiom'
, 'berry@qters.info', '7bc7d38767610d48ee8973e3732ee546', 'berry@qters.info', 1, 9, 1190036935) in
/path/to/drupal/includes/database.mysql.inc on line 172.', 2, '', 'http://www.mysite.net/user/register', 'http://www.mysite.net/user/register', '72.9.105.42', 1190036935)

This shows the duplicate entry error as the users_uid is out of sync. Following that in my mysql.log I see a number of DELETE/INSERT statements updating the profile_values table for all the fields visible on the registration form for the already existing uid.

Basically, the registration process continues (even sending an email) even though there was an error pretty much first thing in the proces.

Comments

quarsan’s picture

quarsan commented

We've got the same issues and a lot of unhappy users and an angry client.

Christefano-oldaccount’s picture

Christefano-oldaccount commented
Status: Active » Postponed (maintainer needs more info)

It sounds like the 'users' table was manually changed but the 'sequences' table wasn't properly adjusted. Can you explain how this is a bug in Drupal if the tables were left out of sync by administrator error?

dpearcefl’s picture

dpearcefl commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

Due to the age of the last comment on this issue and due to the fact that D5 is no longer supported, I am closing this issue.