search

hotosm / HDM-CartoCSS

CartoCSS project focused on the Humanitarian Data Model
Other
139 stars 41 forks source link

SQL Error #313

Open yohanboniface opened 4 years ago

yohanboniface commented 4 years ago 
Mar 31 21:27:34 osm13 renderd[10122]: ERROR: failed to render TILE hot 17 69064-69071 45800-45807
Mar 31 21:27:34 osm13 renderd[10122]:    reason: Postgis Plugin: ERROR:  invalid input syntax for type bigint: "d"#012in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"housenumber","mod5" FROM (select way,"addr:housenumber" AS housenumber, CASE WHEN "addr:housenumber" ~ E'^\d+$' AND mod("addr:housenumber"::bigint, 5) IN (0, 1) THEN 'yes' ELSE 'no' END AS mod5 FROM planet_osm_polygon WHERE "addr:housenumber" IS NOT NULL AND building IS NOT NULL UNION SELECT way,"addr:housenumber" AS housenumber, CASE WHEN "addr:housenumber" ~ E'^\d+$' AND mod("addr:housenumber"::bigint, 5) IN (0, 1) THEN 'yes' ELSE 'no' END AS mod5 FROM planet_osm_point WHERE "addr:housenumber" IS NOT NULL) as data WHERE "way" && ST_SetSRID('BOX3D(1078373.595047846 6031493.027929924,1081431.076179255 6034550.509061333)'::box3d, 3857)'