- Koha - lists.katipo.co.nz

deleting empty records problem
by lukasz.mesek＠alingsas.se 31 May '17

31 May '17

Hello, I have generated report of empty records and as a result I've got about 2 000 of them. When I had tried to batch delete them I've got a message that it is imposible. It looks like this: Bibliographic record 313 was not deleted. An error occurred. (The error was: DBD::mysql::st execute failed: Duplicate entry '313' for key 'PRIMARY' [for Statement "INSERT INTO deletedbiblioitems SET number = ?,marcxml = ?,publishercode = ?,cn_source = ?,pages = ?,collectionissn = ?,place = ?,collectionvolume = ?,totalissues = ?,volume = ?,cn_class = ?,editionstatement = ?,biblionumber = ?,size = ?,timestamp = ?,lccn = ?,marc = ?,agerestriction = ?,ean = ?,url = ?,publicationyear = ?,volumedesc = ?,cn_item = ?,itemtype = ?,volumedate = ?,editionresponsibility = ?,cn_sort = ?,illus = ?,isbn = ?,cn_suffix = ?,collectiontitle = ?,biblioitemnumber = ?,notes = ?,issn = ?" with ParamValues: 0=undef, 1=" 00396camsa2200157ba 4500 009698 940202 1 Hcee.03 Hce.03 Hce.03 SANDBURG, Carl Dikter i urval 1934 0096...", 2=undef, 3=undef, 4=undef, 5=undef, 6=undef, 7=undef, 8=undef, 9=undef, 10=undef, 11=undef, 12='313', 13=undef, 14='2016-06-07 20:42:21', 15=undef, 16='00396camsa2200157ba 4500001000700000008003900007081002800046100001900074245001900093260000900112596003900121700002100160886003200181900001200213999001300225.009698.940202 1 . .aHcee.03.kHce.03.hHce.03.1 .aSANDBURG, Carl.10.aDikter i urval.0 .c1934. .x009698.bDiktonius, Elmer / Ã¶vers..10.aDiktonius, Elmer.0 .bLA ASWSW0000SWES BD.2PULSEN.00.a2158328. .c313.d313..', 17=undef, 18=undef, 19=undef, 20=undef, 21=undef, 22=undef, 23=undef, 24=undef, 25=undef, 26='', 27=undef, 28=undef, 29=undef, 30=undef, 31='313', 32=undef, 33=undef] at /home/kohaadmin/kohaclone/C4/Biblio.pm line 3419. , see the Koha log file for more information). Does anyone have an idea what is a problem? Do I have go through it manually? Med vänlig hälsning Lukasz Mesek Vuxenbibliotekarie Alingsås bibliotek lukasz.mesek(a)alingsas.se

2 1

Koha 17.05.00 released!
by Kyle Hall 31 May '17

31 May '17

Hello all! It is my honor to announce the release of Koha 17.05.00! Thanks you to everyone who contributed time and effort making this the best version of Koha yet! The release notes can be found on the Koha Community website: https://koha-community.org/koha-17-05-released/ Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org )

3 2

Error after upgrading to latest version of Koha
by George Masters 31 May '17

31 May '17

I just recently upgraded to Koha 16.11.08 and the database schema conversion completed OK (based on the screen prompts). However, when I log into the staff client I get the following error message on the screen and no staff menu: Can't call method "param" on an undefined value at /usr/share/koha/lib/C4/Auth.pm line 492. Is there a workaround for this error? Rev. George Masters Director Orthodox Christian Library System 408.242.4632

3 3

Re: [Koha] Koha Digest, Vol 139, Issue 48
by George Masters 31 May '17

31 May '17

