Update to latest/6.73 = errors = create table `members_metafields`

Hi guys.

I’ve just pulled latest image and Ghost fails with logging:

[2026-10-28 10:30:21] ERROR create table `members_metafields` (`id` varchar(24) not null, `namespace` varchar(191) not null constraint members_metafields_namespace_check check (`namespace` REGEXP '(?-i)^[a-z0-9_]+\\z'), `key` varchar(191) not null constraint members_metafields_key_check check (`key` REGEXP '(?-i)^[a-z0-9_]+\\z'), `name` varchar(191) not null, `type` varchar(50) not null, `status` varchar(50) not null default 'active', `member_access` varchar(50) not null default 'none', `sort_order` int unsigned not null default '0', `created_at` datetime not null, `updated_at` datetime null, primary key (`id`)) default character set utf8mb4 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'check (`namespace` REGEXP '(?-i)^[a-z0-9_]+\\z'), `key` varchar(191) not null...' at line 1

create table `members_metafields` (`id` varchar(24) not null, `namespace` varchar(191) not null constraint members_metafields_namespace_check check (`namespace` REGEXP '(?-i)^[a-z0-9_]+\\z'), `key` varchar(191) not null constraint members_metafields_key_check check (`key` REGEXP '(?-i)^[a-z0-9_]+\\z'), `name` varchar(191) not null, `type` varchar(50) not null, `status` varchar(50) not null default 'active', `member_access` varchar(50) not null default 'none', `sort_order` int unsigned not null default '0', `created_at` datetime not null, `updated_at` datetime null, primary key (`id`)) default character set utf8mb4 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'check (`namespace` REGEXP '(?-i)^[a-z0-9_]+\\z'), `key` varchar(191) not null...' at line 1

{"config":{"transaction":false},"name":"2026-10-20-21-48-55-store-metafield-namespaces.js"}
"Error occurred while executing the following migration: 2026-10-20-21-48-55-store-metafield-namespaces.js"

Error ID:
    300

Error Code: 
    ER_PARSE_ERROR

Reverting back to 6.69 - which I’ve run for a while - brings everything back to.. normal

Anybody sees this/smillar?

thanks, L.

It sounds like you’re using a version of MariaDB that doesn’t support some of the syntax used in newer Ghost tables :thinking:

Ghost only officially supports MySQL for production (and SQLite support is going to be dropped in Ghost 7.0) - so you may want to look at switching to a proper MySQL version instead of MariaDB, or updating your MariaDB version to one that supports the newer regex check constraint syntax.