[Koha] Error in SQL during upgrade to 20.05.04

[Katrin Fischer]

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