Totally Zenned
- Join Date:
- Mar 2006
- Posts:
- 909
- Plugin Contributions:
- 1
Search by Product Name or ID:XX Error
I've just tested the new "Search by Product Name or ID:XX" feature in 1.3.8 and it didn't seem to work.
When entering either a product name, product id or any word/number the following error message is displayed.
1054 Unknown column 'o.orders_id' in 'on clause'
in:
[select count(distinct o.orders_id) as total from (zen_orders o, zen_orders_status s left join zen_orders_products op on (op.orders_id = o.orders_id) ) left join zen_orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total') and (op.products_model like '%my product%' or op.products_name like 'my product%')]
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.
Is this a know issue or have I missed something during the upgrade?
