Magma-tech Posted August 20, 2008 Share Posted August 20, 2008 Error mesg. when ever accessing "My Accounts" I am getting this error msg. when ever I try to access "My Accounts" tab in the catalog. Was doing some testing, setting up a bogus customer to check all the functions out before starting up.... but when I create a customer account at log in, or try to access my account I get this... 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_status s where o.customers_id = '4' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' [TEP STOP] Any help would be greatly appreciated. Thanks Rick Link to comment Share on other sites More sharing options...
Magma-tech Posted August 20, 2008 Author Share Posted August 20, 2008 Error mesg. when ever accessing "My Accounts" I am getting this error msg. when ever I try to access "My Accounts" tab in the catalog. Was doing some testing, setting up a bogus customer to check all the functions out before starting up.... but when I create a customer account at log in, or try to access my account I get this... 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_status s where o.customers_id = '4' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' [TEP STOP] Any help would be greatly appreciated. Thanks Rick __________________________________ NEVER MIND I FOUND THE FIX...... __________________________________ Run this SQL statement to fix your issue. This will create the table elements that are missing. alter table orders_status add public_flag int DEFAULT '1'; alter table orders_status add downloads_flag int DEFAULT '0'; Thanks to the others in the past that had this problem . Rick Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.