truenas/apps

nextcloud:memories - Database triggers not set up; trigger compatibility mode in use.

Closed this issue · 2 comments

ct85msi commented

When I install Memories plugin, in "Administration => Memories" I have this warning "Database triggers not set up; trigger compatibility mode in use."
See the documentation for information on how to resolve this. External Link"

I used occ maintenance:repair and I get:

- WARNING: Failed to create filecache trigger (compatibility mode will be used): An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "TRIGGER" LINE 1: CREATE OR REPLACE TRIGGER memories_fcu_trg

From my research, it seems the container needs Postgresql v14 for Memories to be able tu use it`s full performance.

TrueNAS 24.10.X

Thanks in advance,

Sorin

ct85msi commented

Thank you, I omitted the option for choosing the postgress version.

  • 🎉1