1054 - Unknown column 's.public_flag'

[Guest]

When a person logs in and goes to "My Account", this error is displayed. I have searched the forums and although there are many 1054 postings, I can't find this particular one and I'm not sure what column it is referring to...

 

I would appreciate any help.

 

The error is:

 

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'

 

Thanks,

Paul

[Guest]

Never mind. I think I finally found it.... I didn't add the column in the upgrade. My mistake. Apologies for the time.

[Jan Zonjee]

I didn't add the column in the upgrade.

Yep, see this tip.

[tapuahk]

When a person logs in and goes to "My Account", this error is displayed. I have searched the forums and although there are many 1054 postings, I can't find this particular one and I'm not sure what column it is referring to...

 

I would appreciate any help.

 

The error is:

 

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'

 

Thanks,

Paul

 

It appears that a call to your database says that there is no "s.public_flag" column in your orders table.

 

Check your database and let us know....

 

~~~Tapuahk