- Koha - lists.katipo.co.nz

Getting error after migrating data from Koha 3.10 to 16.11
by Server Room Thane 15 May '17

15 May '17

Dear All, We are getting some problem while migration of Koha 3.10.04.000 to 16.11.07.000. I have took backup of Koha 3.10 using *mysqldump. *And after installation of koha 16.11, restored dump. Upgraded Database Schema. Everything goes OK. But when I am trying to login using superadmin (Koha_library), each time I am getting following error in *Staff client. * *Error: You do not have permission to access this page.* But after just refreshing staff clients login page, I am able to login successfully. And logs of intranet-error.log will get following lines. [Sun May 14 11:49:24.256127 2017] [cgi:error] [pid 12639] [client 10.1.1.4:2745] AH01215: [Sun May 14 11:49:24 2017] mainpage.pl: Use of uninitialized value in string eq at /usr/share/koha/lib/Koha/Template/Plugin/Branches.pm line 68.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://10.1.1.28:8080/ [Sun May 14 11:50:54.540250 2017] [cgi:error] [pid 12654] [client 10.1.1.4:2755] AH01215: [Sun May 14 11:50:54 2017] mainpage.pl: Use of uninitialized value $userid in string eq at /usr/share/koha/lib/C4/Auth.pm line 2016.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://10.1.1.28:8080/ [Sun May 14 11:50:54.540345 2017] [cgi:error] [pid 12654] [client 10.1.1.4:2755] AH01215: [Sun May 14 11:50:54 2017] mainpage.pl: Use of uninitialized value $userid in string eq at /usr/share/koha/lib/C4/Auth.pm line 2021.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://10.1.1.28:8080/ [Sun May 14 11:51:18.208037 2017] [cgi:error] [pid 12660] [client 10.1.1.4:2760] AH01215: [Sun May 14 11:51:18 2017] mainpage.pl: Use of uninitialized value $userid in string eq at /usr/share/koha/lib/C4/Auth.pm line 2016.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://10.1.1.28:8080/cgi-bin/koha/mainpage.pl?logout.x=1 [Sun May 14 11:51:18.208235 2017] [cgi:error] [pid 12660] [client 10.1.1.4:2760] AH01215: [Sun May 14 11:51:18 2017] mainpage.pl: Use of uninitialized value $userid in string eq at /usr/share/koha/lib/C4/Auth.pm line 2021.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://10.1.1.28:8080/cgi-bin/koha/mainpage.pl?logout.x=1 In OPAC webpage I am getting following error. Software error: Can't call method "is_debarred" on an undefined value at /usr/share/koha/opac/cgi-bin/opac/opac-user.pl line 93. And logs of opac-error.log will get following lines. [Sun May 14 11:59:06.862748 2017] [cgi:error] [pid 12699] [client 10.1.1.4:2858] AH01215: [Sun May 14 11:59:06 2017] opac-user.pl: Use of uninitialized value $userid in string eq at /usr/share/koha/lib/C4/Auth.pm line 2016.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: http://10.1.1.28/cgi-bin/koha/opac-user.pl [Sun May 14 11:59:06.863125 2017] [cgi:error] [pid 12699] [client 10.1.1.4:2858] AH01215: [Sun May 14 11:59:06 2017] opac-user.pl: Use of uninitialized value $userid in string eq at /usr/share/koha/lib/C4/Auth.pm line 2021.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: http://10.1.1.28/cgi-bin/koha/opac-user.pl [Sun May 14 11:59:07.301035 2017] [cgi:error] [pid 12699] [client 10.1.1.4:2858] AH01215: [Sun May 14 11:59:07 2017] opac-user.pl: Can't call method "is_debarred" on an undefined value at /usr/share/koha/opac/cgi-bin/opac/opac-user.pl line 93.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl, referer: http://10.1.1.28/cgi-bin/koha/opac-user.pl *Koha 3.10's Superadmin's default username was "Kohaadmin". And Koha 16.11's default username is "Koha_library". is this creates problem*? Kindly help me to resolve this issue. Note : If I create new Patron, I am able to login to OPAC. Thanks & Regards, Sandeep Ulhalkar (VPM's Server Room)

3 5

