Bug in My Account

[Guest]

when i go to My Account on my store. i get the following:

 

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

 

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

 

[TEP STOP]

 

I have looked at my database, overridden it. Change my php file and nothing works! Could someone point me in the right direction where i should be looking please?

[Avec]

My orders_status table has no public_flag field, and it sounds like your does not either. Is this from a contribution? Just to get things going, remove the and s.public_flag='1' I don't know what this will change elsewhere in your process, though. You need to figure out where that came from.

[Guest]

thanks for that, i had another look, deleted s.public_flag and it worked, much thanks x x x