- Koha - lists.katipo.co.nz

koha 22.11 upgrading Error
by Sami M. Rasheed 03 Dec '22

03 Dec '22

Hi, I have an upgrade error after upgrading Koha version: 22.05.06.000 to koha 22.11Then I run these commands: root:/# systemctl restart memcached.serviceroot:/# systemctl restart apache2root:/# systemctl restart mysqlroot:/# systemctl restart koha-common.serviceroot:/# koha-upgrade-schema juc Upgrading database schema for libraryUpgrade to 22.06.00.041 [09:45:46]: Bug 30483 - Make issues.borrowernumber and issues.itemnumber NOT NULLERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'borrowernumber': used in a foreign key constraint 'issues_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 739 We have:MySQL version: MySQL Ver 8.0.31-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))version 20.04.5 LTS ThanksSami M. Abu Darbeya

1 0

Two January CatSIGs!
by Hernandez, Heather H 02 Dec '22

02 Dec '22

Hi, all! Guess what? There will be more Cataloging fun in January 2023! Yes—there will be two Koha-US Cataloging Special Interest Group ("CatSIG") meetings! Our regular one, the first Thursday, January 5, 2023, at 8 PT, 9 MT, 10 CT, 11 ET (16:00 UTC) and another one on Thursday, January 26, 2023, at 1(13:00)PT / 4(16:00)ET /9NZT / 20UTC! And since you don't have to be a member of Koha-US to join us, we're hoping the different times will make it possible for more folks to join in! This second meeting will be the first of additional, quarterly CatSIGs during the US's afternoons, as an experiment to see if more folks would like to join us at that time. And remember that you don't even need to self-identify as a cataloger! There will be our usual roundtable of questions, solutions and resource brainstorming, tips, tricks, suggestions, bug & development awareness, and the usual laughter, fun, and fellowship to discuss anything cataloging, authority, or metadata related in Koha. Not sure if it's cataloging related? It probably is! Actual catalogers do attend, as well as the cataloging curious and those who have had cataloging thrust upon them! Information on joining us is on the Koha-US calendar: Calendar – koha-US<https://koha-us.org/calendar/> Can't make it? No worries--it will be recorded and available on the Koha-US YouTube Channel: https://www.youtube.com/c/kohaUS/playlists (See the Cataloging Special Interest Group's playlist for more cataloging fun!) As ever, feel free to send me any questions or topics for discussion ahead of time! See you there! --h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian Library catalog: https://keys.bywatersolutions.com/<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fkeys.bywa…> San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032 (office, generally M, W, F, telecommuting Tu,Th) heather_hernandez(a)nps.gov<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwebmail.l…>

1 0

Template toolkit puzzle 2.
by Raymund Delahunty 02 Dec '22

02 Dec '22

Finding a solution to puzzle 1 would be great, but the solution would not be perfect as I cannot alter the subject line of the ODUE notice. My ideal solution would be not to send the ODUE notice to leavers at all, and instead send a separate notice to them using the patron emailer. So I need TT code / a rule to prevent a notice that *should* go out from being sent. [% IF (borrower.dateexpiry !== CURDATE() %] <standard ODUE notice is sent using a subject line appropriate for current students> [% ELSE %] <no email is sent, to the leaver, and my LEAVERS_FIRST notice is sent via the crontab using the patron emailer> [% END %] I am working to significantly improve messages to students and being able to use TT code / rules to **prevent** a standard Koha notice going out would be great, but I have no idea how I can do this. I'd appreciate any suggestions... indeed, is this possible? This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

1 0

big data
by Nisreen Qabbani 01 Dec '22

01 Dec '22

Welcome I am currently working on big data analysis Question how is that possible for Koha Has anyone used Hadoop for Koha data analysis? Thanks

2 1

Koha 21.05.21 released
by Victor Grousset/tuxayo 01 Dec '22

01 Dec '22

Hello! :-) The Koha Community is happy to announce the release of Koha 21.05.21 The full release notes can be found at: https://koha-community.org/koha-21-05-21-released/ Debian packages should be available shortly. Thanks to everyone involved :-) Cheers, -- Victor Grousset/tuxayo

1 0

