Hi all, We have upgraded from version 1.2.2 to version 2.2.9. We are having issues trying to get a good marc database of our biblio records. When in version 2.2.9 we run koha2marc.pl -d we get "Column 'bibid' cannot be null" for all records. We then have to go back to an older version, and build it from there. After doing this we don't get great results. For example we only had 2 "245" title records so searching by title doesn't work unless you use one of those titles. Any guidance on how to build a marc database with our biblio information would be greatly appreciated. Thanks, Steve Bradwell Application Development Manager Perimeter Institute for Theoretical Physics <http://www.perimeterinstitute.ca/> (519) 569-7600 x5062.
My suggestion for at least part of your problem under 2.2.9 would be to check the links between Koha's table and the MARC fields ("Koha Administration", then "Links Koha - MARC DB"), and make sure that 245 $a, for example, is linked to biblio.title . -- Jesse
Hi Jesse, Yes, the koha field Biblio.title is linked to the tag 245a on that screen. Any idea why when we run the script koha2marc.pl –d we get errors on every record like this: DBD::mysql::st execute failed: Column 'bibid' cannot be null at /web/intranet/koha-2.2.0/modules/C4/Biblio.pm line 459. ERROR ==> insert into marc_subfield_table (bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldorder,subfieldvalue) values (,952,1, ,b,1,PI) Steve. From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jesse Sent: April-14-08 4:32 PM To: Koha@lists.katipo.co.nz Subject: Re: [Koha] Column 'bibid' cannot be null - koha2marc.pl -d My suggestion for at least part of your problem under 2.2.9 would be to check the links between Koha's table and the MARC fields ("Koha Administration", then "Links Koha - MARC DB"), and make sure that 245 $a, for example, is linked to biblio.title . -- Jesse
It looks like something is going wrong when koha2marc attempts to add the MARC tag for the item. Can you check to see if the marc_biblio table in the koha database has any entries, and whether they're correct? -- Jesse
Hi Jesse, We’ve started back at 2.0.0, we then ran the structure_def.sql to populate the marc tags, then ran koha2marc.pl. All the records seemed to process correctly at this version. We then did an update to version 2.2.0 (not sure which rc it was) and most items seem to be working **other than a weird display issue in the librarian interface where /search.marc/search.pl isn’t displaying search results properly, we get the expected number of results, just don’t see any data), we upgraded to 2.26 and see the same results returned but it has now extened to the opac (opac-search.pl). I looked at the marc_biblio table and it has 1086 records, where we have 1086 records in our biblio table. Our test is to search for “quantum” in any word. We get 199 results (but no data returned) just empty lines. Searching the marc_word table gives us 211 results with quantum in the word field… Any other ideas? Thanks, Steve. From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jesse Sent: April-14-08 5:16 PM To: Koha Mailing List Subject: Re: [Koha] Column 'bibid' cannot be null - koha2marc.pl -d It looks like something is going wrong when koha2marc attempts to add the MARC tag for the item. Can you check to see if the marc_biblio table in the koha database has any entries, and whether they're correct? -- Jesse
participants (2)
-
Jesse -
Steve Bradwell