From 17ca7aacff020b391625b28e5644bc1f09a3767c Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Fri, 8 May 2020 13:44:39 +1000 Subject: [PATCH] Add in deprecation notice for MySQL/MariaDB versions below 5.7 --- CRM/Utils/Check/Component/Env.php | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/CRM/Utils/Check/Component/Env.php b/CRM/Utils/Check/Component/Env.php index 63efaddef8..7051ed56a0 100644 --- a/CRM/Utils/Check/Component/Env.php +++ b/CRM/Utils/Check/Component/Env.php @@ -935,4 +935,22 @@ class CRM_Utils_Check_Component_Env extends CRM_Utils_Check_Component { return $messages; } + public function checkMysqlVersion() { + $messages = []; + $version = CRM_Utils_SQL::getDatabaseVersion(); + if (version_compare(CRM_Utils_SQL::getDatabaseVersion(), '5.7', '<')) { + $messages[] = new CRM_Utils_Check_Message( + __FUNCTION__, + ts('This system uses MySQL/MariaDB version %1. To ensure the continued operation of CiviCRM, upgrade your server now. At least MySQL version %2 or MariaDB version %3 is recommended', [ + 1 => $version, + 2 => '5.7', + 3 => '10.1', + ]), + ts('MySQL Out of date'), + \Psr\Log\LogLevel::WARNING, + 'fa-server' + ); + } + } + } -- 2.25.1