- Koha - lists.katipo.co.nz

Installing Koha
by alex 03 Aug '06

03 Aug '06

Hi there. I am attempting to install Koha on a Debian Testing (Etch) system. I downloaded koha-2.2.5.tar.gz I have loosely followed http://www.kohadocs.org/Installing_Koha_on_Debian_sarge.html, however, I tried to satisfy all dependancies using debian packages. I have mysql server version 5 installed, as well as the following debian packages: ii libhtml-tree-perl 3.19.01-2 ii liblocale-gettext-perl 1.05-1 ii libmail-sendmail-perl 0.79-4 ii libmarc-charset-perl 0.95-1 ii libmarc-perl 1.07-4 ii libmarc-record-perl 1.38-3 ii libnet-daemon-perl 0.38-1 ii libnet-ldap-perl 0.33-2 ii libnet-z3950-perl 0.51-1 ii libperl5.8 5.8.8-4 ii libplrpc-perl 0.2017-1 ii libtext-charwidth-perl 0.04-3 ii libtext-iconv-perl 1.4-2 ii libtext-wrapi18n-perl 0.06-4 ii liburi-perl 1.35-2 ii libwww-perl 5.805-1 ii libxml-namespacesupport-perl 1.09-2 ii libxml-sax-perl 0.12-5 ii perl 5.8.8-4 ii perl-base 5.8.8-4 ii perl-modules 5.8.8-4 The installer ran through without requesting I load any modules from CPAN. The installer ran right through to the end, but there were messages during installation that may have indicated database errors. (I didn't record them) I tried to load in as much "default" data and messages as I could (eg. "stop" words etc.) Now the system seems to be partially working. The admin (intranet?) interface seems to work (superficially at least), but the opac interface gives an error (500 Internal Server Error). The error.log is uninformative ([Thu Aug 03 10:01:24 2006] [error] [client 192.168.2.1] Premature end of script headers: opac-main.pl) Running the cgi-script from the command line gives me: PERL5LIB="/usr/local/koha/intranet/modules" /usr/local/koha/opac/cgi-bin/opac-main.pl DBD::mysql::st execute failed: Table 'Koha.itemtypes' doesn't exist at /usr/local/koha/opac/cgi-bin/opac-main.pl line 17. DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/local/koha/opac/cgi-bin/opac-main.pl line 20. DBD::mysql::db selectrow_array failed: Table 'Koha.systempreferences' doesn't exist at /usr/local/koha/intranet/modules/C4/Context.pm line 366. DBD::mysql::db selectrow_array failed: Table 'Koha.systempreferences' doesn't exist at /usr/local/koha/intranet/modules/C4/Context.pm line 366. DBD::mysql::db selectrow_array failed: Table 'Koha.systempreferences' doesn't exist at /usr/local/koha/intranet/modules/C4/Context.pm line 366. HTML::Template->new() : Cannot open included file /usr/local/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl : file not found. at /usr/share/perl5/HTML/Template.pm line 1632 HTML::Template::_init_template('HTML::Template=HASH(0x824f7cc)') called at /usr/share/perl5/HTML/Template.pm line 1205 HTML::Template::_init('HTML::Template=HASH(0x824f7cc)') called at /usr/share/perl5/HTML/Template.pm line 1099 HTML::Template::new('HTML::Template', 'filename', '/usr/local/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl', 'die_on_bad_params', 0, 'global_vars', 1, 'path', 'ARRAY(0x8a65fb4)', ...) called at /usr/local/koha/intranet/modules/C4/Output.pm line 77 C4::Output::gettemplate('opac-main.tmpl', 'opac', 'CGI=HASH(0x8151d54)') called at /usr/local/koha/intranet/modules/C4/Auth.pm line 114 C4::Auth::get_template_and_user('HASH(0x8a3c10c)') called at /usr/local/koha/opac/cgi-bin/opac-main.pl line 32 Just looking at the first error, there is indeed no itemtypes table in the database. The database tables are currently as follows: Database: Koha +-------------------------+ | Tables | +-------------------------+ | accountlines | | accountoffsets | | additionalauthors | | aqbasket | | aqbookfund | | aqbooksellers | | aqbudget | | aqorderbreakdown | | aqorderdelivery | | aqorders | | auth_header | | auth_subfield_structure | | auth_subfield_table | | auth_tag_structure | | auth_types | | auth_word | | authorised_values | | biblio | | biblio_framework | | biblioanalysis | | biblioitems | | bibliosubject | | bibliosubtitle | | bibliothesaurus | | bookshelf | | borexp | | borrowers | | branchcategories | | branches | | branchrelations | | branchtransfers | | catalogueentry | | categories | | currency | | deletedbiblio | | deletedbiblioitems | | deletedborrowers | | deleteditems | | ethnicity | | marc_biblio | | marc_blob_subfield | | marc_breeding | | marc_subfield_structure | | marc_subfield_table | | marc_tag_structure | | marc_word | | marcrecorddone | | serial | | sessionqueries | | sessions | | shelfcontents | | subscription | | subscriptionhistory | | suggestions | | uploadedmarc | | userflags | | websites | | z3950queue | | z3950results | | z3950servers | +-------------------------+ I am not sure if I have a complete initial database structure and just need to do some more setup through the admin interface (eg. add some item types), or if I only have a partial and defective db structure. I will probably play with what I have for a while, but I will probably delete the install and try again taking more note of messages during the install. Specifically, if I reinstall, should I downgrade mysql server to version 4.1 (which is also in etch?) Do I need any updated or additional modules from CPAN or elsewhere? (The sarge install docs mentioned I should get MARC:Record from sourceforge and install manually) Obviously, it would be better from my point of view if I could get all dependencies within Debian. Cheers, Alex king

