Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error msg..... help


Magma-tech

Recommended Posts

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

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

Archived

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

×
×
  • Create New...