[Koha-bugs] [Bug 28012] New: Error on Saving new numbering pattern

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

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

            Bug ID: 28012
           Summary: Error on Saving new numbering pattern
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Serials
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: christian.stelzenmueller at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org

I got an error after klicking on the Save button for saving a new numbering
pattern.

1. go to the serials module
2. click on manage numbering patterns in the left hand navigation
3. add a pattern
4. Fill in the fields
5. Filling in the Numbering formula field leads to an error after saving. 
Leaving the numbering formula field blank, no error occurs, but the new pattern
won't be saved it seems

First lines of error trace:
C4::Serials::Numberpattern::AddSubscriptionNumberpattern(): DBI Exception:
DBD::mysql::st execute failed: Incorrect integer value: '' for column
`koha_christian8`.`subscription_numberpatterns`.`displayorder` at row 1 [for
Statement "INSERT INTO
subscription_numberpatterns(label,description,numberingmethod,displayorder,label1,label2,label3,add1,add2,add3,every1,every2,every3,setto1,setto2,setto3,whenmorethan1,whenmorethan2,whenmorethan3,numbering1,numbering2,numbering3)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" with ParamValues:
0="blablub", 1="blablubdescription", 2="{X}, H. {Y} {Z} ", 3="", 4="Jahr",
5="Jahrgang", 6="Heft", 7="1", 8="1", 9="1", 10="12", 11="6", 12="1", 13="1",
14="1", 15="1", 16="9999", 17="9999", 18="6", 19="", 20="", 21=""] at
/kohadevbox/koha/serials/subscription-numberpatterns.pl line 62
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

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