SVI/ProxmoxVE
1
0
Fork 0
mirror of https://github.com/community-scripts/ProxmoxVE.git synced 2026-03-31 06:34:17 -04:00
Code Issues 2.6k Packages Projects Releases 10 Wiki Activity

Proxmox Helper Script does not create required PostgreSQL extensions (unaccent, pg_trgm) for Tandoor #1931

New Issue
Closed
opened 2025-11-20 05:20:06 -05:00 by saavagebueno · 1 comment
saavagebueno commented 2025-11-20 05:20:06 -05:00
Owner
Copy Link

Originally created by @sebasg1993 on GitHub (Sep 22, 2025).

✅ Have you read and understood the above guidelines?

yes

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

Tandoor Recipes

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

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

⚙️ What settings are you using?

  • Default Settings
  • Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

📈 Which Proxmox version are you on?

9.0.6

📝 Provide a clear and concise description of the issue.

When installing Tandoor using the Proxmox Helper Script (tandoor-install.sh), the required PostgreSQL extensions unaccent and pg_trgm are not created in the db_recipes database.

This causes runtime errors in Tandoor, such as:

ProgrammingError: function unaccent(character varying) does not exist
LINE 1: ...COALESCE(UNACCENT("...
HINT:  No function matches the given name and argument types.

Information on the necessity of Postgres extensions can also be found here: https://docs.tandoor.dev/system/updating/

Root cause

The script does not run:

CREATE EXTENSION IF NOT EXISTS unaccent;
CREATE EXTENSION IF NOT EXISTS pg_trgm;

inside the db_recipes database.

Suggested fix

Extend the installation script so that both extensions are created directly in the db_recipes database, e.g.:

sudo -u postgres psql -d db_recipes -c "CREATE EXTENSION IF NOT EXISTS unaccent;"
sudo -u postgres psql -d db_recipes -c "CREATE EXTENSION IF NOT EXISTS pg_trgm;"

🔄 Steps to reproduce the issue.

  1. Deploy Tandoor using the Proxmox Helper Script.
  2. Try to import recipes.
  3. Observe the error in the logs.

❌ Paste the full error output (if available).

ProgrammingError: function unaccent(character varying) does not exist
LINE 1: ...COALESCE(UNACCENT("...
HINT: No function matches the given name and argument types.

🖼️ Additional context (optional).

No response

Originally created by @sebasg1993 on GitHub (Sep 22, 2025). ### ✅ Have you read and understood the above guidelines? yes ### 📜 What is the name of the script you are using? Tandoor Recipes ### 📂 What was the exact command used to execute the script? bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/tandoor.sh)" ### ⚙️ What settings are you using? - [x] Default Settings - [ ] Advanced Settings ### 🖥️ Which Linux distribution are you using? Debian 12 ### 📈 Which Proxmox version are you on? 9.0.6 ### 📝 Provide a clear and concise description of the issue. When installing Tandoor using the Proxmox Helper Script (tandoor-install.sh), the required PostgreSQL extensions unaccent and pg_trgm are not created in the db_recipes database. This causes runtime errors in Tandoor, such as: ````bash ProgrammingError: function unaccent(character varying) does not exist LINE 1: ...COALESCE(UNACCENT("... HINT: No function matches the given name and argument types. ```` Information on the necessity of Postgres extensions can also be found here: https://docs.tandoor.dev/system/updating/ ### Root cause The script does not run: ````sql CREATE EXTENSION IF NOT EXISTS unaccent; CREATE EXTENSION IF NOT EXISTS pg_trgm; ```` inside the db_recipes database. ### Suggested fix Extend the installation script so that both extensions are created directly in the db_recipes database, e.g.: ````bash sudo -u postgres psql -d db_recipes -c "CREATE EXTENSION IF NOT EXISTS unaccent;" sudo -u postgres psql -d db_recipes -c "CREATE EXTENSION IF NOT EXISTS pg_trgm;" ```` ### 🔄 Steps to reproduce the issue. 1. Deploy Tandoor using the Proxmox Helper Script. 2. Try to import recipes. 3. Observe the error in the logs. ### ❌ Paste the full error output (if available). ProgrammingError: function unaccent(character varying) does not exist LINE 1: ...COALESCE(UNACCENT("... HINT: No function matches the given name and argument types. ### 🖼️ Additional context (optional). _No response_
saavagebueno added the investigation label 2025-11-20 05:20:06 -05:00
saavagebueno commented 2025-11-20 05:20:07 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Sep 22, 2025):

Thats new. Should be an Feature Request, not an Script issue.

@MickLesk commented on GitHub (Sep 22, 2025): Thats new. Should be an Feature Request, not an Script issue.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
🛑 Failure to comply with the guidelines
breaking change
bug
bug
bugfix
deferred
delete script
dependencies
enhancement
external
feature
github
help wanted
Implemented in VED waiting push to Main
in project pipeline
invalid
investigation
json
maintenance
new script
new script
nice to have
not a script issue
not planned
organization
pull-request
Mirrored from GitHub Pull Request
 question
refactor
rename script
security
update script
website
wontdo
No Label investigation
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
saavagebueno
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: SVI/ProxmoxVE#1931
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?