Guest Posted March 9, 2007 Share Posted March 9, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.