- Koha - lists.katipo.co.nz

Koha Error
by Msangi Asanali 03 Apr '18

03 Apr '18

Dear Koha GURU, i have noted that in my system i can not create a new patron, before system was fine to do every thing, i am getting the following error... Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'koha_library.me.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /usr/share/koha/lib/Koha/Objects.pm line 129 Kindly please advice what should be done....

2 1

MarcEdit 7 Koha Integration setup
by Shell, Lezlie [IC] 03 Apr '18

03 Apr '18

Could a MarcEdit 7 user please give me some tips on setting up the Z-39 window of the ILS Integration? I had to reset my computer to factory settings. Yesterday MarcEdit 7 was working with no problems. When I reinstalled today the Z-39 setup in ILS integration was requesting SRU server information. Previously, I thought I'd entered a connection name, host, port and syntax. Now, I need a connection name and URL. Is the database name part of the URL? Do I need to setup a custom search? Thank you, Lezlie Shell Questia

1 0

ERROR DECODING RECORD
by João Pinto 03 Apr '18

03 Apr '18

Hello all, We are having this problem with records, with more than 1600 items: "Use of uninitialized value $self in pattern match (m//) at /usr/share/perl5/MARC/File/XML.pm line 441. ERROR DECODING RECORD - Empty String at /usr/share/perl5/MARC/File/XML.pm line 448. : at /usr/share/koha/lib/C4/Search.pm line 1920." We have koha, 3.20, but i tried in koha 17.09 and had the same error. I saw that Alfredo Sanjuán had the same problem (https://lists.katipo.co.nz/public/koha/2017-February/047280.html) But i'm not shure about the solution that he gaves. Can someone help us? Thank's -- João Pinto [joao.pinto(a)ua.pt] _____________________________________ STIC - Serviços de Tecnologias de Informação e Comunicação [http://www.ua.pt/stic] aSGI-APA – Área de Sistemas de Informação - Área de Plataformas Abertas Universidade de Aveiro Campus Universitário Santiago 3810-193 AVEIRO Suporte Técnico: stic-helpdesk(a)ua.pt / Telf: +351 234 370099 / Ext: 22299 Geral/Administrativo: stic(a)ua.pt / Telf: +351 234 372469 / FAX: +351 234 370214 / Ext: 22250 Linked in - pt.linkedin.com/in/jacfp/ _____________________________________ Aviso de Confidencialidade/ Confidentiality Notice Esta mensagem, e os ficheiros eventualmente anexos, é confidencial e reservada apenas ao conhecimento da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu destinatário, ou se lhe foi enviada por erro, não faça qualquer uso do respectivo conteúdo e proceda à sua destruição, notificando o remetente. This message, and the existing attached files, is confidential and intended exclusively for the individual(s) named as addressees. If you are not the intended recipient, or if it was sent to you by error, you are kindly requested not to make any use of its contents and to proceed to the destruction of the message, thereby notifying the sender.

1 0

multiple public Z39.50 on the same server
by Radek Šiman 03 Apr '18

03 Apr '18

Hi Koha friends, let's assume we have 3 libraries as independent instances on the same Koha server, something like: /etc/koha/sites/libraryA/koha-conf.xml /etc/koha/sites/libraryB/koha-conf.xml /etc/koha/sites/libraryC/koha-conf.xml Every library needs to run its own Z39.50 public server. I still can't find the right way to set it up, although I have no problem with single-instance servers. Could you please provide me instructions what files should I change and how? I know about following parameters: - publicserver's listen port in koha-conf.xml - publicserver's server section in koha-conf.xml - host and port in /etc/koha/zebradb/explain-biblios.xml Even if one can setup different ports in aforementioned koha-conf.xml files, there is only one host+port in explain-biblios.xml. Or maybe I don't understand the right way how to setup multiple biblio servers on the same port but with different credentials. Thanks! Radek Šiman

3 2

Koha General Meeting Reminder - 4 April 14UTC
by Owen Leonard 03 Apr '18

03 Apr '18

Hello all, This is a reminder that there will be a Koha general IRC meeting in about 24 hours, 4 April at 14UTC. Please add anything you want to discuss to the agenda. Please add your apologies if you can't make the meeting. Local time conversion: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+General+IRC+… Meeting agenda: https://wiki.koha-community.org/wiki/General_IRC_meeting_4_April_2018 See you there, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Upcoming koha-US Meetings - April 2018
by koha-US Secretary 02 Apr '18

02 Apr '18

* koha-US meetings are open to any and all.* *Board Meeting -* When: Wednesday, April 4th at 10:30 CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+April+boa…> ) Where: https://kslib.zoom.us/j/450230564 Topic list: http://koha-us.net/index.php/BoardTopics2018-04-04 *Board meetings* focus on business-related matters and topics that would otherwise slow down general meetings. *General Meeting* - When: Wednesday, April 11th at 10:30 CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+April+gen…> ) Where: https://kslib.zoom.us/j/450230564 <https://kslib.zoom.us/j/450230564%E2%80%8B> *General meetings* put an emphasis on Koha -- bugs, issues, development ideas, workflows -- bring your problems and questions so we can discuss! These meetings also include major organizational decisions and reports from various committees. To view minutes and recordings from previous meetings, visit http://koha-us.net/index.php/Meeting_Archives If you have topics for discussion at either meeting, please send them to secretary(a)koha-us.org. For more information about all things koha-US, don't hesitate to contact us <officers(a)koha-us.org>! Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Koha Opac and Staff Client is not working
by Ashok Francis 02 Apr '18

