phpMyAdmin sorting not working #308

Closed
opened 2026-04-05 20:26:40 +02:00 by MrUnknownDE · 0 comments
Owner

Originally created by @ondrejvrabel on 12/10/2023

CloudPanel version(s) affected

2.4.0

Description

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

Originally posted by @ondrejvrabel in https://github.com/cloudpanel-io/cloudpanel-ce/issues/266#issuecomment-1827806211

How to reproduce

Open phpMyAdmin from CloudPanel, open table and try to sort column by clicking.

Possible Solution

No response

Additional Context

No response

*Originally created by @ondrejvrabel on 12/10/2023* ### CloudPanel version(s) affected 2.4.0 ### Description > 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 _Originally posted by @ondrejvrabel in https://github.com/cloudpanel-io/cloudpanel-ce/issues/266#issuecomment-1827806211_ ### How to reproduce Open phpMyAdmin from CloudPanel, open table and try to sort column by clicking. ### Possible Solution _No response_ ### Additional Context _No response_
Sign in to join this conversation.