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 <[email protected]> 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 > > [email protected] > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
