- Koha - lists.katipo.co.nz

Problems while displaying search results
by Abdrahamane ANNE 11 Oct '06

11 Oct '06

Hello, I have just installed Koha 2.2.5 on linux ubuntu Dapper Drake with mysql 5.0.22. After adding some records, I noticed that search results do not display correctly. Some fields (title, ISBN, ...) are not displayed. After some digging around, I discovered that some SQL queries contained in C::Search and C::SearchMarc modules cannot be executed correctly using mysqlclient. I have made some corrections : * C4::Search (/usr/local/koha/intranet/modules/C/Search.pm), line 1493 : I replaced the query : Select *, biblioitems.notes AS bnotes, biblio.notes from biblio, biblioitems left join bibliosubtitle on biblio.biblionumber = bibliosubtitle.biblionumber left join itemtypes on biblioitems.itemtype=itemtypes.itemtype where biblio.biblionumber = ? and biblioitems.biblionumber = biblio.biblionumber by : Select *, biblioitems.notes AS bnotes, biblio.notes from biblio JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber left join bibliosubtitle on biblio.biblionumber = bibliosubtitle.biblionumber left join itemtypes on biblioitems.itemtype=itemtypes.itemtype where biblio.biblionumber = ? and biblioitems.biblionumber = biblio.biblionumber * C4::SearchMarch (/usr/local/koha/intranet/modules/C/SearchMarc.pm), line 343 : I replaced the query : SELECT biblio.biblionumber as bn,biblioitems.*,biblio.*, marc_biblio.bibid,itemtypes.notforloan,itemtypes.description FROM biblio, marc_biblio LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype WHERE biblio.biblionumber = marc_biblio.biblionumber AND bibid = ? by : SELECT biblio.biblionumber as bn,biblioitems.*,biblio.*, marc_biblio.bibid,itemtypes.notforloan,itemtypes.description FROM biblio JOIN marc_biblio ON biblio.biblionumber=marc_biblio.biblionumber LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype WHERE biblio.biblionumber = marc_biblio.biblionumber AND bibid = ? The problem seems to be at FROM .. line. After modification results display correctly. I wonder, if any body else encountred such problems and if these are bugs. ANNE A.

1 0

Is anyone using Koha in S Africa?
by Meryl Federl 10 Oct '06

10 Oct '06

Please contact me. regards Meryl Federl Johannesburg South Africa Meryl Federl w - 332 8112 (011) h - 487 3872 (011) ___________________________________________________________ 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

1 0

Help - msgmerge
by Sushil Rapatwar 10 Oct '06

10 Oct '06

Hello Techies Do you have a dos (Windows) equivalent of *'msgmerge'*? When I run *'tmpl_process3.tmpl create*' command it gives me the following error *'msgmerge' is not recognized as an internal or external command, operable program or batch file.* ** Any inputs in this direction will be greatly appreciated Thanks Sushil

1 0

Missing Koha-tmpl directory
by Sushil Rapatwar 10 Oct '06

10 Oct '06

In order to do the translation I have referred to the documentation that was available. It asks 1. Create your translation file (assuming your current directory is this directory, i.e., misc/translator): ./tmpl_process3.pl create -i ../../koha-tmpl/opac-tmpl/default/en/ -s po/css_opac_fr_FR.po -r However, I have found that *I do not have koha-tmpl directory* at all and all its subcontents. The only directories that I have under c:\usr\koha224\scripts are '*misc'*, *'updater' *and '*z3950daemon*' Can anyone please suggest where can I find the directories that go into it esp. the '*koha-tmpl*' ? Many Thanks -- Sushil +44 (0)795 1923 478

2 3

KOHA versión en español !!!
by Adalid Ortiz 09 Oct '06

09 Oct '06

Disponible la versión en español de Koha por la UNLP basada en la 2.x 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--

1 0

Re: [Koha] Web hosting Koha - Questions
by Venita Glasfurd 09 Oct '06

09 Oct '06

