Thanks to both Fridolyn and Beverly, we now have no errors in our frameworks. I did have links to tab 10 in the other subfields besides 952. I really appreciate everyone's help and patience as I learn about Koha. It's a wonderful community. Linda
Date: Thu, 21 Apr 2011 08:14:55 +0200 From: Fridolyn SOMERS<fridolyn.somers@gmail.com> Subject: Re: [Koha-devel] [Koha] koha: error in MARC Bibliographic Framework Test To: Linda Culberson<lculber@mdah.state.ms.us> Cc: koha-devel@lists.koha-community.org, "Church, Beverly" <bchurch@liblime.com>, koha<koha@lists.katipo.co.nz> Message-ID:<BANLkTi=0YRmQD-183tXgOgiGQ6XDqVJ2vg@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1"
Hie,
I'd say you don't test the right query. The "tab" choosen for subfield in framework configuration is saved in "tab" field of "marc_subfield_structure" :
Try : SELECT DISTINCT(tagfield),tab FROM marc_subfield_structure WHERE tab> 9
You should have only "952 | 10".
Regards,
On Wed, Apr 20, 2011 at 9:18 PM, Linda Culberson <lculber@mdah.state.ms.us>wrote:
Thanks, Bev! That was it! I really appreciate your help. Linda
On 4/20/2011 2:02 PM, Church, Beverly wrote:
Linda,
I haven't seen this message before but it sounds as if the subfields for the other tags are linked to Tab 10 instead of Tab 9. Only the tag 952 subfields should be linked to Tab 10.
Bev
* * * * Beverly Church LibLime Project Manager
phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchurch@liblime.com<mailto:bchurch@liblime.com>
skype: beverlychurch
On Wed, Apr 20, 2011 at 2:37 PM, Linda Culberson <lculber@mdah.state.ms.us<mailto:lculber@mdah.state.ms.us>> wrote:
All, I had done 12 customized frameworks in Koha version 3.02.02.003 and at some point I made an error - and I'm embarrassed that I don't know when the error got in since I worked on them pretty much all at once. I have only the one error and it is: Item tag There is more than 1 MARC tag related to items tab (10) : 952,955,956,960,967,980,981,982,983,984,987,990,995,998.
I've gone through every framework and don't use any of those fields except the 952. I did this sql statement to verify that was the case: SELECT distinct tagfield FROM `marc_subfield_structure` WHERE `tagfield` IN ('952', '955', '956', '960', '967', '980', '981', '982', '983', '984', '987', '990', '995', '998' ) AND `kohafield` LIKE 'items.%';
and the results was one row: 952.
I've checked all the frameworks and even matched them against the demos so kindly posted on koha-community.org<http://koha-community.org>.
I'm thinking that I may not be understanding what the error means, because I was assuming that it indicated that there might be a duplication in the koha link. Can someone tell me what I should be looking for?
Thanks in advance.
-- Linda Culberson lculber@mdah.state.ms.us
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824