problem with searh ID:XX or model
hello, I have this problem, when I search in admin
clients>orders
and I search for example a product
inserting in
Search article name or ID:XX
I have this error
1054 Unknown column 'o.orders_id' in 'on clause'
in:
[select count(distinct o.orders_id) as total from (orders o, orders_status s left join orders_products op on (op.orders_id = o.orders_id) ) left join orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '2' and ot.class = 'ot_total') and (op.products_model like '%G1000000691%' or op.products_name like 'G1000000691%')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Why?
How can I solve it?
:lamo: