From af30f06e476d6befe7b2edec78c54cf98dce3c19 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 28 Oct 2016 11:21:11 -0400 Subject: [PATCH] Correcting typo --- reports/change_reports_owner.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reports/change_reports_owner.pl b/reports/change_reports_owner.pl index 07b807e..4eb60b2 100755 --- a/reports/change_reports_owner.pl +++ b/reports/change_reports_owner.pl @@ -112,7 +112,7 @@ if ($response eq "n") { # under unshared folders cause UI havoc, we unshare everything first. my @folder_tables = qw/reporter.template_folder reporter.report_folder reporter.output_folder/; foreach my $folder_table (@folder_tables) { - my $create_parent = qq/INSERT INTO $folder_table (owner, name) VALUES ($user_id2, 'Reports from $first_name1 $middle_name1 $last_name1 ($old_barcode)')/ + my $create_parent = qq/INSERT INTO $folder_table (owner, name) VALUES ($user_id2, 'Reports from $first_name1 $middle_name1 $last_name1 ($old_barcode)')/; my $unshare_folders = qq/UPDATE $folder_table SET shared = FALSE, share_with = NULL WHERE owner = ?/; my $update_parent = qq/UPDATE $folder_table SET parent = (SELECT id FROM $folder_table WHERE owner = $user_id2 AND name = 'Reports from $first_name1 $middle_name1 $last_name1 ($old_barcode)') WHERE owner = ? AND parent IS NULL/; $sth = $dbh->prepare("$create_parent"); -- 2.11.0