[prev in list] [next in list] [prev in thread] [next in thread]
List: mapbender-users
Subject: Re: [Mapbender-users] UPDATE:Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7
From: Uwe Seher <uwe.seher () gmail ! com>
Date: 2017-05-03 11:46:26
Message-ID: CADtXaaiQ5y4PJpN5AKRV5Ziq+7fL=En1_0uzhVrLSXq-AvCrHA () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hello!
So there is a chance, that the issue is solved in the next version?
Thank you for the help!
Uwe Seher
2017-05-03 13:25 GMT+02:00 Frederik Haefker (WhereGroup) <
frederik.haefker@wheregroup.com>:
> Hi,
>
> for the moment you can use the digitizer in version 1.1.x. As it is not
> released by now you have to change your composer.json accordingly.
>
> The release of the mapbender3 in Version 3.0.6.0 will be soon. We are in
> the last phase of the testing.
>
> Best Regards
> Frederik Häfker
>
>
> Am 03.05.2017 um 11:56 schrieb Gero Wahren:
> > Hi Frederik,
> > when will be the Version 3.0.6.0 released or have i missed the release?
> > I have a experimental installation from github. It runs, but there some
> issues.
> >
> > Mit freundlichen Grüßen
> >
> > Gero Wahren
> > Dipl.-Inf.
> >
> > 25 Jahre Ingenieurbüro Klemm & Hensen GmbH
> >
> > Ingenieurbüro Klemm & Hensen GmbH
> > Fabrikstraße 18 | 04178 Leipzig
> >
> > T: +49 341 45311-13
> > F: +49 341 45311-88
> > M: +49 176 10609065
> > E: g.wahren@klemm-hensen.de
> > W: www.klemm-hensen.de
> >
> > Erfolgreich zertifiziert nach ISO 9001:2008.
> >
> > Geschäftsführer: Günter Klemm | Gerald Schäfer
> > Sitz der Gesellschaft: Fabrikstraße 18 | 04178 Leipzig
> > Registergericht: Amtsgericht Leipzig | HRB 2522
> >
> > ----- Ursprüngliche Mail -----
> > Von: "Frederik Haefker (WhereGroup)" <frederik.haefker@wheregroup.com>
> > An: "Mapbender User List" <mapbender_users@lists.osgeo.org>
> > Gesendet: Mittwoch, 3. Mai 2017 11:35:09
> > Betreff: Re: [Mapbender-users] UPDATE:Re: Mapbender3-3.0.5.3: Error
> after updating PHP5 to PHP7
> >
> > Hi,
> >
> > just as a side note: the mapbender 3.0.6 will bring along full php7
> > support.
> > http://doc.mapbender3.org/en/book/versions.html
> >
> > Best Regards Frederik
> >
> >
> > Am 03.05.2017 um 11:26 schrieb Gero Wahren:
> >> Hi,
> >> it is not the Platformname. It seem's to be a other Problem, maybe the
> preg_replace() in row 480 of the FeatureType.php-File? Are'nt there some
> Modifikations in PHP7?
> >>
> >>
> >> Mit freundlichen Grüßen
> >>
> >> Gero Wahren
> >> Dipl.-Inf.
> >>
> >> 25 Jahre Ingenieurbüro Klemm & Hensen GmbH
> >>
> >> Ingenieurbüro Klemm & Hensen GmbH
> >> Fabrikstraße 18 | 04178 Leipzig
> >>
> >> T: +49 341 45311-13
> >> F: +49 341 45311-88
> >> M: +49 176 10609065
> >> E: g.wahren@klemm-hensen.de
> >> W: www.klemm-hensen.de
> >>
> >> Erfolgreich zertifiziert nach ISO 9001:2008.
> >>
> >> Geschäftsführer: Günter Klemm | Gerald Schäfer
> >> Sitz der Gesellschaft: Fabrikstraße 18 | 04178 Leipzig
> >> Registergericht: Amtsgericht Leipzig | HRB 2522
> >>
> >> ----- Ursprüngliche Mail -----
> >> Von: "Gero Wahren" <g.wahren@klemm-hensen.de>
> >> An: "Mapbender User List" <mapbender_users@lists.osgeo.org>
> >> Gesendet: Mittwoch, 3. Mai 2017 11:01:09
> >> Betreff: Re: [Mapbender-users] Mapbender3-3.0.5.3: Error after updating
> PHP5 to PHP7
> >>
> >> Hi,
> >> i have the same problem. It seem's that the database-query is'nt well
> formed. I think that the where-clause don't have to be empty.
> >> Please correct me.
> >>
> >> Query:
> >> An exception occurred while executing 'SELECT id,
> ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name, xcoord,
> ycoord, bwastrid, station, dist, srid, description, site_type, priority,
> planned, organization, issued_by, contact, is_valid, created, created_by,
> last_edit, edited_by FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT
> 250': SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
> LINE 1: ...dited_by FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 25
> >>
> >> I searched a little bit and you can fix it , when you uncheck the
> "currentExtend" for the digitizer or Pipe it with all in your yaml-File.
> "currentExtend|all".
> >> I think that the Plattformname changed in PHP 7 so the
> genIntersectCondition-Function generates an empty where-clause.
> >>
> >>
> >> Mit freundlichen Grüßen
> >>
> >> Gero Wahren
> >> Dipl.-Inf.
> >>
> >> 25 Jahre Ingenieurbüro Klemm & Hensen GmbH
> >>
> >> Ingenieurbüro Klemm & Hensen GmbH
> >> Fabrikstraße 18 | 04178 Leipzig
> >>
> >> T: +49 341 45311-13
> >> F: +49 341 45311-88
> >> M: +49 176 10609065
> >> E: g.wahren@klemm-hensen.de
> >> W: www.klemm-hensen.de
> >>
> >> Erfolgreich zertifiziert nach ISO 9001:2008.
> >>
> >> Geschäftsführer: Günter Klemm | Gerald Schäfer
> >> Sitz der Gesellschaft: Fabrikstraße 18 | 04178 Leipzig
> >> Registergericht: Amtsgericht Leipzig | HRB 2522
> >>
> >> ----- Ursprüngliche Mail -----
> >> Von: "Uwe Seher" <uwe.seher@gmail.com>
> >> An: "Mapbender User List" <mapbender_users@lists.osgeo.org>
> >> Gesendet: Mittwoch, 3. Mai 2017 09:14:32
> >> Betreff: [Mapbender-users] Mapbender3-3.0.5.3: Error after updating
> PHP5 to PHP7
> >>
> >> Hello group!
> >>
> >> Last week we had to update our server including a switch from PHP5 to
> PHP7. Everything worked fine, but after the update the digitizer element in
> mabender produces an sql-error.
> >> If the digititzer is activated, every move of the map produces the
> following error-message:
> >>
> >> Feature API: Abfrage fehlgeschlagen."<!DOCTYPE html>\n<html>\n <head>\n
> <meta charset=\"UTF-8\" />\n <title>An Error Occurred: Internal Server
> Error</title>\n </head>\n <body>\n <h1>Oops! An Error Occurred</h1>\n
> <h2>The server returned a \"500 Internal Server Error\".</h2>\n\n <div>\n
> Something is broken. Please let us know what you were doing when this error
> occurred.\n We will fix it as soon as possible. Sorry for any inconvenience
> caused.\n </div>\n </body>\n</html>\n"
> >>
> >> The mapbender log shows the following:
> >>
> >> [2017-05-03 06:14:44] request.CRITICAL: Uncaught PHP Exception
> Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT
> id, ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name, xcoord,
> ycoord, bwastrid, station, dist, srid, description, site_type, priority,
> planned, organization, issued_by, contact, is_valid, created, created_by,
> last_edit, edited_by FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 250':
> SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")" LINE 1:
> ...dited_by FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 25... ^" at
> /srv/www/htdocs/mapbender3-3.0.5.3/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php
> line 91 {"exception":"[object] (Doctrine\\DBAL\\DBALException(code: 0):
> An exception occurred while executing 'SELECT id,
> ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name, xcoord,
> ycoord, bwastrid, station, dist, srid, description, site_type, priority,
> planned, organization, issued_by, contact, is_valid, created, created_by,
> last_edit, edited_by FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT
> 250':\n\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near
> \")\"\nLINE 1: ...dited_by FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT
> 25...\n ^ at /srv/www/htdocs/mapbender3-3.0.5.3/vendor/doctrine/dbal/
> lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 42601):
> SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \")\"\nLINE
> 1: ...dited_by FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 25...\n ^
> at /srv/www/htdocs/mapbender3-3.0.5.3/vendor/doctrine/dbal/
> lib/Doctrine/DBAL/Connection.php:699)"} []
> >> [2017-05-03 06:14:44] security.DEBUG: Write SecurityContext in the
> session [] []
> >> prod.log lines 3827-3852/3852 (END)
> >>
> >> The same is found in the database log (postgresql 9.6.2, postgis 2.3.1:
> >>
> >> 2017-05-03 06:14:44 GMT[[unknown]:xxx:59097554.1ed9d:0]ERROR: syntax
> error at or near ")" at character 291
> >> 2017-05-03 06:14:44 GMT[[unknown]:xxx:59097554.1ed9d:0]STATEMENT:
> SELECT id, ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name,
> xcoord, ycoord, bwastrid, station, dist, srid, description, site_type,
> priority, planned, organization, issued_by, contact, is_valid, created,
> created_by, last_edit, edited_by FROM mrh_1509.erkundung_06_2017 t WHERE ()
> LIMIT 250
> >>
> >> Some weeks before updating the server i ran a database update, but
> after that, it worked as expected. So i dont think, the database-upgrade is
> the reason for this.
> >> Executing the sql shows the error, which disappears when the empty
> where-clause is deleted.
> >> I have just no clue how to handle this, so every hint would be helpful.
> >>
> >> Thanks in advance
> >>
> >> Uwe Seher
> >>
> >>
> >> _______________________________________________
> >> Mapbender_users mailing list
> >> Mapbender_users@lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> >> _______________________________________________
> >> Mapbender_users mailing list
> >> Mapbender_users@lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> >> _______________________________________________
> >> Mapbender_users mailing list
> >> Mapbender_users@lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> >
> > _______________________________________________
> > Mapbender_users mailing list
> > Mapbender_users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/mapbender_users
> > _______________________________________________
> > Mapbender_users mailing list
> > Mapbender_users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/mapbender_users
>
> --
> ---------------------------------------
> Aufwind durch Wissen!
> Qualifizierte OpenSource-GIS-Schulungen
> bei der www.foss-academy.com
> ---------------------------------------
>
> Frederik Haefker
> WhereGroup GmbH & Co. KG
> Eifelstraße 7
> 53119 Bonn
> Germany
>
> Fon: +49 (0)228 / 90 90 38 - 21
> Fax: +49 (0)228 / 90 90 38 - 11
>
> frederik.haefker@wheregroup.com
> www.wheregroup.com
> Amtsgericht Bonn, HRA 6788
> -------------------------------
> Komplementärin:
> WhereGroup Verwaltungs GmbH
> vertreten durch:
> Olaf Knopp, Peter Stamm
> -------------------------------
>
>
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>
[Attachment #5 (text/html)]
<div dir="ltr"><div><div>Hello!<br><br></div>So there is a chance, that the issue is \
solved in the next version?<br></div><div><br></div><div>Thank you for the \
help!<br><br></div><div>Uwe Seher<br></div></div><div class="gmail_extra"><br><div \
class="gmail_quote">2017-05-03 13:25 GMT+02:00 Frederik Haefker (WhereGroup) <span \
dir="ltr"><<a href="mailto:frederik.haefker@wheregroup.com" \
target="_blank">frederik.haefker@wheregroup.com</a>></span>:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hi,<br> <br>
for the moment you can use the digitizer in version 1.1.x. As it is not<br>
released by now you have to change your composer.json accordingly.<br>
<br>
The release of the mapbender3 in Version 3.0.6.0 will be soon. We are in<br>
the last phase of the testing.<br>
<br>
Best Regards<br>
Frederik Häfker<br>
<div><div class="h5"><br>
<br>
Am 03.05.2017 um 11:56 schrieb Gero Wahren:<br>
> Hi Frederik,<br>
> when will be the Version 3.0.6.0 released or have i missed the release?<br>
> I have a experimental installation from github. It runs, but there some \
issues.<br> ><br>
> Mit freundlichen Grüßen<br>
><br>
> Gero Wahren<br>
> Dipl.-Inf.<br>
><br>
> 25 Jahre Ingenieurbüro Klemm & Hensen GmbH<br>
><br>
> Ingenieurbüro Klemm & Hensen GmbH<br>
> Fabrikstraße 18 | 04178 Leipzig<br>
><br>
> T: +49 341 45311-13<br>
> F: +49 341 45311-88<br>
> M: +49 176 10609065<br>
> E: <a href="mailto:g.wahren@klemm-hensen.de">g.wahren@klemm-hensen.de</a><br>
> W: <a href="http://www.klemm-hensen.de" rel="noreferrer" \
target="_blank">www.klemm-hensen.de</a><br> ><br>
> Erfolgreich zertifiziert nach ISO 9001:2008.<br>
><br>
> Geschäftsführer: Günter Klemm | Gerald Schäfer<br>
> Sitz der Gesellschaft: Fabrikstraße 18 | 04178 Leipzig<br>
> Registergericht: Amtsgericht Leipzig | HRB 2522<br>
><br>
> ----- Ursprüngliche Mail -----<br>
> Von: "Frederik Haefker (WhereGroup)" <<a \
href="mailto:frederik.haefker@wheregroup.com">frederik.haefker@wheregroup.<wbr>com</a>><br>
> An: "Mapbender User List" <<a \
href="mailto:mapbender_users@lists.osgeo.org">mapbender_users@lists.osgeo.<wbr>org</a>><br>
> Gesendet: Mittwoch, 3. Mai 2017 11:35:09<br>
> Betreff: Re: [Mapbender-users] UPDATE:Re: Mapbender3-3.0.5.3: Error after \
updating PHP5 to PHP7<br> ><br>
> Hi,<br>
><br>
> just as a side note: the mapbender 3.0.6 will bring along full php7<br>
> support.<br>
> <a href="http://doc.mapbender3.org/en/book/versions.html" rel="noreferrer" \
target="_blank">http://doc.mapbender3.org/en/<wbr>book/versions.html</a><br> ><br>
> Best Regards Frederik<br>
><br>
><br>
> Am 03.05.2017 um 11:26 schrieb Gero Wahren:<br>
>> Hi,<br>
>> it is not the Platformname. It seem's to be a other Problem, maybe the \
preg_replace() in row 480 of the FeatureType.php-File? Are'nt there some \
Modifikations in PHP7?<br> >><br>
>><br>
>> Mit freundlichen Grüßen<br>
>><br>
>> Gero Wahren<br>
>> Dipl.-Inf.<br>
>><br>
>> 25 Jahre Ingenieurbüro Klemm & Hensen GmbH<br>
>><br>
>> Ingenieurbüro Klemm & Hensen GmbH<br>
>> Fabrikstraße 18 | 04178 Leipzig<br>
>><br>
>> T: +49 341 45311-13<br>
>> F: +49 341 45311-88<br>
>> M: +49 176 10609065<br>
>> E: <a href="mailto:g.wahren@klemm-hensen.de">g.wahren@klemm-hensen.de</a><br>
>> W: <a href="http://www.klemm-hensen.de" rel="noreferrer" \
target="_blank">www.klemm-hensen.de</a><br> >><br>
>> Erfolgreich zertifiziert nach ISO 9001:2008.<br>
>><br>
>> Geschäftsführer: Günter Klemm | Gerald Schäfer<br>
>> Sitz der Gesellschaft: Fabrikstraße 18 | 04178 Leipzig<br>
>> Registergericht: Amtsgericht Leipzig | HRB 2522<br>
>><br>
>> ----- Ursprüngliche Mail -----<br>
>> Von: "Gero Wahren" <<a \
href="mailto:g.wahren@klemm-hensen.de">g.wahren@klemm-hensen.de</a>><br> >> \
An: "Mapbender User List" <<a \
href="mailto:mapbender_users@lists.osgeo.org">mapbender_users@lists.osgeo.<wbr>org</a>><br>
>> Gesendet: Mittwoch, 3. Mai 2017 11:01:09<br>
>> Betreff: Re: [Mapbender-users] Mapbender3-3.0.5.3: Error after updating PHP5 \
to PHP7<br> >><br>
>> Hi,<br>
>> i have the same problem. It seem's that the database-query is'nt \
well formed. I think that the where-clause don't have to be empty.<br> >> \
Please correct me.<br> >><br>
>> Query:<br>
>> An exception occurred while executing 'SELECT id, \
ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name, xcoord, ycoord, \
bwastrid, station, dist, srid, description, site_type, priority, planned, \
organization, issued_by, contact, is_valid, created, created_by, last_edit, edited_by \
FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 250': SQLSTATE[42601]: Syntax \
error: 7 ERROR: syntax error at or near ")" LINE 1: ...dited_by FROM \
mrh_1509.erkundung_06_2017 t WHERE () LIMIT 25<br> >><br>
>> I searched a little bit and you can fix it , when you uncheck the \
"currentExtend" for the digitizer or Pipe it with all in your yaml-File. \
"currentExtend|all".<br> >> I think that the Plattformname changed in \
PHP 7 so the genIntersectCondition-Function generates an empty where-clause.<br> \
>><br> >><br>
>> Mit freundlichen Grüßen<br>
>><br>
>> Gero Wahren<br>
>> Dipl.-Inf.<br>
>><br>
>> 25 Jahre Ingenieurbüro Klemm & Hensen GmbH<br>
>><br>
>> Ingenieurbüro Klemm & Hensen GmbH<br>
>> Fabrikstraße 18 | 04178 Leipzig<br>
>><br>
>> T: +49 341 45311-13<br>
>> F: +49 341 45311-88<br>
>> M: +49 176 10609065<br>
>> E: <a href="mailto:g.wahren@klemm-hensen.de">g.wahren@klemm-hensen.de</a><br>
>> W: <a href="http://www.klemm-hensen.de" rel="noreferrer" \
target="_blank">www.klemm-hensen.de</a><br> >><br>
>> Erfolgreich zertifiziert nach ISO 9001:2008.<br>
>><br>
>> Geschäftsführer: Günter Klemm | Gerald Schäfer<br>
>> Sitz der Gesellschaft: Fabrikstraße 18 | 04178 Leipzig<br>
>> Registergericht: Amtsgericht Leipzig | HRB 2522<br>
>><br>
>> ----- Ursprüngliche Mail -----<br>
>> Von: "Uwe Seher" <<a \
href="mailto:uwe.seher@gmail.com">uwe.seher@gmail.com</a>><br> >> An: \
"Mapbender User List" <<a \
href="mailto:mapbender_users@lists.osgeo.org">mapbender_users@lists.osgeo.<wbr>org</a>><br>
>> Gesendet: Mittwoch, 3. Mai 2017 09:14:32<br>
>> Betreff: [Mapbender-users] Mapbender3-3.0.5.3: Error after updating PHP5 to \
PHP7<br> >><br>
>> Hello group!<br>
>><br>
>> Last week we had to update our server including a switch from PHP5 to PHP7. \
Everything worked fine, but after the update the digitizer element in mabender \
produces an sql-error.<br> >> If the digititzer is activated, every move of the \
map produces the following error-message:<br> >><br>
>> Feature API: Abfrage fehlgeschlagen."<!DOCTYPE \
html>\n<html>\n <head>\n <meta charset=\"UTF-8\" />\n \
<title>An Error Occurred: Internal Server Error</title>\n </head>\n \
<body>\n <h1>Oops! An Error Occurred</h1>\n <h2>The server \
returned a \"500 Internal Server Error\".</h2>\n\n <div>\n \
Something is broken. Please let us know what you were doing when this error \
occurred.\n We will fix it as soon as possible. Sorry for any inconvenience caused.\n \
</div>\n </body>\n</html>\n"<br> >><br>
>> The mapbender log shows the following:<br>
>><br>
>> [2017-05-03 06:14:44] request.CRITICAL: Uncaught PHP Exception \
Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT \
id, ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name, xcoord, ycoord, \
bwastrid, station, dist, srid, description, site_type, priority, planned, \
organization, issued_by, contact, is_valid, created, created_by, last_edit, edited_by \
FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 250': SQLSTATE[42601]: Syntax \
error: 7 ERROR: syntax error at or near ")" LINE 1: ...dited_by FROM \
mrh_1509.erkundung_06_2017 t WHERE () LIMIT 25... ^" at \
/srv/www/htdocs/mapbender3-3.<wbr>0.5.3/vendor/doctrine/dbal/<wbr>lib/Doctrine/DBAL/<wbr>DBALException.php \
line 91 {"exception":"[object] \
(Doctrine\\DBAL\\<wbr>DBALException(code: 0): An exception occurred while executing \
'SELECT id, ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name, xcoord, \
ycoord, bwastrid, station, dist, srid, description, site_type, priority, planned, \
organization, issued_by, contact, is_valid, created, created_by, last_edit, edited_by \
FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 250':\n\nSQLSTATE[42601]: Syntax \
error: 7 ERROR: syntax error at or near \")\"\nLINE 1: ...dited_by FROM \
mrh_1509.erkundung_06_2017 t WHERE () LIMIT 25...\n ^ at \
/srv/www/htdocs/mapbender3-3.<wbr>0.5.3/vendor/doctrine/dbal/<wbr>lib/Doctrine/DBAL/<wbr>DBALException.php:91, \
PDOException(code: 42601): SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or \
near \")\"\nLINE 1: ...dited_by FROM mrh_1509.erkundung_06_2017 t WHERE () \
LIMIT 25...\n ^ at /srv/www/htdocs/mapbender3-3.<wbr>0.5.3/vendor/doctrine/dbal/<wbr>lib/Doctrine/DBAL/Connection.<wbr>php:699)"} \
[]<br> >> [2017-05-03 06:14:44] security.DEBUG: Write SecurityContext in the \
session [] []<br> >> prod.log lines 3827-3852/3852 (END)<br>
>><br>
>> The same is found in the database log (postgresql 9.6.2, postgis 2.3.1:<br>
>><br>
>> 2017-05-03 06:14:44 GMT[[unknown]:xxx:59097554.<wbr>1ed9d:0]ERROR: syntax \
error at or near ")" at character 291<br> >> 2017-05-03 06:14:44 \
GMT[[unknown]:xxx:59097554.<wbr>1ed9d:0]STATEMENT: SELECT id, \
ST_ASTEXT(ST_TRANSFORM(geom, 25832)) AS geom, id, short_name, xcoord, ycoord, \
bwastrid, station, dist, srid, description, site_type, priority, planned, \
organization, issued_by, contact, is_valid, created, created_by, last_edit, edited_by \
FROM mrh_1509.erkundung_06_2017 t WHERE () LIMIT 250<br> >><br>
>> Some weeks before updating the server i ran a database update, but after \
that, it worked as expected. So i dont think, the database-upgrade is the reason for \
this.<br> >> Executing the sql shows the error, which disappears when the empty \
where-clause is deleted.<br> >> I have just no clue how to handle this, so \
every hint would be helpful.<br> >><br>
>> Thanks in advance<br>
>><br>
>> Uwe Seher<br>
>><br>
>><br>
>> ______________________________<wbr>_________________<br>
>> Mapbender_users mailing list<br>
>> <a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.<wbr>org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" \
rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/mapbender_<wbr>users</a><br>
>> ______________________________<wbr>_________________<br>
>> Mapbender_users mailing list<br>
>> <a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.<wbr>org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" \
rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/mapbender_<wbr>users</a><br>
>> ______________________________<wbr>_________________<br>
>> Mapbender_users mailing list<br>
>> <a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.<wbr>org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" \
rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/mapbender_<wbr>users</a><br>
><br>
> ______________________________<wbr>_________________<br>
> Mapbender_users mailing list<br>
> <a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.<wbr>org</a><br>
> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" \
rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/mapbender_<wbr>users</a><br>
> ______________________________<wbr>_________________<br>
> Mapbender_users mailing list<br>
> <a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.<wbr>org</a><br>
> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" \
rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/mapbender_<wbr>users</a><br>
<br>
</div></div>--<br>
------------------------------<wbr>---------<br>
Aufwind durch Wissen!<br>
Qualifizierte OpenSource-GIS-Schulungen<br>
bei der <a href="http://www.foss-academy.com" rel="noreferrer" \
target="_blank">www.foss-academy.com</a><br>
------------------------------<wbr>---------<br>
<br>
Frederik Haefker<br>
WhereGroup GmbH & Co. KG<br>
Eifelstraße 7<br>
53119 Bonn<br>
Germany<br>
<br>
Fon: <a href="tel:%2B49%20%280%29228%20%2F%2090%2090%2038%20-%2021" \
value="+4922890903821">+49 (0)228 / 90 90 38 - 21</a><br>
Fax: <a href="tel:%2B49%20%280%29228%20%2F%2090%2090%2038%20-%2011" \
value="+4922890903811">+49 (0)228 / 90 90 38 - 11</a><br> <br>
<a href="mailto:frederik.haefker@wheregroup.com">frederik.haefker@wheregroup.<wbr>com</a><br>
<a href="http://www.wheregroup.com" rel="noreferrer" \
target="_blank">www.wheregroup.com</a><br> Amtsgericht Bonn, HRA 6788<br>
------------------------------<wbr>-<br>
Komplementärin:<br>
WhereGroup Verwaltungs GmbH<br>
vertreten durch:<br>
Olaf Knopp, Peter Stamm<br>
------------------------------<wbr>-<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
______________________________<wbr>_________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.<wbr>org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/mapbender_<wbr>users</a></div></div></blockquote></div><br></div>
[Attachment #6 (text/plain)]
_______________________________________________
Mapbender_users mailing list
Mapbender_users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapbender_users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic