Upgrade an older version of OSC to 2.2MS

[winxpauctions]

I have an older version installed by my ISP, im now hosting my own version, and want to keep upto date on OSC revisions.

 

I manged to upgrade the DB using the extras folder script (pr1_to_pr2) and ran the ms1_to_ms2.php file - this ran without errors.

 

So far so good, a 2.2 DB, I then copied over the new 2.2MS and ran the setup, it went fine using the option of not using the dummy database.

 

But when I go into the admin page or homepage, I get errors. See below:

What am I doing wrong?

 

ERROR on Column Right:1054 - Unknown column 'p.products_ordered' in 'where clause'

select distinct p.products_id, pd.products_name 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 10

 

And under payments module in Admin, When I edit the listed payment, it has empty fields.

 

How do i find out what version of OSC I was trying to upgrade from? And what is the correct procedure? I have access to the old site, and database.

[winxpauctions]

Found another error When clicking on the orders in Admin.

 

1146 - Table 'bolly.orders_total' doesn't exist

 

select count(*) as total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total'

 

[TEP STOP]