Customer Default Email Preference duplicate entries

[notset4life]

Upraded to 1.39h and everything went well. However, In Admin/Customer Details, here is the screen I see. There are a bunch of duplicate files for Customer Default Email Preference. Have no idea why. Any feedback on this?
thanks

----------------------------------------------------------------------
Email Salutation true Info
Date of Birth true Info
Company true Info
Address Line 2 true Info
State true Info
State - Always display as pulldown? false Info
Create Account Default Country ID United States Info
Fax Number true Info
Show Newsletter Checkbox 1 Info
Customer Default Email Preference 0 Info
Customer Default Email Preference 0 Info
Customer Default Email Preference 0 Info
Customer Default Email Preference 0
Customer Default Email Preference 0 Info
Customer Default Email Preference 0 Info
Customer Default Email Preference 0 Info
Customer Default Email Preference 0 Info
Customer Product Notification Status 1 Info
Customer Shop Status - View Shop and Prices 0 Info
Customer Approval Status - Authorization Pending 0 Info
Customer Authorization: filename customers_authorization Info
Customer Authorization: Hide Header false Info
Customer Authorization: Hide Column Left false Info
Customer Authorization: Hide Column Right false Info
Customer Authorization: Hide Footer false Info
Customer Authorization: Hide Prices false Info
Customers Referral Status 0

[DrByte]

Looks like you've run the v1.2.2-to-v.1.2.3 upgrade script several times for some peculiar reason.

Those symptoms also suggest that your "configuration" table is missing its unique index on configuration_key, and as such could possibly have many *other* duplicate entries as well.

You'll want to clean up those duplicates. I suggest keeping only the first (lowest configuration_id value) of each as the main, and deleting the others that are duplicates.

[notset4life]

Thanks DrByte. I deleted those dupes. These are the only dupes I found.

do you have a sql statement that I can add to the table?

[DrByte]

alter table configuration add unique index unq_config_key_zen (configuration_key);

[notset4life]

Thanks much for this. In fact, just that sql line was a very useful tool as it pointed me right to some
more duplicates. All have been in there for 5 years.

Anyway, you were spot on, thanks again