- Koha - lists.katipo.co.nz

Koha connection to MSQL - Line 67
by Robert Maynord 29 Aug '05

29 Aug '05

Dear Koha Folks: At our school, we are using Koha version 1.2.3 , with Debian. Recently it was time for me to do the summer upgrades, and I somehow "broke" the Koha server. The Firefox browser loads the first KOHA splash screen, but then gives an error and stops. I am able to access the MYSQL database OK from the command line and from Webmin. It seems that Koha can no longer talk to MYSQL. I checked the error logs and found the following which seems to give a good clue regarding line 67. However, I am not sure where to go from here. Any suggestions would be greatly appreciated......... _My OPAC-error_log says:_ Can't connect to MySQL server on '192.168.0.5' (111) at /usr/local/koha/intranet/modules/C4/Database.pm line 67 _Line 67 says:_ my $dbh=DBI->connect("DBI:mysql:$database:$hostname",$user,$pass); _It also says:_ Can't call method "prepare" on an undefined value at /usr/local/koha/intranet/modules/C4/Output.pm line 183, <KC> line 20. [Mon Aug 29 10:46:27 2005] [error] [client 192.168.0.5] Premature end of script headers: /usr/local/koha/opac/cgi-bin/opac-main.pl Thanks! Robert Maynord _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Fresher
by Baskaran Sankaran 29 Aug '05

29 Aug '05

Hi all, I am a fresher to Koha. I've installed Koha in a linux machine and not able to understand what to do next. I would like to add fer records in it, but I am frantic to see some way how to start it and see it on the screen. Any answers or pointers to where I can find this info? Thanks in advance. Baskaran -- My Blogs: English - http://baskaranshome.blogspot.com/ Tamil - http://baskaransblog.blogspot.com/ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

New document on kohadocs
by Stephen Hedges 29 Aug '05

29 Aug '05

A new link to a document has been added to http://www.kohadocs.org -- "Gestion de la bibliothèque du LabSAD avec le logiciel Koha" by Caroline Naget (available in pdf format only). This document is in the General Information section because it covers several aspects of Koha: installing on Gentoo Linux, setting parameters, and use. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Koha 2.2.3 + basic authentication
by Jared Jennings 28 Aug '05

28 Aug '05

