- Koha - lists.katipo.co.nz

Marc Check error?
by Pasi Korkalo 14 Aug '06

14 Aug '06

Why am I seeing: You have 1 error(s) in your MARC configuration. Please fix them before using Koha on the TOTAL row of Marc Check even though all the tests above it show OK?

1 0

Marc check error?
by Pasi Korkalo 14 Aug '06

14 Aug '06

Why Am I seeing "You have 1 error(s) in your MARC configuration. Please fix them before using Koha" in the total row of Marc Check when all the checks listed above it show OK?

1 0

Marc check error?
by Pasi Korkalo 14 Aug '06

14 Aug '06

Why Am I seeing "You have 1 error(s) in your MARC configuration. Please fix them before using Koha" in the total row of Marc Check when all the checks listed above it show OK?

1 0

importing issues into Koha
by Gavin McCullagh 13 Aug '06

13 Aug '06

Hi, in helping a group to migrate from Alice/Oasis to Koha, I've been asked to automatically import the current loans into Koha. I haven't noticed any scripts to achieve this so I'm having a bash at it here in perl. I'm currently figuring out how exactly the data maps between the two systems. I wonder if I could ask one or two questions about the Koha database. I gather the data I need to create is in the "issues" table which looks like this: +-----------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------+------+-----+---------+-------+ | borrowernumber | int(11) | | MUL | 0 | | | itemnumber | int(11) | | MUL | 0 | | | date_due | date | YES | | NULL | | | branchcode | char(4) | YES | | NULL | | | issuingbranch | char(18) | YES | | NULL | | | returndate | date | YES | | NULL | | | lastreneweddate | date | YES | | NULL | | | return | char(4) | YES | | NULL | | | renewals | tinyint(4) | YES | | NULL | | | timestamp | timestamp(14) | YES | | NULL | | +-----------------+---------------+------+-----+---------+-------+ - The borrowernumber and itemnumber obviously relate to the primary keys in items and borrowers. - Do all loans stay in this table indefinitely even after they are returned? ie is this where the loan history is kept? - In terms of the dates, it looks like "date_due" is the current due date (duh!), "returndate" must then be the date the book is returned -- NULL initially, lastreneweddate is the date of last renewal. If this is so, do you store the date the book was first lent or not? Also, do you store the "renew history" of a given loan and where? - Do I guess correctly that there a single entry in this table per loan, not one for the initial loan and one for every renewal? - What exactly goes in the "return" field? - Is "renewals" an integer count of the number of times this particular loan has been renewed? - Should the timestamp be updated every time any record is changed or at record creation? - If I wanted statistics of how many loans/renewals were given out on a given day some time ago, could I do this? It appears not. I've looked over the wiki but i can't find this stuff directly. I'm happy wo wikifi an "issues table" page based on answers so that this info will be more easily available. Same for borrowers which I've already been over. Only if people thing this is a good idea of course. I guess it might complement: http://wiki.koha.org/doku.php?id=en:development:dbschema Many thanks, Gavin

3 5

Q2
by yared berhanu 13 Aug '06

13 Aug '06

Hi everybody, now i'm a littlebit succesfull I installed Koha by downloading the perl modules and by installing koha installer.But i have got the following message #-------------------------------------------------------------------------------------------------- NOTE: You need to add lines to your main httpd.conf to include /etc/koha-httpd.conf #----------------------------------------------------------------------------------------------------------- but my conf file is not httpd.conf rather apache2.conf file. and when i'm trying to configure apache2.conf file by pasting the koha-httpd.conf file inside, the following message appears. #-------------------------------------------------------------------------------------------------- * Forcing reload of apache 2.0 web server... apache2: Could not determine the server's fully qualified domain name, using 127.0.0.1 for Serv erName [Sun Aug 13 11:28:40 2006] [warn] VirtualHost ubuntu:8080 overlaps with VirtualHost ubuntu:8080 , the first has precedence, perhaps you need a NameVirtualHost directive apache2: Could not determine the server's fully qualified domain name, using 127.0.0.1 for Serv erName [Sun Aug 13 11:28:40 2006] [warn] VirtualHost ubuntu:8080 overlaps with VirtualHost ubuntu:8080 , the first has precedence, perhaps you need a NameVirtualHost directive please if you have any suggetions. --------------------------------- Get your email and more, right on the new Yahoo.com

1 0

Using Koha
by library cdac 12 Aug '06

12 Aug '06

I find that the documentation for serials and reports i not yet complete. Can anyone let me know where cud I get a complete documentation on serials and reports module of Koha. --thanks truptee

1 0

Q1?
by yared berhanu 11 Aug '06

11 Aug '06

Hi Everybody, when i'm trying to install Koha i have got the following problem. would you mind to help me please? ERROR: Unable to call script 'yaz-config': is YAZ installed? at Makefile.PL line 12. --------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.

2 1

Internet Explorer and Admin Interface
by Phill Hardstaff 11 Aug '06

11 Aug '06

