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.
sql.lib.php 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, it is strongly recommended that you manually upgrade to the latest version of phpMyAdmin yourself. Alternatively, you can make a change tosql.lib.php
to temporarily fix the error. Firstly, backupsql.lib.php
before editing.sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.bak
Editsql.lib.php
innano
.sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php
PressCTRL
+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. (PressCTRL
+X
, pressY
and then pressENTER
) Import/Export issues If you are also getting an errorWarning in ./libraries/plugin_interface.lib.php#551
under import and export tabs: Backupplugin_interface.lib.php
sudo cp /usr/share/phpmyadmin/libraries/plugin_interface.lib.php /usr/share/phpmyadmin/libraries/plugin_interface.lib.php.bak
Editplugin_interface.lib.php
sudo nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php
PressCTRL
+W
and search forif (! is_null($options) && count($options) > 0) {
If not found, try search forif ($options != null && count($options) > 0)
Replace withif (! is_null($options) && count((array)$options) > 0) {
Save file and exit. (PressCTRL
+X
, pressY
and then pressENTER
)