Error message account.php

[Guest]

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'

 

[TEP STOP]

 

Can somebody help me with this?

[FIMBLE]

Try to run this in your phpmyadmin

 

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

 

Nic

 

 

Back up first though

[Guest]

Try to run this in your phpmyadmin

 

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

 

Nic

 

 

Back up first though

 

That did the trick!! thanks

[FIMBLE]

You're welcome