[GH-ISSUE #4556] Error when accessing Stream UI ( error 500 ) #2913

Open
opened 2026-02-26 07:37:10 +03:00 by kerem · 2 comments
Owner

Originally created by @Falanteris on GitHub (May 26, 2025).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/4556

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

Originally created by @Falanteris on GitHub (May 26, 2025). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/4556 **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](https://github.com/user-attachments/assets/0912616a-64cb-467f-8d4b-977ee4f14f00) ![Image](https://github.com/user-attachments/assets/a055f53a-7790-40f5-b21b-f150537a2a9d) **Operating System** Both database server and NPM is using Ubuntu 24.04 **Additional context** MySQL version: 8.0.42 Docker version: 28.1.1
Author
Owner

@FragRot commented on GitHub (May 27, 2025):

#4381

<!-- gh-comment-id:2910856074 --> @FragRot commented on GitHub (May 27, 2025): #4381
Author
Owner

@github-actions[bot] commented on GitHub (Dec 11, 2025):

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

<!-- gh-comment-id:3639751364 --> @github-actions[bot] commented on GitHub (Dec 11, 2025): Issue is now considered stale. If you want to keep it open, please comment :+1:
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/nginx-proxy-manager-NginxProxyManager#2913
No description provided.