I’m trying to connect to a managed MySQL database on DigitalOcean from a Docker install.
Every time I try to connect to the DB I get this error:
Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
I found a related topic but the issue should be resolved since NC21: [NC 20.0.3 Fresh install] Unable to create or change a table without a primary key
The apparent fix was done in MySQL Clusters prohibits use of DML commands on tables without an explicit Primary Key · Issue #16311 · nextcloud/server · GitHub
Appreciate the help,
Niklas