2 2

Re: [Koha] Changing language / Spanish Support
by Adalid Ortiz 03 Aug '06

03 Aug '06

Aqui esta: http://koha.unlp.edu.ar/ LIC. FELIPE ADALID ORTIZ ANZALDO Area de Medios Electrónicos Biblioteca Loyola http://www.loyola.tij.uia.mx UNIVERSIDAD IBEROAMERICANA TIJUANA Ave. Centro Universitario 2501 Playas de Tijuana Tijuana, B.C., México 22200 Tel. 664 630-1577 Ext. 623 Fax 664 630-1591 eMail adalid(a)tij.uia.mx "No sobreviven los más fuertes, ni los más inteligentes, sino aquellos que tienen una mayor capacidad para adaptarse a los cambios." --Charles Darwin--> >Subject: [Koha] Changing language / Spanish Support > From: Jorge Tena <j.tena(a)copysolutionsint.com> > Date: Wed, 2 Aug 2006 07:16:55 -0700 (PDT) > To: koha(a)lists.katipo.co.nz > >--===============1872649526== >Content-Type: multipart/related; boundary="0-486607643-1154528215=:17345" >Content-Transfer-Encoding: 8bit > >--0-486607643-1154528215=:17345 >Content-Type: multipart/alternative; boundary="0-275445419-1154528215=:17345" > >--0-275445419-1154528215=:17345 >Content-Type: text/plain; charset=iso-8859-1 >Content-Transfer-Encoding: 8bit > >Hello everyone, > > How can I add spanish support to a english Koha installation? > > I choose not to use es as the default langue as I found some errors post installed. > > Best regards, > > > >Jorge Tena >Analista de Proyectos Corporativos >Copy Solutions International > >T. 809-689-9777 >F. 809-689-9850 >E. j.tena(a)copysolutionsint.com > >--0-275445419-1154528215=:17345 >Content-Type: text/html; charset=iso-8859-1 >Content-Transfer-Encoding: 8bit > >Hello everyone, How can I add spanish support to a english Koha installation? I choose not to use es as the default langue as I found some errors post installed. Best regards, Jorge Tena Analista de Proyectos Corporativos Copy Solutions International T. 809-689-9777 F. 809-689-9850 E. j.tena(a)copysolutionsint.com >--0-275445419-1154528215=:17345-- >--0-486607643-1154528215=:17345-- > >--===============1872649526== >Content-Type: text/plain; charset="us-ascii" >MIME-Version: 1.0 >Content-Transfer-Encoding: 7bit >Content-Disposition: inline > >_______________________________________________ >Koha mailing list >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha > >--===============1872649526==--

