Upon subdomain install i get error: "
Could not install plugin: Could not run migrations': SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'allowed_record_types' can't have a default value (Connection: mysql, Host: x.x.x.x, Port: xxxx, Database: xxxx, SQL: alter table cloudflare_domains add allowed_record_types json not null default '["A","AAAA","CNAME","SRV"]' after prefix)"
I am using MySQL 26.7
Issue in 007_add_allowed_record_types.php. The migration supplies the JSON default as a string literal. MySQL requires JSON defaults to be written as expressions. However JSON default expression may break sqllite?? havent tested.
Current JSON DEFAULT works with sqllite, but not MySQL.
Upon subdomain install i get error: "
Could not install plugin: Could not run migrations': SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'allowed_record_types' can't have a default value (Connection: mysql, Host: x.x.x.x, Port: xxxx, Database: xxxx, SQL: alter table cloudflare_domains add allowed_record_types json not null default '["A","AAAA","CNAME","SRV"]' after prefix)"I am using MySQL 26.7
Issue in 007_add_allowed_record_types.php. The migration supplies the JSON default as a string literal. MySQL requires JSON defaults to be written as expressions. However JSON default expression may break sqllite?? havent tested.
Current JSON DEFAULT works with sqllite, but not MySQL.