How to Fix phpMyAdmin Error: \'count(): Parameter must be an array or an object that implements Countable\'?

phpMyAdmin Error: "count(): Parameter must be an array or an object that implements Countable"

Users encountering the "count(): Parameter must be an array or an object that implements Countable" error while using phpMyAdmin may be confused as to its origin and solution.

This error usually emerges when there's a problem with the count function in the phpMyAdmin codebase. In this case, the error occurs in the libraries/sql.lib.php file, specifically on line 613.

Cause:

The count function on line 613 evaluates to true even when it shouldn't because there's no closing parenthesis after $analyzed_sql_results['select_expr'].

Solution:

To resolve this issue, follow these steps:

1. Edit the /usr/share/phpmyadmin/libraries/sql.lib.php file using the command:

   sudo nano +613 /usr/share/phpmyadmin/libraries/sql.lib.php

2. Locate line 613 and make the following replacements:

Replace:

((empty($analyzed_sql_results['select_expr']))
    || (count($analyzed_sql_results['select_expr'] == 1)
        && ($analyzed_sql_results['select_expr'][0] == '*')))

With:

((empty($analyzed_sql_results['select_expr']))
    || (count($analyzed_sql_results['select_expr']) == 1)
        && ($analyzed_sql_results['select_expr'][0] == '*'))

3. Delete the extra closing parenthesis on line 614.

4. Restart the Apache server with the command:

   sudo service apache2 restart

The above is the detailed content of How to Fix phpMyAdmin Error: \'count(): Parameter must be an array or an object that implements Countable\'?. For more information, please follow other related articles on the PHP Chinese website!