- Koha - lists.katipo.co.nz

new koha installation not working properly
by khayos 29 Sep '06

29 Sep '06

Hello, I've got a new Koha installation that is behaving rather oddly. I should say that, to begin with, the database tables 'systempreferences' and 'itemtypes' did not exist -- I had to create them manually. Subsequently, I had to populate 'systempreferences' with as many of the entries that I could find, but I suspect I haven't got them all, or that some of the settings are incorrect. At any rate, the problem appears to be that, once I add a biblio record to the system, I can't see it. I try searching for it, and I get a blank screen: nothing shows up when I try to display using 'normal', 'marc', or 'isbd'. What should I be looking for? Does anyone know what might have gone wrong during the installation process? I certainly didn't see anything amiss... Further detail: Koha version: 2.2.5 Operating system: Xubuntu (descendent of Debian) Any help at all that can be offerred will be greatly appreciated. Cheers, JR

2 1

MySQL 5 fixes
by BWS Johnson 29 Sep '06

29 Sep '06

Salvete! Is there a reason that the reserved language switch to make Koha play nice with MySQL 5 hasn't been incorporated into the downloads yet? Am I missing something? Cheers, Brooke @ Hinsdale MA

3 2

Re: [Koha] Koha on Ubuntu install guide
by BWS Johnson 29 Sep '06

29 Sep '06

Salvete! >I've installed Koha 2.2.5 on Ubuntu server 6.06 > >Many people have had trouble with installing on this operating system >and I couldn't find many documents on the web concerning koha on ubuntu. > >So here is a link to a guide that I wrote as I completed the install: >http://matthew.metzger.cc/wiki/index.php?title=Install_Koha_on_Ubuntu_6 .06 > >I'll be adding some details and making it read better as I have time. Awesome, thanks a heap! I think we would see a lot more people running Koha if they only needed to put in two CDs and very little effort. Ubuntu installs very smoothly, and I'd love to see a CD for Koha that installs just as smoothly as Ubuntu. Cheers, Brooke @ Hinsdale MA

6 6

French English on same server
by Peter Corrigan 29 Sep '06

29 Sep '06

Hello Koha, I installed Koha 2.2.5 on A gentoo linux box. My question, can I have both french and english versions on the same server? Right now I only have the english version. How would one prceed to add the french content to the web server. Thanks

3 3

Koha on Ubuntu Dapper PC
by Jaime Reinoso 29 Sep '06

29 Sep '06

I followed the Matthew Metzger's guide to install Koha on Ubuntu on a PC. When I tried to search some biblio the server page opac-detail.pl?bib=1 crash (Internal Server Error). I don't know which perl module is wrong. Please, someone could help me to solve this problem

3 2

2.2.4 to 2.2.5 upgrade problem
by Matthew Metzger 27 Sep '06

27 Sep '06

Hello, I've set up an extra koha server using the process described in my koha on ubuntu guide. http://matthew.metzger.cc/wiki/index.php?title=Install_Koha_on_Ubuntu_6.06 The old database was on koha 2.2.4, the new installation is 2.2.5 I have inserted my database by deleting the default database created by the set up, creating a new empty database named Koha, and then using "mysql -uroot -p Koha < 2006_09_21_koha.sql" to insert the database that I had dumped from my other koha installation on the old server. Everything seems to work great and the data seems to be there, but when I search for items in the opac, they just don't show up. It lists the correct number of results, but the fields are just blank. I have put screen shots up at the url below. http://matthew.metzger.cc/wiki/index.php?title=Koha_upgrade_problem I also ran the updater script after adding the line "use lib '/usr/local/koha/intranet/modules';" directly under the "#Koha modules" line near the beginning of the script. Running the script seemed to fail. Here's the output: sudo ./updatedatabase ----------- connected to your DB. Checking & modifying it Could convert to MyISAM database tables... Alter encoding in marc_breeding Alter printername in printers Alter bookfundid in aqbookfund DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at ./updatedatabase line 1186. Alter aqbudgetid in aqbudget DBD::mysql::st execute failed: Invalid default value for 'id' at ./updatedatabase line 1186. Alter id in z3950servers synch'ing borrowers synch'ing items synch'ing biblio synch'ing biblioitems Checking for data required in table userflags... Checking for data required in table systempreferences... ----------- Any help would be greatly appreciated. Thanks. -Matthew

