Dear Sir/Madam,
I tried to upgrade my zen cart site from v1.1.2 to v1.3.9h.
In the upgrade process, I kept getting error messages like
1062 Duplicate entry '1' for key 1
in:
[INSERT INTO product_types VALUES (1, 'Product - General', 'product', '1', 'Y', '', now(), now());]
1062 Duplicate entry '1-1' for key 1
in:
[INSERT INTO paypal_ipn_address_status VALUES (1, 1, 'confirmed');]
1062 Duplicate entry '1-1' for key 1
in:
[INSERT INTO paypal_ipn_address_status VALUES (1, 1, 'confirmed');]
and for many other tables. I pressed F5 to refresh, but it just got stuck and the upgrading process was not able to move on -
So I did a flash install on the v1.3.9 and exported its the database. Compare the v1.1.2 database to v1.3.9h database, and just add new columns directly to v1.1.2 database. The same result with 1062 error message - failed miserably.
I searched the forum, some said I have to use alter table commands in phpmyadmin. I found in the v1.3.9.h \zc_install\sql there are a lot of files containing sql commands and tried to execute them one by one within the phpmyadmin database - failed again.
the 1062 duplicate entry messages are still there and once again, I stuck.
I tried the mysql database v4.1 and 5.0, and the hosting company is goDaddy.com.
Also, I know this may not be relevant, but does anyone know how I can change file permission for the entire directory (including subdirectories and files) to 777 using Putty (ssh). goDaddy does not support ssh, although they admit ssh is the most efficient way to change permission for all subdirectories and files.
Please kindly advise how I can solve this database issue.
Thank you very much -
Bookmarks