http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6428
Paul Poulain <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Signed Off |Failed QA --- Comment #17 from Paul Poulain <[email protected]> 2011-10-14 09:50:33 UTC --- QA comments: There are a few references to the coded_location_qualifier field: installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'BKS', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'CF', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'SR', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'VR', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'AR', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'KT', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'IR', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'SER', '', '', NULL), installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, '', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql: ('952','f','Coded location qualifier','Coded location qualifier',0,0,'items.coded_location_qualifier',10,'','','',NULL,0,'FA','',NULL,NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'BKS', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'CF', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'SR', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'VR', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'AR', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'KT', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'IR', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'SER', '', '', NULL), installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql: ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, '', '', '', NULL), Could you remove them as well ? The updatedatabase SQL says : installer/data/mysql/updatedatabase.pl: $dbh->do("UPDATE marc_subfield_structure SET kohafield = NULL WHERE tagfield = 952 AND tagsubfield = 'f' AND kohafield = 'items.coded_location_qualifier'"); That won't fix the bug with someone having moved this reference in another field. I think this can happend only in theory and wouldn't have marked failed QA just for this, but as you'll have to add some forgotten references, you can also update the SQL (or object/argue if you think i'm wrong) -- 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 [email protected] 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/
