I have a live cart based on 1.2.6 (www.justgolfgifts.co.uk) but I have been unable to upgrade to 1.3.6. I have a local development environment and I’ve decided to keep it simple and not try and retain any old customisations – all I want to do is import my database into the new version, create a new custom template based on 1.3.6 and re-launch my site with a new look. However, I can’t import my data and I can’t find the answer in the forums. Help !.

My installation approach is as follows :-

1) Create a new database using phpMyAdmin

2) Install 1.3.6 and select Install. I enter the new database under ‘Database Name’. I do not install the demonstration categories and products. At this point I have an empty database.

3) Import the SQL backup of my live site using phpMyAdmin to the new database name. The query is successfully executed.

4) Re run installation and select ‘Database Upgrade’. I am prompted to Upgrade DB from 1.2.4 to 1.2.5 through to 1.3.5 to 1.3.6 inclusive and I run these one at a time, to trap the errors. Results as follows, with messages shown :-

Upgrade DB from 1.2.4 to 1.2.5
SKIPPED: Cannot create table admin_activity_log because it already exists

Upgrade DB from 1.2.5 to 1.2.6
No message

Upgrade DB from 1.2.6 to 1.2.7
No message

Upgrade DB from 1.2.7 to 1.3.0
SKIPPED: Cannot create table ezpages because it already exists
SKIPPED: Cannot create table meta_tags_categories_description because it already exists SKIPPED: Cannot drop index idx_categories_parent_id_zen on table categories because it does not exist.
SKIPPED: Cannot drop index idx_customer_id_zen on table coupon_gv_customer because it does not exist.
SKIPPED: Cannot drop index idx_paypal_paypal_ipn_id_zen on table paypal because it does not exist.
SKIPPED: Cannot drop index idx_prod_opt_val_id_zen on table products_options_values because it does not exist.

Upgrade DB from 1.3.0 to 1.3.0.1
SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists SKIPPED: Cannot insert configuration_group_title "EZ-Pages Settings" because it already exists

Upgrade DB from 1.3.0.1 to 1.3.0.2
SKIPPED: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists SKIPPED: Cannot insert configuration_key "TEXT_PREFIX" because it already exists

Upgrade DB from 1.3.0.2 to 1.3.5
SKIPPED: Cannot drop index idx_auth_net_id on table authorizenet because it does not exist. SKIPPED: Cannot drop index idx_auth_net_id on table authorizenet because it does not exist. SKIPPED: Cannot drop index idx_auth_net_id on table authorizenet because it does not exist. SKIPPED: Cannot drop index idx_auth_net_id on table authorizenet because it does not exist.

Upgrade DB from 1.3.5 to 1.3.6 takes me to the ‘Congratulations’ page.

When I run zen cart 1.3.6 , I find no categories, products, customers – nothing.
Unfortunately, I'm not a mysql dba and I can't figure out where I'm going wrong. Can anyone guide me please ?. Thanks in advance.