What type of hardware are you using: VPS bought online
What YunoHost version are you running: 12.0.16
What app is this about: Listmonk
Describe your issue
Upgrading Listmonk from v4.1.0 to v5.0.0 doesn’t work.
The error message is “error running migration v5.0.0: pq: ALTER TYPE … ADD cannot run inside a transaction block”
This is something known on the support of Listmonk :
But I’m not sure of what I have to do.
It seems to be relative to the version of postgres which must be version 17.
Is it something that needs to be handled by the yunohost package ?
Edit :
I finally find a way to resolve this issue :
I took a backup.
De-installed Listmonk
Removed and purged Postgresql (I had version 11 and 15 installed)
Only LSTU was using postgresql too, so I removed it too.
Installed postgresql version 17 : https://cloudspinx.com/how-to-install-postgresql-17-on-debian/
Restored the backup.
And upgraded Listmonk.
6ril