[Koha-bugs] [Bug 27569] marc-framework import function doesn't accept LibreOffice csv/ods file formats

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

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

--- Comment #38 from Victor Grousset/tuxayo <victor at tuxayo.net> ---
It turns out that the following SQL error has been caught by tests in 19.11

koha_1       | DBD::mysql::st execute failed: Unknown column 'important' in
'field list' [for Statement "INSERT INTO marc_tag_structure
(tagfield,liblibrarian,libopac,repeatable,mandatory,important,authorised_value,ind1_defaultvalue,ind2_defaultvalue,frameworkcode)
VALUES (?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE
tagfield=?,liblibrarian=?,libopac=?,repeatable=?,mandatory=?,important=?,authorised_value=?,ind1_defaultvalue=?,ind2_defaultvalue=?,frameworkcode=?"
with ParamValues: 0='000', 1='LEADER', 2='LEADER', 3='0', 4='1', 5='0', 6='',
7='', 8='', 9='h8aS', 10='000', 11='LEADER', 12='LEADER', 13='0', 14='1',
15='0', 16='', 17='', 18='', 19='h8aS'] at
/kohadevbox/koha/C4/ImportExportFramework.pm line 860, <$dom> line 2.

https://jenkins.koha-community.org/job/Koha_19.11_D9/305/

Couldn't find where does it take the column "important" comes from though.

Wait, it actually comes from the test data.
t/db_dependent/data/frameworks/biblio_framework_no_quoted.csv

Add patch fixing the test data has been pushed to 19.11.x
https://git.koha-community.org/Koha-community/Koha/commit/eba92984ddf7fcc62a76bd28d32c42f92d434d84


Good thing that the previous patches made the import fail instead of silently
doing something wrong when having a wrong structure to import.

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