From 27a96a40db9d165f57ef64f09a2a7ef572ab58c2 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Tue, 10 Aug 2010 02:32:50 -0400
Subject: [PATCH] - Fix path to SQL files when using pgsql/mysqli/sqlsrv drivers (#1486902)
---
CHANGELOG | 1 +
bin/update.sh | 3 ++-
installer/test.php | 3 ++-
3 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/CHANGELOG b/CHANGELOG
index fbb721b..117e1cb 100644
--- a/CHANGELOG
+++ b/CHANGELOG
@@ -2,6 +2,7 @@
===========================
- Improve handling of single-part messages with bogus BODYSTRUCTURE (#1486898)
+- Fix path to SQL files when using pgsql/mysqli/sqlsrv drivers (#1486902)
RELEASE 0.4
-----------
diff --git a/bin/update.sh b/bin/update.sh
index 7a4d1cf..2d59b26 100755
--- a/bin/update.sh
+++ b/bin/update.sh
@@ -114,7 +114,8 @@
$success = false;
}
else if ($RCI->db_schema_check($DB, false)) {
- $updatefile = INSTALL_PATH . 'SQL/' . $DB->db_provider . '.update.sql';
+ $db_map = array('pgsql' => 'postgres', 'mysqli' => 'mysql', 'sqlsrv' => 'mssql');
+ $updatefile = INSTALL_PATH . 'SQL/' . (isset($db_map[$DB->db_provider]) ? $db_map[$DB->db_provider] : $DB->db_provider) . '.update.sql';
echo "WARNING: Database schema needs to be updated!\n";
echo "Open $updatefile and execute all queries that are superscribed with the currently installed version number\n";
$success = false;
diff --git a/installer/test.php b/installer/test.php
index b2d3b6f..a465e2f 100644
--- a/installer/test.php
+++ b/installer/test.php
@@ -166,7 +166,8 @@
}
else if ($RCI->db_schema_check($DB, $update = !empty($_POST['updatedb']))) {
$RCI->fail('DB Schema', "Database schema differs");
- $updatefile = INSTALL_PATH . 'SQL/' . $DB->db_provider . '.update.sql';
+ $db_map = array('pgsql' => 'postgres', 'mysqli' => 'mysql', 'sqlsrv' => 'mssql');
+ $updatefile = INSTALL_PATH . 'SQL/' . (isset($db_map[$DB->db_provider]) ? $db_map[$DB->db_provider] : $DB->db_provider) . '.update.sql';
echo '<p class="warning">Please manually execute the SQL statements from '.$updatefile.' on your database.<br/>';
echo 'See comments in the file and execute queries that are superscribed with the currently installed version number.</p>';
$db_working = false;
--
Gitblit v1.9.1