- Koha - lists.katipo.co.nz

Reminder: Internet broadcast of Koha-US
by Christopher Davis 11 Aug '17

11 Aug '17

Dear Colleagues, I am excited about the Koha-US conference beginning tomorrow morning. For those of us who cannot make it up to Coeur d'Alene to attend this conference in person, don't worry...the conference can come to you. Look for the "Broadcast" hyperlinks on the webpage found at http://koha-us.net/index.php/2017_Koha-US_Conference. Please note that since there are two concurrent sessions during each time slot, you will need to select one of the two "Broadcast" links (one for the Community Room and one for the Story Room). There is a limited number of seats open for these broadcasts, so connect early before the seats are taken. Please feel free to contact me with your related comments and/or questions. All the best, Christopher Davis Secretary, Koha-US cgdavis(a)uintah.utah.gov

6 11

Please Help Me
by Rajesh Shelar 11 Aug '17

11 Aug '17

Dear Friends, I Request Please send me the Tag Of Journals & Periodicals ( KOha Version 16.5 ) Details- 1). Accession Date 2). Accession No. 3). Main Title 4). Volume No. 5). Issue No. 6). Pages 7).JOurnal Publish DAte 8).Price 9).Frequency -- ***Thanks & Regards* *Mr. Rajesh R.Shelar* *Sadhu Vaswani Institute Of Management Studies For Girl's ( MBA )* *Koregaon Road,Pune* *Mob.No.8380941380* *Save Water......Conserve Life.............*

2 1

Insitu borrower
by Luis Moises Rojas 11 Aug '17

11 Aug '17

Hello everybody. When a user use a book insitu, on the issues table, the fields onsite_checkout =1 and the date_due is set to one hour later, but as soon as the book is RETURN, the fields onsite_checkout is set to 0. Questions: 1. Why the date_due is set to one hour and how to avoid this? 2. how to avoid the onsite_checkout =0? This is because we need to generate some reports with onsite_checkout =1, it mean: insitu. Thanks -- *Luis Moisés Rojas P.*

2 1

E-mail configuration in koha version 3.0.6
by Dr. B. RAVIIVVENKAT 11 Aug '17

11 Aug '17

Dear Sir, How to do E-mail ( for book remainder purpose) configuration in koha 3.0.6 *Dr. B. RaviivvenkatDeputy LibrarianUniversity LibraryTumkur University, Tumakuru-572103. Joint-Secretary. KULA, Mysuru.Secretary, TUDLA, Tumakuru , Co-ordinator Shodhaganga*

4 3

Getting Elastic search 5.X working with authority searching and presentation in the Koha staff intranet
by David Holoshka 10 Aug '17

10 Aug '17

Hi, We would like to see this feature working. Do we just report what is not working in Bugzilla and submit patches for the items or is their some kind of coordination with other people that we need to take into account ? Is there a plan or roadmap for elastic search work or do we just do what we want ? Is this the right mailing group for this question ? Best Regards, Dave

3 2

Re: [Koha] Patron Club feature
by Krishna K 10 Aug '17

10 Aug '17

