Cannot update to 4.47.4

Bugs
1 
A GhostError occurred.

Message: Ghost was able to start, but errored during boot with: alter table `newsletters` modify  `created_at` datetime null default 'NULL' - Invalid default value for 'created_at'
Suggestion: journalctl -u ghost_domain-com -n 50

Debug Information:
    OS: Ubuntu, v20.04.4 LTS
    Node Version: v16.15.0
    Ghost Version: 4.43.1 to 4.47.1
    Ghost-CLI Version: 1.19.2
    Environment: production
    Command: 'ghost update'
    mariadb version:  Ver 15.1 Distrib 10.3.34-MariaDB
2

This is the same issue as discussed in this thread with a lot of detail: