openpolice-platform icon indicating copy to clipboard operation
openpolice-platform copied to clipboard

Street seach is broken

Open tomjanssens opened this issue 9 years ago • 0 comments

Search returns the following error:

Unknown column 'tbl.islp' in 'where clause' of the following query: SELECT COUNT(*) FROM `bin_relations` AS `tbl` LEFT JOIN `streets_relations` AS `street_relation` ON (`street_relation`.`row` = `tbl`.`bin_relation_id`) LEFT JOIN `data`.`streets` AS `street` ON (`street`.`streets_street_identifier` = `street_relation`.`streets_street_identifier`) LEFT JOIN `data`.`streets_cities` AS `city` ON (`city`.`streets_city_id` = `street`.`streets_city_id`) LEFT JOIN `bin_districts` AS `district` ON (`district`.`bin_district_id` = `tbl`.`bin_district_id`) WHERE `street_relation`.`table` = 'bin_relations' AND `street`.`title` LIKE '%beuk%' OR `tbl`.`islp` LIKE '%beuk%'

Reported by 5355-7.

tomjanssens avatar Oct 13 '15 14:10 tomjanssens