Skip to content

Error when visualizing nullable geometry column #16706

Description

@M393

Describe the bug

Error when visualizing nullable geometry column.

To Reproduce

Steps to reproduce the behavior:

  1. Create table with nullable geometry
CREATE TABLE `a` (`p` polygon DEFAULT NULL);
INSERT INTO `a` (`p`) VALUES (NULL);
SELECT * FROM `a`;
  1. Click on Visualize GIS data
  2. See error
Error in GIS visualize with nullable Polygon column
<b>Fatal error</b>:  Uncaught TypeError: mb_strpos() expects parameter 1 to be string, null given in libraries\classes\Gis\GisVisualization.php:626
Stack trace:
#0 libraries\classes\Gis\GisVisualization.php(626): mb_strpos(NULL, '(')
#1 libraries\classes\Gis\GisVisualization.php(365): PhpMyAdmin\Gis\GisVisualization->scaleDataSet(Array)
#2 libraries\classes\Gis\GisVisualization.php(382): PhpMyAdmin\Gis\GisVisualization->svg()
#3 libraries\classes\Gis\GisVisualization.php(568): PhpMyAdmin\Gis\GisVisualization->asSVG()
#4 libraries\classes\Controllers\Table\GisVisualizationController.php(184): PhpMyAdmin\Gis\GisVisualization->toImage('svg')
#5 libraries\classes\Routing.php(186): PhpMyAdmin\Controllers\Table\GisVisualizationController->index(Array)
#6 index.php(18): PhpMyAdmin\Routing::callControllerForRoute('/table/gis-visu...', Object(FastRoute\Dispatcher\GroupCountBased), Object(Symfony\Component\DependencyInjection\ContainerBuilder))
#7 {main}
  thrown in <b>libraries\classes\Gis\GisVisualization.php</b> on line <b>626</b>

Expected behavior

Ignore null values for visualization.

Server configuration

  • Operating system: Windows 7
  • Web server: Apache 2.4
  • Database version: MySQL 5.7.29
  • PHP version: 7.2
  • phpMyAdmin version: 5.1

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

BugA problem or regression with an existing feature

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions