First, no error message appears
Second,
<body>
<div id="container">
<h1>A Database Error Occurred</h1>
<p>Error Number: 1054</p><p>Unknown column 'Status' in 'where clause'</p><p>SELECT COUNT(*) AS `numrows`
FROM (`orders`)
LEFT JOIN `supplier` as jc5bcd6 ON `jc5bcd6`.`supplier_id` = `orders`.`supplier_id`
WHERE `Status` LIKE '%Hold%'</p><p>Filename: C:\wamp\www\erp_ci\system\database\DB_driver.php</p><p>Line Number: 330</p> </div>
</body>
On the above query, the status column comes from the N to N table -STATUS-
Thanks
Panos
. For now I have only a temporary solution for this. You can see the change that you can do in the version 1.1.4 at https://github.com/s...74b367fef0803ee . This will prevent the error, so the search will be normally for all the fields but NOT for the n-n field. Probably in the next version will be fixed with a normal solution way.
