[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

--- Comment #1 from James, Mason <mtj at kohaaloha.com> 2011-05-30 07:40:43 UTC ---
missing column is referered to in 23 framework files

koha.git:$ grep -irl 'coded_location_qualifier' ./* |wc -l
23

http://git.koha-community.org/cgi-bin/gitweb.cgi?p=koha.git;a=blob;f=installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql;h=383a9d92735530224271ec739ac30ad60e96504e;hb=HEAD#l121


and causes additem.pl to fail sometimes


[Mon May 30 15:11:49 2011] additem.pl: DBD::mysql::st execute failed: Unknown
column 'coded_location_qualifier' in 'field list' at
/home/koha/koha.git/C4/Items.pm line 2088.
[Mon May 30 15:11:49 2011] additem.pl: ERROR in _koha_modify_item UPDATE items
SET
restricted=?,items.cn_sort=?,wthdrawn=?,coded_location_qualifier=?,notforloan=?,replacementpricedate=?,itemnumber=?,itemnotes=?,ccode=?,location=?,itemcallnumber=?,stack=?,itemlost=?,barcode=?,uri=?,items.cn_source=?,materials=?,datelastseen=?,price=?,issues=?,homebranch=?,replacementprice=?,more_subfields_xml=?,holdingbranch=?,booksellerid=?,damaged=?,stocknumber=?,datelastborrowed=?,dateaccessioned=?,enumchron=?,copynumber=?,permanent_location=?,itype=?,paidfor=?
WHERE itemnumber=?Unknown column 'coded_location_qualifier' in 'field list' at
/home/koha/koha.git/C4/Items.pm line 2091.

-- 
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.