[Mapbender-users] UPDATE:Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

Wed May 3 04:46:26 PDT 2017

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 at 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 at 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 at wheregroup.com>
> > An: "Mapbender User List" <mapbender_users at 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 at 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 at klemm-hensen.de>
> >> An: "Mapbender User List" <mapbender_users at 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 at 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 at gmail.com>
> >> An: "Mapbender User List" <mapbender_users at 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 at lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> >> _______________________________________________
> >> Mapbender_users mailing list
> >> Mapbender_users at lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> >> _______________________________________________
> >> Mapbender_users mailing list
> >> Mapbender_users at lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> >
> > _______________________________________________
> > Mapbender_users mailing list
> > Mapbender_users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/mapbender_users
> > _______________________________________________
> > Mapbender_users mailing list
> > Mapbender_users at 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 at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20170503/bbf088f6/attachment-0001.html>