Skip to content

Error when creating Dead Host with PostgreSQL: "invalid input syntax for type integer: 'true'" #4480

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
zdearo opened this issue Apr 10, 2025 · 1 comment
Labels

Comments

@zdearo
Copy link

zdearo commented Apr 10, 2025

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
I'm trying to create a Dead Host using Nginx Proxy Manager with a PostgreSQL database, but I'm encountering the following error:

[4/10/2025] [1:03:10 PM] [Express ] › ⚠ warning insert into "dead_host" ("advanced_config", "certificate_id", "created_on", "domain_names", "hsts_enabled", "hsts_subdomains", "http2_support", "meta", "modified_on", "owner_user_id", "ssl_forced") values ($1, $2, NOW(), $3, $4, $5, $6, $7, NOW(), $8, $9) returning "id" - invalid input syntax for type integer: "true"

I've searched through documentation, GitHub issues, and community forums but couldn't find a clear solution. I’d like to know if anyone else has experienced this issue or has any suggestions on how to resolve it.

Nginx Proxy Manager Version
v2.12.3

To Reproduce
Steps to reproduce the behavior:

  1. Go to the Nginx Proxy Manager dashboard
  2. Click on the “Hosts” menu and select “Dead Hosts”
  3. Click on “Add Dead Host”
  4. Fill in the required fields and try to save
  5. See the Internal Error in the UI and database error in docker logs

Screenshots

Image

Image

Operating System
Operating System
Ubuntu 24.04.2 LTS (Codename: noble)
Nginx Proxy Manager running via Docker (jc21/nginx-proxy-manager:latest)
PostgreSQL database running directly on the host (outside Docker)

@zdearo zdearo added the bug label Apr 10, 2025
@jc21
Copy link
Member

jc21 commented Apr 11, 2025

This is definitely a bug. PG support is pretty new.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants