[Koha-bugs] [Bug 16678] New: updatedatabase.pl 3.23.00.006 DB upgrade crashes if subscription_numberpatterns.numberingmethod contains parentheses

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

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

            Bug ID: 16678
           Summary: updatedatabase.pl 3.23.00.006 DB upgrade crashes if
                    subscription_numberpatterns.numberingmethod contains
                    parentheses
 Change sponsored?: ---
           Product: Koha
           Version: 3.22
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Installation and upgrade (web-based installer)
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: theod at lib.auth.gr
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com

It seems that if subscription_numberpatterns.numberingmethod contains
parentheses, updatedatabase.pl crashes when running the 3.23.00.006 DB upgrade
snippet, with the following error:

[Mon Jun 6 09:06:54 2016] updatedatabase.pl: Unmatched ( in regex; marked by
<-- HERE in m/ ( <-- HERE / at
/home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 11498.

Steps to reproduce:
1/ Have a Koha DB version<3.23.00.006
2/ Create a subscription numbering with parentheses in it:
   ie "Vol. (Month, Year)" with pattern 
       Vol. {X} ({Y}, {Z})
3/ Add some serials using that numbering method so that serialseq is filled in
DB:
   ie  "Vol. 16 (February, 2015)"
4/ Run the updatedatabase.pl script either from the cli or just start the
webinstaller
5/ The error is produced


FYI, you can overcome this error if you go to the DB and remove parentheses
from subscription_numberpatterns.numberingmethod as well as the relevant
parentheses in the entries in serial.serialseq

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