From dc6c8c93f4edfc064ccecea7c8e5196180e3aa6d Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Tue, 14 Feb 2012 11:45:18 -0500 Subject: [PATCH] Fix typos in lp820006 that broke clean schema creation Backslashes to escape single quotes in SQL aren't cool. Also, lists of rows to insert need commas as delimiters. Also, needed a trailing "]" on the 90-day lost notice template. Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 2e1da72c12..918dce1a39 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -6315,7 +6315,7 @@ INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, vali VALUES (2, 'f', 1, '90 Day Overdue Mark Lost', 'checkout.due', 'CircIsOverdue', 'MarkItemLost', '90 days', 'due_date'); INSERT INTO action_trigger.event_params (event_def, param, value) VALUES - (2, 'editor', '\'1\''); + (2, 'editor', '''1'''); -- Sample Auto Mark Lost Notice -- @@ -6335,7 +6335,7 @@ The following items are 90 days overdue and have been marked LOST. [%- copy_details = helpers.get_copy_bib_basics(circ.target_copy.id) -%] Title: [% copy_details.title %], by [% copy_details.author %] Call Number: [% circ.target_copy.call_number.label %] - Shelving Location: [% circ.target_copy.location.name % + Shelving Location: [% circ.target_copy.location.name %] Barcode: [% circ.target_copy.barcode %] Due: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %] Item Cost: [% helpers.get_copy_price(circ.target_copy) %] @@ -6351,7 +6351,7 @@ INSERT INTO action_trigger.environment (event_def, path) VALUES (3, 'target_copy.call_number'), (3, 'usr'), (3, 'billable_transaction.summary'), - (3, 'circ_lib.billing_address') + (3, 'circ_lib.billing_address'), (3, 'target_copy.location'); -- 2.11.0