[Koha] Error in SQL during upgrade to 20.05.04

Mike Lake mikel at speleonics.com.au
Wed Sep 23 22:42:03 NZST 2020


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




More information about the Koha mailing list