Errors upgrading from v1.3.0.2 (due to bad db import)

Hi Dr. Byte

I had the exact same problem as this, [select admin_id, admin_name, admin_pass from admin where admin_name = 'admin'] and proceeeded to update the database 1 version at the time. I got from 132 to 137 and then I got the following error.

Can you please assist.

Thanks

Renz

1062 Duplicate entry 'Customers who have never completed a purchase' for key 2
in:
[INSERT INTO query_builder (query_category, query_name, query_description , query_string) VALUES ('email,newsletters', 'Customers who have never completed a purchase', 'For sending newsletter to all customers who registered but have never completed a purchase', 'SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL');]

You'll have to manually run this database query before you can proceed: ```
delete from query_builder where query_name = 'Customers who have never completed a purchase';

Hi there,

I have done that which allowed me to proceed to patch lever 138.

I got the following errors and I am still unable to see clients orders or anything relevant in the db.

Thanks for your help

Regards

Renz

SKIPPED: Cannot insert configuration_key "SHOW_SHOPPING_CART_COMBINED" because it already exists
SKIPPED: Cannot insert configuration_key "ORDER_COMMENTS_INVOICE" because it already exists
SKIPPED: Cannot insert configuration_key "ORDER_COMMENTS_PACKING_SLIP" because it already exists
SKIPPED: Cannot insert configuration_key "ORDER_COMMENTS_PACKING_SLIP" because it already exists
SKIPPED: Cannot ADD column module_name because it already exists.
SKIPPED: Cannot ADD column module_mode because it already exists.
SKIPPED: Cannot ADD column module_name because it already exists.
SKIPPED: Cannot ADD column module_mode because it already exists.
SKIPPED: Cannot create table nochex_apc_transactions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot create table nochex_sessions because it already exists
SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
SKIPPED: Cannot ALTER or INSERT/REPLACE into table linkpoint_api because it does not exist. CHECK PREFIXES!

Hi Dr.

any ideas on the last 3 issues or should I start a new thread...

These are my steps so far.

Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
v1.3.8 [2010-06-16 09:42:49] (Version Update 1.3.7->1.3.8)
v1.3.8 [2010-06-16 08:23:26] (Version Update 1.3.7->1.3.8)
v1.3.7 [2010-06-15 16:21:45] (Version Update 1.3.6->1.3.7)
v1.3.6 [2010-06-15 16:20:57] (Version Update 1.3.5->1.3.6)
v1.3.5 [2010-06-15 16:10:23] (Version Update 1.3.0.2->1.3.5)
v1.3.8 [2010-06-11 15:46:50] (Fresh Installation)

Thanks

RR

Errors...and there is nothing visible in the store

SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
SKIPPED: Cannot CHANGE column zen_order_id because it does not exist.
SKIPPED: Cannot ALTER or INSERT/REPLACE into table linkpoint_api because it does not exist. CHECK PREFIXES!

I'm not bothered much by those warnings, since they're almost all likely related to having done partial upgrades previously, and they're simply reporting that things are already done, as they should.> Renz:

I am still unable to see clients orders or anything relevant in the db.

Renz:

...and there is nothing visible in the store
Is the data actually there?
I'm guessing it is there, but maybe in a different set of tables due to DB_PREFIX mismatches between old and new? How many tables are in your database?

Hi Dr.

I think the data is there as well as for instance there are 509 entries in the address book (looking at the DB tables)

There are 95 entries in the DB

Thanks

RR

Hmm ... puzzling that you say nothing's visible in the store then.
How many records are in your products table? and your products_description table? and your products_to_categories table? and your categories table?

Uhmm

Yes perhaps you are onto something....all those values are 0 thats weird because they are all in the import of the db I am using..Exported from one site and imported to another for upgrading.

Not sure why they are not showing...
Thanks
RR

That sounds like your import isn't working properly.

Yup BAD BAD..import...just did it again and lots more numbers in the db. Just about to run the ZC_Install DB upgrade..

Should be good though

:clap: Thanks Dr....