[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Error: searching for customer by address field
- Subject: Error: searching for customer by address field
- From: Stroller <..hidden..>
- Date: Sun, 10 Jun 2007 19:07:49 +0100
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