Documenso Script fails

[M-G-86]

✅ Have you read and understood the above guidelines?

yes

📜 What is the name of the script you are using?

Documenso

📂 What was the exact command used to execute the script?

bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/documenso.sh)"

⚙️ What settings are you using?

• Default Settings
• Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

📝 Provide a clear and concise description of the issue.

I get an error while executing the Script:

🔄 Steps to reproduce the issue.

Run the install Script

❌ Paste the full error output (if available).

---

/ __ ____ _______ ______ ___ ___ ____ _________
/ / / / __ / / / / / __ ` / _ / __ / / __
/ // / // / // // / / / / / / / / / ( ) // /
//_/_/_,// // //___// ///_/

⚙️ Using Default Settings on node proxmoxdmz
🆔 Container ID: 101
🖥️ Operating System: debian (12)
📦 Container Type: Unprivileged
💾 Disk Size: 12 GB
🧠 CPU Cores: 6
🛠️ RAM Size: 6144 MiB
🚀 Creating a Documenso LXC using the above default settings

✔️ Validated Storage (rootdir / vztmpl).
✔️ Cluster is quorate
✔️ LXC Template List Updated
✔️ Started LXC Container
✔️ Customized LXC Container
✔️ Set up Container OS
✔️ Network Connected: 10.20.7.144
✔️ IPv4 Internet Connected
✖️ IPv6 Internet Not Connected
✔️ Git DNS: github.com:(✔️ ) raw.githubusercontent.com:(✔️ ) api.github.com:(✔️ ) git.community-scripts.org:(✔️ )
✔️ Updated Container OS
✔️ Setup Functions
✔️ Installed Dependencies
✔️ Setup Node.js 22
✔️ Installed Node.js modules: turbo@1.9.3
✔️ Setup PostgreSQL 16
✔️ PostgreSQL 16 installed
✔️ Set up PostgreSQL
✔️ Installed Documenso
⠴ Create User
[ERROR] in line 159: exit code 0: while executing command "$@" > /dev/null 2>&1

[ERROR] in line 1249: exit code 0: while executing command lxc-attach -n "$CTID" -- bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/install/"$var_install".sh)" $?

🖼️ Additional context (optional).

[MickLesk]

Run in verbose First

[M-G-86]

Run in verbose First

All migrations have been successfully applied.
✔️ Installed Documenso
⏳ Create UserERROR: column "customerId" of relation "User" does not exist
LINE 1: ... roles, "createdAt", "lastSignedIn", "updatedAt", "customerI...
^

[ERROR] in line 82: exit code 0: while executing command $STD sudo -u postgres psql -d documenso_db -c "INSERT INTO "User" (name, email, "emailVerified", password, "identityProvider", roles, "createdAt", "lastSignedIn", "updatedAt", "customerId") VALUES ('helper-scripts', 'helper-scripts@local.com', '2025-01-20 17:14:45.058', '$PASSWORD_HASH', 'DOCUMENSO', ARRAY['USER', 'ADMIN']::"Role"[], '2025-01-20 16:04:05.543', '2025-01-20 16:14:55.249', '2025-01-20 16:14:55.25', NULL) RETURNING id;"

[MickLesk]

documenso/documenso#1880

[M-G-86]

Somehow i get the same Error, installing Habitica and Netbox on two diferent Proxmox Installations.

[MickLesk]

That has no place here. These are 1. errors in your system and 2. without verbose nobody will help you and 3. it is a completely different script.

[blazingsloe]

I am having the same issue

[MickLesk]

Its external

[bigbeka]

@blazingsloe and @M-G-86 I believe Documenso has very good documentation on how to get it running using Docker Compose. Create an LXC, Install Docker and run a single command to start it.

[MickLesk]

Then we can remove the Script 😄

By the way, the docker Install has the Same Migration issues

[C0NN0RAD0]

Same issue for me :(

[LanceCalen]

Run in verbose First

All migrations have been successfully applied. ✔️ Installed Documenso ⏳ Create UserERROR: column "customerId" of relation "User" does not exist LINE 1: ... roles, "createdAt", "lastSignedIn", "updatedAt", "customerI... ^

[ERROR] in line 82: exit code 0: while executing command $STD sudo -u postgres psql -d documenso_db -c "INSERT INTO "User" (name, email, "emailVerified", password, "identityProvider", roles, "createdAt", "lastSignedIn", "updatedAt", "customerId") VALUES ('helper-scripts', 'helper-scripts@local.com', '2025-01-20 17:14:45.058', '$PASSWORD_HASH', 'DOCUMENSO', ARRAY['USER', 'ADMIN']::"Role"[], '2025-01-20 16:04:05.543', '2025-01-20 16:14:55.249', '2025-01-20 16:14:55.25', NULL) RETURNING id;"

I'm getting the same error.

The column "customerId" doesn't exist in the table "User".
In line 82 of the install-script should be :
$STD sudo -u postgres psql -d documenso_db -c "INSERT INTO \"User\" (name, email, \"emailVerified\", password, \"identityProvider\", roles, \"createdAt\", \"lastSignedIn\", \"updatedAt\"") VALUES ('helper-scripts', 'helper-scripts@local.com', '2025-01-20 17:14:45.058', '$PASSWORD_HASH', 'DOCUMENSO', ARRAY['USER', 'ADMIN']::\"Role\"[], '2025-01-20 16:04:05.543', '2025-01-20 16:14:55.249', '2025-01-20 16:14:55.25') RETURNING id;"

instead of :
$STD sudo -u postgres psql -d documenso_db -c "INSERT INTO \"User\" (name, email, \"emailVerified\", password, \"identityProvider\", roles, \"createdAt\", \"lastSignedIn\", \"updatedAt\", \"customerId\") VALUES ('helper-scripts', 'helper-scripts@local.com', '2025-01-20 17:14:45.058', '$PASSWORD_HASH', 'DOCUMENSO', ARRAY['USER', 'ADMIN']::\"Role\"[], '2025-01-20 16:04:05.543', '2025-01-20 16:14:55.249', '2025-01-20 16:14:55.25', NULL) RETURNING id;"

I did the remaining tasks of the script manually including the changes of line 82 and it worked for me. Documenso is running.