Tomorrow (Friday 2): Patch testing session to help enhancements and bug fixes to be released
by Victor Grousset/tuxayo 01 Dec '22

01 Dec '22

Hi :) To be forwarded to librarians, system librarians, educators, devs, sysadmins and other people that could be interested in contributing to Koha. Let's meet Friday the 2nd at any moment in the following timeframe: 13h-20h UTC&UK / 8h-15h US East / 5h-12h US West The place is https://visio.chapril.org/koha (the text chat can be opened with the 4th button at the bottom: 🗨️) Reminder of the modalities: The idea is to test patches to contribute to Koha. The biggest bottleneck for having more bugs fixes and enhancements is patch testing. Thus this call for getting together as Koha users. No need for particular skills, just basic Koha usage. You can come an leave at any moment, even for a short time it's possible to get simple stuff moving forward. We will use a VoIP call with chat tool to speak and eventually screenshare. It's possible to join without sound and only use chat. So if you are at the front desk and there are not much patrons you can still test patches ^^ So, whichever communication mode is the most convenient for you. No need to have a local Koha instance. Just with a web browser we can use the sandboxes [1] to have temporary Kohas to test most patches and do whatever we want without bad consequences. Here is a resource about how to test patches using sandboxes: https://wiki.koha-community.org/wiki/Sandboxes Cheers, [1] https://wiki.koha-community.org/wiki/Sandboxes -- Victor Grousset/tuxayo

1 0

December Cataloging SIG
by Hernandez, Heather H 29 Nov '22

29 Nov '22

Hi, all! The next Koha-US Cataloging Special Interest Group ("CatSIG") meeting is this Thursday, Dec. 1, 2022, at 8 PT, 9 MT, 10 CT, 11 ET (16:00 UTC) and you don't have to be a member of Koha-US to join us! You don't even need to self-identify as a cataloger! Join us for our usual roundtable of questions, solutions and resource brainstorming, tips, tricks, suggestions, bug & development awareness, and the usual laughter, fun, and fellowship to discuss anything cataloging, authority, or metadata related in Koha. Not sure if it's cataloging related? It probably is! Actual catalogers do attend, as well as the cataloging curious and those who have had cataloging thrust upon them! Information on joining us is on the Koha-US calendar: Calendar – koha-US<https://koha-us.org/calendar/> Can't make it? No worries--it will be recorded and available on the Koha-US YouTube Channel: https://www.youtube.com/c/kohaUS/playlists (See the Cataloging Special Interest Group's playlist for more cataloging fun!) As ever, feel free to send me any questions or topics for discussion ahead of time! See you there! --h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian Library catalog: https://keys.bywatersolutions.com/<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fkeys.bywa…> San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032 (office, generally M, W, F, telecommuting Tu,Th) heather_hernandez(a)nps.gov<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwebmail.l…>

1 0

Koha 22.11.00 Rosalie released
by Tomas Cohen Arazi 28 Nov '22

28 Nov '22

The Koha community is proud to announce the release of Koha 22.11.00. Koha 22.11.00 is a major release, that comes with many new features. It includes 13 new features, 351 enhancements, 3 security fixes, 551 bugfixes. The full release notes are available here: https://koha-community.org/koha-22-11-released/ <https://koha-community.org/koha-22-05-released/> Debian packages should be available soon Best regards -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

8 8

Koha Community Newsletter: November 2022
by Koha Newsletter 28 Nov '22

28 Nov '22

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

1 0

Holds to pull question
by Stephen Graham 27 Nov '22

27 Nov '22

Hi All - occasionally our "holds to pull" report shows books which are not available to pull. For example, there is a book on there this morning which has two items. One of the items is already on the holds shelf waiting to be picked up, and the other item is a reference/not for loan item which is on the shelf. Should the book appear on the report? I've checked through the sysprefs to see if there is any options which might help, but cannot spot any. Is this the expected behaviour, or maybe a bug? Stephen -------------------------------------- Stephen Graham Library Technology Consultant Library and Computing Services University of Hertfordshire Hatfield, Hertfordshire, AL10 9AB Email: s.graham4(a)herts.ac.uk<mailto:s.graham4@herts.ac.uk> Website: herts.ac.uk

2 1