[Koha] Error in SQL during upgrade to 20.05.04

[Craig Butosi]

Hi all,

I can confirm the exact same error on my machine after sudo apt-get update
&& sudo apt-get upgrade to Koha 20.05.04. (Currently running: Koha 20.05.04
on Ubuntu 18.04.5, MariaDB 10.1.44).
No errors reported in var/log/mysql.
Koha seems to be working okay and that the new syspref is visible in Koha
--> Administration -->  Global System Preferences.
No warnings listed in About Koha --> System Information

C

Craig Butosi, MA, MLIS, B Mus (Hons)
Library: library.craigbutosi.ca



On Wed, Sep 23, 2020 at 9:04 AM Mike Lake <mikel at speleonics.com.au> wrote:

> Hi
>
> Versions I'm using are:
>
> Debian_Stretch version 9.13 with sources being "deb
> http://debian.koha-community.org/koha stable main"
> Mariadb  Ver 15.1 Distrib 10.1.45-MariaDB, for debian-linux-gnu
>
>
> ---
> Mike Lake
>
> On 2020-09-23 20:42, Mike Lake wrote:
> > Hi
> >
> > Tonight I upgraded our Koha and the following errors occurred from an
> > aptitude update.
> > Update was koha-common 20.05.03-2 to 20.05.04-1
> > I have two instances "library" and "libtest2".
> > Both still appear to be working but the error is concerning.
> >
> >
> > $ sudo aptitude update
> > The following packages will be upgraded:
> >   koha-common
> > ....
> > Get: 1 http://debian.koha-community.org/koha stable/main amd64
> > koha-common all 20.05.04-1 [37.3 MB]
> > Preparing to unpack .../koha-common_20.05.04-1_all.deb ...
> > Unpacking koha-common (20.05.04-1) over (20.05.03-2) ...
> > Processing triggers for systemd (232-25+deb9u12) ...
> > Setting up koha-common (20.05.04-1) ...
> >
> > Upgrading database schema for library
> > DBD::mysql::db do failed: You have an error in your SQL syntax; check
> > the manual that corresponds to your MariaDB server version for the
> > right syntax to use near '' at line 1 [for Statement "
> > INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`,
> > `explanation`, `type` ) VALUES
> >    ('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost
> > statuses by default in longoverdue.pl', 'Free'),
> >     "] at
> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> > line 22388.
> > Upgrade to 20.05.03.001 done [19:42:16]: Bug 25958 - Allow LongOverdue
> > cron to exclude specified lost values
> > Upgrade to 20.05.04.000 done [19:42:16]: 20.05.04 release
> >
> > Upgrading database schema for libtest2
> > DBD::mysql::db do failed: You have an error in your SQL syntax; check
> > the manual that corresponds to your MariaDB server version for the
> > right syntax to use near '' at line 1 [for Statement "
> > INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`,
> > `explanation`, `type` ) VALUES
> >    ('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost
> > statuses by default in longoverdue.pl', 'Free'),
> >    "] at
> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> > line 22388.
> > Upgrade to 20.05.03.001 done [19:42:16]: Bug 25958 - Allow LongOverdue
> > cron to exclude specified lost values
> > Upgrade to 20.05.04.000 done [19:42:16]: 20.05.04 release
> >
> > Processing triggers for man-db (2.7.6.1-2) ...
> > Reading package lists...
> > Building dependency tree...
> > Reading state information...
> > Reading extended state information...
> >
> >
> > ---
> > Mike Lake
> >
> >
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>