Hi all, The other open bugs in patron clubs feature all relate to using MySQL. Looks like the clubs feature will get installed properly only if MariaDB is used.Mark Alexander and Michael Kuhn, are you using MySQL ? Have you tried the clubs feature using Maria DB ? Koha development team, could you please give a recommendation ? On Fri, Aug 4, 2017 at 1:03 PM Krishna K <krishna.moorthy94(a)gmail.com> wrote: > Thanks Michael. > > Hi all, > > Should I report this as a bug w.r.t the clubs feature ? > > > On Wed, Aug 2, 2017 at 10:15 PM Michael Kuhn <mik(a)adminkuhn.ch> wrote: > >> Hi >> >> >> We recently upgraded to 17.05.01 from 16.11.05. When we try to use the >> >> clubs feature by clicking on Tools-> Patron Clubs link, we are getting >> 404 >> >> error. >> > >> > It sounds like there was a problem during the upgrade process, though >> > I don't know what it might have been. One solution would be to take a >> > full backup of your Koha database and reinstall 17.05.x from scratch. >> > >> > Unfortunately it doesn't look like there is any documentation for the >> > patron clubs feature yet. :( >> >> Features without documentation are almost like non-existing... :( >> >> However, out of curiosity I tried to use the clubs feature in my own >> demo installation as well as in an installation that I recently updated >> from Koha 3.20 to 17.05. >> >> Both of them will show no clubs feature but just a white screen saying >> "Not found" when click the "clubs" link which looks something like this >> >> http://yourhost:yourport/cgi-bin/koha/clubs/clubs.pl >> >> The file system of both hosts don't show no file called "clubs.pl" >> anywhere. >> >> The output of the update process said only "Upgrade to 16.12.00.027 done >> (Bug 12461 - Add patron clubs feature)" which doesn't indicate any error. >> >> So maybe the error is somewhere in the upgrade routine. >> >> Best wishes: Michael >> -- >> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis >> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz >> T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > -- > Regards, > Krishna > -- Regards, Krishna

4 4

Register can not be saved
by Luis Moises Rojas 09 Aug '17

09 Aug '17

Hello everybody, If we call a book, and selected EDIT REGISTER, we changed some data (i.e, the title), when we saved it: NOTHING happen. Changes are not saved and without any error. Any idea? -- *Luis Moisés Rojas P.*

3 4

Koha giving frequent software errors
by ILOBWeb 09 Aug '17

09 Aug '17

Hello everyone, We are using Koha for our resource centre and we are getting frequent software errors while working on it. Errors are like - Error 1 : Software error: Wrong CSRF token at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 291. For help, please send mail to the webmaster ([no address given]<mailto:[no%20address%20given]>), giving this error message and the time and date of the error. Error 2: This site can't be reached The connection was reset. Try: * Checking the connection * Checking the proxy and the firewall<data:text/html,chromewebdata#buttons> * Running Windows Network Diagnostics<javascript:diagnoseErrors()> ERR_CONNECTION_RESET Today, I got error when was working on Koha and to check something I clicked on 'Help'. I checked the Intranet error logs file and a snapshot of the same is below. The highlighted error is the error which was logged today when I clicked 'Help'. [Mon Aug 07 15:24:18.684124 2017] [cgi:error] [pid 46288] [client 72.141.68.213:49598] AH01215: [Mon Aug 7 15:24:18 2017] manage-marc-import.pl: Can't call method "results" on an undefined value at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 347.: /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/manag… [Mon Aug 07 17:01:11.388667 2017] [cgi:error] [pid 46753] [client 72.141.68.213:51047] AH01215: [Mon Aug 7 17:01:11 2017] additem.pl: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing… [Mon Aug 07 17:01:42.857633 2017] [cgi:error] [pid 46763] [client 72.141.68.213:51057] AH01215: [Mon Aug 7 17:01:42 2017] additem.pl: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing… [Tue Aug 08 03:39:01.311411 2017] [cgi:error] [pid 52495] [client 72.141.68.213:49809] AH01215: [Tue Aug 8 03:39:01 2017] detail.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing… [Tue Aug 08 03:39:50.095831 2017] [cgi:error] [pid 52517] [client 72.141.68.213:49813] AH01215: [Tue Aug 8 03:39:50 2017] detail.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/uploa… [Tue Aug 08 18:53:48.745776 2017] [cgi:error] [pid 63052] [client 137.122.64.13:16643] AH01215: [Tue Aug 8 18:53:48 2017] detail.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/manag… [Tue Aug 08 18:57:20.166232 2017] [cgi:error] [pid 63135] [client 137.122.64.13:16842] AH01215: [Tue Aug 8 18:57:20 2017] detail.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1410.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/tools/uploa… [Tue Aug 08 19:12:33.214782 2017] [cgi:error] [pid 63456] [client 8.28.16.254:2289] AH01215: [Tue Aug 8 19:12:33 2017] batch_records_ajax.pl: Use of uninitialized value in array element at /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl line 50.: /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl [Tue Aug 08 19:12:33.215002 2017] [cgi:error] [pid 63456] [client 8.28.16.254:2289] AH01215: [Tue Aug 8 19:12:33 2017] batch_records_ajax.pl: Use of uninitialized value $results_per_page in numeric eq (==) at /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl line 53.: /usr/share/koha/intranet/cgi-bin/tools/batch_records_ajax.pl [Tue Aug 08 19:46:24.299851 2017] [cgi:error] [pid 64346] [client 137.122.64.13:16448] AH01215: [Tue Aug 8 19:46:24 2017] additem.pl: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing… [Tue Aug 08 19:46:36.232888 2017] [cgi:error] [pid 64346] [client 137.122.64.13:16448] AH01215: [Tue Aug 8 19:46:36 2017] additem.pl: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing… [Tue Aug 08 19:46:51.483374 2017] [cgi:error] [pid 64367] [client 137.122.64.13:16465] AH01215: [Tue Aug 8 19:46:51 2017] additem.pl: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 83: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: http://ilob-olbi-intra.juliencouturecentre.ca:8888/cgi-bin/koha/cataloguing… [Wed Aug 09 14:05:20.165528 2017] [cgi:error] [pid 13318] [client 199.116.173.196:43345] AH01215: [Wed Aug 9 14:05:20 2017] help.pl: Use of uninitialized value $url in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/help.pl line 31.: /usr/share/koha/intranet/cgi-bin/help.pl Can anyone please suggest why these errors are occurring? Any help would be greatly appreciated because these errors are interrupting our work. Regards, Gurpreet

2 3

How to return from version 17.05 to 16.05
by Luis Moises Rojas 09 Aug '17

09 Aug '17

Hello everybody, We upgrade from 16.05 to 17.05. Now we are having at lot of problems. We can not work at all. Is there is a way to get back? Previous version where everything was ok? Thanks -- *Luis Moisés Rojas P.*

3 11

Unknown column 'metadata' in 'field list'
by Vimal Kumar V. 09 Aug '17

09 Aug '17

Dear Friends, I am trying to generate a book list with keywords from 650$a using the following SQL query, SELECT ExtractValue( metadata, '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode, items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title, biblioitems.pages, biblioitems.publishercode, biblioitems.place, biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) ORDER BY LPAD(items.barcode,40,' ') ASC After running the report, I got the following error message, The database returned the following error: Unknown column 'metadata' in 'field list' Please check the log for further details. Please review the SQL query and help me to solve the problem. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in http://moovandan.blogspot.in <http://moovandan.blogspot.in> --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

4 3