I was able to import the database from os3 to Zhen using a script I found on the internet. Everything looks good all customers and orders are in the zen database. Only one problem the cart does not see the orders. The orders are in the database. If I logon the cart and search the order ID it pull up . If I search by name it gives me this error.
LEGEND: Billing and Shipping does not match
1054 Unknown column 'o.orders_id' in 'on clause'
in:
[select count(distinct o.orders_id) as total from (orders o, orders_status s left join orders_products op on (op.orders_id = o.orders_id) ) left join orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '4' and ot.class = 'ot_total') and (op.products_model like '%sr%' or op.products_name like 'sr%')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Anybody have any ideas ???
Thanks in advance.
Ed
Bookmarks