Tag: tips
-
Digital Ocean – Missing columns on Managed Databases
After migrated from a local mysql server into Managed Database on Digital Ocean, I came with another issue where my software was complaining of missing columns. My column in question was called language and that issue was because managed database has a configuration called ANSI_QUOTES. Because language is some sort of special word it then…
-
Digital Ocean – General error: 3750 Unable to create or change a table without a primary key
If you are trying to set Digital Ocean Managed Database and you need to customize the configurations to allow some specific flag. A lot of places on the internet says you cannot do it but there is a way. DO allow you to customize configs via the API. doctl databases configuration update DB-UUID –engine mysql…