#1012847 Fails (500 Internal Server Error) with some queries

Package:
phpmyadmin
Source:
phpmyadmin
Submitter:
Date:
2022-07-01 15:36:07 UTC
Severity:
important
Tags:
#1012847#5
Date:
2022-06-15 12:58:02 UTC
From:
To:
Hi William,

In Bullseye (and Buster backports), some queries ends with an Internal
Server Error (500), e.g.:

	SELECT *, count(reference)
	FROM declaloc_declarant
	GROUP BY reference, platform_uuid
	HAVING count(reference) > 1;

I notice you fixed it in recent versions, and the same fix has been
deployed in production with success.

https://github.com/phpmyadmin/phpmyadmin/commit/16f81e47eab289b13bf39ed2ca6c3c0b0c923845

Would it be possible to backport that fix in a stable point release, and
in buster-backports?

Thanks in advance.

Regards

David
#1012847#16
Date:
2022-06-15 14:30:14 UTC
From:
To:
Hi David,
in buster-backports?

For buster-backports, sure, I am working on making
"php-nikic-fast-route" packaged into buster-backports. Once this will be
done I will send the last phpMyAdmin version into buster-backports.

I am really not sure what is accepted into stable point releases and how
it works to send such changes. Maybe you could help me better understand
this ?


Thank you for this report,
William
#1012847#21
Date:
2022-06-15 14:55:04 UTC
From:
To:
Hi William,

Thank you for your quick feedback.

Le 15/06/2022 à 16:30, William Desportes a écrit :

[…]

The documentation should answer most of your questions, if not, feel
free to ping me back (and feel free to keep me in the loop before or
after you submit a bug to release.debian.org).

https://www.debian.org/doc/manuals/developers-reference/pkgs#upload-stable

Regards

David
#1012847#28
Date:
2022-06-27 01:18:17 UTC
From:
To:
Upload is done, it is in process now.
#1012847#33
Date:
2022-07-01 15:32:12 UTC
From:
To:
We believe that the bug you reported is fixed in the latest version of
phpmyadmin, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 1012847@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
William Desportes <williamdes@wdes.fr> (supplier of updated phpmyadmin package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@ftp-master.debian.org)
Format: 1.8
Date: Sun, 19 Jun 2022 18:58:24 +0200
Source: phpmyadmin
Built-For-Profiles: noudeb
Architecture: source
Version: 4:5.0.4+dfsg2-2+deb11u1
Distribution: bullseye
Urgency: medium
Maintainer: phpMyAdmin Packaging Team <team+phpmyadmin@tracker.debian.org>
Changed-By: William Desportes <williamdes@wdes.fr>
Closes: 1012847
Changes:
 phpmyadmin (4:5.0.4+dfsg2-2+deb11u1) bullseye; urgency=medium
 .
   * Add a patch for error 500 with some SQL queries (Closes: #1012847)
Checksums-Sha1:
 ecb3d82f1707735a30b5975dc84f71d51b58bce2 2683 phpmyadmin_5.0.4+dfsg2-2+deb11u1.dsc
 04af6b3931db64d876418fa3179ef6cfa55812ad 312916 phpmyadmin_5.0.4+dfsg2-2+deb11u1.debian.tar.xz
 52eba53b84ccdd36c1800b3a34a30764603df142 15612 phpmyadmin_5.0.4+dfsg2-2+deb11u1_source.buildinfo
Checksums-Sha256:
 05331d5266fafbf7023af9d6072b8037259c966a2bbb35deb3d6b9d711050bbc 2683 phpmyadmin_5.0.4+dfsg2-2+deb11u1.dsc
 f711d7fc5567f500f8331d7bdbedda0709d2fc8f1787c7ab9434647b25e7e56f 312916 phpmyadmin_5.0.4+dfsg2-2+deb11u1.debian.tar.xz
 9ce5c0a96dbfc191bf3b02b68a6a77f4d6cb4d9fb4d690503eb186ff93351e8b 15612 phpmyadmin_5.0.4+dfsg2-2+deb11u1_source.buildinfo
Files:
 20a0be4a484c02f05bcbd19f7a172985 2683 web optional phpmyadmin_5.0.4+dfsg2-2+deb11u1.dsc
 ca52968b0efb9c6413261461467b55d4 312916 web optional phpmyadmin_5.0.4+dfsg2-2+deb11u1.debian.tar.xz
 6605b863eb5b1e4e95c585f7e1db589f 15612 web optional phpmyadmin_5.0.4+dfsg2-2+deb11u1_source.buildinfo
-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEExNkf3872tKPGU/14kKDvG4JRqIkFAmKvVlwACgkQkKDvG4JR
qIloBA/8DcSqyfCUyIrq23mdipFOakkF1LMrz8Nm8wKzHUhYDLaTpuwn8hQCB9CH
CiRewMaqreeHBZ/gubJr+W6wWDccdQ9Fgr892rdszspEwvEISgvTr4KyLxZpDrLx
sRnD/B9rO10fcTlKNoeJl7W7LksDFCFHRZgwk/Cesf4olA6RUUNzngTj42skoGUw
nGAz0lGsKfuFwD3vI75umQr1nnMaiuPPmPM4n7XT8mQqHeNvsT9TUbrAc13bIFOp
nDSd++8qwZmutLg6H52toXtSyFL7F914GaYqcVQyTqVU49vellGb9du20S6473yt
COrlXfVqWJP3YfoYhF6XHkvh3QOltLsPz93DDEXkyseM2XyMaU6hk84HmqlGvMir
EOn1I7cXl0g8v5iXp2hloSHkzP3inFaHzi5U7v8QfkG2Oj3cdWjNM1lwtlpjP3Nu
skZIyNt9VXYfPwzkXHfA01o9u/kqDbxpEn6z0bnQE4afxtEylqoXq3IFA6O9oYXu
2y532AWJoIJXR6s94nPCaIFC5I0XhS0sh/4v6NpmMnV5qLnxaF8Rr1e6pfIqLR9t
2waThnzxjU5iRTe2OtqY4TQbMSP2SpzGIui/rj6R6rs3Jfe/Z5P0G1F2cX/GROHB
21/ICnPXOiwVDI8Nm59sAkELyMKvgbch+jnEeuqxrEEz8ADFnYQ=
=HZKW
-----END PGP SIGNATURE-----