Reduce Library efforts and Enhance service with Koha Public report and CoverFlow
by vinod mishra 14 May '17

14 May '17

Dear All, As we know librarians are always very busy professionals in my view and they are very dedicated too !!!, Hence some recent research i have did through which you can not only reduce the library professionals efforts and save the time but you can drastically enhance your library services with the help of Koha Library automation software CoverFlow and Public Report feature. For more details please feel free to contact and read at: http://mishravk.com/2017/05/coverflow-2/ With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

1 0

Customizing Labels in Label Creator -- Help
by Boulier, Jack 12 May '17

12 May '17

I am attempting to bring in several of the Koha fields from the cataloging side into my labels. I am able to collect items from the Marc21 record without any problems. But I cannot seem to get the syntax for exporting the Koha fields such a s the 8 field, or the alpha fields below it. Your documentation states the all Koha fields are available, but I can only place fields that are one word. I would also like to create a custom print label that would fit a sheet that has two columns, in column/row there are two spine labels and 4 book pocket labels. This is PRD # H43602, SKU# 14216850 from DEMCO. There are five rows to a sheet. The sheet is 8.5" X 11". I have research this through the documentation, on-line help, and just did my homework, but I am unable to configure a means of resolving the problem. Thanks for any suggestions, Jack Jack Boulier Learning Resource Center Director MTI College 5221 Madison Ave. Sacramento, CA 95841 (916)339-4370 (916)339-0305 FAX

2 1

Migrating Data from Koha 3.14 to Koha 16.11...
by Samuel Crawford 12 May '17

12 May '17

Greetings, Koha Community! I have a tech dilemma re: the Koha upgrade we're currently trying to implement. The issue was recently brought to our attention by the lead "support" in our IT Department, Jovian. Jovian is pretty stellar with systems computing / working the back end of things for us; he set up our initial version of Koha (3.14) completely on his own, without a hitch. He's now prepared to help us set up the LATEST stable version of Koha (16.11, yes?), but he could use just a bit of advice from you fine folks, if anyone has any tips / information to offer... His recent messages to me are as follows: 1. ------------------------------------------------------------ ------------------------------------------------------------ -------------------- *Currently we're running Koha 3.14 on Ubuntu 12..* *We understand the new modules and requirements for the newer releases and are looking to setup an Ubuntu 16 system with the latest version of Koha...* *What we would like to know is the best, recommended way of migrating the data from the old system to the new. I don't feel comfortable upgrading the Ubuntu 12 to 16 and maintaining its integrity.* *(**we do have a running Ubuntu 16 with the most current Koha build running fresh. Now we just need to migrate the data. We could do it manually... but key pointers may help)* ------------------------------------------------------------ ------------------------------------------------------------ -------------------- 2. -------------------------------------------------------------------------------------------------------------------------------------------- *I created a backup and am currently importing it into the new Koha system.. it IS imported, but I'm running the schema upgrade. There have been some errors... so I don't know how it will all work out. The errors were due to duplicate entries and things like that so I'm not 100% on whether or not this is an issue... * *I will run the zebra index afterwards to clean up as much integrity as possible before letting you guys take a stab at the new one (assuming it will even load in the new system anymore...)* -------------------------------------------------------------------------------------------------------------------------------------------- 3. -------------------------------------------------------------------------------------------------------------------------------------------- *So I tried a straight update of the schema from that old version database to the new and there are just too many errors... duplicate entries, dirty data etc. that cause it to not roll over well. * *Patrons (or at least some) can still log in.. I can't login with the koha_library account... but the database of books didn't appear to copy over. More than likely there's some error in it that it just decided to not import any of it... * *We could try a manual import... but that would assume you could even login with your admin rights.* -------------------------------------------------------------------------------------------------------------------------------------------- Could at least one of you out there lend your expertise and speak to the issues Jovian's encountering, and how we might resolve them? I'll be happy to put him in touch directly with a fellow Koha community member, if need be... Thanks in advance for the help, guys! Cheers, Sam --------------------------------------------------------- *Samuel Judson Crawford*, M.M., M.L.I.S. Academic Librarian Northern Marianas College P. O. Box 501250 Saipan, MP 96950 Phone | 670.237.6798 Fax | 670.234.0759 samuel.crawford(a)marianas.edu -- Start Smart. Start at NMC. Visit the Northern Marianas College website at www.marianas.edu. <http://www.marianas.edu> This message and any attachments may contain proprietary and, or confidential information. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please notify the sender immediately and destroy all copies.

