Thread

My client is getting an error when attempting to register a new user manually.
 
MySQL ERROR:

Error Number: 1062

Description: Duplicate entry ‘bc05e4e7c14abbbecd7cc2ecbe9021c140efc5ce’ for key 2

Query: INSERT INTO `exp_members` (`group_id`, `username`, `password`, `ip_address`, `unique_id`, `join_date`, `email`, `screen_name`) VALUES (‘8’, ‘jente’, ‘bc05e4e7c14abbbecd7cc2ecbe9021c140efc5ce’, ‘66.167.102.98’, ‘f076dfa8d26e8b1253fda21fe798d00956e9b40a’, ‘1284600990’, ‘[email protected]’, ‘Joan Ente’)

This “duplicate” entry seems to only be appearing in the database, because the user does not appear in the CP.

Where in the DB should I look for this entry in order to delete it?

Paul,

Can you try a repair and optimize on your database via the SQL Manager in your control panel please?
It would also be a good to make a backup before doing so.

Also what version and build of EE are you using?
Are you using any extensions?

Evening John Henry,

Followed your instructions and the same “duplicate entry” error persists ... I suspected you were a bit of a hack old boy.

Running 1.6.9 with enough extensions to make your hair curl. 

This error only occurs for two users who were entered out of a group of twenty.  I can add NEW names without a problem.

Cheers,
Paul

“Registering manually” refers to using the form in the CP, I suppose? I would suggest to simply remove the offending db record manually, using a tools such as phpMyAdamin. As John Henry said, making & verifying a db backup before you attempt something like that is practically mandatory.

Morning,

“Registering manually” refers to using the form in the CP? 
Yessir, the site is not accepting members per se, this is specifically for content contributors and staff added manually through the CP.

I’ve absolutely made a backup.  What should I be looking for in the DB? 

Snark aside, I appreciate the assistance guys!

My suggestion would be to open the db with something like phpMyAdmin, find exp_members, then search for the duplicate string and delete the whole record. Makes sense?

Thanks.

This is getting more interesting. Using phpMyAdmin, the names throwing the duplicate entry error do NOT appear in the exp_members table.

Hi Paul,

Would you please go to CP Home > Admin > Utilities > SQL Manager > Database Query Form and run this:

describe exp_members

Then please take a screenshot making sure to include at all the lines down to at least ‘authcode’ and post it here.

Cheers

Greg

Screenshot attached

Paul,

Running 1.6.9 with enough extensions to make your hair curl.

Can you list them along with any third party modules as well please.

Also try disabling extensions temporarily using the large green button on the top right of the extensions screen. This allows you to disable without deleting any settings. Don’t disable individually.

Disabling extensions then attempting to add the names of the two members results in the same error note above.

MySQL ERROR:

Error Number: 1062

Description: Duplicate entry 'bc05e4e7c14abbbecd7cc2ecbe9021c140efc5ce' for key 2

Query: INSERT INTO `exp_members` (`group_id`, `username`, `password`, `ip_address`, `unique_id`, `join_date`, `email`, `screen_name`) VALUES ('7', 'jente', 'bc05e4e7c14abbbecd7cc2ecbe9021c140efc5ce', '66.190.94.46', 'fd9627ca04635dfc5a2addb7adac02e6ecdb57bf', '1287115276', '[email protected]', 'Joan')

Extensions used:
Fieldframe
structure
edit tab ajax
gypsy
required category
md character count
calendar
tracker
category checkboxes
entry reedirect
login redirect
low nospam
add sitename

Modules used:
Calendar
freeform
low nospam
sitemap
structure
tracker

It looks like you already have an entry with username “jente” in exp_members. Can you conform that?

I’ve attached a screenshot form PHPMyAdmin showing all the current members.

Jente is not listed.

Paul, do you have the same number of entries for:

exp_members
exp_member_data
exp_member_homepage

exp_members= 25 records
exp_member_data = 56 records
exp_member_homepage = 56 records

Half of both the data and homepage rows show member_id 0 (zero)