SQL Errors in PhpMyAdmin

Chris Andrews6 years ago

I just stood up a new server for testing. It is running Ubuntu 18.10, MySql v 5.7.25 and PhpMyAdmin. The install seems to be running fine, I can enter units, and it is properly mapping the location data. However, when I load PhpMyAdmin and browse to any table in the Traccar database, the below error shows. Is this anything to worry about?

Warning in ./libraries/sql.lib.php#613
 count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'traccar',
string 'tc_statistics',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tc_statistics`',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'traccar',
string 'tc_statistics',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tc_statistics`',
NULL,
NULL,
)
Ernesto Vallejo6 years ago

This issue is not related to this forum.

Tony Shelver6 years ago

Try the standard MySQL admin tool instead of PHPAdmin, see if it changes. Or load Posgresql 10/11 and pgAdmin4 instead ;)