I believe I've uncovered a bug in Koha's handling of basic authentication in 2.2.3. If you log in using sesion ID's and cookies and all this, the checkauth function will sooner or later have a line like: $flags = haspermission($dbh, $userid, $flagsrequired); This will happen before it returns $flags. But in the case of basic authentication, $flags is never assigned anything before it is returned. The result of this is that when I use basic authentication, I can't see any parameters in the parameters page. Nigel Titley <nigel(a)titley.com> was having some problems like this around July 30, 2005. When I applied this change to /usr/local/lib/koha/intranet/modules/Auth.pm, I could see all the parameters on the parameters page that I should be able to see as a superlibrarian. The patch follows. --- Auth.pm.old 2005-08-26 00:35:22.000000000 +0000 +++ Auth.pm 2005-08-26 00:34:34.000000000 +0000 @@ -292,6 +292,7 @@ -value => '', -expires => ''); $loggedin = 1; + $flags = haspermission($dbh, $userid, $flagsrequired); } elsif ($sessionID=$query->cookie('sessionID')) { my ($ip , $lasttime); ($userid, $ip, $lasttime) = $dbh->selectrow_array( _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Help regarding 'items.itemcallnumber' (re-sent message)
by Joseph Coelho SJ 27 Aug '05

27 Aug '05

_I am re-sending this message since I sent it from the wrong email address:_ Hello. I am running Koha 2.2.3 on Windows 98. About 2,800 (out of the over 40,000) books of our library have already been entered into the database. The small hitches have been sorted out and things as of now are going on well. The 'Circulation' part has not yet been used (though it has been tested). However, I have one problem which I am not able to solve. The field 'biblioitems.classification' is mapped to the MARC tag 942 $a (Institution Code) I would like to also store this value in the field 'items.itemcallnumber' for every item of the particular biblio. I could not find any way out and, therefore, now run this script in MySQL after the day's data entry is done: use blank223 update items,biblioitems set items.itemcallnumber=biblioitems.classification where items.biblionumber=biblioitems.biblionumber; quit I tried peeking into the code in additems.pl but could not understand where I can tweak to get any change done. I will be grateful if anyone can tell me what is the code I should include and where. I guess it may just be a line or two. (I am not a Perl programmer!) Thanks in anticipation. Good wishes Joe Coelho, SJ Pune, India. -- Joseph Coelho SJ (KHM) De Nobili College, Nagar Road, Ramwadi Post Box 3007 Pune 411014. INDIA (020) 2703-4401/4737 joecoelhosj(a)jesuits.net joecoelhosj(a)gmail.com -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 8/19/05 _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

New document on kohadocs
by Stephen Hedges 23 Aug '05

23 Aug '05

A new document is available on http://www.kohadocs.org -- "MARC Holdings, Koha, and Migration" by Thomas Dukleth. Look for it in section 2.2, "Migration." -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: itemcallnumber
by Mike D. 22 Aug '05

22 Aug '05

Waylon Robertson <waylon@...> writes: > > > At 06:38 a.m. 20/08/2005, Mike D. wrote: > >Part of my question is what does the itemcallnumber preference setting do > >exactly? I've read the section in the user's guide several times and it's > >still > >not clear to me. > In additem.pl it determines if and where the itemcallnumber field should be > placed, and a cgi list (FIXME, a cgi scrolling list embedded into perl) > displays some kid of list using results of this as a default. Relevant code > follows. > line 205 > # search for itemcallnumber if applicable > if ($tagslib->{$tag}->{$subfield}->{kohafield} eq > 'items.itemcallnumber' && C4::Context->preference('itemcallnumber')) { > my $CNtag = > substr(C4::Context->preference('itemcallnumber'),0,3); > my $CNsubfield = > substr(C4::Context->preference('itemcallnumber'),3,1); > my $temp = $record->field($CNtag); > if ($temp) { > $value = $temp->subfield($CNsubfield); > } > } > then from line 245: > $subfield_data{marc_value}= > CGI::scrolling_list(-name=>'field_value', > -values=> > \ <at> authorised_values, > -default=>"$value", > -labels => > \%authorised_lib, > -size=>1, > -multiple=>0, > ); > > >Is it supposed to give you a default call number from another MARC field? > >Say I > >have item.itemcallnumber linked to 952c now if I set the itemcallnumber > >preference to 050a should it copy the contents of 050a to 952c as a > >default call > >number to edit when adding an item? > >From C:\usr\koha200pre2\scripts\updater\updatedatabase... > (818): variable => 'itemcallnumber', > (822): explanation => 'The MARC field/subfield that is used to > calculate the itemcallnumber (in UNIMARC : 676a for Dewey, 680a for Loc)', > (1341): $dbh->prepare("ALTER TABLE `items` CHANGE `bulk` > `itemcallnumber` VARCHAR( 30 ) DEFAULT NULL"); > (1343): $sti = $dbh->prepare("update marc_subfield_structure set > kohafield=\"items.itemcallnumber\" where kohafield=\"items.bulk\""); > (1532):# adding itemcallnumber entry > > >OR > >Is it used to tell the opac what the callnumber field is? So instead of > >displaying/searching a call number using biblioitems.classification it uses > >952c? This seems somewhat circular to me so I'm think it's the other one. > > > >I think I might be visiting an old topic here but I didn't see any solution to > >the thread in the archives. Regarding the thread "opac call number display > >different in normal & marc views" from 2005-05-15, I am experiencing the same > >issue where item level call numbers show in MARC view but not normal view. I > >know VERY little about perl but I managed to figure out that if I change > >/usr/local/koha/opac/htdocs/opac-tmpl/npl/en/opac-detail.tmpl at line 95 from > ><td></td> > >to > ><td></td> > >it will display the proper item level call number. > > > >Is this a really crude hack and am I likely to break something? I've noticed > >several other areas of the NPL intranet interface where the Call Number is > >inconsistent. Sometimes it uses biblioitems.classification and others it uses > >item.itemnumber. Can these screens be fixed in a similar manner? Is there a > >better way? > > > >Thanks for your time, > >Mike > > > >_______________________________________________ > >Koha mailing list > >Koha@... > >http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > >-- > >No virus found in this incoming message. > >Checked by AVG Anti-Virus. > >Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 18/08/2005 > Thank you both Waylon and Thomas for your replies. Unfortunately I feel I'm almost able to grasp it but just not quite. Sorry if I confuse some terminology like tags and fields but it's due to being a MARC newbie (a PERL newbie as well). From the first code section I believe it's parsing the itemcallnumber preference setting for a MARC tag/subfield, the contents are then assigned to $value. $value is then used to provide a default value for the call number field when adding an item. But this seems to contradict the following sentence in the Users's Guide Ch1: "If you choose to use item call numbers -- ... -- then you must use this preference to tell Koha which subfield in your MARC holding tag contains the entire call number." Following that would lead me to believe the itemcallnumber preference should be set to the same field that item.itemcallnumber is mapped to. (See what I mean by circular?) Ok, I think I may have just grasped the concept. The above excerpt only applies to migrating to Koha and the old system contains the entire call number in some other tag? I'm setting up a completely new system using MARC21 and LOC classification/call numbers. So my call numbers are based on 050a and 050b. Looking at the code it doesn't look like I can specify more than one subfield so my best bet is to use 050a for the itemcallnumber preference? Thomas, when you say "Map 852 $k, 050 $a, 050 $b, and 852 $m concatenated together sequentially to 952 $h for items.itemcallnumber" you are talking about manipulating the MARC records externally to Koha right? I think most of your document is targeted at people migrating to Koha correct? But the "KOHA TEMPLATE CALL NUMBER USE" section did help me. This means I should be able to change the templates in the manner I did below, correct? Thanks, Mike _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha-devel] Borrower photograph in circulation panel
by Waylon Robertson 22 Aug '05

22 Aug '05

Don't know how to change my address for Koha-devel. can't find the panel to do so. can someone do that for me? change it from my old to this one. Anyway.... The following idea I like, and will implement today. waylon At 12:12 a.m. 22/08/2005, you wrote: > > > Is it possible to add a field in the memeber record > > > where we can add picture of the memeber (in gif, jpg or png > > > format)? > >As I recall this functionality was developed by one library, but the >improvements have not been incorporated into the official Koha. I'm not >sure what they added to accomplish this, but there's an easy way to achieve >it without any changes to the code. > >If you named your image files according to borrower number and uploaded >them manually, a simple change to the template could add the member image: > ><img src="/images/.jpg" /> > >Does anyone know what other features the Argentinians' code offered? >Integrated file upload would be the most important thing, I'd imagine. > > -- Owen > > >------------------------------------------------------- >SF.Net email is Sponsored by the Better Software Conference & EXPO >September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices >Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA >Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf >_______________________________________________ >Koha-devel mailing list >Koha-devel(a)lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/koha-devel > > >-- >No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 19/08/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 19/08/2005 Send instant messages to your online friends http://au.messenger.yahoo.com _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

user's guide request; itemcallnumber
by kim＠secondhandknowledge.net 20 Aug '05

20 Aug '05

Hi, thanks for the updates to the Koha 2.2 User's Guide document. It is very helpful and I appreciate the time you've put into it. Is it possible to get a copy of the whole thing as one document or PDF? I want to print it out and read it and refer to it, rather than read it on screen (and I want to avoid printing out each chapter individually...) Another matter, regarding Mike D's fix to NPL template regarding itemcallnumbers (changing line 95 of opac-detail.tmpl), I too want to know if it is safe to make that change or will it break something? Thanks much! (oh, and I would also like to hear comments from the developers about what's happening with the dropped subfields in subject headings issue...) Kim Scannell _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

itemcallnumber
by Mike D. 19 Aug '05

19 Aug '05

Part of my question is what does the itemcallnumber preference setting do exactly? I've read the section in the user's guide several times and it's still not clear to me. Is it supposed to give you a default call number from another MARC field? Say I have item.itemcallnumber linked to 952c now if I set the itemcallnumber preference to 050a should it copy the contents of 050a to 952c as a default call number to edit when adding an item? OR Is it used to tell the opac what the callnumber field is? So instead of displaying/searching a call number using biblioitems.classification it uses 952c? This seems somewhat circular to me so I'm think it's the other one. I think I might be visiting an old topic here but I didn't see any solution to the thread in the archives. Regarding the thread "opac call number display different in normal & marc views" from 2005-05-15, I am experiencing the same issue where item level call numbers show in MARC view but not normal view. I know VERY little about perl but I managed to figure out that if I change /usr/local/koha/opac/htdocs/opac-tmpl/npl/en/opac-detail.tmpl at line 95 from <td></td> to <td></td> it will display the proper item level call number. Is this a really crude hack and am I likely to break something? I've noticed several other areas of the NPL intranet interface where the Call Number is inconsistent. Sometimes it uses biblioitems.classification and others it uses item.itemnumber. Can these screens be fixed in a similar manner? Is there a better way? Thanks for your time, Mike _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0