Skip to content

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

@zdearo

Description

@zdearo

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)

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