2 1

Delete authorities with not title
by Luis Moises Rojas 11 May '17

11 May '17

Hello everybody, We have at lot of authorities with 0 records ,this is with not title. Can we delete or how can we delete all these records (authorities)? Thanks. -- *Luis Moisés Rojas P.*

2 3

Enquiry
by mohammed abdelgadir 11 May '17

11 May '17

Hello have a nice day I want to inquiry if there are website to learn KOHA professionally online I looking forward to hear soon from you. thanks in advance

3 2

How to upload cusomized koha into repository
by koha＠viavitae.co.in 11 May '17

11 May '17

Hello everyone, I am new in koha and I do not know how upload customized koha into repository. If anyone help me by saying the step, then i will be helpful. Amal Maitra Via Vitae Solutions EC - 202, Sector - I Salt Lake City Kolkata - 700064 E-mail: contact(a)viavitae.co.in W.B. India

2 1

Fwd: Re: bulkmarcimport
by Katrin 11 May '17

11 May '17

I started a staged import run about 6:16pm with 499 records. It's now 6:46pm and it's still running. The only error messages I could find are in the koha-zebraserve-output.log, 499 [warn] ir_session (exception). This from a fresh reload of the koha database; I loaded about 6000 serials records yesterday in 500 record chunks and it went fine although slow. I did use the undo when I forgot to set the framwork--nice. (It would be nice to have an audible alarm when a batch completed.) It's obviously in some sort of loop and should have terminated with an error message. I'm going to reboot, reload koha, rebuild_zebra and try again. What else can I do? Bob On 05/10/2017 04:09 PM, Katrin wrote: > Hi Bob, > > I've never used the bulkmarcimport.pl with matching rules, so I am not > much help there. But wondering, why don't you use the staged import > tools? 13.000 records should not be a problem and it's easier to set > up and can be undone if the results are not as you expected them to be. > > Katrin > > > On 10.05.2017 15:13, Bob Ewart wrote: >> I'mtrying to import about 13K records from our serials and archives >> recordsin dbText for Libraries into Koha. (Our books were converted >> in 2009) >> >> I tried: >> bulkmarcimport.pl -b -file serial-01.mrc -v -framework SER -all >> -match Control-number,001 001Code >> >> where 001Code is the matching rule set up as Nicole described to >> match the Control-number to the incoming 001 MARC field. It works on >> the web. >> >> It ran in a little over 9 seconds and said it processed 500 records. >> No errors were reported. >> >> After reindexing zebra, none of the records in serial-01.mrc could be >> found. >> >> What I want to do is to replace any matching records and insert the >> new ones. >> >> What am I doing wrongwith bulkmarcimport? >> >> -- >> Bob Ewart >> Koha 16.11.07 >> >> (repeat of message yesterday that didn't seem to get to the list) >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha

3 3

Unable to check-in Item
by Adekunle Oyadeyi 11 May '17

11 May '17

Hello everyone, i tried to check-in some items and it returned empty value. I also tried it on the patron's check-out page, the error message i got was 'unable to check-in'. Any Help? Adekunle E. OYADEYI

3 3

Error in Patrons
by Rejeesh K.Nair 11 May '17

11 May '17

Hi All, We just migrated KOHA version 3.18.01.000 to 16.05.04. When we click on any of the letter(A-Z listing) in 'Patrons' tab it won't show the corresponding patrons. Data already exist in database and the error log shows the following error. "Argument "NO_LIBRARY_SET" isn't numeric in modulus (%) at /usr/share/koha/lib/C4/Context.pm line 1246.: /usr/share/koha/intranet/cgi-bin/mainpage.pl," Can anyone help on this issue? Thanks & Regards, Rejeesh K.Nair m: +91 (0) 9495316906 e: rejeeshknair(a)gmail.com <https://www.facebook.com/rejeeshnairk> <https://twitter.com/rejeeshknair> <http://in.linkedin.com/in/rejeeshknair> <https://www.instagram.com/rejeeshknair/>

4 8