1062 Duplicate entry 'Administrator' for key 2

[Renz]

Upgrade Issue

--------------------------------------------------------------------------------

Hi There,

I wonder if anyone can point me in the right direction, I am having a problem updating my database from this.......

Zen Cart 1.3.0.2
Database Patch Level: 1.3.0.1

This is the error:


1062 Duplicate entry 'Administrator' for key 2
in:
[INSERT INTO query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]
What to do....what to do..........Lost!!

Many Thanks in advance

[DrByte]

This is caused by re-running the upgrade a second time.

To work around it, edit the /zc_install/mysql_upgrade_1301_to_1302.sql file
find the line that says

INSERT INTO query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');

and change the first word "INSERT" to "REPLACE".

Then re-upload the file and rerun the upgrade.

You could also change "INSERT" to "#INSERT" (just add the # in front of it, to skip that line altogether)

[cmc_entertainment]

thanks for that DR, it worked for me

[rcmh]

thanks! I had the exact same problem...minutes later fixed. God I love you guys! Thanks again!

[oceano]

me three!!

thanks -

[Karina_L]

.....
and change the first word "INSERT" to "REPLACE".

Then re-upload the file and rerun the upgrade.

You could also change "INSERT" to "#INSERT" (just add the # in front of it, to skip that line altogether)

Changing to "REPLACE" didn't work.... but changing to "#INSERT" did!

[bigjoed]

I'm getting this same error every once in a while but I'm running zen-cart-v1.3.5. How could I fix this?

thanks

[DrByte]

I'm getting this same error every once in a while but I'm running zen-cart-v1.3.5. How could I fix this?

thanks

what is the "exact" error you're getting?
The error discussed above is specific to performing a site-upgrade, which you shouldn't be "getting every once in a while" ...

[bigjoed]

Error is too long to post here, this is part of the error.

1062 Duplicate entry 'zc_7eb4ed1f36d90140477d9474b61e0e26' for key 1
in:
[insert into zen_db_cache set cache_entry_name = 'zc_7eb4ed1f36d90140477d9474b61e0e26', cache_data = 'a:572:{i:0;a:2:{s:6:\"cfgkey\";s:10:\"STORE_NAME\";s:8:\"cfgvalue\";s:6:\...... ....<edited>......:\"


I noticed that it normally happens after I reboot my computer.

[DrByte]

It appears you are having an intermittent caching problem.

Change your configure.php files to say this:

define('SQL_CACHE_METHOD', 'none');