- Koha - lists.katipo.co.nz

param errors persisting after enabling plack
by George Masters 03 Jun '17

03 Jun '17

Hello Marc, I did some more investigation as to the cause of the param errors I am experiencing with Koha since upgrading to 16.11. The following log entries from today seem to be revealing: gmasters@server1:/var/log/koha/library$ tail -10 *opac-error.log* [Fri Jun 02 16:43:55.057378 2017] [cgi:error] [pid 21358] [client 82.80.249.143:56285] AH01215: [Fri Jun 2 16:43:55 2017] 404.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/errors/404.pl [Fri Jun 02 16:43:56.352809 2017] [cgi:error] [pid 21381] [client 82.80.249.143:56395] AH01215: [Fri Jun 2 16:43:56 2017] 404.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/errors/404.pl [Fri Jun 02 16:43:58.982060 2017] [cgi:error] [pid 21390] [client 82.80.230.228:59667] AH01215: [Fri Jun 2 16:43:58 2017] 404.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/errors/404.pl [Fri Jun 02 16:43:59.306611 2017] [cgi:error] [pid 21393] [client 82.80.230.228:57266] AH01215: [Fri Jun 2 16:43:59 2017] 404.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/errors/404.pl [Fri Jun 02 16:43:59.583504 2017] [cgi:error] [pid 21396] [client 82.80.230.228:52914] AH01215: [Fri Jun 2 16:43:59 2017] 404.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/errors/404.pl [Fri Jun 02 16:44:00.432558 2017] [cgi:error] [pid 21399] [client 82.80.230.228:59790] AH01215: [Fri Jun 2 16:44:00 2017] 404.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/errors/404.pl [Fri Jun 02 18:18:26.003233 2017] [cgi:error] [pid 23865] [client 180.76.15.136:44399] AH01215: [Fri Jun 2 18:18:26 2017] opac-main.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/opac-main.pl [Fri Jun 02 18:18:26.017423 2017] [cgi:error] [pid 23865] [client 180.76.15.136:44399] AH01215: [Fri Jun 2 18:18:26 2017] opac-main.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/opac-main.pl [Fri Jun 02 18:18:35.522767 2017] [cgi:error] [pid 23874] [client 180.76.15.11:24457] AH01215: [Fri Jun 2 18:18:35 2017] opac-main.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/opac-main.pl [Fri Jun 02 18:18:35.535631 2017] [cgi:error] [pid 23874] [client 180.76.15.11:24457] AH01215: [Fri Jun 2 18:18:35 2017] opac-main.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/opac/cgi-bin/opac/opac-main.pl gmasters@server1:/var/log/koha/library$ tail -10 *intranet-error.log* [Thu Jun 01 22:27:16.241162 2017] [cgi:error] [pid 19626] [client 127.0.0.1:52832] AH01215: [Thu Jun 1 22:27:16 2017] mainpage.pl: DBD::mysql::st execute failed: Table 'koha_library.sessions' doesn't exist [for Statement "SELECT a_session FROM sessions WHERE id=?" with ParamValues: 0='43d20a030010c2dd2acbec1552cd3252'] at /usr/share/perl5/CGI/Session/Driver/DBI.pm line 72.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://library-intra.oclibsys.org/ [Thu Jun 01 22:27:16.241441 2017] [cgi:error] [pid 19626] [client 127.0.0.1:52832] AH01215: [Thu Jun 1 22:27:16 2017] mainpage.pl: Can't call method "param" on an undefined value at /usr/share/koha/lib/C4/Auth.pm line 829.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://library-intra.oclibsys.org/ [Thu Jun 01 22:34:05.073353 2017] [cgi:error] [pid 20174] [client 127.0.0.1:52964] AH01215: [Thu Jun 1 22:34:05 2017] mainpage.pl: DBD::mysql::st execute failed: Table 'koha_library.sessions' doesn't exist [for Statement "SELECT a_session FROM sessions WHERE id=?" with ParamValues: 0='43d20a030010c2dd2acbec1552cd3252'] at /usr/share/perl5/CGI/Session/Driver/DBI.pm line 72.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://library-intra.oclibsys.org/ [Thu Jun 01 22:34:05.073612 2017] [cgi:error] [pid 20174] [client 127.0.0.1:52964] AH01215: [Thu Jun 1 22:34:05 2017] mainpage.pl: Can't call method "param" on an undefined value at /usr/share/koha/lib/C4/Auth.pm line 829.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://library-intra.oclibsys.org/ [Thu Jun 01 22:36:36.662060 2017] [cgi:error] [pid 20607] [client 127.0.0.1:52972] AH01215: [Thu Jun 1 22:36:36 2017] mainpage.pl: DBD::mysql::st execute failed: Table 'koha_library.sessions' doesn't exist [for Statement "SELECT a_session FROM sessions WHERE id=?" with ParamValues: 0='43d20a030010c2dd2acbec1552cd3252'] at /usr/share/perl5/CGI/Session/Driver/DBI.pm line 72.: /usr/share/koha/intranet/cgi-bin/mainpage.pl [Thu Jun 01 22:36:36.664142 2017]sessions [cgi:error] [pid 20607] [client 127.0.0.1:52972] AH01215: [Thu Jun 1 22:36:36 2017] mainpage.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/intranet/cgi-bin/mainpage.pl [Thu Jun 01 22:36:40.221562 2017] [cgi:error] [pid 20607] [client 127.0.0.1:52972] AH01215: [Thu Jun 1 22:36:40 2017] mainpage.pl: DBD::mysql::st execute failed: Table 'koha_library.sessions' doesn't exist [for Statement "SELECT a_session FROM sessions WHERE id=?" with ParamValues: 0='8c7da8630f56ffbaee6374f6f60838c1'] at /usr/share/perl5/CGI/Session/Driver/DBI.pm line 72.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://library-intra.oclibsys.org/ [Thu Jun 01 22:36:40.221834 2017] [cgi:error] [pid 20607] [client 127.0.0.1:52972] AH01215: [Thu Jun 1 22:36:40 2017] mainpage.pl: Can't call method "param" on an undefined value at /usr/share/koha/lib/C4/Auth.pm line 829.: /usr/share/koha/intranet/cgi-bin/mainpage.pl, referer: http://library-intra.oclibsys.org/ [Fri Jun 02 14:36:37.463768 2017] [cgi:error] [pid 17602] [client 205.174.240.239:4037] AH01215: [Fri Jun 2 14:36:37 2017] mainpage.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/intranet/cgi-bin/mainpage.pl [Fri Jun 02 15:02:15.705523 2017] [cgi:error] [pid 18456] [client 64.74.215.150:40105] AH01215: [Fri Jun 2 15:02:15 2017] mainpage.pl: DBD::mysql::db do failed: Table 'koha_library.sessions' doesn't exist [for Statement "INSERT INTO sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session = ?"] at /usr/share/perl5/CGI/Session/Driver/mysql.pm line 50.: /usr/share/koha/intranet/cgi-bin/mainpage.pl gmasters@server1:/var/log/koha/library$ tail -10 *zebra-error.log* 20170529 07:35:21 library-koha-zebra: client (pid 30802) killed by signal 15, stopping 20170531 07:35:16 library-koha-zebra: client (pid 2067) killed by signal 15, stopping 20170531 07:35:57 library-koha-zebra: client (pid 28285) killed by signal 15, stopping I am not sure if the two errors in the logs are related. Was the sessions table introduced at a later time (after version 3.22 and before 16.11)? My backup on 4-26-2017 does not include a sessions table. This was the backup I performed before upgrading to 16.11 Rev. George Masters Director Orthodox Christian Library System 408.242.4632

