- Koha - lists.katipo.co.nz

Kohacon sponsorship and shout-outs and
by Kathryn Tyree 24 Feb '20

24 Feb '20

Kia ora koutou, So far Kohacon has three major Pounamu sponsors. Thank you so much to all three organisations, helping us keep Kohacon tickets free for everyone: - Bywater Solutions (plus a lot staff travelling to New Zealand!) - EBSCO Information Services - Catalyst IT If your organisation, or any of the vendors your library works with, may be interested in sponsoring the conference, please send them to the sponsorship page of the Kohacon website: https://2020.kohacon.org/posts/sponsors/ Alternately you could send us the relevant contact details and we will be happy to extend an invitation to sponsor. With any sponsorship details or queries please contact kohacon2020(a)catalyst.net.nz Kia pai tō ra, Kathryn and the Kohacon team at Catalyst -- Kathryn Tyree Koha Services Manager - Libraries Catalyst IT DDI: +64 4 803 2414 Tel: +64 4 499 2267 www.catalyst.net.nz CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

1 0

UPGRADING FROM KOHA 3.09 TO 19.11 UPGRADE ISSUES
by Josh Getanda 24 Feb '20

24 Feb '20

Hi, Please below errors when I try upgrading my database to the most current of KOHA then advise what could be the issue. Thanks in advance. Update report : - Status: 500 - Content-type: text/html - - <h1>Software error:</h1> - <pre>Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. - </pre> - <p> - For help, please send mail to the webmaster (<a href="mailto:[no address given]">[no address given]</a>), giving this error message - and the time and date of the error. - - </p> Update errors : - Thu Feb 20 14:40:34 2020] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqinvoices' already exists [for Statement " - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CREATE TABLE aqinvoices ( - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: invoiceid int(11) NOT NULL AUTO_INCREMENT, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: invoicenumber mediumtext NOT NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: booksellerid int(11) NOT NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentdate date default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: billingdate date default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: closedate date default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentcost decimal(28,6) default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentcost_budgetid int(11) default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: PRIMARY KEY (invoiceid), - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: ) ENGINE=InnoDB DEFAULT CHARSET=utf8 - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5916. - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: DBD::mysql::st execute failed: Unknown column 'aqorders.booksellerinvoicenumber' in 'field list' [for Statement " - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: SELECT aqorders.booksellerinvoicenumber AS invoicenumber, aqbasket.booksellerid, aqorders.datereceived - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: FROM aqorders - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: WHERE aqorders.booksellerinvoicenumber IS NOT NULL - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: AND aqorders.booksellerinvoicenumber != '' - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: GROUP BY aqorders.booksellerinvoicenumber - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5941. - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.

2 1

Download errors
by Tom Hanstra 24 Feb '20

24 Feb '20

I'm getting a 404 error from: http://download.koha-community.org/koha-latest.tar.gz Did something get missed when deploying the current version of Koha? -- *Tom Hanstra* *Sr. Systems Administrator* hanstra(a)nd.edu

1 0

Adding MANUAL_INV ON Koha 19.11.02
by Admire Mutsikiwa 24 Feb '20

24 Feb '20

I have upgraded to Koha 19.11.02 on Ubuntu 18.04 LTS. I have read from https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24316 that MANUAL_INV authorised value have been replaced by a dedicated table. I want to add an entry to this table but I do not know how. Any pointers would be appreciated. Kind Regards, Admire Mutsikiwa

2 2

Koha Search Error after upgrade from version 19.05 to 19.11.02
by Admire Mutsikiwa 24 Feb '20

24 Feb '20

Hi I did an upgrade from Koha version 19.05 to Koha version 19.11 on Ubuntu 18.04. Om search the OPAC or Staff catalog, I am getting the following error: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'reserves.item_level_hold' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm Kind Regards, Admire Mutsikiwa

2 3

Please remove us from your list
by Rasuwa Community Library 24 Feb '20

24 Feb '20

Please remove us from your list Rasuwa Community Library Jibajibe, Kalika-5, Rasuwa, Nepal Sent from Mail for Windows 10

1 0

Koha cirulcation error after upgrade to Koha 19.11.02
by Admire Mutsikiwa 24 Feb '20

24 Feb '20

Hi I am running Koha 19.11.02 on Ubuntu 18.04 LTS. When I try to search for a patron record using barcode, I am getting the following error Can't call method "subtract" on an undefined value at /usr/share/koha/lib/Koha/Patron.pm line 695.: /usr/share/koha/intranet/cgi-bin/circ/circulation.pl. However, when I search using the name I do not seem to get that error. Kind Regards, Admire Mutsikiwa

2 1

Re: [Koha] Customizing the Koha Homepage
by Mohammad Nashbat 23 Feb '20

23 Feb '20

Best Regards, Mohammed Nashbat Instructor Librarian -------------------------------------------------- Alfaisal University PO Box 11533 Riyadh 50927 Saudi Arabia Tel +966 11 2157942 Mob +966 503 101214 Email mnashbat(a)alfaisal.edu ________________________________ From: Mohammad Nashbat Sent: Thursday, February 13, 2020 12:17 PM To: Koha Community Subject: Customizing the Koha Homepage Dears, I have installed a new koha based system. I would like to customize the Homepage or landing page just like below for https://libkoha.alfaisal.edu Currently when i test my latest koha the page is taking to the login page and not that of search. just like below. ? Therefore i would like your kind advice on how to customize a landing page in koha system. Best Regards, Mohammed Nashbat Instructor Librarian -------------------------------------------------- Alfaisal University PO Box 11533 Riyadh 50927 Saudi Arabia Tel +966 11 2157942 Mob +966 503 101214 Email mnashbat(a)alfaisal.edu ________________________________ DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While "Alfaisal University" has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment.

1 0

qr code
by Nisreen Qabbani 22 Feb '20

22 Feb '20

Hello My question is about the possibility of direct linking and how to benefit from the qr code technology from Koha. Is there Koha the ability to generate it directly? Thank you

2 2

Password, hash, bcrypt
by robm 21 Feb '20

21 Feb '20

Something goes wrong, but... Let's go again. Hi people. I am getting envolved with Koha since last november. I am contributing in translation too, and digging BD, and scripts... Right now I have a new challenge: I need to know which method the system apply to encrypt borrowers' passwords. I know that uses Bcrypt 8, but the stored encrypted string does not match with typed string. Some clue??? Thanks in advance. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 6