Problem with phpMyAdmin and PHP 7.2: “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable”
Last updated on June 27th, 2018
It’s possible that when you installed phpMyAdmin, the version in the repository (phpMyAdmin v4.6.6) was not fully compatible with PHP 7.2. There is a newer version available on the official website (v4.8 as of writing), which fixes these compatibility issues with PHP 7.2.
This error is caused by a line of code in /usr/share/phpmyadmin/libraries/sql.lib.php.
If you don’t want to wait for the repositories to update with the latest version, you can manually upgrade to the latest version of phpMyAdmin yourself.
Alternatively, you can make a small change to sql.lib.php to fix the error.
Firstly, backup sql.lib.php before editing.
sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.bak
Edit sql.lib.php in nano.
sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php
Press CTRL + W and search for (count($analyzed_sql_results['select_expr'] == 1)
Replace it with ((count($analyzed_sql_results['select_expr']) == 1)
Save file and exit. (Press CTRL + X, press Y and then press ENTER)
Note that this is just a temporary fix and other compatibility issues may crop up until you update phpMyAdmin to the latest version.
If you are also getting an error Warning in ./libraries/plugin_interface.lib.php#551 under import and export tabs, see comments below.
Let me know in the comments if this helped. Follow me @DevAnswers or read more.
Backup plugin_interface.lib.php
sudo cp /usr/share/phpmyadmin/libraries/plugin_interface.lib.php /usr/share/phpmyadmin/libraries/plugin_interface.lib.php.bak
Edit plugin_interface.lib.php
sudo nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php
Press CTRL + W and search for
if (! is_null($options) && count($options) > 0) {
Replace with
if (! is_null($options)) {
Save file and exit. (Press CTRL + X, press Y and then press ENTER)
if not found:
if (! is_null($options) && count($options) > 0) {
please search:
if ($options != null && count($options) > 0) {
and …
It works.
[https://devanswers.co/problem-php-7-2-phpmyadmin-warning-in-librariessql-count/](https://devanswers.co/problem-php-7-2-phpmyadmin-warning-in-librariessql-count/)
