View Full Version : 1054 error and another little issue

10-19-2008, 07:45 PM
1054 - Unknown column 's.public_flag' in 'where clause'

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

My site seems to be going along fine during testing until I get to the my account link and I get the above error message. I've looked for the order status table in phpMyadmin and it is there however, I see no mention of a public_flag field. Any ideas how to fix this error message anyone?

Also, I can't seem to see how a customer would log off my site. Once they register and log in, I don't see a mention of log off anywhere? Sorry, to bother everyone but I'm a newbie hoping to get started in the online sales business. I need info if anyone can guide me.

Any and all help will be appreciated.