I am getting the following errors in my phpmyadmin for the database. Database seems to be populating, however this error pops up everytime I check the database.
PHP Code:
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 'rankme',
string 'rankme',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `rankme`',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'rankme',
string 'rankme',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `rankme`',
NULL,
NULL,
)
Solved -
Open sql.lib.php file
PHP Code:
nano /usr/share/phpmyadmin/libraries/sql.lib.php
Find for
PHP Code:
count($analyzed_sql_results['select_expr']
This above code is at line ~613. You can see this below wrong code
PHP Code:
|| (count($analyzed_sql_results['select_expr'] == 1)
Just replace that wrong code with this below one
PHP Code:
|| ((count($analyzed_sql_results['select_expr']) == 1)
Save the file. Restart the server