Attachment 87008 Details for Bug 22577 – Bug 22577: Retrospectively assign '-1' for cronscripts

[patch] Bug 22577: Retrospectively assign '-1' for cronscripts

Bug-22577-Retrospectively-assign--1-for-cronscript.patch (text/plain), 1.26 KB, created by Martin Renvoize (ashimema) on 2019-03-26 11:17:36 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-03-26 11:17:36 UTC

Size: 1.26 KB

patch

obsolete

>From 011e5d8944713b361723241d7316b4627a62bb23 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Tue, 26 Mar 2019 11:14:55 +0000
>Subject: [PATCH] Bug 22577: Retrospectively assign '-1' for cronscripts
>
>---
> installer/data/mysql/atomicupdate/bug_22577.perl | 4 ++++
> 1 file changed, 4 insertions(+)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_22577.perl b/installer/data/mysql/atomicupdate/bug_22577.perl
>index 3d14f004f2..975209b0c0 100644
>--- a/installer/data/mysql/atomicupdate/bug_22577.perl
>+++ b/installer/data/mysql/atomicupdate/bug_22577.perl
>@@ -1,6 +1,10 @@
> $DBversion = 'XXX'; # will be replaced by the RM
> if( CheckVersion( $DBversion ) ) {
>     $dbh->do( "INSERT INTO `borrowers` (borrowernumber, surname, firstname) VALUES ('-1', 'CRON', 'CRON')" );
>+    $dbh->do( "UPDATE `statistics` SET borrowernumber = '-1' WHERE borrowernumber = '0'" );
>+    $dbh->do( "UPDATE `statistics` SET borrowernumber = '-1' WHERE borrowernumber = '0'" );
>+    $dbh->do( "UPDATE `accountlines` SET manager_id = '-1' WHERE manager_id = '0'" );
>+    $dbh->do( "UPDATE `action_logs` SET user = '-1' WHERE user = '0'" );
>     
>     SetVersion( $DBversion );
>     print "Upgrade to $DBversion done (Bug 22577 - Add internal user for cron)\n";
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 22577: 86991 | 86992 | 86993 | 87007 | 87008 | 87013 | 87014 | 87015 | 87017 | 87028 | 87029 | 87030 | 87031 | 87032 | 87053 | 87054 | 87055 | 87056 | 87057 | 87058 | 87059 | 87060