From d636c81cd60623504cb265b7dd9e63b54dbc23cb Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 16 Jun 2023 12:15:25 +0000 Subject: [PATCH] Bug 34033: (bug 30649 follow-up) Fix update typos Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 96794db65956051b19df8240a14816e11f967ba6) Signed-off-by: Martin Renvoize --- installer/data/mysql/db_revs/221200041.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/db_revs/221200041.pl b/installer/data/mysql/db_revs/221200041.pl index 44777c040f..1c71449d3c 100755 --- a/installer/data/mysql/db_revs/221200041.pl +++ b/installer/data/mysql/db_revs/221200041.pl @@ -11,7 +11,7 @@ return { }); my $edi_vendors = - $dbh->selectall_arrayref( "SELECT * FROM vendor_edit_accounts", { Slice => {} } ); + $dbh->selectall_arrayref( "SELECT * FROM vendor_edi_accounts", { Slice => {} } ); if (@$edi_vendors) { require Koha::Encryption; my $e = Koha::Encryption->new; @@ -19,7 +19,7 @@ return { my $id = $edi_vendor->{id}; my $password = $edi_vendor->{password}; $password = $e->encrypt_hex($password); - $dbh->do("UPDATE edi_vendor_accounts SET password = $password WHERE id = $id"); + $dbh->do("UPDATE vendor_edi_accounts SET password = '$password' WHERE id = $id"); } } }, -- 2.39.2