2 1

user history
by Scott Owen 02 Jun '17

02 Jun '17

Hi all, One of my Koha installs, (3.22.06.000 ) seems to not save user check out data. I have set the default privacy setup as "forever", but, once the patron checks the book in, it is removed from their history. (I CAN see the items checked out while the patron has the item, but once it is returned, the item/user history seems to be cleared) Any other setting I should be looking at ?? Thanks, -S

2 2

Request for Information - reg...
by Paramasivam J 02 Jun '17

02 Jun '17

Dear Sir, We are using Koha Ver. 3.20.03.00 for Automated Circulation System in our library . In this Version the following BUGS are appearing after the Check- In of documents 1. CHECK - IN details are not displaying in the CIRCULATION HISTORY in the Patron's Account 2. CHECK OUT HISTORY of document (Book/ Technical Report/Stadnard/ Back Volume etc)is also not displaying 3. While CHECK - IN of documents, the message SERVER ERROR is appearing , but our server is working . What is the LATEST VERSION of KOHA Please suggest me sir, How to rectify/ solve this BUGS J ParamasivamTIC - LibraryCABS, DRDO, Govt of India, Bangalore - 560 037

2 4

Problem on Staged MARC management
by anjoze 02 Jun '17

02 Jun '17

Hi. I've set up a new VM with Koha (16.11.08.000) and imported my old UNIMARC Frameworks. I tried to import a MARC Record (marcxml). I can upload the file, then Stage for import, but then when I *Import this batch into the catalog* on *Manage staged MARC records*, the Job progress bar will keep *0%* forever. If I refresh page it shows that the record was staged ok. The problem is related with the *Item* because when I choose *NO* on *Check for embedded item record data?* it works, the Job progress bar will go to *100%* On */var/log/koha/koha/intranet-error.log* /[cgi:error] [pid 1580] [client xx.xx.xx.xx:35538] AH01215: [Tue May 30 14:34:16 2017] stage-marc-import.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/MARC/File/XML.pm line 397, <__ANONIO__> chunk 2.: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer: http://yy.yy.yy.yy::8080/cgi-bin/koha/tools/stage-marc-import.pl/ Maybe a bug? Thank you ----- Koha version: 16.05.05 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-tp59352… Sent from the Koha-general mailing list archive at Nabble.com.

