Attachment 157619 Details for Bug 15504 – Bug 15504: (QA follow-up) Fix dbrev

[patch] Bug 15504: (QA follow-up) Fix dbrev

Bug-15504-QA-follow-up-Fix-dbrev.patch (text/plain), 1.76 KB, created by Andrii Nugged on 2023-10-22 07:24:05 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Andrii Nugged

Created: 2023-10-22 07:24:05 UTC

Size: 1.76 KB

patch

obsolete

>From 59d44e4ea34157e15dc31768611c99765cae15ed Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Thu, 12 Oct 2023 07:26:40 +0000
>Subject: [PATCH] Bug 15504: (QA follow-up) Fix dbrev
>
>Resolve:
>ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Unknown column 'check_out' in 'field list' at /usr/share/koha/C4/Installer.pm line 741
>
>Test plan:
>Remove new pref from db.
>Run dbrev again.
>Check results.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> .../bug_15504-add-tracklastpatronactivityoptions.pl            | 3 ++-
> 1 file changed, 2 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_15504-add-tracklastpatronactivityoptions.pl b/installer/data/mysql/atomicupdate/bug_15504-add-tracklastpatronactivityoptions.pl
>index 0ef83b0118..4064a2ed11 100755
>--- a/installer/data/mysql/atomicupdate/bug_15504-add-tracklastpatronactivityoptions.pl
>+++ b/installer/data/mysql/atomicupdate/bug_15504-add-tracklastpatronactivityoptions.pl
>@@ -14,7 +14,8 @@ return {
> 
>         my $triggers = $tracklastactivity ? 'check_out,connection,login' : '';
>         $dbh->do(
>-            qq{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('TrackLastPatronActivityTriggers',$triggers,NULL,'If set, the field borrowers.lastseen will be updated every time a patron is does a selected option','multiple') }
>+            qq{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('TrackLastPatronActivityTriggers',?,NULL,'If set, the field borrowers.lastseen will be updated every time a patron is does a selected option','multiple') },
>+            undef, $triggers,
>         );
> 
>         say $out "Added system preference 'TrackLastPatronActivityTriggers'";
>-- 
>2.42.0

Actions: View | Diff | Splinter Review

Attachments on bug 15504: 152332 | 152333 | 152334 | 152335 | 152336 | 152500 | 152501 | 152502 | 152503 | 152504 | 152505 | 152506 | 155290 | 155291 | 155292 | 155293 | 155294 | 155295 | 155296 | 155534 | 155535 | 155536 | 155537 | 155538 | 155539 | 155540 | 156598 | 156599 | 156600 | 156601 | 156602 | 156603 | 156604 | 156605 | 156606 | 156607 | 156608 | 156742 | 156855 | 156856 | 156857 | 156858 | 156859 | 156860 | 156861 | 156862 | 156863 | 156864 | 156865 | 156866 | 156867 | 156868 | 156869 | 156870 | 156875 | 156879 | 156898 | 156899 | 156900 | 156901 | 156902 | 156903 | 156904 | 156905 | 156906 | 156907 | 156908 | 156909 | 156910 | 156911 | 156912 | 156913 | 156914 | 156915 | 156917 | 156918 | 156919 | 156920 | 156921 | 156922 | 156923 | 156924 | 156925 | 156926 | 156927 | 156928 | 156929 | 156930 | 156931 | 156932 | 156933 | 156934 | 156935 | 157602 | 157603 | 157604 | 157605 | 157606 | 157607 | 157608 | 157609 | 157610 | 157611 | 157612 | 157613 | 157614 | 157615 | 157616 | 157617 | 157618 | 157619 | 157620 | 157624