Warning in ./libraries/sql.lib.php shown, when any table contents are listed
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
phpmyadmin (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
1) The release of Ubuntu you are using, via 'lsb_release -rd' or System -> About Ubuntu
Ubuntu 16.04.6 LTS
2) The version of the package you are using, via 'apt-cache policy pkgname' or by checking in Software Center
phpmyadmin:
Installed: 4:4.5.4.
Candidate: 4:4.5.4.
Version table:
*** 4:4.5.4.
500 http://
500 http://
100 /var/lib/
4:
500 http://
3) What you expected to happen
Any table is opened from any database. The rows from table should be listed on PHPMyadmin display.
4) What happened instead
An error pop-up appears: "Some errors have been detected on the server! Please look at the bottom of this window." (Ignore All) (Ignore)
The detailed error is:
Warning in ./libraries/
count(): Parameter must be an array or an object that implements Countable
Backtrace
./libraries/
./libraries/
array,
boolean true,
string 'mailserver',
string 'virtual_aliases',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/
NULL,
NULL,
NULL,
string 'SELECT * FROM `virtual_aliases`',
NULL,
NULL,
)
./sql.php#216: PMA_executeQuer
array,
boolean true,
string 'mailserver',
string 'virtual_aliases',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/
NULL,
NULL,
NULL,
string 'SELECT * FROM `virtual_aliases`',
NULL,
NULL,
)
This error can be corrected by editing file /usr/share/
line 601:
Replace || count($
With || (count(
line 602:
Replace && ($analyzed_
With && ($analyzed_
ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: phpmyadmin 4:4.5.4.
Uname: Linux 2.6.32-042stab140.1 x86_64
ApportVersion: 2.20.1-0ubuntu2.21
Architecture: amd64
Date: Thu Nov 14 08:34:19 2019
PackageArchitec
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
XDG_RUNTIME_
SHELL=/bin/bash
SourcePackage: phpmyadmin
UpgradeStatus: No upgrade log present (probably fresh install)
mtime.conffile.
Hello,
You can have a look at https:/ /github. com/phpmyadmin/ phpmyadmin/ issues/ 15515#issuecomm ent-552211446 and install using our PPA:
sudo add-apt-repository ppa:phpmyadmin/ppa
sudo apt-get update
sudo apt-get install phpmyadmin