- Koha - lists.katipo.co.nz

how to run Koha server behind a proxy server
by Fahad Ubaid 01 Aug '17

01 Aug '17

Hi Guys, Can someone help me about how to run Koha server behind a proxy server? and also guide how to change database connection by changing the IP address of the database ... waiting for your positive response from Koha community. Best Regards Fahad Ubaid Resident Engineer Interactive Group of Companies, Islamabad Pakistan Cell # *923445505422*

1 0

Unable to place hold on any item
by ILOBWeb 01 Aug '17

01 Aug '17

Hello, I have successfully imported records in my library but when any patron try to place hold on an item, its giving error : 'Sorry, none of these items can be placed on hold.' Can someone guide which configurations I need to do? Regards, Gurpreet

3 3

Koha Check- Error -The item has not been checked in due to a configuration issue in your system.
by Admire Mutsikiwa 01 Aug '17

01 Aug '17

Hi I have upgraded my Koha to version . Now when I check in an item I am getting the following error: The item has not been checked in due to a configuration issue in your system. You must ask an administrator to take a look at the about page <http://uzlibraries.uz.ac.zw:8080/cgi-bin/koha/about.pl#sysinfo> and search for the "data problems" section. When I visit the About page, I am greeted with : Data problems Some of your tables have problems with their auto_increment values which may lead to data loss. You should not ignore this warning. The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup the auto_increment values are set to max(table.id)+1. See the related wiki page <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> to know how to avoid this problem. Problems found Checkouts The following ids exist in both issues and old_issues tables: 2, 3 Warnings regarding the system configuration However, when I check the schema for old_issues, it has no auto-increment turn on for issue_id though it is the primary key I will appreciate any pointers Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

2 1

request help for bulk import of Library Books Catalog in Koha
by Rajesh Shelar 01 Aug '17

01 Aug '17

Dear Sir/Madam, I request help for bulk import of Library Books Catalog in Koha. Kindly guide and suggest solutions for the following 1. Importing Books all Feilds 2. Preparing marc file for our accession register attached. I have used the following tags? Are they correct...if yes theer seems to be a problem especially for Tag 952. *TAG* Accession No. 001 Barcode 952 p Accession Date. 952 d Author 100 $ a Title 245 $ a Purchase Bill NO. 024 $ a Purchase Bill Date. 952 $ w Page No. 300 $ a Book Supplier 952 $ e Book Price 952 $ g Call No. 082 $ a ISBN 020 $ a Edition 250 $ a Publication Place 260 $ a Publisher Name 260 $ b Book Publish Year 260 $ c Library Shelf Location 952 $ c Subject *Use Of Version* Koha version:16.05.05.000 OS version ('uname -a'):Linux koha-server 3.16.0-33-generic #44~14.04.1-Ubuntu SMP Fri Mar 13 10:33:29 UTC 2015 x86_64 Perl interpreter:/usr/bin/perlPerl version:5.018002Perl @INC:/usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.18.2 /usr/local/share/perl/5.18.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.18 /usr/share/perl/5.18 /usr/local/lib/site_perl . MySQL version:mysql Ver 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64) using readline 6.3Apache version:Server version: Apache/2.4.7 (Ubuntu)Zebra version:Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU I humbly request your guidance and express my gratitude in anticipation of your help -- ***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.............* -- ***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

Everything listed as "not renewable"
by mpw 01 Aug '17

01 Aug '17

I'm running Koha version 17.05.01 on Debian 8.8. All of the items that are checked out are labeled as "Not renewable (0 of 0 renewals remaining)". I've tried changing the settings in "Circulation and fine rules" in several different ways but nothing makes any difference. While researching this problem I've noticed two other mentions of the same thing but neither of them with a real solution. -- View this message in context: http://koha.1045719.n5.nabble.com/Everything-listed-as-not-renewable-tp5940… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml
by Josef Moravec 01 Aug '17

01 Aug '17

