Account Page Error

[twosister42]

Just upgraded to osCommerce Merchant v2.2 RC2 and came across this error on account.php:

 

>>1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '3' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]<<

 

Can someone help me out with this? Need to fix this soon. Thank you!

[twosister42]

(!) Did a fresh install of the osCommerce RC2 and did not receive the error message like before. Restored my last dbase I backed up and got the error message again.

 

So- once again osCommerce dbases are not "convertible" to the upgrade and I'm up crap creek once again with having to re-enter all my products and contact customers to see if they are willing to re-enter there information and lose all previous orders?

 

Is there any one who can help fix this so I don't have to go through all of this again?

 

Error Message at top of page

 

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '3' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

blank space

 

My Account Information