http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6993

             Bug #: 6993
           Summary: Incorrect data type in auth_subfield_structure
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: master
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: critical
          Priority: P5
         Component: Database
        AssignedTo: gmcha...@gmail.com
        ReportedBy: cnighswon...@foundations.edu
         QAContact: koha-bugs@lists.koha-community.org


kohastructure.sql makes auth_subfield_structure.linkid a tinyint(1) NOT NULL,
but then authorities_normal_marc21.sql tries to insert an null string value for
that field.

>From kohastructure.sql:

DROP TABLE IF EXISTS `auth_subfield_structure`;
CREATE TABLE `auth_subfield_structure` (

...

  `linkid` tinyint(1) NOT NULL default 0,

...

>From authorities_normal_marc21.sql :

INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`,
`tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`,
`authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`,
`kohafield`, `frameworkcode`) VALUES
        ('', '000', '@', 'fixed length control field', 'fixed length control
field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', '')

...

-- 
Configure bugmail: 
http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to