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

[Guest]

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

[TEP STOP]

 

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

[TEP STOP]

 

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

 

???????

 

help please