Hi MJ Ray/All, Thanks for your response to my mail. As mentioned earlier, I have to set up a koha on shared server, but i can't have koha installed. The Koha install image is going to be copied to the server. Hence I need to set up all the perl dependencies ahead of time. How can i do this?. Is there a pre-packaged set of perl packages for koha that can be given to the web hosting service providers? Please let me know. Thanks, Venita. Message: 2 > Date: Fri, 06 Oct 2006 16:05:58 +0100 > From: MJ Ray <mjr(a)phonecoop.coop> > Subject: Re: [Koha] Web hosting Koha - Questions > To: koha(a)lists.katipo.co.nz > Message-ID: <452670d6.Wokje+XpT9SQr+ku%mjr(a)phonecoop.coop> > Content-Type: text/plain; charset=us-ascii > > Venita Glasfurd wrote: > > 1. since I will not get root access to the web server, how can I install > the > > software. Obviously, a simple copy or unzip will not work. > > A simple copy should work. > > > 2. If I go with Linux, do I need to ask for special support when it > comes to > > installing the perl modules for Koha? > > Probably. As a bare minimum, you will need installer access to install > and/or compile libyaz and Net::Z3950. > > > 3. Has anyone hosted koha on a shared server? If so, please mail me. I > would > > like to get more inputs on this. > > I have. > > Hope that helps, > -- > MJ Ray - see/vidu http://mjr.towers.org.uk/email.html > Somerset, England. Work/Laborejo: http://www.ttllp.co.uk/ > IRC/Jabber/SIP: on request/peteble >

1 0

Call Number not displayed after upgrade to 2.2.6
by Scott Leafe 07 Oct '06

07 Oct '06

After upgrading to v2.2.6, I notice that in the biblio simple/normal display, the call number is no longer displayed. This also occurs when a search result is displayed. Seems as though this info was previously pulled from MARC at 942(k). Am I missing some new mapping or something here?

1 1

Resetting Marc structure & Marc/Koha links
by Aren Olson 07 Oct '06

07 Oct '06

Is there an easy way to reset koha's Marc structure and the Marc -> Koha links to the default? Thanks, Aren -- "Whoever said sunshine brings happiness has never danced in the rain." - K. Jackson Ubuntu Linux - www.ubuntu.com

1 0

Problem creating new marc structure in koha 2.2.6
by Pedro Faria 06 Oct '06

06 Oct '06

Dear all, I noticed some kind of a bug in the new koha 2.2.6. When I tried to make my own marc structure named TEST I got this error (this is just a piece of it...): more before ... [Fri Oct 06 17:28:47 2006] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Duplicate entry 'TEST-686-c' for key 1 at /usr/local/koha/intranet/cgi-bin/admin/marctagstructure.pl line 383., referer: http://localhost:8080/cgi-bin/koha/admin/marctagstructure.pl [Fri Oct 06 17:28:47 2006] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Duplicate entry 'TEST-700-3' for key 1 at /usr/local/koha/intranet/cgi-bin/admin/marctagstructure.pl line 383., referer: http://localhost:8080/cgi-bin/koha/admin/marctagstructure.pl [Fri Oct 06 17:28:47 2006] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Duplicate entry 'TEST-700-4' for key 1 at /usr/local/koha/intranet/cgi-bin/admin/marctagstructure.pl line 383., referer: http://localhost:8080/cgi-bin/koha/admin/marctagstructure.pl ... more after It says 'duplicate entry...' but I have no other structure with the same name (I tryed many just in case...). So I got the new structure but when I go try to add or remove some tags none appears. -- Pedro Faria

1 0

Web hosting Koha - Questions
by Venita Glasfurd 06 Oct '06

06 Oct '06

Hi all, I've been testing out koha for a library I am trying to set up in Bangalore, India.I've set up Koha for Windows on my windows based home PC and it works fine there. Now, I am planning to put up Koha on a shared server. My service provider gives me an option of going for Linux or Windows. However, since my service provider says that i cannot "install" on the web server, the Windows installer is out. Since I have not much knowledge of linux, I have this big doubt on how to install koha on the server. My basic doubt is 1. since I will not get root access to the web server, how can I install the software. Obviously, a simple copy or unzip will not work. 2. If I go with Linux, do I need to ask for special support when it comes to installing the perl modules for Koha? 3. Has anyone hosted koha on a shared server? If so, please mail me. I would like to get more inputs on this. Regards, Venita. I searched the archives for information on this, But for the one query by Bernard Shiundu in May 2006, I did not find anything else.

2 1