Just installed this app on a clean install nextcloud with PostgreSQL as database. The app crashes when I try to open it and I get an error in the logs:
Error | index | DbalExceptionAn exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR: function year(date) does not exist LINE 1: SELECT YEAR(t.date) as year, "c"."id" as "customer_id", "c".... ^
HINT: No function matches the given name and argument types. You might need to add explicit type casts. | 15 apr. 2026 11:14:27 |
-- | -- | -- | -- | --
It seems the application uses MySQL-specific functions such as YEAR(),
which are not supported in PostgreSQL.
Instead EXTRACT(YEAR FROM ...) should be used as it works across PostgreSQL, MySQL, and MariaDB.
Just installed this app on a clean install nextcloud with PostgreSQL as database. The app crashes when I try to open it and I get an error in the logs:
It seems the application uses MySQL-specific functions such as YEAR(),
which are not supported in PostgreSQL.
Instead EXTRACT(YEAR FROM ...) should be used as it works across PostgreSQL, MySQL, and MariaDB.