Unable to sort table record : Error 400 Bad Request

[baptistepl]

When I sort record in a table I have a error 400 bad request. Impossible to sort table record.

[baptistepl]

Problem was not fixed, I cannot manage my database since 6 months ...

[baptistepl]

Not solved yet ... It's boring ... What are you doing ?

[Pastaloverzzz]

Same problem here. I installed the MariaDB database yesterday and get the same error. (FYI i never used PHPMyAdmin before so i don't know if it has something to do with MariaDB)

Opening PHPMyadmin seems to be functioning normal although i'm not sure it should give more log lines after "Starting NGINX"

s6-rc: info: service base-addon-banner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service base-addon-log-level: starting
s6-rc: info: service fix-attrs successfully started
Log level is set to INFO
s6-rc: info: service base-addon-log-level successfully started
s6-rc: info: service legacy-cont-init: starting
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service init-phpmyadmin: starting
s6-rc: info: service init-nginx: starting
s6-rc: info: service init-nginx successfully started
s6-rc: info: service init-phpmyadmin successfully started
s6-rc: info: service php-fpm: starting
s6-rc: info: service php-fpm successfully started
s6-rc: info: service nginx: starting
s6-rc: info: service nginx successfully started
s6-rc: info: service legacy-services: starting
[00:33:11] INFO: Starting PHP-FPM...
s6-rc: info: service legacy-services successfully started
[00:33:12] INFO: Starting NGinx....

Hope this info helps to find a fix

[hirenshah]

Been a while... is this being looked at?

[Pastaloverzzz]

I don't have a fix for the add-on but you could solve it if you are running home assistant on proxmox. You can create a lxc with Maria db and phpmyadmin and move your database over there. I did this a few days ago and now i can sort without errors and since the database is external home assistant backups are much much smaller. (25MB instead of 600 for me)
It's also really easy to set up.

[Cougar]

This looks like Home Assistant security check that does not like some phpMyAdmin URLs. This is how it looks like in Home Assistant log:

Dec 04 20:02:07 homeassistant homeassistant[552]: 2025-12-04 20:02:07.887 WARNING (MainThread) [homeassistant.components.http.security_filter] Filtered a request with unsafe byte query string: /api/hassio_ingress/N12VmjGC7Ea4nljDeC-g1jMl4unjrU-qMKKCMHfYV8I/index.php?route=/sql&db=homeassistant&table=states&sql_query=SELECT+%2A+FROM+%60states%60+%0AORDER+BY+%60states%60.%60state_id%60+ASC+&sql_signature=655cf07c2d73335019a6193f20cbf31d5986d76bab9c20fc78d5dcacf2962407&session_max_rows=25&is_browse_distinct=0&ajax_request=true&ajax_page_request=true&_nocache=1764871328803524576&token=5b432555675045464f697769596f652f

Similar problem is described in home-assistant/core#143635