2 1

Itemtype problem
by Sandra Turner 03 Aug '06

03 Aug '06

Hi We are having a problem with our item types. From what I can see the item types information is stored in biblioitems.itemtypes. Our items types are long term, short term, Reference and audio visual. This information is stored in 995Z in our export from our current system (Alice/Oasis). The item type is linked to each individual item along with its barcode, location etc. We have all of our tab 10 items in 995. We cannot get Koha to recognise this as an item type as it is in the items table as opposed to the biblioitems table. It needs to be in 952b as far as we can figure out. If we define is as being biblioitems.itemtype then it can't be in tab 10 or 995. What can we do to fix it? We have send the borrowing rules but nothing can be lent until koha can recognise the item type! Please help. Many thanks Sandra Turner The Library Griffith College Dublin South Circular Road Dublin 8 Tel : +353 (0)1 4150490/1 Fax: +353 (0)1 4549595 Web: <http://www.gcd.ie/> <http://www.gcd.ie/library> www.gcd.ie/library Email: <mailto:sandra.turner@gcd.ie> sandra.turner(a)gcd.ie

1 0

Post Installation Error
by Jorge Tena 02 Aug '06

02 Aug '06

Hi Koha Developers, I'm looking for support regarding an issue I'm facing right after I install Koha on my FC4 web server. The first time I try to browse the system just after finishing a new, clean installation I get this Internal Server Error that doesnt allow me to browse the system. If I look into the opac error log I find the following error messages: [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] File does not exist: /usr/local/koha/opac/htdocs/favicon.ico [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] HTML::Template->new() : Cannot open included file /usr/local/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl : file not found. at /usr/lib/perl5/site_perl/5.8.6/HTML/Template.pm line 1632 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tHTML::Template::_init_template('HTML::Template=HASH(0x9d05a38)') called at /usr/lib/perl5/site_perl/5.8.6/HTML/Template.pm line 1205 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tHTML::Template::_init('HTML::Template=HASH(0x9d05a38)') called at /usr/lib/perl5/site_perl/5.8.6/HTML/Template.pm line 1099 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tHTML::Template::new('HTML::Template', 'filename', '/usr/local/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl', 'die_on_bad_params', 0, 'global_vars', 1, 'path', 'ARRAY(0xa63dabc)', ...) called at /usr/local/koha/intranet/modules/C4/Output.pm line 77 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tC4::Output::gettemplate('opac-main.tmpl', 'opac', 'CGI=HASH(0x9cf7cd4)') called at /usr/local/koha/intranet/modules/C4/Auth.pm line 114 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tC4::Auth::get_template_and_user('HASH(0xa64ffd0)') called at /usr/local/koha/opac/cgi-bin/opac-main.pl line 32 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] Premature end of script headers: opac-main.pl [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] File does not exist: /usr/local/koha/opac/htdocs/favicon.ico Any help around this subjetc!? __ Jorge Tena Analista de Proyectos Corporativos Copy Solutions International T. 809-689-9777 ext. 242 F. 809-689-9850 M. 809-440-8697 E. j.tena(a)copysolutionsint.com

2 3

koha 2.2.6RC2 is ...
by Paul POULAIN 02 Aug '06

02 Aug '06

