Error Message when customer tries to login or set up new account

[sanikicreations]

I'm not good with programming, so I have no idea what to do. I'm testing my shop and when I try to login as a new customer or existing customer I get this error code:

 

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

 

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

 

[TEP STOP]

 

Does anyone know what that means?

 

I use to use vstore and had switched hosting servers, so I imported the backup data from the old vstore to the new host. If that made any sense. All my products and descriptions are there (except the images) and for some reason I can't get the account module to let people buy without an account.

 

Help.......please

 

Here's the store if you want to take a looksie

 

My link

 

I'm going to be putting a link to my shop once I know everything is working fine and dandy

[Jan Zonjee]

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

 

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

 

[TEP STOP]

 

Does anyone know what that means?

In the RC2 update for osCommerce this (there are a few more changes) new field was added to the table orders_status.

alter table orders_status add public_flag int DEFAULT '1';

Looks like you need to take a look at the RC2a download, upgrade-22rc2.html and see if the database changes were added (I assume you use RC2a but a backup from the old store).