Can't edit recipies after database migration - "An error occurred while updating a resource!"

[Mad-at]

Discussed in #3210

^{Originally posted by Mad-at July 9, 2024}
Hi everybody!
I am a long time fan & user of Tandoor, but after the migration to postgres 16 everything went downwards. Maybe someone is willing to guide me through solving my problem: I can't edit recpies anymore, I get a quite general "Beim Aktualisieren einer Ressource ist ein Fehler aufgetreten!" - "An error occurred while updating a resource!".
This is happening on Tandoor v1.5.17.
The System panel in Tandoor says that everything is alright and all subsystems/connections work nominally.

Background:
I initially used this guide: https://github.com/vabene1111/recipes/files/6901601/Tandoor.on.a.Synology.Disk.Station.pdf to (years ago) install everything on my Synology using the Container manager. Then I had to migrate from Postgres 11 to Postgres 16 which took sime fumbling but I finally managed to get all data accross. Everything seemed to work fine, but editing seems to be a problem.
I found some Error discussions for synology but they all refer to deleting the user from the docker compose, which the Synology Container Manager" doesnt have (at least did not have when I did the initial install, so I can't use this for the current install).
Permissions on disc are read/write for everyone with exception of the database folder - but there access would be managed by the database backend, right?

There are discussions about installations where permissions seem to be a problem, but as far as I can tell, this should create a permissions error (see: https://forum.yunohost.org/t/permission-broken-after-tandoor-app-update-cant-edit-recipes-anymore/28308 and https://www.synology-forum.de/threads/tandoor-rezepte-lassen-sich-nicht-mehr-veraendern.130667/)

Btw. adding a foto to a recipe works. It produces the same error message, but the foto still is and remains visible in the recipe. So I think it must be some databse issue. But I may be on the completly wrong track here.

Thanks for reading through this!

Mad