1054 Unknown column 'o.orders_id' in 'on clause' -- in admin order search

[rxalex]

I have this error coming up when I search in customer orders by item name or item model

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 '%098590%' or op.products_name like '098590%')]
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.

[tony_sar]

answer to your question can be found at the bottom of this page. .also you can look at this thread

http://www.zen-cart.com/forum/showth...27on+clause%27

[rxalex]

Thanks tony no more error but search doesnt find anything at all.

[DrByte]

When did this "start" for you?

[rxalex]

Dr it started when I installed click and ship Im guessing because thats the mod that changes order.php.. But cant find orders by product name if I dont remember the customers name or order number, Drbyte is there a way to fix this search in admin to work?

[DrByte]

The symptoms you describe are strongly similar to putting an old version of orders.php over a newer version.

You'll need to put the newer one back up, and then merge just the unique additions/changes for the addon that replaced it.

[rxalex]

Oh my php is not so good....

[tony_sar]

you don't need much php knowledge for merging files.
if your OS is window , then download and install free tool called winmerge . this tool allow you to compare files with one anther and merge differences.

using this tool , compare the fresh copy of order.php with order.php that comes with addon . you can see the differences highlighted by this utility. simply copy the difference from addon to zencart order.php file ( done from winmerge window ) .

[rxalex]

Actually even if I put back the original orders.php file, the search function always comes back as zero result

[DrByte]

Actually even if I put back the original orders.php file, the search function always comes back as zero result

The search on a clean install without mods properly locates orders when putting customer names in the Search box, and product names or product models in the products search box, and orders when putting the order number in the Order Number search box.

Have you tried searching using upper/lower case? Maybe you've got a case-sensitivity problem?