Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 's.public_flag'


Guest

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...