Some errors have been detected on the server! Please look at the bottom of this window. Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable
This error is caused by a line of code in
It seems when I installed phpMyAdmin using
apt, the version in the repository (phpMyAdmin v4.6.6) is 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.
You can download the latest version and install it manually or wait for the repositories to update with the newer version.
Alternatively, you can make a small change to
sql.lib.php to fix the error.
sql.lib.php before editing.
sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.bak
sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php
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
Y and then press
Note that this is just a temporary fix and other compatibility issues may crop up until you update phpMyAdmin.