Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

How do I upgrade Nov 9, 2001 db to current db????


Recommended Posts

I know there have been some conversations online regarding how to do this using the stuff in the extras folder but I have not been able to convert my db from the 11/9/01 snapshot to the current snapshot version - there are always errors when I try to use it afterwards


I have run mysqldiff.pl on the 11/9 db vs the current oscommerce.sql file


I have removed the shipping_cost and shipping_method lines from the diff file


I apply the diff file to a copy of the 11/9 db


I run the extras/orders script on it and it says Done!


then when i try to use it I get the following errors:


1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_BESTSELLERS' at line 1

select p.products_id, pd.products_name, p.products_ordered from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered DESC, pd.products_name limit MAX_DISPLAY_BESTSELLERS



1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_ALSO_PURCHASED' at line 1

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '268' and opa.orders_id = opb.orders_id and opb.products_id != '268' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit MAX_DISPLAY_ALSO_PURCHASED



the prices are all missing or wrong, AND the right column is missing




help please

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...