4.1.x with MariaDB / MySQL: broken user home screen
After upgrading from 3.5.8 to 4.1.3, the /home page showed a "server error" page. The installation uses MariaDB 10.6.4 instead of PostgreSQL. It's a docker setup.
The logs of the app container showed the well-known exception "MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'". Before the migration, the error only showed up when accessing the "recently created" documents. With 4.1.3, it prevents accessing the /home page.
As far as I can tell, the reason is the new "user dashboard" introduced with 4.1. Most likely the user dashboard triggers an unsupported database query that leads to an exception with subsequent "server error" on the /home page.
Since the administrator dashboard is not affected by that error, changing COMMON_HOME_VIEW_DASHBOARD_NAME from "user" to "administrator" can be used as workaround. This sets the admin dashboard as the default dashboard for all users.
Although MariaDB / MySQL is not the recommended database, maybe it's possible to define a default user dashboard that doesn't throw the aforementioned exception in future releases.