Warning when browsing certain tables

[ibennetch]

On the demo server, I can reproduce this with the opengis database by trying to browse the "gis_all" table. I don't see anything obviously different about that table, though. The problem exists with both master and QA_4_8.

When browsing the table, I get a long line of warnings, starting with:

Warning in ./libraries/classes/Dbi/DbiMysqli.php#262
mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given

Backtrace

./libraries/classes/Dbi/DbiMysqli.php#262: mysqli_fetch_array(
boolean false,
integer 2,
)
./libraries/classes/DatabaseInterface.php#2554: PhpMyAdmin\Dbi\DbiMysqli->fetchRow(boolean false)
./libraries/classes/Util.php#2985: PhpMyAdmin\DatabaseInterface->fetchRow(
boolean false,
integer 0,
)
./libraries/classes/Display/Results.php#3703: PhpMyAdmin\Util::asWKT(string )
./libraries/classes/Display/Results.php#3050: PhpMyAdmin\Display\Results->_getDataCellForGeometryColumns(
string ,
string 'data not_null ',
,
array,
array,
boolean false,
array,
array,
array,
array,
)
./libraries/classes/Display/Results.php#2695: PhpMyAdmin\Display\Results->_getRowValues(
,
array,
integer 0,
boolean false,
array,
string '',
boolean false,
string 'SELECT * FROM `gis_all`',
array,
)
./libraries/classes/Display/Results.php#4289: PhpMyAdmin\Display\Results->_getTableBody(
,
array,
array,
array,
boolean false,
)
./libraries/classes/Sql.php#1738: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean false,
)
./libraries/classes/Sql.php#2031: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean false,
string '7',
integer 7,
NULL,
,
array,
)
./libraries/classes/Sql.php#2252: PhpMyAdmin\Sql->getQueryResponseForResultsReturned(
,
array,
string 'opengis',
string 'gis_all',
NULL,
NULL,
,
string './themes/pmahomme/img/',
string '7',
integer 7,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'SELECT * FROM `gis_all`',
NULL,
)
./libraries/classes/Sql.php#2129: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'opengis',
string 'gis_all',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `gis_all`',
NULL,
NULL,
)
./sql.php#215: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'opengis',
string 'gis_all',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `gis_all`',
NULL,
NULL,
)

[williamdes]

Seems to be only with MySQL

[aroralakshya]

I'm getting a 500 error.

[williamdes]

I am unable to reproduce this issue on demo-servers and on local setups.
@ibennetch /close ?
Demo servers (root, no password)

• 5.0.0-dev
• 4.8.x

[williamdes]

Param	Value
Error Type	Warning
Error Message	mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given
Exception Type	php
phpMyAdmin version	4.8.5
Incident count	3936
Link	Report#55947

This comment is posted automatically by phpMyAdmin's error-reporting-server.

[ibennetch]

I don't think I can reproduce this any longer.

[williamdes]

@ibennetch You can reproduce this with a table that was a GIS row (with data) using a mysql 8.0 server

[github-actions]

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.