Fix Bug Phpmyadmin [sql.lib.php] + Php7.2 + Ubuntu 16.04
I have faced this error recently , look like this
Warning in ./libraries/sql.lib.php#601
count(): Parameter must be an array or an object that implements Countable
This warning comes again and again when you try to access phpmyadmin databases tables ,
below solution I tried may be got help to you also :
OPEN THE BELOW FILE
/usr/share/phpmyadmin/libraries/sql.lib.php
and search for this line
(count($analyzed_sql_results[‘select_expr’] == 1)
change this line to this :
(count($analyzed_sql_results[‘select_expr’]) == 1
Whole Function will be look like this:
function PMA_isRememberSortingOrder($analyzed_sql_results)
{
return $GLOBALS['cfg']['RememberSorting']
&& ! ($analyzed_sql_results['is_count']
|| $analyzed_sql_results['is_export']
|| $analyzed_sql_results['is_func']
|| $analyzed_sql_results['is_analyse'])
&& $analyzed_sql_results['select_from']
&& ((empty($analyzed_sql_results['select_expr']))
|| ((count($analyzed_sql_results['select_expr']) == 1)
&& ($analyzed_sql_results['select_expr'][0] == '*')))
&& count($analyzed_sql_results['select_tables']) == 1;
}Hope this will remove the warning.
Thanks
Join the conversation