[Koha-devel] [Bug 139] New: Inconsistency between MARC DB schema & initial data gives error 1048 during installation
bugzilla-daemon at wilbur.katipo.co.nz
bugzilla-daemon at wilbur.katipo.co.nz
Tue Dec 3 22:47:02 CET 2002
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: chris at katipo.co.nz
ReportedBy: a.c.li at ieee.org
QAContact: koha-devel at lists.sourceforge.net
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.
More information about the Koha-devel
mailing list