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 quote it so that MySQL understand that you want the column name.
In order to fix the issue you need to edit the settings on Digital Ocean Managed Databases, remove the configuration ANSI_QUOTES and save.
After that you should be able to reimport your database and that should just work.
Leave a Reply