- Koha - lists.katipo.co.nz

EDS Plugin not loading
by Mohamed Negm 12 Jun '18

12 Jun '18

Hi I’m trying to configure EBSCO EDS plugin into Koha 17.11, I filled out all require information in the plugin but when press loading data from EBSCO admin, nothing change, any suggestions Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

3 4

Plugin Error
by SATISH 12 Jun '18

12 Jun '18

Hi, With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation method, I am getting follwoing error while uploading .kpz file at Home › Tools › Plugins. *Cannot unpack file to the plugins directory.Please verify that the Apache user can write to the plugins directory.* What is the right permission ?? . As a root user, I have created plugins directory drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun 8 22:48 gechlibrary drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins I tried to change, chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/ drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun 8 22:48 gechlibrary drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins Alias /plugin/ "/var/lib/koha/plugins/" is updated in /etc/apache2/sites-available/gechlibrary.conf In both cases, I am not able to to perform upload plugin. Please help. Satish MV Librarian Govt. Engineering College, Hassan

4 3

bugs.koha-community.org outage warning
by Chris Cormack 12 Jun '18

12 Jun '18

Hi All The linode bugzilla (and a few outher services like the dashboard) is on is going down for a bit now to be upgraded to the next size up. This will cause a brief outage It should be back shortly Chris

1 0

Koha used for asset inventory
by Tim Atwood 12 Jun '18

12 Jun '18

Has anyone used Koha for asset inventory purposes? -- Tim Atwood Computer Systems Technician/ Grant Public Schools tatwood(a)grantps.net 231.834.5910 x5398

1 0

SQL report with Comma Delimited Paramater
by ksorbo 12 Jun '18

12 Jun '18

Is it possible to create a SQL report using a parameter with comma delimited ids? Specifically I would like to be able to select random, non-contiguous items. The following sql statement works when called directly from mysql: *select * from items where barcode in (3456,2346);* However, when I create a sql report with the following code: *select * from items where barcode in (<<Enter Barcodes>>)* it works if I enter 1 barcode, but fails if I enter 2 barcodes separated by a comma. Is there any workaround for this? -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 3

Zebra - less logging
by Tom Hanstra 12 Jun '18

12 Jun '18

Does anyone with Zebra knowledge know how to scale back the amount of logging which takes place. I'm still running Zebra for indexing with V17.11 and finding the logs are very large each day. I'd like to scale back logging so I only get errors logged. How might that be done? Thanks, Tom -- *Tom Hanstra* *Sr. Systems Administrator* hanstra(a)nd.edu <http://library.nd.edu/>

2 1

Migration problem
by Przemek Kosiński 12 Jun '18

12 Jun '18

Hi everyone, I tried to do a base migration from 3.20 to 17.11.06. The conversion of the database to the new schema and indexation has gone ok - everything works except the possibility of a full preview of the patron - after choosing one they receive such an error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_biblio-main.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269 I did two attempts and this problem appeared every time. System: Ubuntu 16.04LTS DataBase: MariaDB 10.0.34 Plack not enabled - when enable plack I get an error: Internal Server Error In the version of koha 17.11.05 there was no such error - the earlier attempt to migrate to this version was successful. I have a question about what I can do about it. Alternatively, how to withdrawal to an earlier version 17.11.05 to check whether this error can be invoked. Best regards Przemek Kosiński -- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu mail: p.kosinski(a)biblioteka24.eu *************************************************

2 2

SQL help please
by Kerrie Stevens 11 Jun '18

11 Jun '18

I have the following report which almost does what I need but I can't quite get it there. I want to be able get a list of titles and the Dewey from 082$a but I also want to be able to select for which collection I want the results - that is where I'm getting stuck. I can select the collection when I run the report, but I get the following error so there is something else missing... Error: The following error was encountered: The database returned the following error: Unknown column 'items.ccode' in 'where clause' Here is my report so far: SELECT biblio.biblionumber, biblio.title, biblio.author, concat (ExtractValue( metadata, '//datafield[@tag="082"]/subfield[@code="a"]' ), " ", ExtractValue( metadata, '//datafield[@tag="082"]/subfield[@code="b"]' )) as Dewey FROM biblio_metadata JOIN biblio ON ( biblio_metadata.biblionumber = biblio.biblionumber ) WHERE items.ccode=<<Collection|CCODE>> ORDER BY biblio.title ASC It works if I remove the WHERE line, but then I can't select which collection. Thanks for any help you may provide! Kerrie Stevens AALIA(CP), MAppSci(LibMgt), BBus(Info&LibMgt) Melbourne Campus - Librarian kerrie.stevens(a)ac.edu.au | ac.edu.au<http://ac.edu.au/> P +61 3 8799 1155 | F +61 3 8799 1199 1 Keith Campbell Court, Scoresby VIC 3179 Australia This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this email in error, please notify the sender and delete this email immediately. Any confidentiality, privilege or copyright is not waived or lost because this email has been sent to you in error. It is your responsibility to check this email and any attachments for viruses. <p> Scanned by the Alphacrucis Netbox from <a href="http://cyberhound.com/">CyberHound</a>

2 1

Item cataloging interface proposal
by Owen Leonard 11 Jun '18

11 Jun '18

Bug 13680, "Items list on edit items page separates add items form from header and sidebar" (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13680) proposes a layout change to the item add/edit screen: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=35720 I have a counter-proposal which would hide the entry form by default and move the "views" (Normal, MARC, ISBD, etc) into a dropdown menu: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=75964 The entry form in a modal window: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=75965 I would love to get opinions and/or suggestions. Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

ssl for koha login
by Alvaro Cornejo 10 Jun '18

10 Jun '18

Hi I´m trying to setup a ssl connection to Koha (using letsEncrypt certs ) so my users, admin and opac can have a secure connection. I´ve folllowed letsEncrypt & certbot instrucctions but neither opac nor admin pages work. I´ve tried directing connections manually and configuring apache for redirect unsuccessfully. Any hints on this? This is mostly to avoid the upcoming chrome config where it will display an unsafe site warning to any site requiring login that does not use ssl Regards, Alvaro

3 5