Error when accessing Stream UI ( error 500 )

[Falanteris]

Checklist

• Have you pulled and found the error with jc21/nginx-proxy-manager:latest docker image?
  • Yes
• Are you sure you're not using someone else's docker image?
  • Yes
• Have you searched for similar issues (both open and closed)?
  • Yes

Describe the bug select stream.* from stream where is_deleted = 0 group by id order by CAST(incoming_port AS INTEGER) ASC - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER) ASC' at line 1

I found this error when checking the NGINX Proxy Manager container log. Database is a MySQL native database on a separate server.

Nginx Proxy Manager Version v2.12.3

To Reproduce Steps to reproduce the behavior:

1. Go to /nginx/stream
2. See error

Expected behavior Error 500

Screenshots

Operating System Both database server and NPM is using Ubuntu 24.04

Additional context MySQL version: 8.0.42 Docker version: 28.1.1

[FragRot]

#4381

[github-actions[bot]]

Issue is now considered stale. If you want to keep it open, please comment :+1: