- Koha - lists.katipo.co.nz

Error upgrading Koha from version 18.06 to Koha 21.05
by Admire Mutsikiwa 02 Sep '21

02 Sep '21

Good day. I was trying to upgrade Koha from version 18.06 to 21.05 on Ubuntu 20.05. I installed Ubuntu 20.04 and then installed Koha 20.05. I then used the Koha 18.06 database dump to restore the Koha database after dropping the Koha 20.05 database. On trying to do the database schema upgrade, I am getting the following error: The following error occurred while importing the database structure: DBD::mysql::st execute failed: Referencing column 'message_transport_type' and referenced column 'message_transport_type' in foreign key constraint 'borrower_message_transport_preferences_ibfk_2' are incompatible. at /usr/share/perl5/DBIx/RunSQL.pm line 279, <$args{...}> line 1. Something went wrong loading file /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE TABLE `borrower_message_transport_preferences` ( `borrower_message_preference_id` int(11) NOT NULL DEFAULT 0, `message_transport_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`borrower_message_preference_id`,`message_transport_type`), KEY `message_transport_type` (`message_transport_type`), CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `borrower_message_preferences` (`borrower_message_preference_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `borrower_message_transport_preferences_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ) at /usr/share/koha/lib/C4/Installer.pm line 580. Any pointers will be greatly appreciated. Kind Regards,

2 1

Monthly Community Meeting
by Renvoize, Martin 02 Sep '21

02 Sep '21

Hi all, We had our monthly general meeting today, as usual, hosted on IRC. Attendance has been very low for a while now and we mooted the idea of dropping it from our schedule and instead just having perhaps two meetings a year, one for Kohacon votes and a second for a broader annual general meeting should anyone want to raise any points in that formal setting. The next meeting is scheduled for 13th October 2021 at 1400 UTC where we will vote on the new reduced format. We're open to new idea's at any time and I'd be happy to try a video meeting or something if people would prefer. But at this point, we're not discussing much and I don't know if we're missing peoples views or people just don't have many or they have other ways of communicating with the community at large. Hope everyone is well, *Martin Renvoize, MPhys (Hons)* <https://www.ptfs-europe.com> Head of Development and Community Engagement *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com www.ptfs-europe.com *Sign up for our newsletters here <http://eepurl.com/dPjjkn> or by scanning the QR code* Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

2 1

koha-US September 2021 Events & Meetings
by Jason Robb 01 Sep '21

01 Sep '21

koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. *Meetings* Board Meeting - Wednesday, September 8 @ 8:30a PT / 11:30a ET / 15:30 UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1UKEg2VjrHP-WV3xnLBP4ReNynqOeQWZ8_YgYjom… General Meeting - Wednesday, September 22 @ 8:45a PT / 11:45a ET / 15:45 UTC *koha-US Annual Conference* Tuesday, September 21 - Friday, September 24 This year's conference will be held in-person and live streamed to YouTube -- register and view the full schedule here: https://koha-us.org/conference2021/ *Special Interest Groups* *Note: Most groups will be meeting during the conference this month* Cataloging - Thursday, September 2 @ 8:00a PT / 11:00a ET / 15:00 UTC Acquisitions - Thursday, September 23 @ 8:00a PT / 11:00p ET / 15:00 UTC Circulation - Thursday, September 23 @ 12:00p PT / 3:00p ET / 19:00 UTC Cataloging - Thursday, September 23 @ 1:00p PT / 4:00p ET / 20:00 UTC Consortia - Friday, September 24 @ 12:00p PT / 3:00p ET / 19:00 UTC Sys Admin + Web Development - September 24 @ 1:00p PT / 4:00p ET / 20:00 UTC Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Display issue: IntranetNav in 21.05.02.003
by Elaine Bradtke 01 Sep '21

01 Sep '21

Our test site is on 21.05.02.003 . Our production site is 21.05.00 The problem is in 21.05.02.003 We have some extra links in the IntranetNav There seems to be a limit to how much you can put to the left of the More menu. Once exceeded, the More menu ends up on the next line, but in an odd place. In this case on the very far left of the page: https://drive.google.com/file/d/1AWF36xmnYSkvsxT-n7a9a4N6W2kGPFNn/view?usp=… When the More menu is clicked, it actually falls off the edge of the page - there's no way to bring it into view. https://drive.google.com/file/d/19fb6nR21jWKJG1-4WObawP4vBrCGoOX-/view?usp=… By cutting down on the number of characters that display, I managed to bring it into view, More is still on the next line, despite the fact that there is plenty of room for it above. Weirdly (and I struggle with left and right, so I never thought about it before), the production site running the older version puts our added links to the RIGHT of the More menu, but on the same line. I'm not sure if it's related to bug 23840 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23840> or if it's a new problem. Elaine Bradtke VWML <https://www.vwml.org> English Folk Dance and Song Society <https://www.efdss.org> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

3 4

How can I temporarily disable the visibility of an OPAC Library?
by Victor Barroso Oliveira 01 Sep '21

01 Sep '21

Good afternoon, I have a Koha installation with multiple libraries. How can I temporarily disable the visibility of an OPAC Library?

3 2

Re: [Koha] How can I temporarily disable the visibility of an OPAC Library?
by Indranil Das Gupta 31 Aug '21

31 Aug '21

Hi, On Tue, 31 Aug, 2021, 10:34 pm Victor Barroso Oliveira, <vbovictor(a)gmail.com> wrote: > I don't want to enable login and password to access opac. > I just want to temporarily disable access to a library in OPAC. > In that case: https://koha-community.org/manual/18.11/en/html/systempreferences.html#opac… Regards, Indranil Das Gupta L2C2 Technologies. > >

2 1

payment/fines with offline circulation
by vinod mishra 30 Aug '21

30 Aug '21

Hello May I know how to pay fines in offline mode and upload later like issue/return? I have tried but it seems it's not working, the file created contains all the fields except barcodes during payment of fines. Barcode is also mandatory if yes then how to add barcode against the fines. Thanking You With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: http://vinod.itshelp.co.in/ ORCID ID: http://orcid.org/0000-0003-4666-7874 Scopus ID: 57223138343 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

1 0

SQL report for status change within time period
by Bonnie Gardner 27 Aug '21

27 Aug '21

Hello, Does anyone know if it's possible to write a report that would give me all of the items that have had their status change from Long Lost Overdue to Available within a specified time period? I want to be able to see when long lost overdue books have been turned in so that we can ensure that the fee has been removed. Any help would be appreciated. Best, Bonnie -- *Bonnie Gardner, MLIS* *Technology Librarian* *Office: 208.798.2525 x8012* *Cell: 208.792.1560* *Lewiston City Library* *411 D Street* *Lewiston, ID 83501* -- [City of Lewiston] Notice : This email message is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is confidential and may be privileged. It is intended only for the designated recipient(s). If you are not the designated recipient, retention, distribution or copying of this email message is prohibited and may be unlawful. Please reply to the sender if you have received this message in error, then delete the message.

1 0

Koha Community Newsletter: August 2021
by Koha Newsletter 27 Aug '21

27 Aug '21

The Koha Community Newsletter for August 2021 is here: * https://koha-community.org/koha-community-newsletter-august-2021/ Many thanks to everyone who submitted articles and news this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

account lines table truncated by mistake
by Arunkumar Sampath 27 Aug '21

27 Aug '21

Hello all, without current backup mistakenly truncated accountlines table, therefore lost all fine data, is it possible to populate fine information for existing issued items. Thanks in advance -- *with regards * *S.ARUNKUMAR*

2 1