From 4c9c98e689f86a5f3b254fb33803f608e32a14c4 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Thu, 13 Sep 2012 12:47:32 -0400 Subject: [PATCH] rel_2_1 does not have a config.upgrade_log.applied_to column Thanks to Michael Peters for running into & reporting this problem when attempting to upgrade from 2.1.2 to 2.1.3! Fix the version upgrade script. Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/version-upgrade/2.1.2-2.1.3-upgrade-db.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.1.2-2.1.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.1.2-2.1.3-upgrade-db.sql index bec59a45fd..8ee3b862f8 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.1.2-2.1.3-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.1.2-2.1.3-upgrade-db.sql @@ -1,6 +1,6 @@ --Upgrade Script for 2.1.2 to 2.1.3 BEGIN; -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.1.3', :eg_version); +INSERT INTO config.upgrade_log (version) VALUES ('2.1.3'); -- Evergreen DB patch 0722.schema.acq-po-state-constraint.sql -- @@ -10,8 +10,8 @@ ALTER TABLE acq.purchase_order ADD CONSTRAINT valid_po_state CHECK (state IN ('new','pending','on-order','received','cancelled')); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0725', :eg_version); -- gmcharlt/denials -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0726', :eg_version); -- denials +INSERT INTO config.upgrade_log (version) VALUES ('0725'); -- gmcharlt/denials +INSERT INTO config.upgrade_log (version) VALUES ('0726'); -- denials CREATE OR REPLACE FUNCTION evergreen.maintain_901 () RETURNS TRIGGER AS $func$ use strict; -- 2.11.0