- Koha - lists.katipo.co.nz

painful upgrade from 2.25 to 3.0.1: incomplete tables
by ghenry 20 Mar '09

20 Mar '09

hello all, i'm following the document: http://wiki.koha.org/doku.php?id=22_to_30 and it's failing when executing the script koha-3.00.01-stable/misc/migration_tools/22_to_30/rebuild_unimarc_100.pl Creating/updating field 100 if needed DBD::mysql::st execute failed: Unknown column 'done' in 'where clause' at /usr/local/koha/lib/C4/Biblio.pm line 2299. DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/local/koha/lib/C4/Biblio.pm line 2300. Use of uninitialized value in numeric eq (==) at /usr/local/koha/lib/C4/Biblio.pm line 2302. ... the reason is that the zebraqueue table isn't as expected: CREATE TABLE `zebraqueue` ( `id` int(11) NOT NULL auto_increment, `biblio_auth_number` int(11) NOT NULL default '0', `operation` char(20) NOT NULL default '', `server` char(20) NOT NULL default '', `done` int(11) NOT NULL default '0', `time` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; but my actual table looks like: CREATE TABLE `zebraqueue` ( `id` int(11) NOT NULL AUTO_INCREMENT, `biblio_auth_number` int(11) NOT NULL DEFAULT '0', `operation` char(20) NOT NULL DEFAULT '', `server` char(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9555 DEFAULT CHARSET=utf8; as you can see, done and time are missing, so my guess is that something was wrong during the script execution, update22to30.pl ? The only errors i had are: 090319 9:23:24 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`BDkoha4_test`.`#sql-455b_55bd`, CONSTRAINT `#sql-455b_55bd_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /home/henry/koha-3.00.01-stable/installer/data/mysql/update22to30.pl line 3442. ==================== An error occured during : alter table items ADD FOREIGN KEY holdingbranch (holdingbranch) REFERENCES branches (branchcode) on update CASCADE on delete RESTRICT It probably means there is something wrong in your DB : a row (items.holdingbranch) refers to a value in branches.branchcode that does not exist. solve the problem and run updater again (or just the previous SQL statement). You can find those values with select items.* from items where holdingbranch not in (select branchcode from branches) ==================== the last error is easily corrected, but for the first one, i have no idea if it's related to the uncomplete table? and how can i verify if others tables where affected during the update process? thanks in advance for reply, gerard

2 6

Koha to MARC mapping
by Beth Willis 20 Mar '09

20 Mar '09

Dear list members, How can I modify the Koha to MARC mapping table? Thank you. -- Beth Willis Catalog & Digital Librarian North of Boston Library Exchange, Inc. Danvers, Massachusetts willis(a)noblenet.org

2 1

Re: [Koha] Firefox on Windows XP and Koha
by Emrys Minnig 20 Mar '09

20 Mar '09

I had a similar problem with Koha 3.0.0 on FF3/WinXP (with no add-ons), but I noticed that the slowdown was progressive. In other words, the first few records seemed to process rather quickly after hitting the 'Save' button, but as more records were added, it got slower and slower. However, after 'Clearing private data' from FF's 'Tools' menu, everything sped up again. (Perhaps Koha was desperately looking for cached data?) Now I've set up my browser to clear all private data whenever I close it... Hope that helps! Emrys ________________________________ From: koha-bounces(a)lists.katipo.co.nz on behalf of Beda Szukics Sent: Mon 16/03/2009 16:46 To: Koha-Mailingliste Subject: [Koha] Firefox on Windows XP and Koha Hello all I'd like to use Firefox (3.0.7) on WindowXP to work with Koha. Most of the things do all right. But adding MARC-Records the Firefox takes about half a minute to save the record (and the harddisk is quite busy). Why is that so? I tried Safary and Google Chrome: those two don't show this behaviour. Also using Firefox with Linux (Ubuntu). Beda _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

6 9

Re: [Koha] Hiding lost items
by Olugbenga Adara 19 Mar '09

19 Mar '09

Hello Savitra, I will check the link. Thanks Olugbenga Adara Mobile: 234-803-3220288 --- On Thu, 3/19/09, savitra sirohi <savitra.sirohi(a)osslabs.biz> wrote: > From: savitra sirohi <savitra.sirohi(a)osslabs.biz> > Subject: Re: [Koha] Hiding lost items > To: "Olugbenga Adara" <gbengaadara(a)yahoo.com> > Date: Thursday, March 19, 2009, 12:29 AM > Olubenga, > > This post has information on your problem: > http://www.nabble.com/Lost-items-display-td17190147.html > > Thanks, > Savitra Sirohi > Nucsoft OSS Labs > http://www.osslabs.biz > > On Wed, Mar 18, 2009 at 3:42 AM, Olugbenga Adara <gbengaadara(a)yahoo.com> > wrote: > > > > Hello all, > > > > If i enable the hide lost items systems preferences > OPAC searches does not work. what do i need to do to enable > hide lost items and still have non lost items show up in > opac search? > > > > Thanks so much for your help. > > > > Olugbenga Adara > > Mobile: 234-803-3220288 > > > > > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > >

1 0

Re: [Koha] Item Type Defined in MARC
by Doug Dearden 19 Mar '09

19 Mar '09