Hi all, we hit a few snags with Firefox not displaying form fields properly, see this post : >On Wed, Aug 09, 2006 at 03:43:15PM +1100, Eleanor Kleiber said: > Hello everyone, > I am new to the list as I have inherited Koha from my predecessor, so please bear with me. >This will be the first of >> several posts! > >We are working with Koha 2.2.5. >Our biggest problem here at the SPC is that the cursor does not show up >on the right side of the screen. This is on the Admin pages, default theme, English, Catalogue - Catalogue Search - then the 4 fields under Other Options (ie Item Barcode) on the right hand side, in Firefox click in any of them and you will not be able to see the cursor, this won't happen if you are running say 800x600 screen resolution and these boxes are bunched over to the left hand side, you then have a cursor, however these work fine in Internet Explorer, so ... I did a little digging, and I am aware that for the admin Interface that Mozilla is the only approved browser, why I am not sure but anyway, that's how it is. The one big problem with IE and Koha is that is does not work on these pages. Catalogue - Add Biblio - Create Empty Biblio Then anywhere where you have the three little dots that normally open a popup (in Firefox this works) nothing happens in IE, you get a script error saying "invalid argument". So, I am really interested in getting Koha Admin to work with IE here so I took a look at the code. What IE is choking on is the following. This does not work function Dopop(link,i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(link+"&result="+defaultvalue,"value builder",'width=550,height=550,toolbar=false,scrollbars=yes'); This does work function Dopop(link,i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(link+"&result="+defaultvalue,"value_builder",'width=55 0,height=550,toolbar=false,scrollbars=yes'); When "value builder" is "value_builder" IE works fine ? I changed this in the default template files addbiblio.tmpl line 599, additem.tmpl line 121, authorities.tmpl line 162 and things started working in Internet Explorer, I start to get pop-ups on addbiblio etc where it calls javascript:Dopop() Then found I also needed to change the files under /koha/intranet/cgi-bin/value_builder, This is for all the Clic() functions. Take marc21_field_008.pl as an example (as this was one I had to change) before function Clic$function_name(i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(\"../plugin_launcher.pl?plugin_name=marc21_field_008.p l&index=\"+i+\"&result=\"+defaultvalue,\"unimarc field 100\",'width=1000,height=600,toolbar=false,scrollbars=yes'); after function Clic$function_name(i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(\"../plugin_launcher.pl?plugin_name=marc21_field_008.p l&index=\"+i+\"&result=\"+defaultvalue,\"unimarc_field_100\",'width=1000 ,height=600,toolbar=false,scrollbars=yes'); ie if I change \"unimarc field 100\" to \"unimarc_field_100\" it then works fine in IE, why is this ? Is this something that can easily be changed to accommodate IE as most everything else except this works ? It seems most of the admin interface now works for us in IE, and we can see the cursor that we cannot see in Firefox :) Cheers Phill -- Phill Hardstaff MCSA 2003_A+_Network+_Inet+_Server+ Senior Support Engineer Secretariat of the Pacific Community B.P. D5 Noumea Cedex 98848 New Caledonia

1 0

KOha errro Z3950 Search
by Sergio R Poltronieri 09 Aug '06

09 Aug '06

Hello. I am trying search z3950 ,but returns no results. At errorlog apche we get the message DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 169. query=Select id,file,isbn,title,author from marc_breeding where title= isbn= at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167 Who could help me.. Thanks. --

1 0

Z3950 Misbehaviours Fixed
by Mike D. 09 Aug '06

09 Aug '06

Over the past day or two I've been setting up Z39.50 servers on my Koha 2.2.5 running on OpenBSD 3.9 and ran into several issues which I've been able to resolve so I'm posting here in case someone has similar issues. First two pertain to running Koha on *BSD but the other two are more general. Mike D. PROBLEM: attempting to start Z3950 with z3950-daemon-launch.sh results in the following error: # ./z3950-daemon-launch.sh # This account is currently not available. CAUSE: OpenBSD's default Apache configuration is more secure than most. By default the www user has no login shell and normally apache is chrooted to /var/www after it starts. Most cgi scripts require some modification to run in the chroot. I may eventually work on getting Koha running in the chrooted Apache but until then I've just disabled it. SOLUTION: Since the www user has no shell and therefore can't run the z3950 I've created a z3950 user and modified z3950-daemon-options to reflect this. # cat z3950-daemon-options #20060806 - changed RunAsUser from www to z3950 RunAsUser=z3950 KohaZ3950Dir=/var/www/koha/intranet/scripts/z3950daemon KohaModuleDir=/var/www/koha/intranet/modules LogDir=/var/www/koha/log KohaConf=/etc/koha.conf PROBLEM: attempting to start Z3950 with z3950-daemon-launch.sh results in the following error: # ./z3950-daemon-launch.sh # su: no such login class: /var/www/koha/intranet/scripts/z3950daemon/z3950-daemon-shell.sh CAUSE: The syntax for the su command in /koha/intranet/scripts/z3950daemon/z3950- daemon-launch.sh is invalid for OpenBSD and FreeBSD and quite likely NetBSD. For OpenBSD (FreeBSD and NetBSD are similar) the command syntax is: su [-fKLlm] [-a auth-type] [-c login-class] [login [shell arguments]] also the '-' switch has been deprecated in favour of -l SOLUTION: Change the su command in z3950-daemon-launch.sh. So instead of su -c $KohaZ3950Shell - $RunAsUser & change it to the following su -l $RunAsUser -c $KohaZ3950Shell & The -c is actually an argument to the shell in this case which means take a command from argument instead of stdin. It should work with sh, csh, tcsh, ksh, and bash shells. I have filed a bug report on this issue which contains the same information as above. See bug #1141 http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1141 PROBLEM: The following problems MAY only appear when using the NPL template. 1) When using the NPL template Z3950 search results from certain servers may not be present in the pop-up "Z3950 Search Results" even though the log indicates that records were found and retrieved from that server. I specifically had this problem when searching AMICUS. 2) You may get error messages in the z3950 log file like the following: Can't call method "size" on an undefined value at /var/www/koha/intranet/scripts/z3950daemon/processz3950queue line 271. I would get that error when trying to query the Library of Congress server. You will also notice that log file will be missing entries that normally appear. The following lines marked with *** should normally appear but don't. 24369/32 : Processing isbn=0672305410 at LIBRARY OF CONGRESS z3950.loc.gov:7090 Voyager MARC21 (8 forks) 24369/32 : 2 >> 24369/32 : creating and 24369/32 : working on results entry 69 24369/32 : connected to LIBRARY OF CONGRESS ***24369/32 : LIBRARY OF CONGRESS : 1 records found, retrieving them (max 80) ***24369/32 : z3950.loc.gov:7090 search done. 3) If you are accessing multiple Z3950 servers you may notice in the pop- up "Z3950 Search Results" that one or more seem not to respond. The page will infinitely display "Still 1 requests to go" or whatever number of servers are not responding. If you notice this, it's most likely related to the #2 symptom above. The following threads also discuss similar symptoms: 20060306 http://thread.gmane.org/gmane.comp.misc.koha/5696/focus=5696 20051129 http://thread.gmane.org/gmane.comp.misc.koha/5315/focus=5316 20051028 http://thread.gmane.org/gmane.comp.misc.koha/5211/focus=5219 20051026 http://thread.gmane.org/gmane.comp.misc.koha/5201/focus=5201 20051006 http://thread.gmane.org/gmane.comp.misc.koha/5101/focus=5101 20050905 http://thread.gmane.org/gmane.comp.misc.koha/4978/focus=4978 20050103 http://thread.gmane.org/gmane.comp.misc.koha/4152/focus=4152 CAUSE: This is a symptom of bug #1051 http://bugs.koha.org/cgi- bin/bugzilla/show_bug.cgi?id=1051 Basically the MARC flavour option was changed from USMARC to MARC21 but the NPL template wasn't updated. The result is that the remote server isn't informed of your MARC flavour preference. The offending snippets of code are listed below. NPL version of z3950servers.tmpl: <select name="syntax"> <option value="USMARC">USMARC</option> <option value="UNIMARC">UNIMARC</option> </select> DEFAULT version of z3950servers.tmpl: <select name="syntax"> <option value="MARC21">MARC21</option> <option value="UNIMARC">UNIMARC</option> </select> processz3950queue: eval { $conn->option(preferredRecordSyntax => Net::Z3950::RecordSyntax::USMARC);} if ($globalsyntax eq "MARC21"); eval { $conn->option(preferredRecordSyntax => Net::Z3950::RecordSyntax::UNIMARC);} if ($globalsyntax eq "UNIMARC"); Looking at CVS it appears this bug was introduced into processz3950queue on Mar 30 2005. As of Jun 11 2006 MARC21 was switched back to USMARC. SOLUTION: Since the NPL version of z3950servers.tmpl is the odd one out, the easiest thing to do is modify it to be the same as the default version (see code snippets above). It appears the latest code has reverted back to USMARC and you *SHOULD* also be able to change the default template and processz3950queue to mirror those changes. Alternatively, the next time you upgrade to 2.2.6 or later this problem should be resolved (or at least this specific cause will be). PROBLEM: When using NPL and a Z3950 search completes the "Z3950 Search Results" refreshes into an Error 404 when attempting to load the page /cgi- bin/koha/z3950/0/ 20060405 http://article.gmane.org/gmane.comp.misc.koha/5798/match=z3950 20051026 http://article.gmane.org/gmane.comp.misc.koha/5201/match=z3950 20050818 http://article.gmane.org/gmane.comp.misc.koha/4935/match=z3950 my own question on this problem last year :) SOLUTION: Thomas D. has posted a fix a number of times (thanks again) http://article.gmane.org/gmane.comp.misc.koha/5316/match=z3950 http://thread.gmane.org/gmane.comp.misc.koha/4925/focus=4935 but since this has been around since at least version 2.2.3 I've opened a bug report. Bug #1143 http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1143

4 7