[Koha-devel] [Bug 139] New: Inconsistency between MARC DB schema & initial data gives error 1048 during installation

[bugzilla-daemon]

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

           Summary: Inconsistency between MARC DB schema & initial data
                    gives error 1048 during installation
           Product: Koha
           Version: CVS
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Database
        AssignedTo: address@hidden
        ReportedBy: address@hidden
         QAContact: address@hidden


When US MARC is selected during installation, MySQL reports

ERROR 1048 at line 20: Column 'kohafield' cannot be null

This refers to the marc_subfield_structure table, created in
scripts/marc/marcschema.sql. However, in both
scripts/misc/marc_datas/marc21_en/structure_def.sql
and scripts/misc/marc_datas/unimarc_fr/structure_def.sql, there are a lot of
INSERT statements where the "kohafield" field (the 5th last field) is NULL. As a
result, a lot of MARC fields will not be pre-entered into the MARC subfield
structure table.

It seems that, in "kohafield", the empty string '' is used instead of NULL to
mean "no Koha field".



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