Error updating database

[DaveS]

Hi, I'm attempting to upgrade my database from 1.3.6 to 1.3.7 but whenever I hit the 'update database now' button it gives me the following error..

1062 Duplicate entry '0' for key 1
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Credit Card Enable Status - SOLO', 'CC_ENABLED_SOLO', '0', 'Accept SOLO Card 0= off 1= on', '17', '8', 'zen_cfg_select_option(array(\'0\', \'1\'), ', now());]


Can anyone suggest what I am doing wrong?

Cheers,
Dave

[DaveS]

So I spent 3 hours trying to fix this, then posted the question here, then thought to use the search button...

The answer is here if anyone needs it

http://www.zen-cart.com/forum/showth...t=35770&page=2

[DrByte]

Actually, the CORRECT answer is to follow the documented upgrade instructions in the /docs folder (or in the SQL file itself) .... which instructs you to run the zc_install/index.php program via your browser in order to do the database upgrade.

The upgrader in the zc_install program will handle those exceptions automatically for you.

[DaveS]

Not sure if it's a problem at my end but that's what I did, it was when I was hitting the "upgrade database" button in zc_install that it gave me the error.

I still had my main database live and was working on a test install. Whenever I backed up my live database (using my hosts control panel) and then imported it to my test one, it gave that error when I used zc_install.

In the end I exported the database in phpmyadmin, removed a couple of lines with the live database name in them and imported to my test database, Worked fine then.