My Account displaying error message

[theinkjetmarket]

Hi

Wondering if someone can help with this problem. After a customer signs in and clicks on "My Account" the following error is displayed:

 

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

 

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

 

[TEP STOP]

 

 

Regards

Garry

[Guest]

Hi

Wondering if someone can help with this problem. After a customer signs in and clicks on "My Account" the following error is displayed:

 

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

 

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

 

[TEP STOP]

 

 

Regards

Garry

The first entry in a google search reveals this.

[theinkjetmarket]

The first entry in a google search reveals this.

 

 

Thanks Leslie. I will from now on use Google to search out my problems. Problem fixed.

 

Best wishes from the other side of the world!!

 

Garry