[Koha-bugs] [Bug 7726] New: AllowItemsOnHoldCheckout has columns in wrong order in sysprefs.sql

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7726

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 7726
                CC: gmcharlt at gmail.com
          Assignee: paul.poulain at biblibre.com
           Summary: AllowItemsOnHoldCheckout has columns in wrong order in
                    sysprefs.sql
        QA Contact: koha.sekjal at gmail.com
          Severity: trivial
    Classification: Unclassified
                OS: All
          Reporter: magnus at enger.priv.no
          Hardware: All
            Status: NEW
           Version: master
         Component: System Administration
           Product: Koha

installer/data/mysql/sysprefs.sql has this, on line 341: 

INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES
('AllowItemsOnHoldCheckout',0,'Do not generate RESERVE_WAITING and RESERVED
warning when checking out items reserved to someone else. This allows self
checkouts for those items.','','YesNo');

The order of the columns should be switched to this:

(variable,value,explanation,options,type)

The problem is also present in updatedatabase.pl:

$dbh->do("INSERT INTO `systempreferences`
(variable,value,options,explanation,type) VALUES
('AllowItemsOnHoldCheckout',0,'Do not generate RESERVE_WAITING and RESERVED
warning when checking out items reserved to someone else. This allows self
checkouts for those items.','','YesNo')");

This does probably not have any practical implications (hence severity =
trivial), since the "explanation" is not used anymore and "options" is not used
when the type is YesNo (I think?).

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