[PR #1872] [CLOSED] Issue when setting a different schema instead of public #1902

Closed
opened 2026-02-26 20:31:35 +03:00 by kerem · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/documenso/documenso/pull/1872
Author: @cosmo83
Created: 6/29/2025
Status: Closed

Base: mainHead: main


📝 Commits (4)

📊 Changes

3 files changed (+26 additions, -77 deletions)

View changed files

📝 .github/workflows/publish.yml (+19 -70)
📝 docker/build.sh (+3 -3)
📝 packages/prisma/migrations/20240205120648_create_delete_account/migration.sql (+4 -4)

📄 Description


name: Pull Request
about: Submit changes to the project for review and inclusion

Description

When setting a postgresql schema with url like postgres://USER:PASS@localhost/dbname?schema=documenso, iam getting this error because of a faulty migration.sql

Error: P3018
A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve
Migration name: 20240205120648_create_delete_account
Database error code: 42P01
Database error:
relation "public.User" does not exist

Changes Made

Changes made to packages/prisma/migrations/20240205120648_create_delete_account/migration.sql

Testing Performed

Tested on a new docker build


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/documenso/documenso/pull/1872 **Author:** [@cosmo83](https://github.com/cosmo83) **Created:** 6/29/2025 **Status:** ❌ Closed **Base:** `main` ← **Head:** `main` --- ### 📝 Commits (4) - [`f6c4aaa`](https://github.com/documenso/documenso/commit/f6c4aaa78a55fee1f2e7008d9649efb5341e87ae) Update migration.sql - [`9d8ee96`](https://github.com/documenso/documenso/commit/9d8ee962addbf6cf3baec1ec65b77d7cd3849655) Update migration.sql - [`cc20574`](https://github.com/documenso/documenso/commit/cc20574cbfe754c8b736f645f26fee26a8f40ba8) Changes to workflow - [`41b7bf0`](https://github.com/documenso/documenso/commit/41b7bf03ff60bfe7dd0b4a33959218211a8a4070) Changes ### 📊 Changes **3 files changed** (+26 additions, -77 deletions) <details> <summary>View changed files</summary> 📝 `.github/workflows/publish.yml` (+19 -70) 📝 `docker/build.sh` (+3 -3) 📝 `packages/prisma/migrations/20240205120648_create_delete_account/migration.sql` (+4 -4) </details> ### 📄 Description --- name: Pull Request about: Submit changes to the project for review and inclusion --- ## Description When setting a postgresql schema with url like postgres://USER:PASS@localhost/dbname?schema=documenso, iam getting this error because of a faulty migration.sql Error: P3018 A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve Migration name: 20240205120648_create_delete_account Database error code: 42P01 Database error: relation "public.User" does not exist ## Changes Made Changes made to packages/prisma/migrations/20240205120648_create_delete_account/migration.sql ## Testing Performed Tested on a new docker build --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
kerem 2026-02-26 20:31:35 +03:00
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/documenso#1902
No description provided.