Our WordPress website is powered by an outdated MySQL version (5.5).
WordPress recommends a minimum version of 5.6 for MySQL.
Using this outdated MySQL is currently a blocker for properly installing the Give WordPress plugin
to enhance our donation form due to a database migration issue (CURRENT_TIMESTAMP
is only avaible since MySQL 5.6.5).
[30-Mar-2021 09:40:30 UTC] WordPress database error Invalid default value for 'last_run' for query CREATE TABLE wp_give_migrations ( id VARCHAR(180) NOT NULL, status VARCHAR(16) NOT NULL, error text NULL, last_run DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\Helpers\Hooks::Give\Helpers\{closure}, call_user_func_array, Give\Framework\Migrations\MigrationsRunner->run, Give\MigrationLog\Migrations\CreateMigrationsTable->run, Give\Framework\Database\DB::delta, Give\Framework\Database\DB::runQueryWithErrorChecking, Give\Framework\Database\DB::Give\Framework\Database\{closure}, dbDelta
I already contact Gandi support a couple of months ago on that subject and got the following answer:
Gandi support can upgrade MySQL to version 5.7. Please confirm via reply you have a taken a recent backup of your website files and databases as a precautionary measure. Expect around 30 minutes of downtime for the upgrade to be completed. So if there is a specific time-frame you'd like this upgrade to occur, let us know and we'll try to accommodate as best we can.
I will ping them back to schedule that upgrade.