... available for download at : http://download.savannah.nongnu.org/releases/koha/ WARNING : this is a Release Candidate, so, if you decide to install it, you must know that : - some bugs may remain - you MUST backup your database before updating - you must know how to roll-back to previous version if things goes wrong. Otherwise, don't install it and wait for official 2.2.6 ! Release notes : *************************************** RELEASE NOTES ============= Koha is the first Open-Source Integrated Library System. Released in New Zealand, in January 2000, it is maintained by a team of volunteers from around the globe. The Koha system is a full catalogue, opac, circulation and acquisitions system. Koha 2.2.6 is more than 247 000 lines of code, developed by more than 30 differents developers (and even more translators). With the 2.2.6 version, Koha is now a mature product, with a lot of nice features. It's used in more than 100 libraries, of all kinds (public, schools, religious...), of different sizes (from 1 to 8 branches, from 1000 to 300 000 items). ======== WARNINGS ======== * The librarian interface is tested only with Mozilla/Firefox. Should work (partially) with IE. OPAC should work fine with any browser. * In this release, french & english are uptodate. Other language po files are provided in the package. If you update/complete one of them, please send it to paul.poulain @ free.fr, it will be included in a 2.2.6b release ! * NEW PACKAGES REQUIRED : - Class::Accessor (0.25) - XML::SAX (0.14) - MARC::File::XML (0.83), - MARC::Charset (0.95), - LWP::Simple - XML::Simple KNOWN BUGS ********** Critical/blocking : none see bugs.koha.org for more information. Please report any problem in bugs.koha.org Apple users : it seems there is an annoying bug in Firefox, that you can have in librarian biblio search: only the first MARC field list is available and the others can't be opened. The problem is described and fixed at http://www.macfixit.com/article.php?story=20051226091140372 ======= CHANGES ======= Changes 2.2.5 => 2.2.6 ********************** DB CHANGES ********** DB structure : dewey field has been moved to a char(30) DB content : many many new systempreferences Koha opac stylesheets : none BUGFIXES === CATALOGUING === * result page display was incorrect when searching a biblio before adding a new one. * no more saving of an empty field in the DB * Fix for splitting up fixed fields containing | in them causing incorrect storage of fixed fields in Koha DB. * An item that is on loan can't be deleted anymore. === CIRCULATION === * minor bugfix : Adding 0 before days and months in order to make date comparison work. === PARAMETERS === * adding page facility in book funds. IMPROVEMENTS Almost nothing has changed in the DB, so the stability should be good. But you are warned that some/few bugs may occur. Please READ the release notes. Everything is compatible with previous versions, so, if you just install Koha, you should have the same behaviour as previously, but you will miss many interesting features! === ACQUISITION === * added a (crontab) script : check_suggestion.pl, that send a mail to the librarian when a suggestion is pending * *MAJOR IMPROVEMENT* : - online help has been added - the order.pl page doesn't show baskets closed for more than 6 months anymore. - when recieving an order, you now see the list of existing parcels. The parcel code used to be the "Supplier invoice information". Now when you go to the reciept page, you see all previous recieves, and can create a new parcel, exactly as before. This does not require any change in Koha internals, but we hope it's clearer than before. - when recieving an order in a parcel, you now see all orders still waiting for a receipt. Thus, you can enter isbn/title as previously, or directly click on a title in the list. We worked hard on those new acquisition screens, and hope that you'll find it easier to use than before. === AUTHORITIES === * if the library doesn't define a summary for an authority, a standard/default one will be built automatically. * if the librarian set * as subfield, all subfields will be shown, without any separator, but respecting the order. Previously, you had to define every subfield, causing problems in case of reordered subfields. === CIRCULATION=== * added a (crontab) script : overduenoticesSelect.pl, that can be used as replacement for the overduenotice script. This one has many more parameters, including a filter on branches and an external letter (to avoid the need to modify the script on each release) * merged today & previous issues list during issuing. Added a button to renew issues & return issues in 1 click === CATALOGUE === * highly improved MARC21 default framework * new systempref "sortbynonfiling". If you catalogue with complete MARC (including indicators), you can set this pref to Yes. It will remove non filing chars and order "The King Henry IV" to letter "K". This systempref is USELESS for UNIMARC (as UNIMARC doesn't manage non-filing chars in an indicator, unlike MARC21) === CATALOGUING === * added a (crontab) script : delete_authority.pl, that deletes all entries of an authority in a biblio. * *MAJOR IMPROVEMENT* in MARC editing : - duplicating a field (+ on the tag) does not require a server call anymore : it's much faster. - duplicating a subfield is no longer done with a pipe (|), but by clicking on the + facing the subfield - the "hidden" property of the framework now has 19 possible values. Look in the online help to see them. The immediate interesting value is -1, which means the subfield is minimized on the MARC editor and you must click on it to expand it. Rarely used fields/subfields are easier to manage. - a advancedMARCeditor systempref has been added. If set, tag/subfield values are not shown, except when putting the mouse on the tag/subfield. This systempref is only for "MARC addicts"! * MARC21 : many plugins have been added (by joshua). It seems you now have as many plugins for fixed length fields in MARC21 as in UNIMARC! Note that plugins help you filling a tag/subfield in the MARC editor. === MEMBERS === * patron images management. A new systempreference has been added (patronimages, in borrowers section). If set (to an image extension, like jpg or gif), the image will be shown on patron detail or circulation page. The images must be stored in KOHADIR/htdocs/intranet-tmpl/patronimages/ . The image must be named <borrowernumber>.<patronimagessystempref> (1.jpg for example, for borrower #1) === OPAC === Many preferences have been added to OPAC. Read them carefully, as you will be able to modify highly the look and behaviour of your OPAC! * new default stylesheet for css (purple on white). A new stylesheet (contributed by liblime.com) has been added to show everybody the changes in OPAC. If you want to stay with the old one (dark/light green), just reach Koha >> Parameters >> Systempreferences >> OPAC >> opacstylesheet > modify > /opac-tmpl/default/opac_old.css * Amazon content : if the new AmazonContent systempref is set AND an AmazonDevKey/AmazoneDevTag (available on www.amazon.com) is entered in systempreferences AND XML::Simple package is installed, OPAC will show amazon cover pages when available. Note that this feature may not be legal everywhere. For example, it seems it may not be legal in France (you must ask each editor for permission) * new systempref : opaccredit. If something (including html) is stored there, the footer of OPAC pages will contain what is there (instead of the "Library powered by Koha..." that is on css default templates) * new systempref : opacnav. In this preference, you can put any html that will be added to your menu. For example, to add a button to reach the koha website : <a class="menu" href="http://www.koha.org" title="Koha world website">Koha</a> * new systempref : opacbookbag : if set to 0, the basket/book bag features will be hidden in OPAC (even for logged in users). * authorities heading search : a new menu has been added so the user can search in authorities (same behaviour as in intranet) * new systempref : opaclanguagesdisplay. If set to "yes" (default value), the list of available language is shown. Otherwise, there is no list, koha will stay in default language only. * new systempref : opacreadinghistory. If set to "yes" (default value), the reading history will be available on OPAC (for logged in users). If set to "no", the reading history never appears. * Recent Acquisition : added a new page to filter recent acquisitions on a given branch. * if you use npl templates, you can have an alternate stylesheet (to set it, go to librarian interface >> Parameters > Systempreferences > OPAC > opacstylesheet > modify > /opac-tmpl/npl/en/includes/opac.liblime.css) * when there is more than 1 item at a given location (branch/callnumber/location), the list shows the number of items, not 1 line for each (same) value. === REPORTS === * Inventory : you can now scan in a text file, on an unconnected laptop, with every book in your library. Then, just upload the file in Koha. It will "mark as seen" all books. Once you've scanned everything in your library, just query for all books not seen since the beginning of the inventory, and you'll get "lost" books. === SERIALS === * MAJOR IMPROVEMENT : Adding item creation on the fly when receiving serial : if you activate systempref > Catalogue > serialsadditems, you'll have a form to create an item on the fly at the end of the serial receipt form. The item contains the callnumber, the branch, the barcode and the location (where applicable). Go to the catalogue after setting a serial to "arrived", and you should see the item created. If you let serialsadditems to OFF, behaviour is unchanged from previous releases. * the last 5 arrived serials are shown when receiving serials. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