3 8

Display Search Order by Title in OPAC
by Luis Moises Rojas 01 Jun '17

01 Jun '17

Hi everybody, We want to display search order by TITLE (A-Z), but we can not find where to set up this. Any Help pls? Thanks -- *Luis Moisés Rojas P.*

1 1

Elastic search demo interface
by BOUIS Sonia 01 Jun '17

01 Jun '17

Hello everybody, First of all, congratulations Kyle for the 17.05 koha release ! I'm wondering if someone have planned to propose an interface demo (staff and public) on Koha 17.05 with Elastic Search turn on. It would be great :) It would help librarians that have heard about Elastic Search for one year to make it more real and to evaluate if it could be relevant for them to switch from zebra to elastic search. And I have 2 more questions about elastic search : - Is it compatible with unimarc ? - Is it usable with non-latin character ? Thanks in advance, Cheers Sonia BOUIS Responsable du Service des application documentaires BIBLIOTHÈQUES UNIVERSITAIRES Bibliothèque de la Manufacture UNIVERSITÉ JEAN MOULIN LYON 3 1C AVENUE DES FRÈRES LUMIÈRE CS 78242 69372 LYON CEDEX 08 ligne directe : +33 (0)4 78 78 79 03 http://bu.univ-lyon3.fr<http://bu.univ-lyon3.fr/> L'Université Jean Moulin est membre fondateur de l'Université de Lyon

1 0

koha 17.05.00 make test FAIL
by Bob Ewart 31 May '17

31 May '17

I'm making Koha 17.05.00 on openSuse Leap 42.2 with MariaDB version 10.0.29. sql_mode is set to 'NO_ENGINE_SUBSTITUTION' . I created the koha database, but of course it has notables defined. When I run 'make test', it fails on t/Matcher.t failed tests: 3-5 and t/Prices.t failed on test 5 There are a lot of errors like: DBD::mysql::st execute failed: Table 'koha.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='casauthentication'] at /usr/lib/perl5/vendor_perl/5.18.2/DBIx/Class/Storage/DBI.pm line 1836. So t/Matcher.t get 'undef' when trying to select from that table. 't/Prices.t' fails because koha.aqbooksellersdoesn't exist. I tried running make test with out a koha database and got a bunch of other errors in the tests: 'Unknown database 'koha'. That failed on t/Koha_ExternalContent_OverDrive.t and t/XSLT.t Why are the tests trying to access tables before the table structure is set up? -------- Question: Are Catmandu::Importer::MARC and Catmandu::Store::ElasticSearch required? 'koha_perl_deps.pl' doesn't show them, but there was a mention of them in one of the tests. So I installed them before these tests. Didn't make any difference in the results. -- Bob

2 2

Koha Community Newsletter: May 2017
by kohanews 31 May '17

31 May '17

Fellow Koha users: The Koha Community Newsletter for May 2017 is here: https://koha-community.org/koha-community-newsletter-may-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

What's on in koha-devel #13
by Jonathan Druart 31 May '17

31 May '17