02 Apr '18

Dear All, I am using koha 17.03 version in ubuntu. I am getting the following error after restarting the apache. root@GSS-LIBRARY-SERVER:/home/gss-library-server# sudo service apache2 restart * Restarting web server apache2 [Mon Apr 02 13:52:52.249818 2018] [core:warn] [pid 12703] AH00111: Config variable ${instance} is not defined [Mon Apr 02 13:52:52.249868 2018] [core:warn] [pid 12703] AH00111: Config variable ${instance} is not defined AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message (98)Address already in use: AH00072: make_sock: could not bind to address [::]:8000 (98)Address already in use: AH00072: make_sock: could not bind to address [::]:8001 [fail] * The apache2 instance did not start within 20 seconds. Please read the log files to discover problems Now, I am not able to getting the library opac and staff client. Please help me. Ashok. New Delhi

2 1

KohaCon2018 Website
by Jesse Maseto 02 Apr '18

02 Apr '18

The KohaCon18 Website is ready for registrations. Individuals can register, submit a proposal and more through the site. The KohaCon International Conference will take place on September 10th through 12th, followed by a Cultural Day on September 13th and Hackfest on the 14th through 16th. http://kohacon2018.bywatersolutions.com/index.html Have a wonderful day. JesseM -------------------- Jesse Maseto Dev/Ops Support ByWater Solutions Support & Consulting for OSS Office - Stratford,CT T/F 888.900.8944 http://bywatersolutions.com Jesse(a)bywatersolutions.com

1 0

New install restore old database cannot find any records in collection
by Jack Boulier 02 Apr '18

02 Apr '18

I have a new install of Koha 17.11.04, web install, running on ubuntu 16.04. I have run all the updates and upgrades. Completed the configuration from the web setup. Established koha_library in the Mariadb and restored the dump back to the koha_library. I performed the migration for the conversion of the old database to the new database. Everything seemed to work correctly. However, when doing a search of the catalog, no matching records are found. I believe that the right permissions have been granted to the database. But maybe not. Any help will be appreciated. When running koha-rebuild-zebra -v -f library, it shows that there are over 1500 records. I am at a loss to proceed. Nothing that I have attempted to research has given me any more clues that would help me resolve my situation. Any help would be greatly appreciated. Thanks,Jack Boulier

2 1

Serials, frequency, subscription - a question
by Evgeni Dimitrov 01 Apr '18

01 Apr '18

I am wondering what frequency and 'First issue publication date' can be used for: A. newspaper published every week on Tuesday and Friday B. newspaper published every day except Sunday and public holidays Best regards

2 2