[Koha-bugs] [Bug 25958] Allow LongOverdue cron to exclude specified lost values

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25958

Pablo AB <pablo.bianchi at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |pablo.bianchi at gmail.com

--- Comment #15 from Pablo AB <pablo.bianchi at gmail.com> ---
Today while upgrading a Koha on stable from 20.05.04-1 to 20.05.03-1 I got:

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.

Probably "fixed" running the query afterward:
sudo koha-mysql $INSTANCE -e "INSERT IGNORE INTO systempreferences (variable,
value, options, explanation, type) VALUES
('DefaultLongOverdueSkipLostStatuses', '', NULL, 'Skip these lost statuses by
default in longoverdue.pl', 'Free');"

-- 
You are receiving this mail because:
You are watching all bug changes.