Just looked again, also put it into 942$c. Doug >>> "Doug Dearden" <dearden(a)sarsf.org> 3/19/2009 11:57:21 AM >>> Ed, I believe your answer is in here: =952 \\$bFiction$hFIC DLA$pT0025982$t1$xFSC@aR@b148@c20081014@i1@jHardcover@fFollett$xFUND: District$aSHS The $x fields contain the detail info that was exported from Follett. I think the item code you are looking for in this example is "R". The string that starts $xFSC has fields that are delimited by "@". The item type is in the @a field. The script I sent and later posted to the web site contains code to do the conversion, if you use it you need to modify it to convert from your Follett item type codes to your koha item type codes. Looking at the script I put it into the 952$y field. Best, Doug >>> "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> 3/19/2009 11:34:27 AM >>> That is what I am trying to do . The only thing I can find for Follett is it put a 3 character code in the LDR field at position 5, 6 and 7 to represent the type of item. Anyone that migrates from Follett how did you assign your item types? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Joe Atzberger [mailto:ohiocore@gmail.com] Sent: Thursday, March 19, 2009 12:59 PM To: Roche III, Edward Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Item Type Defined in MARC You should create the itemtype codes in Koha to match your data, or edit your data to match your new codes. The question you are asking is better directed to a FOLLETT group regarding where that system outputs itemtype. --Joe 2009/3/19 Roche III, Edward <edward_roche(a)solanco.k12.pa.us> Good Morning All Does anyone know where in MARC is the item type defined? In my exported data from Follett I dont see anything that looks like the item type codes that are in Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] Item Type Defined in MARC
by Doug Dearden 19 Mar '09

19 Mar '09

Ed, I believe your answer is in here: =952 \\$bFiction$hFIC DLA$pT0025982$t1$xFSC@aR@b148@c20081014@i1@jHardcover@fFollett$xFUND: District$aSHS The $x fields contain the detail info that was exported from Follett. I think the item code you are looking for in this example is "R". The string that starts $xFSC has fields that are delimited by "@". The item type is in the @a field. The script I sent and later posted to the web site contains code to do the conversion, if you use it you need to modify it to convert from your Follett item type codes to your koha item type codes. Looking at the script I put it into the 952$y field. Best, Doug >>> "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> 3/19/2009 11:34:27 AM >>> That is what I am trying to do . The only thing I can find for Follett is it put a 3 character code in the LDR field at position 5, 6 and 7 to represent the type of item. Anyone that migrates from Follett how did you assign your item types? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Joe Atzberger [mailto:ohiocore@gmail.com] Sent: Thursday, March 19, 2009 12:59 PM To: Roche III, Edward Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Item Type Defined in MARC You should create the itemtype codes in Koha to match your data, or edit your data to match your new codes. The question you are asking is better directed to a FOLLETT group regarding where that system outputs itemtype. --Joe 2009/3/19 Roche III, Edward <edward_roche(a)solanco.k12.pa.us> Good Morning All Does anyone know where in MARC is the item type defined? In my exported data from Follett I dont see anything that looks like the item type codes that are in Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Item Type Defined in MARC
by Roche III, Edward 19 Mar '09

19 Mar '09

Good Morning All Does anyone know where in MARC is the item type defined? In my exported data from Follett I don't see anything that looks like the item type codes that are in Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

2 2

(no subject)
by MATALDA CHARLES 19 Mar '09

19 Mar '09

Daer all , I'm using debian 5.0 but i'd like to confirm that koha 3.0.1 is support following : mysql -sever -4.1 or mysql-server-5 perl 5.8 or perl 5.10 charles(a)biblo.fr _________________________________________________________________ Join the all-new Windows Live Messenger family http://get.live.com

2 1

Authority search
by Liny Varghese 19 Mar '09

19 Mar '09

Hi all We are using Koha 3.0. While adding biblio , the Authority search for Personal name always outputs no results. Ho we can solve this? Thanks in advance regards Liny Varghese CUSAT

3 2

Re: [Koha] Cataloguing articles within serials
by Nelson Fredsell -CCE 19 Mar '09

19 Mar '09

Thank you, Joy, for the detailed explanation. A responding question I put to Verónica Lencinas in Argentina is whether I would enter both a serial and its articles as main items. To try and be clear, a serial with 10 articles would then result in 11 main entries in the ILS. Would this confuse patrons? However, I suspect it would be preferable to do it this way as opposed to 1 main item with 10 entries in TOC 505 repeatable fields so that both Keyword *and* Subject fields could be used for an article, and therefore more searchable by patrons. Take care, Nelson Centre for Creative Education Cape Town, South Africa www.cfce.org.za > -----Original Message----- > From: Banks, Joy M [mailto:jbanks@flsouthern.edu] > Sent: 17 March 2009 03:14 PM > To: Nelson Fredsell > Subject: RE: [Koha] Cataloguing articles within serials > > Nelson- > > I've done this at least once for a faculty article in a journal to > which we don't subscribe. To view that record, go here: > http://fsc.kohalibrary.com/cgi-bin/koha/opac- > detail.pl?biblionumber=140301 > > You can view the MARC to see how exactly I formatted it. I received > some help from other OCLC libraries building the bib, so I'm pretty > confident that it follows the "rules." While your original post didn't > exactly say if you wanted the article as the main entry (as opposed to > the journal), this example show how you can make the article the main > entry. > > If you are looking to keep the original item (the book, journal, > whatever) that the article is in as the main entry, than the 505 field > (Table of Contents) would be the place to put it. I've found that the > unformatted table of contents field (505 0_) works a little bit better > with the indexing of Koha. We're a hosted system, though, so that might > make a difference. For an example of how that looks, go here: > http://fsc.kohalibrary.com/cgi-bin/koha/opac- > detail.pl?biblionumber=134277. This has an unformatted contents note in > the "Description" tab. That means it's not putting the chapter titles > and authors into any index, but they are all still accessible through > keyword searching. You can also see the MARC for this record as well. > > I hope this helps. > > ~Joy > > Joy M. Banks > Catalog Librarian > Florida Southern College > 111 Lake Hollingsworth Dr. > Lakeland, FL 33801 > (863)680-4736 > jbanks(a)flsouthern.edu<mailto:jbanks@flsouthern.edu>

1 0