Mysql2::Error: BLOB, TEXT, GEOMETRY or JSON column 'metadata' can't have a default value

[estebanutz]

I ran into this issue while running the migrations:

Mysql2::Error: BLOB, TEXT, GEOMETRY or JSON column 'metadata' can't have a default value

I'm running rails 8.0.1, mysql2 0.5.6 gem, and my local mysql is 8.4.4 for what I found from version 8.0.13 onwards

The BLOB, TEXT, GEOMETRY, and JSON data types can be assigned a default value only if the value is written as an expression, even if the expression value is a literal.

Could it be an issue with the mysql2 gem? Any pointers, can I just remove the default values from the migration?

Thanks!

[rameerez]

@estebanutz this was a problem with the usage_credits gem not supporting MySQL databases. Databases differ a lot between them, especially in how they handle JSON fields, and they usually need special case handling, which didn't exist for MySQL in usage_credits. I've just added support for MySQL in #28, I've also added CI testing against MySQL and PostgreSQL so the gem stays compatible with all major databases moving forward. This was already merged and shipped in v0.4.0 of usage_credits, please try again now and feel free to open a new issue if something doesn't work as it should!