it should theoretically work, but i didn't try it... note, that in mysql tables biblio and biblioitems aren't all data, which are normally in Marcxml record... co the MARC will be incomplete! but if you do not have backup, you don't have many options... Josef út 1. 8. 2017 v 11:26 odesílatel Gevork Grigorian <gelinger777(a)yandex.com> napsal: > The problem is that I have no backup :(((((((((((((((((((((( I mentioned > that the only problem is this missing MARCXML. From that XML file most of > the things are in normal mysql table exists. Am I right? Only the IDs and > Location fields are not there. > > Am I right? If i write a script which will generate the XML from the > existing data , and put in the biblio_metadata database, it will work? > > 01.08.2017, 10:48, "Josef Moravec" <josef.moravec(a)gmail.com>: > > Hello, > > just reload db from backup, then set mysql according to this guide: > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04… > > then you can update your database structure and everything should be ok > > regards > Josef > > út 1. 8. 2017 v 9:08 odesílatel gevos <gelinger777(a)yandex.com> napsal: > > Overyesterday We have updated ubuntu server and the koha was updated too. > Apparently because of the mysql 5.7 the script somehow failed and we have > landed to a point where only from 30.000 books only 2 books landed to the > book_metadata. and we don't have now the original column marcxml in > biblioitems :((((((((((((((((( > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-m… > Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > >

1 0

Records are not show in catelog
by Fahad Ubaid 01 Aug '17

01 Aug '17

Dear Community, We facing a Problem regarding searching records in the catalog of Koha. Koha server was working properly on the day before problem created and also showing the records from the catalog but now today we cannot find any records in Koha. we also rebuild zebra but fail. Regards, Fahad Ubaid

2 1

Re: [Koha] Koha Digest, Vol 142, Issue 1
by Admire Mutsikiwa 01 Aug '17

01 Aug '17

Hi Bob Birchall For now, my 'message_queue is empty and as for cron jobs , in the /etc/cron.daily/koha-common I have the following entries koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/overdue_notices.pl -t koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/advance_notices.pl -c and in the /etc/cron.d/koha-common, I have */3 * * * * root cd /tmp && koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/process_message_queue.pl I am not sure if I should have additional cron jobs Regards, Admire Mutsikiwa -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Monday, 31 July 2017 9:21 PM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 142, Issue 1 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: System not generating check-in and check-out messages (Bob Birchall) 2. Impossible to renew items (mpw) 3. Searching capability dies every few days - Zebra problem? (mpw) 4. Re: Impossible to renew items (Marc Véron) 5. Re: Impossible to renew items (Jonathan Druart) 6. Saving Template for Send EMAIL (Luis Moises Rojas) 7. Re: Saving Template for Send EMAIL (Jonathan Druart) 8. Re: Searching capability dies every few days - Zebra problem? (Mark Alexander) 9. Re: Error 500 when trying to upload batch of local cover images (Owen Leonard) ---------------------------------------------------------------------- Message: 1 Date: Mon, 31 Jul 2017 22:35:52 +1000 From: Bob Birchall <bob(a)calyx.net.au> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] System not generating check-in and check-out messages Message-ID: <a361f5d9-66dc-1e14-bb4f-850eada37b39(a)calyx.net.au> Content-Type: text/plain; charset=utf-8; format=flowed Have you started the email cron jobs? If you have database access, are there entries in the table 'message_queue'? Bob Birchall Calyx On 31/07/17 18:01, Admire Mutsikiwa wrote: > Hi > > > > I am running Koha . I have configured and test that my Koha server is > sending messages. However, it appears my Koha system is not > generating message to add to the mail queue. I am testing with a > particular patron account and have enabled Item -check-in and item > check-out notification by email. However, when I check the Notices Tab > in the user account , I am getting the message " There is no record of > any messages that have been sent to this patron " > > > > Any pointers would be greatly appreciated. > > > > Kind Regards, ------------------------------ Message: 2 Date: Mon, 31 Jul 2017 06:07:29 -0700 (MST) From: mpw <wyneken(a)physik.uni-freiburg.de> To: koha(a)lists.katipo.co.nz Subject: [Koha] Impossible to renew items Message-ID: <1501506449981-5941578.post(a)n5.nabble.com> Content-Type: text/plain; charset=us-ascii I'm running Koha version 17.05.01 on Debian 8.8. I'm setting up a new library. I have checked out eight books. In the renewable column they are all listed as "Not renewable (0 of 0 renewals remaining)". Several people have suggested removing all the circulation and fine rules and creating a single rule the holds for all patron types and all item types. For example here: http://koha.1045719.n5.nabble.com/All-items-quot-not-renewable-quot-td59254… I've tried that several times but none of the tries ever made any difference. Right now I only have one rule: Patron category - All Item type - All Current checkouts allowed - 20 Renewals allowed - 3 Renewal period - 14 Automatic renewal - no Since somebody in the above mentioned thread said that this might be a bug, I opened a bug report but they referred me back to this list because it's supposedly just a configuration problem. I have set the option that enables the "Override renewal limit" checkbox so I can trick the system into renewing books, but that's just a workaround and I'd like to get to the root of the problem. I've been going around in circles here for well over a week. Can anybody point me in the right direction? -- View this message in context: http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 3 Date: Mon, 31 Jul 2017 06:24:49 -0700 (MST) From: mpw <wyneken(a)physik.uni-freiburg.de> To: koha(a)lists.katipo.co.nz Subject: [Koha] Searching capability dies every few days - Zebra problem? Message-ID: <1501507489364-5941587.post(a)n5.nabble.com> Content-Type: text/plain; charset=us-ascii I'm running Koha version 17.05.01 on Debian 8.8. I set up Koha a few months ago and we're still learning the system. One thing we've noticed that presumably is not normal is that every few days the searching capability dies for some reason or other. My guess is that it has something to do with Zebra. I occasionally get a message from my logrotate cronjob: Zebra already stopped for instance xxx. When I check, there are no koha or zebra processes running. I can restore the search capability by restarting Koha with "invoke-rc.d koha-common restart". Presumably some daemon or other dies but I haven't been able to figure out which one. Maybe it happens during the regular cronjobs? Does anybody have any idea how I can figure out what's happening? One workaround I'm considering is setting up a regular cronjob to restart koha-common regularly, but that doesn't strike me as being a very elegant solution. -- View this message in context: http://koha.1045719.n5.nabble.com/Searching-capability-dies-every-few-days-… Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 4 Date: Mon, 31 Jul 2017 17:18:12 +0200 From: Marc Véron <veron(a)veron.ch> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Impossible to renew items Message-ID: <7249b1e4-68b2-9b61-6ff1-e9ba3aca0e64(a)veron.ch> Content-Type: text/plain; charset=utf-8; format=flowed Hi Matthew I tried to reproduce the issue (on current master), however no luck. Is it possible to check the MySQL table issuingrules? Is there only one row? What are the values? For the records: Bug 18997 - Everything listed as "not renewable" https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18997 Marc Am 31.07.2017 um 15:07 schrieb mpw: > I'm running Koha version 17.05.01 on Debian 8.8. > > I'm setting up a new library. I have checked out eight books. In the > renewable column they are all listed as "Not renewable (0 of 0 > renewals remaining)". > > Several people have suggested removing all the circulation and fine > rules and creating a single rule the holds for all patron types and > all item types. For example here: > > > http://koha.1045719.n5.nabble.com/All-items-quot-not-renewable-quot-td > 5925467.html#none > > I've tried that several times but none of the tries ever made any > difference. Right now I only have one rule: > Patron category - All > Item type - All > Current checkouts allowed - 20 > Renewals allowed - 3 > Renewal period - 14 > Automatic renewal - no > > Since somebody in the above mentioned thread said that this might be a > bug, I opened a bug report but they referred me back to this list > because it's supposedly just a configuration problem. > > I have set the option that enables the "Override renewal limit" > checkbox so I can trick the system into renewing books, but that's > just a workaround and I'd like to get to the root of the problem. > > I've been going around in circles here for well over a week. Can > anybody point me in the right direction? > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578. > html Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 5 Date: Mon, 31 Jul 2017 15:27:17 +0000 From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Impossible to renew items Message-ID: <CAJzKNY7y5O8MOKkFi=16riEooGUZ3UVCQF5Z-e1kHFG1YaEFUA(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hi, What is the value of AllowRenewalIfOtherItemsAvailable? And the result of SELECT * FROM issuingrules; Regards, Jonathan On Mon, 31 Jul 2017 at 10:07 mpw <wyneken(a)physik.uni-freiburg.de> wrote: > I'm running Koha version 17.05.01 on Debian 8.8. > > I'm setting up a new library. I have checked out eight books. In the > renewable column they are all listed as "Not renewable (0 of 0 > renewals remaining)". > > Several people have suggested removing all the circulation and fine > rules and creating a single rule the holds for all patron types and > all item types. For example here: > > > > http://koha.1045719.n5.nabble.com/All-items-quot-not-renewable-quot-td > 5925467.html#none > > I've tried that several times but none of the tries ever made any > difference. Right now I only have one rule: > Patron category - All > Item type - All > Current checkouts allowed - 20 > Renewals allowed - 3 > Renewal period - 14 > Automatic renewal - no > > Since somebody in the above mentioned thread said that this might be a > bug, I opened a bug report but they referred me back to this list > because it's supposedly just a configuration problem. > > I have set the option that enables the "Override renewal limit" > checkbox so I can trick the system into renewing books, but that's > just a workaround and I'd like to get to the root of the problem. > > I've been going around in circles here for well over a week. Can > anybody point me in the right direction? > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Impossible-to-renew-items-tp5941578. > html Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 6 Date: Mon, 31 Jul 2017 11:40:09 -0400 From: Luis Moises Rojas <lmoisesrojas(a)gmail.com> To: Comunidad Koha <koha(a)lists.katipo.co.nz> Subject: [Koha] Saving Template for Send EMAIL Message-ID: <CAKSqYx8ak7Zq3kJZFpeA=r_pnXH3e7_xfAQkbTK0o+GPvSYJUQ(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hello everybody, When we go to: Home->tools - Notices & Slips and create a new template (By the way, we do not see any templates) and we try to save it: Nothing happen. Any help? Thanks -- *Luis Moisés Rojas P.* <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> ------------------------------ Message: 7 Date: Mon, 31 Jul 2017 16:35:20 +0000 From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> To: Comunidad Koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Saving Template for Send EMAIL Message-ID: <CAJzKNY4s0-7D-jb-8jWw8z2tK7g+ZWwzm5zYVQX4pbU_odWLQw(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hi, Something in the logs? In the console? Regards, Jonathan On Mon, 31 Jul 2017 at 12:40 Luis Moises Rojas <lmoisesrojas(a)gmail.com> wrote: > Hello everybody, > > When we go to: Home->tools - Notices & Slips and create a new template (By > the way, we do not see any templates) and we try to save it: Nothing > happen. > > Any help? > > Thanks > > -- > *Luis Moisés Rojas P.* > > > < > https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai… > > > Libre > de virus. www.avast.com > < > https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai… > > > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 8 Date: Mon, 31 Jul 2017 13:03:24 -0400 From: Mark Alexander <marka(a)pobox.com> To: mpw <wyneken(a)physik.uni-freiburg.de> Cc: koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Searching capability dies every few days - Zebra problem? Message-ID: <1501520540-sup-951@t60p> Content-Type: text/plain; charset=UTF-8 Excerpts from mpw's message of 2017-07-31 06:24:49 -0700: > I set up Koha a few months ago and we're still learning the system. One > thing we've noticed that presumably is not normal is that every few days the > searching capability dies for some reason or other. My guess is that it has > something to do with Zebra. It might be this problem: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16885 I solved it on my installation using this: https://lists.katipo.co.nz/pipermail/koha/2016-September/046167.html ------------------------------ Message: 9 Date: Mon, 31 Jul 2017 15:20:49 -0400 From: Owen Leonard <oleonard(a)myacpl.org> To: Koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Error 500 when trying to upload batch of local cover images Message-ID: <CAO4qe2OomsivEEbXB5mNSQ3akQku733K=Kan9Dr_tP2MK_j0iQ(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" > I am trying to upload around 400 local cover images in a batch and I get a > 500 error Have you tried importing a smaller batch? Do you have access to your installation's error logs? Those might show a clue about what the actual problem is. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 142, Issue 1 ************************************

1 0

Koha Community Newsletter: July 2017
by kohanews 01 Aug '17

01 Aug '17

Fellow Koha users: The Koha Community Newsletter for July 2017 is here: https://koha-community.org/koha-community-newsletter-july-2017/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

adding more than first 20 results to a list
by Vasiliki Mela 31 Jul '17

31 Jul '17

Hello, everyone I need to add the results of a search to a list in order to export and batch edit the biblios. When I check select all and add to list, only the first twenty results are added. Is there a way to add all results at once? Thank you *Vasiliki Mela* * ERT S.A. Hellenic Broadcasting Corporation Archives Department Library*

3 2