Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


promosat

Recommended Posts

hi i dont know what happened in my shop after restore of data base i get this error when i try to access MY ACCOUNT in shop front page any help

 

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

 

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

 

[TEP STOP]

 

My Account Information

Link to comment
Share on other sites

problem sort it out

 

The quick fix:

 

if you are able to access your DB is to run the sql statement:

 

CODE

alter table orders_status add public_flag int DEFAULT '1';

 

This will create the missing field in the order_status table and the world will be a happy place once more.

Unless anyone has any better ideas... thumbsup.gif

 

thanks to the help of the best community

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...