To add to this: I have tried buildinga new app with a fresh database (a managed db mysql on digitalocean) and using the environment variable NC_DB set from the first deployment. This results in a similar migration failed error where if cannot create table ‘nc_projects’. Am I missing something here?
2-09-21 12:45:36] sqlMessage: “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.”,
After reading up for a bit I found that on a digitalocean managed mysql database sql_require_primary_key is set to true on default. I requires api access to change this setting. They warn that setting this to false can lead to issues:
‘For clusters with more than one node, we strongly recommend keeping sql_require_primary_key as True. Setting it to False may severely impact replication and cause issues.’