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

Bug #1769447 reported by JohnShep
22
This bug affects 5 people
Affects Status Importance Assigned to Milestone
phpmyadmin (Ubuntu)
Confirmed
Undecided
Unassigned

Bug Description

Version conflict with php7.2 but apt reports phpmyadmin is already the newest version (4:4.6.6-5).
There is a screenshot of the problem here https://stackoverflow.com/questions/47668550/error-in-phpmyadmin-after-updating-to-php-7-2-0

ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: phpmyadmin 4:4.6.6-5 [modified: usr/share/phpmyadmin/config.sample.inc.php]
ProcVersionSignature: Ubuntu 4.15.0-20.21-generic 4.15.17
Uname: Linux 4.15.0-20-generic x86_64
ApportVersion: 2.20.9-0ubuntu7
Architecture: amd64
CurrentDesktop: MATE
Date: Sun May 6 11:42:43 2018
InstallationDate: Installed on 2016-10-05 (577 days ago)
InstallationMedia: Ubuntu-MATE 16.04.1 LTS "Xenial Xerus" - Release amd64 (20160719)
PackageArchitecture: all
SourcePackage: phpmyadmin
UpgradeStatus: Upgraded to bionic on 2018-05-02 (3 days ago)

Revision history for this message
JohnShep (john-boxrec) wrote :
Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in phpmyadmin (Ubuntu):
status: New → Confirmed
Revision history for this message
david (drtechno1971) wrote :

This my fix for sql.lib.php on lines # 604-616
  in /usr/share/phpmyadmin/libraries

installation was on lubuntu 18.04 installed on feb 2nd,2019

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;
}

Revision history for this message
Günter Neustädter (guenterneust) wrote :

I'm still having this problem about a year later, on ubuntu server (no desktop), with phpmyadmin 4.6.6-5 and php 7.2.15-0ubuntu0.18.04.2.
I suppose that the problem goes unnoticed if php warnings are deactivated, but I'm doing also some development on this server, and the warnings are useful for me.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.