phpmyadmin – count(): Parameter must be an array or an object that implements Countable

by

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

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

On line 613 the count function always evaluates to true since there is no closing parenthesis after $analyzed_sql_results['select_expr']. Making the below replacements resolves this, then you will need to delete the last closing parenthesis on line 614, as it’s now an extra parenthesis.

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

Restart the server apache:

sudo service apache2 restart

More Related Contents:

  1. Can I store query result of one field into different variables? if not then what should I do for that?
  2. how to compare the two fields in php with different table in mysql?
  3. Php foreach give 2 users random value
  4. The requested URL was not found on this server.
  5. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  6. How to write a stored procedure using phpmyadmin and how to use it through php?
  7. Import file size limit in PHPMyAdmin
  8. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  9. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  10. Mysql event error using php
  11. Call to undefined function __() error – phpMyAdmin
  12. Auto increment in phpmyadmin
  13. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  14. Store procedures in phpMyAdmin
  15. How to connect sql server with php using xampp?
  16. How to solve time out in phpmyadmin?
  17. WAMP/MySQL errors not in correct language
  18. phpmyadmin automatic logout time
  19. WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded
  20. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. Extension mysqli is missing, phpmyadmin doesn’t work
  23. mysqli_real_connect(): (HY000/2002): No such file or directory
  24. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  25. How to SELECT DEFAULT value of a field
  26. How to log in to phpMyAdmin with WAMP, what is the username and password?
  27. Auto Increment skipping numbers?
  28. How to write a stored procedure in phpMyAdmin?
  29. Installing PDO driver on MySQL Linux server
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment