promosat Posted November 24, 2008 Share Posted November 24, 2008 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 More sharing options...
promosat Posted November 24, 2008 Author Share Posted November 24, 2008 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 More sharing options...
certify Posted November 25, 2008 Share Posted November 25, 2008 Tks for the fix! :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.