Hi Marc, I cleared the cookies in the browser (using Chrome latest version on Ubuntu 16.04 LTS and MariaDB) Memcached was not installed so I installed it and started it. Plack did not install so I went through the process of setting up Placek and restarting apache. On the staff client if I log in as the master user koha_<instance name>, I do get a menu. When I select functions at that menu it takes me to the login screen. If I log in with my patron credentials (which I set for all librarian functions), I still get the error message I reported earlier. However, the line number is now 829 in the same module. The OPAC reports the same error in line 492 as before. I have been in the 16.07 series for some time. I can send the database backup if it will help isolate the upgrade issues. It was created prior to the upgrade on April 26, 2017. We have been down since April 26. Rev. George Masters 408.242.4632 On Sun, May 28, 2017 at 5:00 PM, <koha-request(a)lists.katipo.co.nz> wrote: > 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. Error after upgrading to latest version of Koha (George Masters) > 2. Re: Error after upgrading to latest version of Koha > (16.11.08) (Marc Véron) > 3. Koha 17.05 Release Delay (Kyle Hall) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 27 May 2017 20:52:33 -0700 > From: George Masters <masters.george(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Error after upgrading to latest version of Koha > Message-ID: > <CACDNHC=hKcW_PMFAa7ywLPX_KKbrsJwsz28RpvBpp4FG1Hstsg@ > mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > I just recently upgraded to Koha 16.11.08 and the database schema > conversion completed OK (based on the screen prompts). However, when I log > into the staff client I get the following error message on the screen and > no staff menu: > > Can't call method "param" on an undefined value at > /usr/share/koha/lib/C4/Auth.pm line 492. > > Is there a workaround for this error? > > > > Rev. George Masters > Director > Orthodox Christian Library System > 408.242.4632 > > > ------------------------------ > > Message: 2 > Date: Sun, 28 May 2017 07:39:52 +0200 > From: Marc Véron <veron(a)veron.ch> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Error after upgrading to latest version of Koha > (16.11.08) > Message-ID: <8e752250-29a9-fdc3-709d-c3b9029e6d8b(a)veron.ch> > Content-Type: text/plain; charset=utf-8; format=flowed > > Good morning Rev. George Masters > > Just a guess, but maybe the following could help: > > Clear all cookies > > In console, do: > service memcached restart > koha-plack --restart [Name of your Koha instance] > > Information that might help: > - Does the OPAC properly display? > - Can you log in to OPAC? > - Does search in OPAC work? > > - Koha version where you upgraded from? > - What is your Linux version? > > Kind regards > Marc Véron > > > Am 28.05.2017 um 05:52 schrieb George Masters: > > I just recently upgraded to Koha 16.11.08 and the database schema > > conversion completed OK (based on the screen prompts). However, when I > log > > into the staff client I get the following error message on the screen and > > no staff menu: > > > > Can't call method "param" on an undefined value at > > /usr/share/koha/lib/C4/Auth.pm line 492. > > > > Is there a workaround for this error? > > > > > > > > Rev. George Masters > > Director > > Orthodox Christian Library System > > 408.242.4632 > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > Message: 3 > Date: Sun, 28 May 2017 11:53:14 -0400 > From: Kyle Hall <kyle.m.hall(a)gmail.com> > To: Koha Devel <koha-devel(a)lists.koha-community.org>, Koha > <koha(a)lists.katipo.co.nz> > Subject: [Koha] Koha 17.05 Release Delay > Message-ID: > <CACpVHfyd0LASy5KA7+L=uhopQJV0X7EMQkkP_Tf6VjqpzTyxig@mail. > gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hello All, > > As some of you may have heard at the last IRC meeting, I'm in the middle of > moving into a new home. This has delayed the release of 17.05 a bit. I hope > to have it out the door sometime tonight or tomorrow ( as soon as I've got > internet access again ). > > Sorry for the delay! > Kyle > > http://www.kylehall.info > ByWater Solutions ( http://bywatersolutions.com ) > Meadville Public Library ( http://www.meadvillelibrary.org ) > Crawford County Federated Library System ( http://www.ccfls.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 139, Issue 48 > ************************************* >

1 0

Default Koha to delete records if no items remain?
by Christopher Davis 30 May '17

30 May '17

Dear Colleagues, I know that there is a check box in Koha's Batch item deletion tool for this, but is there a way to have Koha default to automatically delete a title record when its last item record is deleted from the system? I have searched within the Koha system preferences for this default to no avail. We are running Koha 16.11.05. TIA, Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgdavis(a)uintah.utah.gov (435) 789-0091 ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary instagram.com/uintahcountylibrary

