[GH-ISSUE #4301] check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER) ASC' at line 1 #2769

Open
opened 2026-02-26 07:36:44 +03:00 by kerem · 1 comment
Owner

Originally created by @geekyouth on GitHub (Jan 15, 2025).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/4301

Checklist

  • Have you pulled and found the error with jc21/nginx-proxy-manager:latest docker image?
    • No
  • 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

[1/15/2025] [10:59:32 PM] [Express  ] › ⚠  warning   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

Nginx Proxy Manager Version

chishin/nginx-proxy-manager-zh:2.12.2

To Reproduce
image

Expected behavior

add a port forward

Screenshots

image

Operating System

centos7

Additional context

Originally created by @geekyouth on GitHub (Jan 15, 2025). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/4301 <!-- Are you in the right place? - If you are looking for support on how to get your upstream server forwarding, please consider asking the community on Reddit. - If you are writing code changes to contribute and need to ask about the internals of the software, Gitter is the best place to ask. - If you think you found a bug with NPM (not Nginx, or your upstream server or MySql) then you are in the *right place.* --> **Checklist** - Have you pulled and found the error with `jc21/nginx-proxy-manager:latest` docker image? - No - 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** <!-- A clear and concise description of what the bug is. --> ``` [1/15/2025] [10:59:32 PM] [Express ] › ⚠ warning 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 ``` **Nginx Proxy Manager Version** <!-- What version of Nginx Proxy Manager is reported on the login page? --> `chishin/nginx-proxy-manager-zh:2.12.2` **To Reproduce** ![image](https://github.com/user-attachments/assets/995ce361-d1dc-4f9c-8a7f-a260ccda821f) **Expected behavior** <!-- A clear and concise description of what you expected to happen. --> add a port forward **Screenshots** <!-- If applicable, add screenshots to help explain your problem. --> ![image](https://github.com/user-attachments/assets/101656dc-1810-49c0-a6d2-b60b2770f0da) **Operating System** <!-- Please specify if using a Rpi, Mac, orchestration tool or any other setups that might affect the reproduction of this error. --> centos7 **Additional context** <!-- Add any other context about the problem here, docker version, browser version, logs if applicable to the problem. Too much info is better than too little. -->
Author
Owner

@github-actions[bot] commented on GitHub (Jul 24, 2025):

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

<!-- gh-comment-id:3111731428 --> @github-actions[bot] commented on GitHub (Jul 24, 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#2769
No description provided.