<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>