Hi,
We have currently six warehouses set up in inventory management. Since updating to version 1.7.1 clicking on one of the warehouses in the list fails with an error message:
Type: E_USER_ERROR (256)
Message: mysqlt error: [1054: Unknown column 'r.f_item_name' in 'order clause'] in EXECUTE("SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50")
File: D:\crm.hcp0.local\libs\adodb\adodb-errorhandler.inc.php
Line=77
...
Full error message on pastebin: http://pastebin.com/kVJBRmTb
