phpMyAdmin

[foxly-it]

CloudPanel version(s) affected

2.3.1

Description

Buggy version phpMyAdmin 5.1.2:
Sorting a column in a table is not possible via mouse click, only via dropdown.
Switching pages in the left sidebar creates an incorrect display and does not change the page.

How to reproduce

Open a database
Open a table and try to sort the table with the mouse.

Try to change the page in the left sidebar.

Possible Solution

The whole behavior will be fixed with a newer version starting with 5.2.0 according to phpMyAdmin.

Additional Context

The latest version of phpMyAdmin is version 5.2.1, which also brings several bugfixes.

[shamim1992]

I'm unable to upload database in phpmyadmin

[foxly-it]

I'm unable to upload database in phpmyadmin

This has nothing to do with the error here. For this you should use the CLI commands

[Richardvd]

We were able to reproduce this bug on more than 10 cloud panel servers. Very annoying.

[faizananwerali]

Same here. Very annoying

[cloudpanel-io]

It's not a bug. In the earlier days of phpMyAdmin you just clicked on a column to sort it.

In the latest versions, press "shift" and click on the column to sort.

However, phpMyAdmin will be updated to 5.2.1 with the next CloudPanel version at the end of this month.

[ondrejvrabel]

It's not a bug. In the earlier days of phpMyAdmin you just clicked on a column to sort it.

In the latest versions, press "shift" and click on the column to sort.

However, phpMyAdmin will be updated to 5.2.1 with the next CloudPanel version at the end of this month.

Yes, this is a bug. I installed fresh, new phpMyAdmin 5.2.1 on another server and sorting with click works just fine. The shift+click scenario is used for sorting by multiple columns. You can even try this on phpMyAdmin demo (https://demo.phpmyadmin.net/master-config/).

The issue is still present in new Cloudpanel, this is very annoying and makes work with phpMyAdmin very unplesant. I suspect that the issue is with phpMyAdmin's HMAC signatures of queries when clicking the link - perhaps some problems with nginx config for phpMyAdmin?

Thanks