The Art of Writing Short Stories Read Here

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

You may also like :