How to Fix phpMyAdmin Error: \'count(): Parameter must be an array or an object that implements Countable\'?-PHP Tutorial-php.cn

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

Mary-Kate Olsen

Release： 2024-10-20 13:04:29

Original

572 people have browsed it

How to Fix phpMyAdmin Error:

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:

Edit the /usr/share/phpmyadmin/libraries/sql.lib.php file using the command:
```
sudo nano +613 /usr/share/phpmyadmin/libraries/sql.lib.php
```
Copy after login
Locate line 613 and make the following replacements:

Replace:

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

Copy after login

With:

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

Copy after login

Delete the extra closing parenthesis on line 614.
Restart the Apache server with the command:
```
sudo service apache2 restart
```
Copy after login

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!