github-starred/pangolin
2
0
Fork 0
mirror of https://github.com/fosrl/pangolin.git synced 2026-05-21 09:21:15 -05:00
Code Issues 856 Packages Projects Releases 74 Wiki Activity

[GH-ISSUE #1343] [Bug] PostgreSQL Migration 1.9.0 fails: column "online" is of type integer but default expression is of type boolean #16846

New Issue
Closed
opened 2026-05-18 17:05:54 -05:00 by GiteaMirror · 5 comments
GiteaMirror commented 2026-05-18 17:05:54 -05:00
Owner
Copy Link

Originally created by @Blacks-Army on GitHub (Aug 25, 2025).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/1343

Hi,
when running the 1.9.0 migration, the following error occurs:

Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL;
error: column "online" is of type integer but default expression is of type boolean

Logs:

DrizzleQueryError: Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL;
cause: error: column "online" is of type integer but default expression is of type boolean
code: '42804'

Expected behavior:
The migration should add the column successfully.

Originally created by @Blacks-Army on GitHub (Aug 25, 2025). Original GitHub issue: https://github.com/fosrl/pangolin/issues/1343 Hi, when running the 1.9.0 migration, the following error occurs: ```yaml Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL; error: column "online" is of type integer but default expression is of type boolean ``` Logs: ```yaml DrizzleQueryError: Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL; cause: error: column "online" is of type integer but default expression is of type boolean code: '42804' ``` Expected behavior: The migration should add the column successfully.
GiteaMirror commented 2026-05-18 17:05:55 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Aug 25, 2025):

Hey sorry about this I fixed the migration. I think you can just fix the
column manually in postgres to be a boolean and you should be good to
go. Let me know if you need help with that.

<!-- gh-comment-id:3221728815 --> @oschwartz10612 commented on GitHub (Aug 25, 2025): Hey sorry about this I fixed the migration. I think you can just fix the column manually in postgres to be a boolean and you should be good to go. Let me know if you need help with that.
GiteaMirror commented 2026-05-18 17:05:56 -05:00
Author
Owner
Copy Link

@Blacks-Army commented on GitHub (Aug 25, 2025):

Doesn't work behause the Migration still wants to execute that command

<!-- gh-comment-id:3221734903 --> @Blacks-Army commented on GitHub (Aug 25, 2025): Doesn't work behause the Migration still wants to execute that command
GiteaMirror commented 2026-05-18 17:05:57 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Aug 25, 2025):

The containers should be updated if you give it a pull and try again
does it work?

<!-- gh-comment-id:3221745423 --> @oschwartz10612 commented on GitHub (Aug 25, 2025): The containers should be updated if you give it a pull and try again does it work?
GiteaMirror commented 2026-05-18 17:05:57 -05:00
Author
Owner
Copy Link

@cendenta commented on GitHub (Aug 25, 2025):

I had this issue too, and can confirm that pulling the new container fixed it.

<!-- gh-comment-id:3221813555 --> @cendenta commented on GitHub (Aug 25, 2025): I had this issue too, and can confirm that pulling the new container fixed it.
GiteaMirror commented 2026-05-18 17:05:58 -05:00
Author
Owner
Copy Link

@Blacks-Army commented on GitHub (Aug 25, 2025):

Okay it works now thanks!

<!-- gh-comment-id:3221853373 --> @Blacks-Army commented on GitHub (Aug 25, 2025): Okay it works now thanks!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
api
authentication
bug
config
dependencies
docker
documentation
enhancement
good first issue
help wanted
Improvement
Look Into
needs investigating
networking
new feature
non-critical bug
potential bug
pull-request
Mirrored from GitHub Pull Request
 question
reverse proxy
Security
stale
ui
wontfix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/pangolin#16846
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?