Hello everyone! The Koha community is proud to announce the release of Koha 20.05.04. Koha 20.05.04 is a security release including 1 security fix, 23 enhancements, and 40 bugfixes. The full release notes are available here: https://koha-community.org/koha-20-05-04-released/ Debian packages are ready and can be downloaded here: https://download.koha-community.org/ -- Lucas Gass Web Developer
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
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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi all, I believe an additional ',' in the updatedatabase statement is responsible for this error and have filed: *Bug 26548* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26548> - [20.05] Update for 20.05.03.001 has wrong SQL The good news is, that this is not a big issue for your installations: Try changing and saving the new DefaultLongOverduesSkipLostStatuses system preference. If the changes save ok - it's all good. Hope this helps, Katrin On 23.09.20 15:24, Craig Butosi wrote:
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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Craig Butosi -
Katrin Fischer -
Lucas Gass -
Mike Lake