1054 - Unknown column 'o.orders_id' in 'on clause'

[Guest]

hello

the web host just changed from mysql 4 to 5 , i fixed the other issues but now i still have 1 left.

 

i get this error in the admin area under customers --> orders

 

i get this error

 

1054 - Unknown column 'o.orders_id' in 'on clause'

 

select count(*) as total from orders o, customers mc left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where mc.customers_id = o.customers_id and mc.customers_retail = '0' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total'

 

[TEP STOP]

 

Any suggestions to fix that.

thanks

Ian