Support Geometry MySQL 8

Created on 28 April 2022, about 2 years ago
Updated 27 May 2024, about 1 month ago

1) Drupal\Tests\geolocation_geometry\Functional\GeolocationGeometryViewsBoundaryTest::testBoundaryLocations
Drupal\Core\Entity\EntityStorageException: SQLSTATE[22S03]: : 3617 Latitude 170.000000 is out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000].: UPDATE "test21474466node_revision__field_geolocation_geometry_polyg" SET "field_geolocation_geometry_polyg_geometry"=ST_GeomFromText(field_geolocation_geometry_polyg_wkt, 4326), "field_geolocation_geometry_polyg_geojson"=ST_AsGeoJSON(ST_GeomFromText(field_geolocation_geometry_polyg_wkt, 4326)), "field_geolocation_geometry_polyg_data"=:db_update_placeholder_0
WHERE ("entity_id" = :db_condition_placeholder_0) AND ("revision_id" = :db_condition_placeholder_1) AND ("bundle" = :db_condition_placeholder_2) AND ("delta" = :db_condition_placeholder_3) AND ("langcode" = :db_condition_placeholder_4); Array
(
[:db_update_placeholder_0] => N;
[:db_condition_placeholder_0] => 31
[:db_condition_placeholder_1] => 31
[:db_condition_placeholder_2] => geolocation_geometry_demo
[:db_condition_placeholder_3] => 0
[:db_condition_placeholder_4] => en
)

/var/www/html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:811
/var/www/html/core/lib/Drupal/Core/Entity/EntityBase.php:339
/var/www/html/modules/contrib/geolocation/modules/geolocation_geometry/tests/src/Functional/GeolocationGeometryViewsBoundaryTest.php:80
/var/www/html/vendor/phpunit/phpunit/src/Framework/TestResult.php:726

Caused by
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22S03]: : 3617 Latitude 170.000000 is out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000].: UPDATE "test21474466node_revision__field_geolocation_geometry_polyg" SET "field_geolocation_geometry_polyg_geometry"=ST_GeomFromText(field_geolocation_geometry_polyg_wkt, 4326), "field_geolocation_geometry_polyg_geojson"=ST_AsGeoJSON(ST_GeomFromText(field_geolocation_geometry_polyg_wkt, 4326)), "field_geolocation_geometry_polyg_data"=:db_update_placeholder_0
WHERE ("entity_id" = :db_condition_placeholder_0) AND ("revision_id" = :db_condition_placeholder_1) AND ("bundle" = :db_condition_placeholder_2) AND ("delta" = :db_condition_placeholder_3) AND ("langcode" = :db_condition_placeholder_4); Array
(
[:db_update_placeholder_0] => N;
[:db_condition_placeholder_0] => 31
[:db_condition_placeholder_1] => 31
[:db_condition_placeholder_2] => geolocation_geometry_demo
[:db_condition_placeholder_3] => 0
[:db_condition_placeholder_4] => en
)

πŸ› Bug report
Status

Closed: cannot reproduce

Version

3.0

Component

Geometry

Created by

πŸ‡©πŸ‡ͺGermany ChristianAdamski Berlin, Germany

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024