[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Error: searching for customer by address field



Under AR > Customers > Reports > Search, I get the following error if I try to search by street name.

I assume this is a known issue & not unique to my installation, but I send it just in case it's otherwise.

Stroller.



DBD::Pg::st execute failed: ERROR: column "street" does not exist
Error!


SELECT ct.*, b.description AS business,
e.name AS employee, g.pricegroup,
l.description AS language, m.name AS manager
FROM customer ct
LEFT JOIN business b ON (ct.business_id = b.id)
LEFT JOIN employee e ON (ct.employee_id = e.id)
LEFT JOIN employee m ON (m.id = e.managerid)
LEFT JOIN pricegroup g ON (ct.pricegroup_id = g.id)
LEFT JOIN language l ON (l.code = ct.language_code)
WHERE 1 = 1 AND (lower(ct.address1) LIKE '%street%' OR lower (ct.address2) LIKE ''%street%'') ORDER BY name ASC
ERROR: column "street" does not exist