Hello librarians and developers, I have a lot of things to tell you :) First, Koha 17.05 is out! I would like to congratulate Kyle and all the release team! It includes 7 new features and many enhancements and bug fixes. You can find the release notes on the website : https://koha-community.org/koha-17-05-released/ I would like to highlight a feature that I am talking about for months now, Hea version 2 = Hea v2 = The development is now in the last version of 3.22.x and has been backported to all supported releases. So if you are using 3.22, 16.05 or 16.11 you should upgrade to (at least) 3.22.21, 16.05.13 or 16.11.08 and share with us information about your libraries! See the global map to see all libraries https://hea.koha-community.org/libraries-on-a-map (just a few at the moment, we are waiting for you!) See an example of the detail of a Koha installation with several libraries: https://hea.koha-community.org/libraries/425 You can tune and choose the information to share with the community on a new administration page. You can find it under "Administration › Usage statistics". I really hope to see a whole map full of libraries in the next weeks :) = 17.11 development has started = 17.05 is out, that means the next development cycle has just started. I have been elected to take the lead as Release Manager for this one. I announced in my RM proposal ( https://wiki.koha-community.org/wiki/Proposal_for_RM_17.11_joubu) that I wanted to integrate more people in the team. To this end, I needed to know 1) who is willing to dedicate time for the next 6 months, 2) what are the needs of everybody and 3) coordinate and assign tasks to ease and speed the integration of patches. As I am not a politician I will try and do what I said. You may have noticed that I already started, here are the different actions that have already been triggered: == Contact people == I have sent an email to 1) the support companies, 2) the contributors and 3) the general list ( https://lists.katipo.co.nz/pipermail/koha/2017-May/048066.html) to ask them/you filling a form ( https://framaforms.org/ready-to-help-the-koha-community-1493918217) to collect ideas/needs on what we could work on the next release and who is going to help. I have received 40 answers so far, for a total of 62 persons and 852h per months. 29 support companies, 6 libraries and 5 volunteers. That's a good start, but quite a lot of (active) support companies did not answer yet. If you are not an employee of a support company, you can still fill the form! == A new tool - kanban == To coordinate and assign tasks I suggest a new tool that is quite easy to use: a kanban. You can find it at https://tree.taiga.io/project/joubu-koha-rm-1711/kanban There is a wiki page to explain a bit how it works: https://tree.taiga.io/project/joubu-koha-rm-1711/wiki/home It will be a very important tool for the next release, so if you are involved directly or indirectly in the Koha community (translation, documentation, write or test patches, etc.) you should join us if it is not done yet. For instance we are currently reworking our entry points on the wiki to welcome new contributors, there is a task on the kanban subdivided in several tasks: https://tree.taiga.io/project/joubu-koha-rm-1711/us/21 == Welcoming new contributors, a priority == As I just said previously we are focussing on welcoming new contributors, if you are new and willing to help us it's certainly the best moment to do it. You should just wait a bit to let us rebuilt our wiki and give you the desire to help! If you always wanted to dive into the Koha code, we are writing a tutorial to help and guide you throughout the different steps of a patch: write a patch, attach it to the bug tracker, sign it off, etc. It is called koha-howto and you can find more information about it on the kanban. The official announcement should arrive soon. = Collaborative what's on = Heh yeah, I am sure some of you are sick of my English grammar and my obsession for the wiki syntax in my emails :) Since I guess other developers would like to share what they did over the previous month I have created a pad ( https://annuel2.framapad.org/p/What_s_on_in_koha-devel) where everybody can contribute to the next "what's on in koha-devel" email. Feel free to add stuffs to this page when you want to highlight something. = Push refactoring patches soon = I have a lot of refactoring patches that are in the queue for too long. I really would like to see a collective effort done on them. They will lead to cleaner and more flexible and maintainable code. We have seen lot of bug recently that would have been avoided with them. See the kanban and filter on the "Refactoring" Epic to see what must be done quickly. Do not forget the IRC meetings! If you want to tell us something or highlight a problem, start a discussion, it is the place to do it (do not forget to add the topic on the agenda!) The next general IRC meeting is on June 7th at 13 UTC. https://wiki.koha-community.org/wiki/General_IRC_meeting_7_June_2017 The next dev IRC meeting is on June 14 at 21 UTC https://wiki.koha-community.org/wiki/Development_IRC_meeting_14_June_2017 Cheers, Jonathan

1 0

Regarding sql query for analytical records
by Suresh Kumar Tejomurtula 31 May '17

31 May '17

HI, Thanks for the correction. I updated my query and modified as below. I wanted to link the barcode in the marc tag(773 / 0) to the items serial barcode for getting the serial publication date and serial planned date. In the below query all fields are having correct values except the serial planneddate and serial published and they are blanks, as Iam not able to link the serial barcode with the marc barcode(773/o). SELECT ExtractValue(marcxml,'//datafield[@tag="773"]/subfield[@code="o"]') AS accno, ExtractValue(marcxml,'//datafield[@tag="773"]/subfield[@code="t"]') AS Journalname, ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code="a"]') AS subject, ExtractValue(marcxml,'//datafield[@tag="300"]/subfield[@code="a"]') AS imprint, biblio.title as Title, biblio.author as Author, biblio.abstract as abstract, items.enumchron,serial.planneddate,serial.publisheddate FROM biblio LEFT JOIN biblioitems on (biblioitems.biblionumber=biblio.biblionumber) LEFT JOIN items on (items.biblionumber=biblio.biblionumber) LEFT JOIN serial on (serial.biblionumber=biblio.biblionumber) where ExtractValue(marcxml,'//datafield[@tag="773"]/subfield[@code="o"]')>'400000' Thanks in advance. -- Regards T. Suresh Kumar

1 0