Skip to content

Error when accessing Stream UI ( error 500 ) #4556

Open
@Falanteris

Description

@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

Image

Image

Operating System
Both database server and NPM is using Ubuntu 24.04

Additional context
MySQL version: 8.0.42
Docker version: 28.1.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions