account.php page not coming up

[aprilbryan]

When someone signs on to account, the page it goes to the account.php and shows this error message below. This is a new install of v2.2 rc2. I have not opened/edited the account.php file, so I'm not sure what to look at to find the problem. The same error message shows up on shoppingcart.php as well.

 

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

 

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

 

[TEP STOP]

 

My Account Information

 

I setup a dummy acct, with user- dummy, pword-dummy if anyone wants to see the error in action

 

 

Thanks for any insight at all! Just moved a client off a builder site to my server and now this problem is a real pain and embarrassment.

fyi- I am new to oscommerce

[arietis]

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

 

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

 

this is telling you that there is a column named 'public_flag' that the sql is looking for, but it does not exist in the 'orders_status' table.

 

this should be there, as it is part of the stock osc database schema, but for some reason it is unable to find that column name. use phpmyadmin to check and make sure that the table has that column name in it.

[aprilbryan]

THANKS SO MUCH, WITH YOUR HELP AND SEARCHING FORUMS WITH THE NEW DATA YOU GAVE ME, I FOUND SOME SQL QUERIES TO RUN WHICH ADDED THE MISSING FILES I NEEDED.

 

THANKS AGAIN!