4 9

Re: RE: [Koha] Barcodes required by Koha
by Steven F.Baljkas 26 Sep '06

26 Sep '06

Monday, September 18, 2006 11:35 CDT finally sent Thursday, September 21, 2006 17:19 CDT Hi, Yan, Thanks for your answer to Una's question. The whole thing with barcodes has been puzzling me for quite a while, and it isn't for lack of trying to understand what Koha requires/prefers. So before anybody tells me to read the manual (#$&%'in or otherwise), let me quote what I was able to find in Koha documentation, and ask for ***** someone among the cognoscenti (programmers/developpers) please to clarify this for those of us who are not programmers, so that we can figure out what the Koha and MARC coding requirements are. ***** This is what it says in the Koha 2.2 Users Guide as of today at URL <http://www.kohadocs.org/usersguide/ch01s04.html#d0e1564> | *** Currently, the barcodes generator works best with 11-digit barcodes. *** | [emphasis added] The last few digits of longer barcodes will not be printed | under the barcode itself, and shorter barcodes will have the check digit | printed after the barcode number. You should have a Perl programmer alter | the Koha code for you if you wish to use something other than 11-digit | barcodes. If there is a more relevant passage somewhere else in the guide, my humble apologies for missing it. I have sincerely tried to find the answer on my own. To a non-programmer like me, the above passage implies that Koha wants/prefers 11-digit barcodes. The example you cited, Yan, I know too: but it is 14-digit. ***Are 14-digit numbers of the type Yan cited in use in Koha libraries?*** What adjustments need to be made to accommodate such? Could someone share what needs to be done? Where I am, 14-digit numbers seem much more common and are (commercially) much more readily available. >From all the info I was able to find online, 11 digits also didn't seem to work with the formulae I could find for constructing valid Code 39 numbers with check digits. Possibly just my bad math skills, but I would really prefer to keep the check digits option open, again in the vein of keeping as many options as possible open for the future. In any case, it would be enormously helpful if some people/s could share a short list of valid, working barcode numbers/types that are actually in use, as a kind of sampler for those of us trying to figure this out. Thanks for your response, Yan, and thanks in advance to any who tackle my additional questions. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: "Han, Yan" <hany(a)u.library.arizona.edu> Date: 2006/09/15 Fri PM 04:03:51 CDT To: "una simon" <unasimon(a)hotmail.com>, <koha(a)lists.katipo.co.nz> CC: elijah(a)elijahcentre.org Subject: RE: [Koha] Barcodes required by Koha I believe that codabar and Code 39 both work with Koha. You can find out a typical library barcode. e.g. 3 9001 04796 2694, where 3 means "item", 9001 means a library, others are item number. Most libraries use codabar, and there are a few use Code 39. Code 39 allows you to encode alphabetic letters and I chose Code 39 for a project. You do not need a software, but a reader will pick up these barcode very quickly. I have purchased Symbol LS2208 scanner (http://www.barcodesinc.com/symbol/ls2208.htm <http://www.barcodesinc.com/symbol/ls2208.htm> ) and it picks up the code quickly. ________________________________ From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of una simon Sent: Thursday, September 14, 2006 8:23 PM To: koha(a)lists.katipo.co.nz Cc: elijah(a)elijahcentre.org Subject: [Koha] Barcodes required by Koha Hello Listserve: I realise there are several barcodes on the market. I should like your guidance in selecting the type of barcodes acceptable by Koha. How many digits - 11 or 14? Which works best for you giving the least problem? Do I need a software and reader from this end if very few items from our collection will leave the physical location? Thank you. Una Simon ============================================================ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Re: [Koha] Koha Bulk Imports
by bluejaydesign＠sympatico.ca 26 Sep '06

26 Sep '06

Hi Paul, I think the easiest option is to use the mysqldump application and select the tables you want, or backup everything and copy everything. I moved the hole schebang from an old computer to another yesterday, including all my old settings, see also the kohadocs pages. Works like a charm. http://www.kohadocs.org/ Maintenance and Troubleshooting Backups and Restoring (English, XML source, HTML, PDF) by Joshua Ferraro > > From: Paul Scaer <pscaer(a)phila.k12.pa.us> > Date: 2006/09/26 Tue AM 10:15:42 EST > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Koha Bulk Imports > > Hi, > Has anyone found a way to bulk import book records in Koha from an > earlier version? We're migrating to version 2.2.5 with MySQL 14.7 and > PERL 5.008007 from version 2.0.0 > Perl version: 5.008003 > MySQL version: 4.0.16-log . > > I've done so much cataloging on the earlier version and don't want to > do the item-by-item import. > > thanks > > Paul Scaer, Librarian > Science Leadership Library > Philadelphia, PA > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

Thanks, Net::Z3950 make error resolved
by Marty Jongepier 26 Sep '06

26 Sep '06

-----Original Message----- From: h lowe [mailto:heidilowe@gmail.com] Sent: Friday, September 22, 2006 10:14 AM To: Marty Jongepier Thanks Heidi, That worked wonderful, also with Net::Z3950 version 0.51 What would I have done without you!? Thanks again, Marty Subject: Re: [Koha] Net::Z3950 make error... Hmm it sounds like y'all are talking about two different things. you are talking about net::z3950, he's talking about net::z3950::zoom. you probably could use zoom, I don't know. But the install document says Net::z3950 so thats what I went with. Your error and set up sounds a lot like one I experienced, so I will tell you in (hopefully specific) steps what I did to make it work. First, I went to the a website (I didn't write down which one, eek. So, lets say I found it on cpan somewhere) and downloaded the net::z3950 module as an archive(tar.gz). I used version 0.50. Then I unpacked it. Then I opened Makefile.PL using a text editor. I don't remember which one. (They always say you should use vi editor, but its so tricky. I never know if its saved or not.) Anyways I commented out the last three lines, like this: sub MY::postamble { '$(MYEXTLIB): yazwrap/Makefile cd yazwrap && $(MAKE) INC=$(PASTHRU_INC) $(PASTHRU)'; } #sub MY::post_constants { # 'PASTHRU_INC=$(INC)' #} Then saved it (if using vi, make sure you press esc and :wq, not :q as I am prone to do :) Then I double checked it, to make sure it saved, and then I was able to install it using perl Makefile.PL make make install and lo and behold I got my z3950 to work. I don't know if that will work for you, especially since I don't understand why I got that error in the first place. But, I figure it can't hurt to try. Good luck and let me know if it works. -Heidi

3 2

Starting z39.50
by Elizabeth Richens 26 Sep '06

26 Sep '06

Hi, This is my first post to the list. I'm impressed by all the work that's gone into Koha, but I now have a problem and can't find the answer in the documentation nor on the mailing list archive. I'm guessing it's my lack of techie knowledge... My library recently installed Koha 2.2.5 on Debian, but I can't get the z39.50 function to work. When I try to Add Biblio as instructed in the Koha 2.2 Users Guide, I get the message "Still ?? records to go" over and over. According to the manual, this means I haven't started the z39.50 daemon. I've tried starting the z39.50 daemon by running the script z3950-daemon-launch.sh from the command line, but it aborts with the error message "line 17: no such file or directory" (apparently it can't find z3950-daemon-options). I noticed that the script z3950-daemon-launch.sh should actually be run during system startup from something called rc.local, but I don't know how to do this. Will the z3950 daemon launch script only work if run from a system startup file? Can anyone tell me what's wrong and what I should look up in my Linux for Dummies book? :-) Elizabeth Richens Buddhist Society Library London, UK ___________________________________________________________ Try the all-new Yahoo! Mail. "The New Version is radically easier to use" The Wall Street Journal http://uk.docs.yahoo.com/nowyoucan.html

2 1