[Koha-bugs] [Bug 25861] New: Unknown column 'important' in 'field list'

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

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

            Bug ID: 25861
           Summary: Unknown column 'important' in 'field list'
 Change sponsored?: ---
           Product: Koha
           Version: 19.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: MARC Bibliographic record staging/import
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: ctw2100 at protonmail.com
        QA Contact: testopia at bugs.koha-community.org

Koha Version: 19.11.06.000

I found out it's doesn't work when I add new MARC frameworks, error log said
there is an Unknown column 'important', So I checked the database structure,
there isn't a column called 'important', I also try to delete 'important' from
file marctagstructure.pl, and it works, try to fix this ASAP plz

System Error Log:
[Wed Jun 24 11:01:15.882256 2020] [cgi:error] [pid 22124] [client
172.105.200.142:37851] AH01215: [Wed Jun 24 11:01:15 2020] marctagstructure.pl:
DBD::mysql::db do failed: Unknown column 'important' in 'field list' [for
Statement "INSERT INTO marc_subfield_structure
(frameworkcode,tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,important,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,seealso,hidden,link,defaultvalue,maxlength):
/usr/share/koha/intranet/cgi-bin/admin/marctagstructure.pl, referer:
http://47.113.102.87:8080/cgi-bin/koha/admin/marctagstructure.pl?frameworkcode=STT

[Wed Jun 24 11:01:15.882612 2020] [cgi:error] [pid 22124] [client
172.105.200.142:37851] AH01215: [Wed Jun 24 11:01:15 2020] marctagstructure.pl:
        SELECT
?,tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,important,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,seealso,hidden,link,defaultvalue,maxlength
from marc_subfield_structure where frameworkcode=?:
/usr/share/koha/intranet/cgi-bin/admin/marctagstructure.pl, referer:
http://47.113.102.87:8080/cgi-bin/koha/admin/marctagstructure.pl?frameworkcode=STT

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