[Koha-bugs] [Bug 1008] New: Long MARC breaks KOHA

[bugzilla-daemon]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1008

           Summary: Long MARC breaks KOHA
           Product: Koha
           Version: 2.2.0
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Database
        AssignedTo: address@hidden
        ReportedBy: address@hidden
         QAContact: address@hidden


If you have a very long MARC record KOHA seems to create ýt with no problem. 
But when you come back to edit it its all messed up.
The problem according to our diagnosis lies in the marc_subfield_table tagorder
(TINYINT) declaration. This locks the value at 127 and keeps giving value 127 
to all the following fields and breaking koha.
As far as I know a MARC21 record has got a limitation of 99,999 bytes in total 
size and no limitation on the number of fields. So in rare cases like ours a 
total size of 6K MARC record is causing KOHA to break with no indication that 
it actually is broke.
So if there is no other necessity to keep this field as TINYINT I suggest we 
change it to INT. But if there is a reason behind it which I missed then KOHA 
should warn you that you reached this limit and not save the record.



------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.