2 2

Regarding sql report for analytical records created
by Suresh Kumar Tejomurtula 30 May '17

30 May '17

Hi, I would like to get a report on analytical records created in koha. The below is the query I tried, but getting a blank output. Iam very new to sql reports. I tried looking in the sql reports library, but could not get any. SELECT biblio.biblionumber, biblio.title, biblio.author, ExtractValue(bi.marcxml,'//datafield[@tag="773"]/subfield[@code="0"]') AS hostrecordnumber FROM biblio LEFT JOIN biblioitems ON (biblio.biblionumber=biblioitems.biblionumber) where ExtractValue(bi.marcxml,'//datafield[@tag="773"]/subfield[@code="0"]') is not null -- Regards T. Suresh Kumar

2 1

Koha 16.05.13 release
by Mason James 30 May '17

30 May '17

The Koha community is proud to announce the release of Koha 16.05.13 This is a maintenance release and includes 36 bugfixes, and Hea2 :0) https://hea.koha-community.org/ The full release notes are available at https://koha-community.org/koha-16.05.13-release/ Packages will be available soon. Mason

6 6

KohaCon 2017 update
by Manny Tamayao 30 May '17

30 May '17

Dear Koha Community, Only 20 days to go before our Koha Conference will be held in Makati, Philippines. This is to update you on what's going on in the Philippines. Most of you have read and heard news about the terrorist attack in Marawi City, Iligan which is part of Mindanao, a southern island of the Philippines. Our venue in Makati City, the central business district of the Philippines is 1,495.6 km away from Marawi. Our government is doing its best to control the situation there and assures the public safety throughout the nation. Also, since our venue is in the business district additional security are more visible from the city government and the venue itself has its own security personnel. The organizers are cooperating with the local authorities to make sure the safety of all KohaCon participants. You can read this article from CNN for the update http://cnnphilippines.com/news/2017/05/29/AFP-Marawi-control-clearing-ops.h…. Koha ILS Philippines volunteers

1 0

link to detail broken in lists with xslt view
by Hugo Agud 29 May '17

29 May '17

Good morning This friday we upgrade one koha 3.22 to 16.11.06 everything goes fine until we check the lists, all links to detail view of the bib record drives to 404.pl., we discovered that the biblionumber was no in the link :S We have done some fresh install, create library with sample data and links to list were working fine, but once we import the data from old server and upgrade mysql server all lists links were broken... after many hours of working we have realized that if we change XSLTListsDisplay into no xslt links are fine again. We have several servers with 1611 and this is only happening with one, but we have tried a new install and upgrade and the behaviour is the same, it is quite weird behaviour, perhaps some combination of syspref??? anybody has faced a similar situation? Thanks you in advance! -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> <http://www.orex.es/omeka> Director Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933 856 138 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

3 3

Re: [Koha] Typos in Koha database description (Table "borrowers")
by Marc Véron 29 May '17

29 May '17

Hi Michael, The typos come from installer/data/mysql/kohastructure.sql The typos can be found in current master as well. Best way to fix the typos is to file a bug on https://bugs.koha-community.org/bugzilla3/ and then to attach a patch. Kind regards Marc Véron Am 27.05.2017 um 15:47 schrieb Michael Kuhn: > Hi > > Recently I have found some typos in the SchemaSpy description of table > "borrowers". > * http://schema.koha-community.org/16_11/tables/borrowers.html > > 1. In the comment for field "debarred" (YYY-MM-DD) should by replaced > by (YYYY-MM-DD) > > 2. In the comment for field "smsalertnumber" SNS should be replaced by > SMS > > 3. In the comments of fields "contactname", "contacttitle", > "guarantorid", "relationship" the term "guarentor" is used, but it > should be "guarantor". > > 4. The comment for field "password" reads "patron/borrower's encrypted > password". I think it could be mkore explicit by writing > "patron/borrower's MD5 encrypted password". > > Where can I correct these typos? > > Best wishes: Michael

2 5