I’ve uploaded the backup to a table, opening the table I see this:

Warning in ./libraries/sql.lib.php#601
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/sql.lib.php#2038: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#1984: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'alternativegirls',
string 'tgp_photo',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tgp_photo`',
NULL,
NULL,
)
./sql.php#216: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'alternativegirls',
string 'tgp_photo',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,

Inside phpMyAdmin…

PHP is 7.2, the server is Ubuntu 16.04, installed yesterday.

Looking for I saw that some have this error in their code, but I did not find anyone who received it in phpMyAdmin…

What should I do? Is that my error? A phpmyadmin error? wait update ? I go back to PHP 7.1?

Those who are facing problem as: if ( count($articles)){..} in CodeIgniter, they should use: if ( count((array)$articles)){..} as here

– fWd82May 31, 2018 at 19:32

i had this issue on phpmyadmin v4.6 i updated to 4.8 it disappeared . , looks like it have something to do with mariadb 10.3 as i had not that issue on mariadb 10.1 with phpmyadmin 4.6 

– user889030Jan 25, 2019 at 15:17

In my case the problem occured when I had installed php 7.3 while my phpMyAdmin was 4.7.1, I switched back to php 7.0 and it works fine or you shoud install version of phpMyAdmin compatible with php 7.3 

– vinsaJun 7, 2019 at 22:06

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

Unbelievable. Works on Ubuntu 18.04 with phpmyadmin installed using apt. 

– 

Worked in that I could select tables, but error returned when I tried to export Db 

– 

Bug has been reported: bugs.launchpad.net/ubuntu/+source/phpmyadmin/+bug/1767361

– 

If you face a similar problem in DB export you need to edit /usr/share/phpmyadmin/libraries/plugin_interface.lib.php, line 551 from if ($options != null && count($options) > 0) { to _if ($options != null && count((array)$options) > 0) { Might be interesting for @alperian and others 

– 

This didn’t work for me. I got Error in processing request Error code: 500 Error text: Internal Server Error. The solution of @Chandra Nakka fixed my problem. 

– 

The Easiest Method:

Just run this below command line in terminal and come back to PhpMyAdmin.

sudo sed -i "s/|\s*\((count($analyzed_sql_results\['select_expr'\]\)/| ()/g" /usr/share/phpmyadmin/libraries/sql.lib.php

Manual Method:

Open sql.lib.php file

nano /usr/share/phpmyadmin/libraries/sql.lib.php

Find for count($analyzed_sql_results['select_expr'] code on file. You can get this at line ~613. You can see this below wrong code

|| (count($analyzed_sql_results['select_expr'] == 1)

Just replace that wrong code with this below one

|| ((count($analyzed_sql_results['select_expr']) == 1)

Save the file and come to PhpMyAdmin.

Works in Ubuntu 18.04 at Aug 2018 🙂 

– 

Works like charm 

– 

Works on Ubuntu 19.04. Thanks 

– 

A neat little trick to nano is, that you can type nano +613 filename in order to take you directly to the specific line. 

– 

@SteffenNielsen thanks a lot for this useful tip 🙂 

– 

112

I found this PHP 7.2 count() – SYNTAX error in sql.lib.php

That perfectly works on my config:

Debian 9, 
PHP 7.2.3-1+0~20180306120016.19+stretch~1.gbp81bf3b (cli) (built: Mar  6 2018 12:00:19) ( NTS )

Open /usr/share/phpmyadmin/libraries/sql.lib.php

Change line: Move parenthesis before ==

|| ((count($analyzed_sql_results[‘select_expr’] ) == 1) && ($analyzed_sql_results[‘select_expr’][0] == ‘*’)))

in

function PMA_isRememberSortingOrder($analyzed_sql_results){

return $GLOBALS['cfg']['RememberSorting']
    && ! ($analyzed_sql_results['is_count']
        || $analyzed_sql_results['is_export']
        || $analyzed_sql_results['is_func']
        || $analyzed_sql_results['is_analyse'])
    && $analyzed_sql_results['select_from']
    && ((empty($analyzed_sql_results['select_expr']))
        || ((count($analyzed_sql_results['select_expr'] ) == 1)
            && ($analyzed_sql_results['select_expr'][0] == '*')))
    && count($analyzed_sql_results['select_tables']) == 1;
 }

In the following line you will also have to remove one of the closing paranthesis at the end. 

– 

Thanks. How did such an error get released with an apt installable package? Just a bit ridiculous. 

– 

@floppes No, it is not correct. You SHOULD NOT remove that closing paranthesis. I have tested your way and it caused server error. @loquace’s answer should be the one to be accepted. 

– 

Thanks for spelling it out for us and using bold font where it’s needed. Neither the 1st nor the 2nd answers were clear enough for me because they didn’t say what they were doing. Editing on nano isn’t the same as gedit or whatever. 

– 

tested on Debian, should works on Ubuntu:

1.) First download latest phpMyadmin file.

2.) Delete (make a backup) all previous version file located in /usr/share/phpmyadmin directory.

3.) Uncompress to /usr/share/phpmyadmin/ directory all files of latest phpmyadmin.

4.) Modify file libraries/vendor_config.php and change line:

define('CONFIG_DIR', '');

to

define('CONFIG_DIR', '/etc/phpmyadmin/');

and

define('TEMP_DIR', './tmp/');

to

define('TEMP_DIR', '/tmp/');

5.) restart apache server and done.

Works on Ubuntu 16.04 

– 

Works on Ubuntu 18.04 

– 

Ubuntu 18.04, phpMyAdmin 4.8.0.1 – I needed to mkdir /usr/share/phpmyadmin/tmp; chgrp www-data tmp; chmod g+w tmp;

– 

Ubuntu 16.04 just extracting it to /usr/share/phpmyadmin worked. Did not need to follow the later steps. 

– 

@billynoah Same here with new install. I created the tmp directory, set it to 777, restarted Apache, logged out of phpMyAdmin and the errors went away. 

– 

Edit file: '/usr/share/phpmyadmin/libraries/sql.lib.php'

Replace: (count($analyzed_sql_results['select_expr'] == 1)

With: (count($analyzed_sql_results['select_expr']) == 1

this worked for me

Its worked for me based on condition u have fix internal 500 error was solved, but old error issue “phpmyadmin – count(): Parameter must be an array or an object that implements Countable” is not solved. 

– 

this seems to work for me but does any one know why this has happened? My phpmyadmin was working just fine and then all the sudden I logged in today and it appeared to have this issue? Ubuntu 18.04.2 LTS 

– 

Works on UBuntu 18.04 , wing Nginx , php 7.2 

– 

If someone have similar error in DB export page (I had this issue in Ubuntu 18.04), then replace line 551 in file /usr/share/phpmyadmin/libraries/plugin_interface.lib.php with code

if ($options != null && (is_array($options) || $options instanceof Countable) && count($options) > 0) {

This helped me as well, but I had to do both the answer and this. Ubuntu 18.04 

– 

This worked to get rid of the error messages, but I think it then avoids the if statement all together and I don’t get anything in my database export (with a bunch of errors showing at the bottom after refreshing the page upon completing a database export with a tiny file footprint) 

– 

On Debian 9 replace the line 551: if ($options != null && count($options) > 0) { with : if ($options != null) { then you can export 

– 

This is the fix for the error ending 551 – as error is at line 551. The other fix is good too but is a fix for another problem. This should be the accepted answer for this problem. 

– 

Works on UBUNTU 18.04 


Edit file: '/usr/share/phpmyadmin/libraries/sql.lib.php'
Replace: (count($analyzed_sql_results['select_expr'] == 1)
With:  ((count($analyzed_sql_results['select_expr']) == 1)

Restart the server
sudo service apache2 restart

This worked for me on 18.04, thanks! No need even to restart the server – PHP is interpreted ‘live’. 

– 

@JelleVeraa , You are the special case hehehe 😉 

– 

phpmyadmin 4.7.4 is supposed to have “Fixed several compatibility issues with PHP 7.2”

Chances are you have an older version of phpmyadmin.

https://www.phpmyadmin.net/news/2017/8/24/phpmyadmin-474-released/

Ubuntu 18.04 LTS

These are the steps which worked for me. Many, many thanks to William Desportes for providing the automatic updates on their Ubuntu PPA.

Step 1 (from William Desportes post)
$ sudo add-apt-repository ppa:phpmyadmin/ppa

Step 2
$ sudo apt-get --with-new-pkgs upgrade

Step 3
$ sudo service mysql restart

If you have issues restarting mysql, you can also restart with the following sequence
$ sudo service mysql stop;
$ sudo service mysql start;

Solves the issue on Ubuntu 18.04 LTS. Should be the accepted answer. 

– 

Proceed following steps at ubuntu-18.04:

Step 1) locate sql.lib.php

It will show something like:

/usr/share/phpmyadmin/libraries/sql.lib.php

Step 2) Open terminal (Alt t) and write:

sudo /usr/sbin/pma-configure

Step 3)sudo gedit /usr/share/phpmyadmin/libraries/sql.lib.php and search below function:

function PMA_isRememberSortingOrder($analyzed_sql_results)
     {
        return $GLOBALS['cfg']['RememberSorting']
            && ! ($analyzed_sql_results['is_count']
                || $analyzed_sql_results['is_export']
                || $analyzed_sql_results['is_func']
                || $analyzed_sql_results['is_analyse'])
            && $analyzed_sql_results['select_from']
            && ((empty($analyzed_sql_results['select_expr']))
                || (count($analyzed_sql_results['select_expr'] == 1)
                    && ($analyzed_sql_results['select_expr'][0] == '*')))
            && count($analyzed_sql_results['select_tables']) == 1;
     }

Step 4) Replace above function with:

     function PMA_isRememberSortingOrder($analyzed_sql_results)
     {
        return $GLOBALS['cfg']['RememberSorting']
            && ! ($analyzed_sql_results['is_count']
                || $analyzed_sql_results['is_export']
                || $analyzed_sql_results['is_func']
                || $analyzed_sql_results['is_analyse'])
            && $analyzed_sql_results['select_from']
            && ((empty($analyzed_sql_results['select_expr']))
                || (count($analyzed_sql_results['select_expr']) == 1)
                    && ($analyzed_sql_results['select_expr'][0] == '*'))
            && count($analyzed_sql_results['select_tables']) == 1;
     }

Step 4) Save & close file and below command on terminal

sudo /usr/sbin/pma-secure

Step 5) sudo service mysql reload

Step 6) sudo service apache2 reload

It works for me.. Goodluck

The MySQL and apache reload are not necessary. 

– 

I got this message after file modifications : “— root@Lalla:~# /usr/sbin/pma-secure — Securing phpMyAdmin installation… — Setup script won’t be able to write configuration. — root@Lalla:~# ” 

– 

open this file: ‘/usr/share/phpmyadmin/libraries/sql.lib.php’

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

press ctrl+w to search (count($analyzed_sql_results[‘select_expr’] == 1)

Find: count($analyzed_sql_results['select_expr'] == 1)

Replace With:  (count($analyzed_sql_results['select_expr']) == 1)

Restart the server

 sudo service apache2 restart

moreover, If you still facing same issue then do following.

open this file /usr/share/phpmyadmin/libraries/plugin_interface.lib.php

sudo nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php

Find : if ($options != null && count($options) > 0) {

Ctrl+w : if ($options != null && count($options) > 0) {

replace with following code

if ($options != null && count((array)$options) > 0) {

now save and restart the server

sudo /etc/init.d/apache2 restart

You simply added a brace. But thanks. I removed the extra brace at the end of the line 

– 

I have xampp installed on my mac, I couldnt find /usr/share/phpmyadmin folder and hence ‘/usr/share/phpmyadmin/libraries/sql.lib.php’ this dosent exist for me, can you help in that ? 

– 

Try replace this function in file: /usr/share/phpmyadmin/libraries/sql.lib.php

function PMA_isRememberSortingOrder($analyzed_sql_results)
{
    return $GLOBALS['cfg']['RememberSorting']
        && ! ($analyzed_sql_results['is_count']
            || $analyzed_sql_results['is_export']
            || $analyzed_sql_results['is_func']
            || $analyzed_sql_results['is_analyse'])
        && $analyzed_sql_results['select_from']
        && ((empty($analyzed_sql_results['select_expr']))
            || (count($analyzed_sql_results['select_expr']) == 1)
                && ($analyzed_sql_results['select_expr'][0] == '*'))
        && count($analyzed_sql_results['select_tables']) == 1;
}

Thanks! this line is where i was mistaken at the end where i had 3 closing bracket insted i needed 2 closing brackets only && ($analyzed_sql_results[‘select_expr’][0] == ‘*’)). Worked on phpmyadmin 4.6, php 7.2.10 , ubuntu 18.4.1 

– 

This worked. There are two changes, on line 613 add missing closing parenthesis for (count($analyzed_sql_results['select_expr'] == 1) should be (count($analyzed_sql_results['select_expr']) == 1) and remove extra parenthesis on line 614 && ($analyzed_sql_results['select_expr'][0] == '*'))) should be && ($analyzed_sql_results['select_expr'][0] == '*')). 

– 

I think the best option is to update Phpmyadmin to a version which has this already fixed.

Until it is published as a deb, you could do it like in @crimson-501 answer which I will copy below:

• Your first step is to install PMA (phpMyAdmin) from the official Ubuntu repo: apt-get install phpmyadmin.
• Next, cd into usr/share directory: cd /usr/share.
• Third, remove the phpmyadmin directory: rm -rf phpmyadmin.
• Now we need to download the latest PMA version onto our system (Note that you need wget: apt-get install wget): wget -P /usr/share/ "https://files.phpmyadmin.net/phpMyAdmin/4.9.4/phpMyAdmin-4.9.4-english.zip" Let me explain the arguments of this command, -P defines the path and “the link.zip” is currently (7/17/18) the latest version of PMA. You can find those links HERE.
• For this next step you need unzip (apt-get install unzip): unzip phpMyAdmin-4.9.4-english.zip. We just unzipped PMA, now we will move it to it’s final home.
• Lets use the cp (copy) command to move our files! Note that we have to add the -r argument since this is a folder. cp -r phpMyAdmin-4.9.4-english phpmyadmin.
• Now it’s time to clean up: rm -rf phpMyAdmin-4.9.4-english.

Keep Reading!

You might now notice two errors after you log into PMA.

the configuration file now needs a secret passphrase (blowfish_secret). phpmyadmin
The $cfg['TempDir'] (./tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.

However, these issues are relatively easy to fix. For the first issue all you have to do is grab your editor of choice and edit /usr/share/phpmyadmin/config.inc.php but there’s a problem, we removed it! That’s ok, all you have to do is: cd /usr/share/phpmyadmin & cp config.sample.inc.php config.inc.php.

• We will now add our Blowfish Secret! nano config.inc.php and copy the dynamically generated secret from near the bottom of this page: https://www.question-defense.com/tools/phpmyadmin-blowfish-secret-generator.

Example phpMyAdmin Blowfish Secret Variable Entry:

/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = '{^QP+-(3mlHy+Gd~FE3mN{gIATs^1lX+T=KVYv{ubK*U0V'; 
/* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Now save and close the file.

• Now we will create a tmp directory for PMA: mkdir tmp & chown -R www-data:www-data /usr/share/phpmyadmin/tmp. The last command allows the Apache web server to own the tmp directory and edit it’s contents.

This answer has been incredibly useful! Solved the problem for me! Thanks! PS: You can find blowfish generators online. 

– 

And the solution at this link: devanswers.co/manually-upgrade-phpmyadmin follows a similar plan, except replaces the blowfish steps with easier ones.. 

– 

This is a much better solution compared to editing older versions’ config files. 

– 

This is the best solution. Following this link: devanswers.co/manually-upgrade-phpmyadmin I was able to remove the count-parameter error and the Server error 500 error (which is not removed by the accepted answer). Definitely the real problem was the by default installed phpmyadmin version. Thanks a lot. +1. 

– 

Ubuntu 18.10 (December, 2018)

Line 613, 614, 615, replace with:

        || count($analyzed_sql_results['select_expr']) == 1
            && ($analyzed_sql_results['select_expr'][0] == '*'))
    && count($analyzed_sql_results['select_tables']) == 1;

It’s worked for me.. No need to upgrade mysql or anything… Thanks @ole 

– 

Work for me.. Ubuntu 18.04

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

Find for count($analyzed_sql_results['select_expr'] code on file. You can get this at line ~613.

|| (count($analyzed_sql_results['select_expr'] == 1)

Just replace with code :

|| ((count($analyzed_sql_results['select_expr']) == 1)

Save the file and reload PhpMyAdmin.

Done!!!

In line 613, change to || (count($analyzed_sql_results['select_expr']) == 1

– 

For my version of phpmyadmin (4.6.6deb5), I found line 613, and realized the count() parentheses were not closed properly. To fix this temporarily until the next release, just change:

|| (count($analyzed_sql_results['select_expr'] == 1)

to:

|| (count($analyzed_sql_results['select_expr']) == 1

There were a missing parenthesis to close the function call || (count($analyzed_sql_results[‘select_expr’]) == 1 is the correct statement 

– 

file path is “/usr/share/phpmyadmin/libraries/sql.lib.php” for those who don’t know where to find it. 

– 

This worked for me;

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

Line No : 614

Replace two codes :

Replace:

(count($analyzed_sql_results[‘select_expr’] == 1)

With:

(count($analyzed_sql_results[‘select_expr’]) == 1)

AND

Replace:

($analyzed_sql_results[‘select_expr’][0] == ‘*’)))

With:

($analyzed_sql_results[‘select_expr’][0] == ‘*’))

save, exit and run

sudo service apache2 restart

worked for me Raspbian GNU/Linux 10 (buster) 

– 

This is fixed in later versions of PHPMyAdmin. The Ubuntu Software Repositories for Ubuntu 18.04.2 holds version 4.6.6.5, while they’re currently at 4.9.0.1. Updating your PHPMyAdmin installation will fix this problem, but might prove to be riskier than just editing that one line of code. Here’s how I did it on my Ubuntu Server. Steps are essentially the same (with a different path) for all operating systems.

1. Download PHPMyAdmin.

wget https://files.phpmyadmin.net/phpMyAdmin/4.9.0.1/phpMyAdmin-4.9.0.1-all-languages.zip
unzip phpMyAdmin-4.9.0.1-all-languages.zip

2. Backup your old PHPMyAdmin installation.

cp -r /usr/share/phpmyadmin ~/phpmyadmin-backup

3. Drop your new PHPMyAdmin on your old PHPMyAdmin

cd phpMyAdmin-4.9.0.1-all-languages
rm -r /usr/share/phpmyadmin/doc/html
cp -R * /usr/share/phpmyadmin/

Verify that it works. If it doesn’t, welll… You have a backup, so restore it and manually edit the faulty line. In my own personal experience, I discovered after doing this that version 4.6.6.5 was not only riddled with bugs, but also incredibly slow compared to the new 4.9.0.1. The speed increase was pure magic for something I though was of “WordPress” quality.

I would switch the order of 1 and 2, and before wget I would cd /tmp but aside from that, excellent, thank you. 

– 

Works on UBUNTU 16.04.3 Just open

usr/share/libraries/sql.lib.php

modify

|| (count($analyzed_sql_results['select_expr'] == 1)

To

|| ((count($analyzed_sql_results['select_expr']) == 1)

This worked well for me on Ubuntu 18.04.

Open sql.lib.php file

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

Replace this wrong code:

|| (count($analyzed_sql_results['select_expr'] == 1)

With this one:

|| ((count($analyzed_sql_results['select_expr']) == 1)

Save the file.

Restart your server with:

sudo service apache2 restart

And refresh PhpMyAdmin

Share

Improve this answer

A server restart is not needed for this. 

– Upgrade to phpMyAdmin 4.8.3. this solves the PHP 7.2 compatibility issues

Edit file ‘/usr/share/phpmyadmin/libraries/sql.lib.php’ Replace: (make backup)

"|| (count($analyzed_sql_results['select_expr'] == 1) 
&&($analyzed_sql_results['select_expr'][0] == '*'))) 
&& count($analyzed_sql_results['select_tables']) == 1;"

With:

"|| (count($analyzed_sql_results['select_expr']) == 1) 
&& ($analyzed_sql_results['select_expr'][0] == '*') 
&& (count($analyzed_sql_results['select_tables']) == 1));"

Hi the following solve my same problem absolutely (import/export and so on):

Fix Bug Phpmyadmin [plugin_interface.lib.php] + Php7.2 + Ubuntu 16.04

so… under ubuntu 18.04, mysql, php7.2: Terminal:

sudo gedit /usr/share/phpmyadmin/libraries/plugin_interface.lib.php

Find the following line(ctrl+f):

if ($options != null && count($options) > 0) {

it was on line #551 for me

and change for following:

if ($options != null && count((array)$options) > 0) {

ctrl+s for save the changes

and in terminal: ctrl+c for get back promt…

and: sudo systemctl restart apache2

“I think in new php version.It can’t use count() or sizeof() with un array type. Force parameter to array is easy way to solve this bug,…”

Thanks for the original author for the problem solving! I try to share it!

|| ((count($analyzed_sql_results['select_expr']) == 1

This is what I changed in line 614 and phpmyadmin works without any error. Need one ( before count, and one ) before == . That’s it.

Just correct the count() function and closing parentheses from line 604 till 615 in /usr/share/phpmyadmin/libraries/sql.lib.php file:

function PMA_isRememberSortingOrder($analyzed_sql_results)
{
    return $GLOBALS['cfg']['RememberSorting']
        && ! ($analyzed_sql_results['is_count']
            || $analyzed_sql_results['is_export']
            || $analyzed_sql_results['is_func']
            || $analyzed_sql_results['is_analyse'])
        && $analyzed_sql_results['select_from']
        && ((empty($analyzed_sql_results['select_expr']))
            || (count($analyzed_sql_results['select_expr']) == 1)
                && ($analyzed_sql_results['select_expr'][0] == '*'))
        && count($analyzed_sql_results['select_tables']) == 1;
}

Much clearer and simpler than the other answers! Thank you! 

– 

4

I tried all of above solution but didn’t work for me.

Try this:-

Install required version of PHP(in my case 7.0) and then in terminal, type

sudo update-alternatives --config php

Output will be like this :-

Then you can switch to any version of PHP by simply entering the selection number(in my case 1).

Hope this may help other -:)

Open the /usr/share/phpmyadmin/sql.lib.php file with elevated privileges, and edit the following in the function PMA_isRememberSortingOrder():

1. ~ line 613 to fix the initial error:
   • Replace || count($analyzed_sql_results['select_expr'] == 1)
   • With || (count($analyzed_sql_results['select_expr']) == 1)
2. ~ line 614 to fix the 500 error that will probably follow:
   • Replace && ($analyzed_sql_results['select_expr'][0] == '*')))
   • With && ($analyzed_sql_results['select_expr'][0] == '*'))

Restart your Apache server: sudo service apache2 restart.

Tested on Linux Mint 19.1 based on Ubuntu 18.04, with PhpMyAdmin 4.6.6 and PHP 7.2.

Replace Function:

function PMA_isRememberSortingOrder($analyzed_sql_results) {
return $GLOBALS['cfg']['RememberSorting']
    &&!(
        $analyzed_sql_results['is_count']
        || $analyzed_sql_results['is_export']
        || $analyzed_sql_results['is_func']
        || $analyzed_sql_results['is_analyse']
    )&&
    $analyzed_sql_results['select_from']&&
    (
        empty($analyzed_sql_results['select_expr'])||
        count($analyzed_sql_results['select_expr'])==1&&
        $analyzed_sql_results['select_expr'][0] == '*'
    )
    && count($analyzed_sql_results['select_tables']) == 1;
}

Add the phpmyadmin ppa

sudo add-apt-repository ppa:phpmyadmin/ppa
sudo apt-get update
sudo apt-get upgrade

Actually a really useful answer besides other ones fixing the source’s bug 

– 

That’s right, I forgot to mention it but I did an upgrade in my case. Thank you ! 

– 

add-apt-repository ppa:phpmyadmin/ppa
apt-get clean
apt-get update
apt-get purge phpmyadmin
apt-get install phpmyadmin

Fixed it for me, on Ubuntu 18.04.

source : https://stackoverflow.com/questions/48001569/phpmyadmin-count-parameter-must-be-an-array-or-an-object-that-implements-co