Skip to content
This repository has been archived by the owner on Feb 4, 2022. It is now read-only.

Street seach is broken #205

Open
tomjanssens opened this issue Oct 13, 2015 · 0 comments
Open

Street seach is broken #205

tomjanssens opened this issue Oct 13, 2015 · 0 comments
Milestone

Comments

@tomjanssens
Copy link
Contributor

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 tomjanssens added this to the Current milestone Oct 13, 2015
@tomjanssens tomjanssens added the bug label Feb 1, 2016
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant