From 4ede76280b79ec02a5e1c05bf08bd87cf37c4334 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 4 Mar 2021 09:43:12 +0300 Subject: migrations: don't try to use transactions on mysql --- classes/db/migrations.php | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/classes/db/migrations.php b/classes/db/migrations.php index e5133ddf6..26866698b 100644 --- a/classes/db/migrations.php +++ b/classes/db/migrations.php @@ -82,7 +82,9 @@ class Db_Migrations { else Debug::log("Starting migration to $version...", Debug::LOG_VERBOSE); - $this->pdo->beginTransaction(); + // mysql doesn't support transactions for DDL statements + if (Config::get(Config::DB_TYPE) != "mysql") + $this->pdo->beginTransaction(); foreach ($this->get_lines($version) as $line) { Debug::log($line, Debug::LOG_EXTENDED); @@ -99,7 +101,9 @@ class Db_Migrations { else $this->set_version($version); - $this->pdo->commit(); + if (Config::get(Config::DB_TYPE) != "mysql") + $this->pdo->commit(); + Debug::log("Migration finished, current version: " . $this->get_version(), Debug::LOG_VERBOSE); } catch (PDOException $e) { -- cgit v1.2.3