1 0

Re: Re: [Koha] Z39.50
by Steven F.Baljkas 02 Aug '06

02 Aug '06

Wednesday, August 2, 2006 01:11 CDT Hi, Lalitanand, Just one other thing I think Stephen Hedges missed mentioning, just in case someone else hasn't told you already ... *** When entering ISBNs for searches, you do NOT want to include the hyphens. ISBNs are encoded hyphenless in the 020 field. *** Some systems seem to be able to cope with hyphens being included in search strings, but LC, in my experience, definitely does not. Probably won't matter in the specific case of the book you are referencing since no similar ISBN seems to occur in any of the probable match records in LC. HTH. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: "lalitanand dandge" <dandgelb(a)gmail.com> Date: 2006/08/01 Tue PM 11:37:28 CDT To: "Stephen Hedges" <st.hedges(a)gmail.com> CC: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Z39.50 Hi thanks.. I started Z3950 daemon, and i am using, mysql Ver 14.7 Distrib 4.1.15, for pc-linux-gnu (i386) using readline 4.3 thanks and regards, Lalitanand. On 8/1/06, Stephen Hedges <st.hedges(a)gmail.com> wrote: > > I'm guessing that: > 1) you have not started the Z3950 daemon > 2) you are using MySQL 5 > > Stephen > > On 8/1/06, lalitanand dandge <dandgelb(a)gmail.com> wrote: > > Hi > > I installed Koha2.2.5 on my debian system. > > I want to import the marc tags from the Library of Congress or other > z39.50 > > server, > > I added the Z3950 server: the entries I added are: > > hostname: z3950.loc.gov > > Port No: 7090 > > and Database name: voyager > > but the problem i am facing is: > > when i do search on particular ISBN no. like 0-07-049543 (Java Complete > > Reference) > > then the result i get is: Nothing found: > > (the url shows > > " > http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&isbn=0-07-049543 > " > > and then changes to " > > > http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&random=249094171.… > ") > > please tell me how to configure and check my koha system with z3950 > support. > > > > another problem I am getting is, > > when i search for patrons it gives the list of members page > > "http://localhost:8080/cgi-bin/koha/members/member.pl " > > then after clicking issue: i get > > "http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1" > > page > > there is link "details" of the borrower, i get > > " > http://localhost:8080/cgi-bin/koha/members/moremember.pl?borrowernumber=1 > > " > > this page, but the borrower details fields are blank (it does not show > name > > and other things) > > the error i get while doing these steps in the koha-error_log is > > > > [Tue Aug 01 12:38:42 2006] [error] [client localhost] 2007-07-19 at > > /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line > > 127., referer: > > http://202.141.152.81:8080/cgi-bin/koha/members/member.pl > > > > [Tue Aug 01 12:39:02 2006] [error] [client localhost] 2007-07-19 at > > /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line > > 127., referer: > > http://202.141.152.81:8080/cgi-bin/koha/members/member.pl > > > > [Tue Aug 01 12:40:56 2006] [error] [client localhost] 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 > > 'and reserves.borrowernumber = borrowers.borrowernumber, referer: > > http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1 > > > > [Tue Aug 01 12:40:56 2006] [error] [client localhost] \t\t\t\t\tand > > reserves.biblio' at line 2 at > > /usr/local/koha/intranet/modules/C4/Reserves2.pm line 147., > > referer: > > > http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1 > > > > [Tue Aug 01 12:40:56 2006] [error] [client localhost] DBD::mysql::st > > fetchrow_hashref failed: fetch() without execute() at > > /usr/local/koha/intranet/modules/C4/Reserves2.pm line 149., > > referer: > > > http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1 > > > > So please help me in this regard, > > How to configure my koha system to enable the marc record search using > z3950 > > and how to get the above mentioned errors sorted out. > > > > thanks > > > > lalitanand. > > > > > > > > -- > > "Talk is cheap. Show me the code. Think Open, use Open Source!" > > Visit & Register at http://www.ossrc.org.in > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > -- "Talk is cheap. Show me the code. Think Open, use Open Source!" Visit & Register at http://www.ossrc.org.in ============================================================ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Z39.50
by lalitanand dandge 02 Aug '06

