Order Status

[fabby]

Hi all,

 

I have a problem. my order status is not showing up in my admin. Customer still able to receive my confirm order email, But when they log in to their account, they cant view it under their account status.

 

That time i have this error

 

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

 

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

 

[TEP STOP]

 

Then I add this to my database

 

CREATE TABLE orders_status (

orders_status_id int DEFAULT '0' NOT NULL,

language_id int DEFAULT '1' NOT NULL,

orders_status_name varchar(32) NOT NULL,

public_flag int DEFAULT '1',

downloads_flag int DEFAULT '0',

PRIMARY KEY (orders_status_id, language_id),

KEY idx_orders_status_name (orders_status_name)

);

 

The error seem gone, but when I do a retest, I found the problem about the order status not showing up. Seem like my database got some mistakes. Anyone know what wrong with it? thanks alot in advance...

 

Fabby

[johnnybebad]

Hi all,

 

I have a problem. my order status is not showing up in my admin. Customer still able to receive my confirm order email, But when they log in to their account, they cant view it under their account status.

 

That time i have this error

 

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

 

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

 

[TEP STOP]

 

Then I add this to my database

 

CREATE TABLE orders_status (

orders_status_id int DEFAULT '0' NOT NULL,

language_id int DEFAULT '1' NOT NULL,

orders_status_name varchar(32) NOT NULL,

public_flag int DEFAULT '1',

downloads_flag int DEFAULT '0',

PRIMARY KEY (orders_status_id, language_id),

KEY idx_orders_status_name (orders_status_name)

);

 

The error seem gone, but when I do a retest, I found the problem about the order status not showing up. Seem like my database got some mistakes. Anyone know what wrong with it? thanks alot in advance...

 

Fabby

 

Do you have any entries in your order status table?

[fabby]

Thanks, i solved it accidentally. I upload the clean sql and it solved... thanks..

[Tim Romero]

how did you solve this problem? i am having the same problem, but I am lost.