Restoring old DB on new installation of osCommerce 2.2 rc2

[oscommerce21]

I'm installing store from Fantastico.

 

All works, as DB is empty.

 

I'm able to create a new user, go to checkout, pay by check.

 

however, if I import old DB, I'm getting error massage listed below.

 

Please help.

 

Server info:

http://freebible.us/test.php

 

 

 

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

 

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

[GemRock]

as far as i can remember, theres one or two fields or columns that older versions of osc (prior to rc2a) is missing but the new osc rc2a is referring to. the public_flag is one of them. for me i would manually create the missing field(s). quite straightforward.

these rae the two missing fields in the orders_status table:

 

public_flag

downloads_flag

 

both data type INT, and default for public_flag is 1, for downloads_flag is 0

 

 

Ken