[Koha] Error in SQL during upgrade to 20.05.04

[Mike Lake]

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