simply-static
simply-static copied to clipboard
Issue with content_type column using aurora mysql
I believe I've rootcaused a bug using AWS aurora mysql with simplystatic. When simply static is initially installed, the db table creation fails. I believe this is because the content_type column name isn't escaped and content_type is now a reserved word in aurora.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraMySQLReleaseNotes/AuroraMySQL.Updates.3060.html#:~:text=Aurora%20MySQL%20version%203.06.,aws_sagemaker_invoke_endpoint%20%2C%20content_type%20%2C%20and%20timeout_ms%20.
You can create the table manually and just wrap the column names in backticks ... content_type and it works fine.
Documenting here in case others encounter the same issue