phpMyAdmin and PHP 7 issues

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

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, it is strongly recommended that you manually upgrade to the latest version of phpMyAdmin yourself.

Alternatively, you can make a change to sql.lib.php to temporarily 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 arise until you update phpMyAdmin to the latest version.

Import/Export issues

If you are also getting an error Warning in ./libraries/plugin_interface.lib.php#551 under import and export tabs:

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) {

If not found, try search for if ($options != null && count($options) > 0)

Replace with if (! is_null($options) && count((array)$options) > 0) {

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 arise until you update phpMyAdmin to the latest version.

Let me know in the comments if this helped. Follow me on Twitter, Facebook and YouTube.

p.s. I increased my AdSense revenue by 68% using AI 🤖. Read my Ezoic review to find out how.

1 Star2 Stars3 Stars4 Stars5 Stars 4.84 (119 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *

We use Markdown to style comments, like on Github and Reddit.
To do a line break, type two spaces after the sentence.
You can add inline code by wrapping it in backticks: `code here`

    To do an entire block of code  
    type four spaces before the line
    and it will appear in a block like this.
    <-- four empty spaces

128 replies

You saved me from a world of pain and horror, thank you! Works on Ubuntu 18.04.1 / PHP 7.2.17 / Apache 2.4.29. I was having trouble with exporting and the second fix did it for me. I applied both just in case.

For the import/export issue you can replace the code with:
if (! is_null($options) && count((array)$options) > 0) {

For import/export issue ,
If you don’t find : (! is_null($options) && count($options) > 0)
search : if ($options != null && count($options) > 0)

Import/Export issues
If you are also getting an error Warning in ./libraries/plugin_interface.lib.php#551 under import and export tabs:
Search:
if ($options != null && count($options) > 0) {

Very nice. Did it via FileZilla. Only download file, edit and upload. Or even edit it via nano and save. Reload the page in phpmyadmin and the error isnt there anymore. Thank you very much 😀

it help me a lot but after this solution i am facing count () function is not working with group by . hosting to Digital Ocean Droplet where
OS is Ubuntu 18.04,
Apache2,
PHP 7.2,
Tomcat 9,
MySQL 5.7 ,
PhpMyAdmin 4.8.
but same program is working in another hosting (not VPS) which is running.
will you give me guideline ?

I seem to have errors in phpmyadmin. I get Warning in ./libraries/plugin_interface.lib.php#551 under import and export tabs. I have done above 🙁

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 ($options != null) {

Save file and exit. (Press CTRL + X, press Y and then press ENTER)

I ended up taking a complete back flip. I worked out what i did wrong. I set up the database users incorrectly and wouldn’t connect. I ended up using a raspberry pi instead of laptop. Easier to make backups or repair if it goes down. I have found your posts very handy. thanks

if not found: if (! is_null($options) && count($options) > 0) {

please search: if ($options != null && count($options) > 0) { and … It works.

Hi, thanks for the article and this comment. When I tried this, the section of the screen is blank. There is nothing in the section that has the import options.

Carefull for some of us does changing this setting isn’t working, You get Blank Page, follow the steps @Ardhia Mangku Ikhsan Provided.

Error in processing request
Error code: 500
Error text: Internal Server Error

1, I get this error when selecting a table and query in Phpmyadmin.
2, Also My imported files are not in the db.
3, Export page in the created DB is blank.

Kindly help me to solve this issue.
Thank you in advance. Have a great day

Regards,
Sampath