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