orders missing in admin

[allpedal]

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

 

select o.customers_id from orders o, orders_status s where o.orders_id = '54' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

 

 

I can't find it on the forum to try and fix it. The orders are in the db but dont' show up in the admin. When I click on 'account" history in the email I get the above error.

 

Thanks!

[FIMBLE]

Hi,

Back up first, then run this through phpmyadmin.

 

alter table orders_status add public_flag int DEFAULT '1';

 

Nic

[allpedal]

Hi,

Back up first, then run this through phpmyadmin.

 

alter table orders_status add public_flag int DEFAULT '1';

 

Nic

 

thanks Nic, that worked except that the orders still aren't showing up in admin. I was hoping that was the problem with that but I'm not lucky enough!

[allpedal]

I'm guess it has something to do with a hack. I installed it again on a fresh db and everything works just like it is supposed to. But when I merge the backup in, the orders don't show up in admin.

 

I'm not sure what else to do because I have almost 2200 products in the db so they need to be moved but how do I move them and all that is necessary but not anything else?

[allpedal]

I'm guess it has something to do with a hack. I installed it again on a fresh db and everything works just like it is supposed to. But when I merge the backup in, the orders don't show up in admin.

 

I'm not sure what else to do because I have almost 2200 products in the db so they need to be moved but how do I move them and all that is necessary but not anything else?

 

Just to give an update, I went into phpmyadmin and exported the tables I wanted to keep and moved them into a fresh db with a fresh install of OSC and everything worked just fine. The orders are there, customers are there, everything.