[Koha-bugs] [Bug 6428] refered column 'items.coded_location_qualifier' does not exist

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

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

Paul Poulain <paul.poulain at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
       Patch Status|Signed Off                  |Failed QA

--- Comment #17 from Paul Poulain <paul.poulain at biblibre.com> 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.