02 Aug '06

Hi I installed Koha2.2.5 on my debian system. I want to import the marc tags from the Library of Congress or other z39.50server, I added the Z3950 server: the entries I added are: hostname: z3950.loc.gov Port No: 7090 and Database name: voyager but the problem i am facing is: when i do search on particular ISBN no. like 0-07-049543 (Java Complete Reference) then the result i get is: Nothing found: (the url shows " http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&isbn=0-07-049543" and then changes to " http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&random=249094171.… ") please tell me how to configure and check my koha system with z3950 support. another problem I am getting is, when i search for patrons it gives the list of members page " http://localhost:8080/cgi-bin/koha/members/member.pl" then after clicking issue: i get " http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1" page there is link "details" of the borrower, i get " http://localhost:8080/cgi-bin/koha/members/moremember.pl?borrowernumber=1" this page, but the borrower details fields are blank (it does not show name and other things) the error i get while doing these steps in the koha-error_log is [Tue Aug 01 12:38:42 2006] [error] [client localhost] 2007-07-19 at /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line 127., referer: http://202.141.152.81:8080/cgi-bin/koha/members/member.pl [Tue Aug 01 12:39:02 2006] [error] [client localhost] 2007-07-19 at /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line 127., referer: http://202.141.152.81:8080/cgi-bin/koha/members/member.pl [Tue Aug 01 12:40:56 2006] [error] [client localhost] 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 'and reserves.borrowernumber = borrowers.borrowernumber, referer: http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1 [Tue Aug 01 12:40:56 2006] [error] [client localhost] \t\t\t\t\tand reserves.biblio' at line 2 at /usr/local/koha/intranet/modules/C4/Reserves2.pm line 147., referer: http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1 [Tue Aug 01 12:40:56 2006] [error] [client localhost] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Reserves2.pm line 149., referer: http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1 So please help me in this regard, How to configure my koha system to enable the marc record search using z3950 and how to get the above mentioned errors sorted out. thanks lalitanand. -- "Talk is cheap. Show me the code. Think Open, use Open Source!" Visit & Register at http://www.ossrc.org.in

2 2

from Windows to Linux system
by Lewis Satini 01 Aug '06

01 Aug '06

I am now planning to move to current KOHA system to Linux system, what I should do? how can I install Koha Linux system remotely? thanks _________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

1 0

Asian language search
by Lewis Satini 01 Aug '06

01 Aug '06

when I try to search using the asian character, i can't find the book, but when i search through the ISBN and it shows the books in the asian character, I need help on this to fix the search problem thanks _________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

1 0

Item Number field
by Robert McKenna 01 Aug '06

01 Aug '06

Hi, we're mapping the marc data (from a UKMarc export from Alice/Oasis) for our Koha install and the Items.Itemnumber causes an error unless it is set to tab -1. That is unless it is ignored and not managed by Koha. We need the item number to be information associated with an item, or some other way of doing an item count. What are we doing wrong? Robert McKenna Librarian Griffith College Dublin South Circular Road Dublin 8 Ireland 353 1 4150490

2 1