How to Fix the Error \"count(): Parameter must be an Array or Object that Implements Countable\" in phpMyAdmin?

phpMyAdmin Error: "count(): Parameter must be an Array or Object that Implements Countable"

In phpMyAdmin, users may encounter an error message indicating "count(): Parameter must be an array or an object that implements Countable." This error typically occurs while interacting with database tables.

原因：

The error is caused by an incorrect parameter being passed to the count() function within phpMyAdmin's code. Specifically, the parameter should be an array or an object that supports the Countable interface, but instead, it is receiving a different type of parameter, such as a string.

解决方案：

To resolve this error, it is necessary to edit the /usr/share/phpmyadmin/libraries/sql.lib.php file using the following command:

<code class="pre">sudo nano +613 /usr/share/phpmyadmin/libraries/sql.lib.php</code>

On line 613, the code should be modified to ensure that the count() function is passed the correct parameter. The following changes should be made:

• Replace this code:

  <code class="pre">((empty($analyzed_sql_results['select_expr']))
  || (count($analyzed_sql_results['select_expr'] == 1)
      &amp;&amp; ($analyzed_sql_results['select_expr'][0] == '*')))</code>

  • With this code:

  <code class="pre">((empty($analyzed_sql_results['select_expr']))
  || (count($analyzed_sql_results['select_expr']) == 1)
      &amp;&amp; ($analyzed_sql_results['select_expr'][0] == '*'))</code>

  • Remove the extra closing parenthesis on line 614, which is now unnecessary.

After making these changes, save the file and restart the Apache server:

<code class="pre">sudo service apache2 restart</code>

This should resolve the error and allow users to interact with their database tables without encountering the "count() parameter must be an array or an object that implements Countable" error.

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