Home > Article > Backend Development > How to Fix phpMyAdmin Error: \"count(): Parameter must be an array or an object that implements Countable\"?

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

Mary-Kate OlsenOriginal: 2024-10-20 13:04:29486browse

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
```
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] == '*')))

With:

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

Delete the extra closing parenthesis on line 614.
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!

php sql Array Object count while Error using delete function this apache issue phpMyAdmin

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：How to Capture Millisecond Precision of the Current Time Using PHP?Next article：How to Capture Millisecond Precision of the Current Time Using PHP?

See more

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

Related articles