Forums / Customization from the Admin / problem with searh ID:XX or model

problem with searh ID:XX or model

Locked

Views: 876

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
22 Oct 2009, 9:30 PM
#1
giuly avatar

giuly

Zen Follower

Join Date:
May 2007
Location:
Italy
Posts:
438
Plugin Contributions:
0

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: