Error encountered on upgradation to MySql 5

[Guest]

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

 

select count(*) as total from orders o Left Join orders_total ot ON (o.orders_id = ot.orders_id), orders_status s Left Join customers_invoice ON o.orders_id = customers_invoice.orders_id where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total'

 

File admin/orders.php

 

Please help

[BryceJr]

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

 

select count(*) as total from orders o Left Join orders_total ot ON (o.orders_id = ot.orders_id), orders_status s Left Join customers_invoice ON o.orders_id = customers_invoice.orders_id where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total'

 

File admin/orders.php

 

Please help

http://www.oscommerce.com/forums/index.php?&showtopic=230304

[Jan Zonjee]

from orders o Left Join orders_total ot ON (o.orders_id = ot.orders_id), orders_status s Left Join customers_invoice ON o.orders_id = customers_invoice.orders_id

This must be a contribution added because customers_invoice is not a regular osC table.

 

You could try to rearrange the order somewhat in the query that give the error. Perhaps this works:

... from orders o Left Join orders_total ot ON (o.orders_id = ot.orders_id) Left Join customers_invoice ON o.orders_id = customers_invoice.orders_id, orders_status s where ...