Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

useher
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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

useher
Update:

The error occurs when 'current extent' is activated. If this is deactivated everything works. Also the sql-statemant works, when the empty brackets are filled with a 'true'.

Uwe Seher

2017-05-03 9:14 GMT+02:00 Uwe Seher <[hidden email]>:
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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

Gero Wahren
In reply to this post by useher
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: [hidden email]
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" <[hidden email]>
An: "Mapbender User List" <[hidden email]>
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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

UPDATE:Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

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: [hidden email]
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" <[hidden email]>
An: "Mapbender User List" <[hidden email]>
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: [hidden email]
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" <[hidden email]>
An: "Mapbender User List" <[hidden email]>
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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: UPDATE:Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

Frederik Haefker (WhereGroup)
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: [hidden email]
> 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" <[hidden email]>
> An: "Mapbender User List" <[hidden email]>
> 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: [hidden email]
> 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" <[hidden email]>
> An: "Mapbender User List" <[hidden email]>
> 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
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users


_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: UPDATE:Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

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: [hidden email]
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)" <[hidden email]>
An: "Mapbender User List" <[hidden email]>
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: [hidden email]
> 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" <[hidden email]>
> An: "Mapbender User List" <[hidden email]>
> 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: [hidden email]
> 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" <[hidden email]>
> An: "Mapbender User List" <[hidden email]>
> 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
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users


_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: UPDATE:Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

Frederik Haefker (WhereGroup)
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: [hidden email]
> 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)" <[hidden email]>
> An: "Mapbender User List" <[hidden email]>
> 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: [hidden email]
>> 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" <[hidden email]>
>> An: "Mapbender User List" <[hidden email]>
>> 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: [hidden email]
>> 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" <[hidden email]>
>> An: "Mapbender User List" <[hidden email]>
>> 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
>> [hidden email]
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>> _______________________________________________
>> Mapbender_users mailing list
>> [hidden email]
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>> _______________________________________________
>> Mapbender_users mailing list
>> [hidden email]
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> 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

[hidden email]
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------


_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: UPDATE:Re: Mapbender3-3.0.5.3: Error after updating PHP5 to PHP7

useher
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) <[hidden email]>:
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: [hidden email]
> 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)" <[hidden email]>
> An: "Mapbender User List" <[hidden email]>
> 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: [hidden email]
>> 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" <[hidden email]>
>> An: "Mapbender User List" <[hidden email]>
>> 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: [hidden email]
>> 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" <[hidden email]>
>> An: "Mapbender User List" <[hidden email]>
>> 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
>> [hidden email]
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>> _______________________________________________
>> Mapbender_users mailing list
>> [hidden email]
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>> _______________________________________________
>> Mapbender_users mailing list
>> [hidden email]
>> https://lists.osgeo.org/mailman/listinfo/mapbender_users
>
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
> _______________________________________________
> Mapbender_users mailing list
> [hidden email]
> 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: <a href="tel:%2B49%20%280%29228%20%2F%2090%2090%2038%20-%2021" value="+4922890903821">+49 (0)228 / 90 90 38 - 21
Fax: <a href="tel:%2B49%20%280%29228%20%2F%2090%2090%2038%20-%2011" value="+4922890903811">+49 (0)228 / 90 90 38 - 11

[hidden email]
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------


_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users


_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users