simply-static icon indicating copy to clipboard operation
simply-static copied to clipboard

Issue with content_type column using aurora mysql

Open gfavinger opened this issue 1 year ago • 0 comments

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

gfavinger avatar Jun 25 '24 16:06 gfavinger