Internal 500 Error on the stream list page

[afexer]

Describe the bug
When going to the streams page in the latest version v2.12.2 I get a 500 Internal error message.
This is a line from the logs:
⚠ 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
2.12.2

To Reproduce
Steps to reproduce the behavior:

1. Go to the streams page
2. See the error

Expected behavior
List the streams

Screenshots

Operating System
Ubuntu 24 - using docker image

[truebigsand]

It's from here: (seems to be add for PostgreSQL)

nginx-proxy-manager/backend/internal/stream.js

Line 302 in 9687e9e

.orderByRaw('CAST(incoming_port AS INTEGER) ASC');

However, it goes wrong on MySQL 8.0, probably can be fixed by this:

--- CAST(`stream`.incoming_port AS INTEGER) DESC;
+++ CAST(`stream`.incoming_port AS UNSIGNED INTEGER) DESC;

or just replace INTEGER with UNSIGNED
PgSQL and MySQL conflict here, I'm not familiar with PgSQL so I cannot give a perfect solution, maybe just delete the sorting :)