Forum PHP.pl

vmError: exeSortSearchListQuery Column 'created_on' in where clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,pm.payment_name AS payment_method FROM fk_virtuemart_orders as o LEFT JOIN fk_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN fk_virtuemart_paymentmethods_pl_pl as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" AND ( u.first_name LIKE "%k%" OR u.middle_name LIKE "%k%" OR u.last_name LIKE "%k%" OR `order_number` LIKE "%k%" OR `created_on` LIKE "%k%")) ORDER BY created_on DESC LIMIT 0, 5