Zen Cart Logo
Forums / Managing Customers and Orders / zen_order does not exist error in database no orders show in admin

zen_order does not exist error in database no orders show in admin

Locked

Views: 864

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
23 Mar 2010, 2:56 PM
#1
lyon avatar

lyon

Zen Follower

Join Date:
Jul 2004
Posts:
68
Plugin Contributions:
0

zen_order does not exist error in database no orders show in admin

Using Zen version Zen Cart 1.3.8a with php version 5.2.8

I was trying to import data from an old database for customers orders. changes all file names from 'orders' to 'zen_orders' and used sql to insert into and come back with an error code table 'zen_orders' does not exist. I can see it in my phpAdmin.

I tried a couple of test orders. The shopping cart processes the orders, sends all the appropriate emails but the order history page in both the admin area and the customer account are blank.

The orders are showing up the Paypal IPN for that option.

Also both the shopping cart and the admin are taking forever to load. The main site is running fine.

Can someone please tell me how to fix the database so it realizes it has those tables?

23 Mar 2010, 9:33 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: zen_order does not exist error in database no orders show in admin

I was trying to import data from an old database for customers orders.
Old?? What version?

Unless you know the ins & outs of mysql - This is not the way to get outside tables into a NEW DB
You should be importing the full previous DB and upgrading it via zc_install

23 Mar 2010, 9:42 PM
#3
lyon avatar

lyon

Zen Follower

Join Date:
Jul 2004
Posts:
68
Plugin Contributions:
0

Re: zen_order does not exist error in database no orders show in admin

Thanks. I restored the clean database and it's working now. I'm just going to not worry about the old orders. They're all closed anyway.