From 7a91be18148b1e9449837ff9efc77fef9b024be7 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy 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 Signed-off-by: Tomas Cohen Arazi --- .../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.39.5