- Koha - lists.katipo.co.nz

Database upgrade error from 20.06.00.000 to 20.11.00-1
by skaman.tx＠gmail.com 07 Jan '21

07 Jan '21

I am running Koha on Debian 10 X64. Database is mariadb. When I attempt to perform the most recent routine update of koha-common via the apt package manager, the upgrade fails during the upgrade of the Koha database schema for my library database. Below is the verbose output of the installation failure. ------------ snip ----------------------------------- Upgrading database schema for library Upgrade to 20.06.00.000 done [11:18:06]: All our codebase are belong to everybody Upgrade to 20.06.00.001 done [11:18:06]: Bug 24986 - Switch borrowers address related fields to TINYTEXT or MEDIUMTEXT Upgrade to 20.06.00.002 done [11:18:06]: Bug 25184 - Items with a negative notforloan status should not be captured for holds Upgrade to 20.06.00.003 done [11:18:06]: Bug 24156 - Add new table tables_settings Upgrade to 20.06.00.004 done [11:18:07]: Bug 25851 - Remove holdallowed rule if value is an empty string Upgrade to 20.06.00.005 done [11:18:07]: Bug 24379 - Set login_attempts NOT NULL Upgrade to 20.06.00.006 done [11:18:09]: Bug 24151 - Add pseudonymized_transactions tables and sysprefs for Pseudonymization Upgrade to 20.06.00.007 done [11:18:09]: Bug 22844 - Add borrower_attribute_types.mandatory Upgrade to 20.06.00.008 done [11:18:09]: Bug 23148 - Replace Bridge icons with transparent PNG files Upgrade to 20.06.00.009 done [11:18:10]: Bug 23391 - Hide finished ILL requests Upgrade to 20.06.00.010 done [11:18:10]: Bug 20815 - Add NoRefundOnLostReturnedItemsAge system preference Upgrade to 20.06.00.011 done [11:18:10]: Bug 5087 - Add export_format.staff_only Upgrade to 20.06.00.012 done [11:18:10]: Bug 23795 - Convert OpacCredits system preference to news block Upgrade to 20.06.00.013 done [11:18:10]: Bug 23795 - Convert OpacCustomSearch system preference to news block Upgrade to 20.06.00.014 done [11:18:10]: Bug 23797 - Extend the opac_news lang column to accommodate longer values Upgrade to 20.06.00.015 done [11:18:10]: Bug 23797 - Convert OpacLoginInstructions system preference to news block Upgrade to 20.06.00.016 done [11:18:11]: Bug 23092 - Add 'daterequested' field to transfers table Upgrade to 20.06.00.017 done [11:18:11]: Bug 25709 - Rename systempreference to NotesToHide Upgrade to 20.06.00.018 done [11:18:11]: Bug 24157 - Add new permissions reopen_closed_invoices, edit_invoices, delete_invoices, merge_invoices, delete_basket Upgrade to 20.06.00.019 done [11:18:11]: Bug 22660 - Adds NewsToolEditor system preference Upgrade to 20.06.00.020 done [11:18:11]: Bug 26070 - Remove references to deprecated Google Transliterate API Upgrade to 20.06.00.021 done [11:18:11]: Bug 25871 - Add library option to OpacItemLocation Upgrade to 20.06.00.022 done [11:18:17]: Bug 21946 - Add parent type to itemtypes Configuration not defined at /usr/share/perl5/Log/Log4perl/Config.pm line 579. dpkg: error processing package koha-common (--configure): installed koha-common package post-installation script subprocess returned error exit status 11 Errors were encountered while processing: koha-common E: Sub-process /usr/bin/dpkg returned an error code (1) ---------- snip end ----------------------------- I have not been able to figure out where this failure is actually occurring, but it seems to be a problem with the database structure. Any help would be greatly appreciated. Scott

2 2

Koha 19.11.13 released
by Victor Grousset/tuxayo 06 Jan '21

06 Jan '21

Hello! The Koha Community is happy to announce the release of Koha 19.11.13 The full release notes can be found at: https://koha-community.org/koha-19-11-13-released/ Debian packages will be available shortly. Thanks to everyone involved :) Cheers, -- Victor Grousset/tuxayo _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Release of Koha 20.11.01
by Fridolin SOMERS 06 Jan '21

06 Jan '21

Hello everyone 🤗 The Koha community is proud to announce the release of Koha 20.11.01. It is a maintenance release including 45 bugfixes. The full release notes are available here: https://koha-community.org/koha-20-11-01-released/ Debian packages should be available in a few days! 💡 Remember Git repo as moved to : https://git.koha-community.org/Koha-community/Koha.git A great and heathy new year to you all, let's hope we can go IRL again 🍻 Best regards 🐌 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0

Report help needed
by Elaine Bradtke 05 Jan '21

05 Jan '21

I'm trying to find records lacking 300 fields. The following keeps failing. Any help would be appreciated. Thanks! SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber= ',biblionumber,'\">',biblionumber,'</a>') AS bibnumber FROM (SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="a"]') AS suba, ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="b"]') AS subb, ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="3"]') AS sub3, FROM biblio_metadata) AS subfields WHERE suba = "" AND subb = "" AND sub3 = "" Elaine Bradtke VWML <https://www.vwml.org> Our income is severely diminished in these exceptionally uncertain times. Please help us to survive beyond this national crisis. Donate now <https://www.efdss.org/support-us>. 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 3

Re: [Koha] Koha 20.05 - Adding a description meta tag to <head>
by Craig Butosi 04 Jan '21

04 Jan '21

Hi all, The jquery wasn't picked up by Google; however, I upgraded to 20.11 and took advantage of the new syspref that allows you to insert a meta description in Opacusercss. It was picked up by Google after a few days. Yay! Craig Butosi, MA, MLIS, BMus Hons. Library: library.craigbutosi.ca On Mon, Jan 4, 2021, 3:06 PM Craig Butosi <cbutosi(a)gmail.com> wrote: > Hi all, > > The jquery wasn't picked up by Google; however, I upgraded to 20.11 and > took advantage of the new syspref that allows you to insert a meta > description in Opacusercss. It was picked up by Google after a few days. > Yay! > > C > > Craig Butosi, MA, MLIS, BMus Hons. > Library: library.craigbutosi.ca > > On Mon, Jan 4, 2021, 1:11 PM Elaine Bradtke <eb(a)efdss.org> wrote: > >> Just curious what the result was. I'm interested in trying it myself. >> We just got a 'no description' flag on two catalogue records (out of >> thousands). The working theory is it's really flagging the whole catalogue, >> but the bot only looked at two records. >> Elaine >> VWML <https://vwml.org> >> >> >> >> On Sun, Jun 21, 2020 at 10:30 AM Craig Butosi <cbutosi(a)gmail.com> wrote: >> >>> Hi Alvaro, >>> >>> Thank you for this. Wasn't sure if a jquery stanza would be picked up by >>> Googlebot or not. I'll do something like, >>> >>> //Insert description meta tag in <head> >>> $(head).append('<meta name="description" content="{description of content >>> here}" />'); >>> >>> in OpacUserJS and see what happens. >>> >>> Many thanks, >>> >>> Craig Butosi, MA, MLIS, B Mus (Hons) >>> Library: library.craigbutosi.ca >>> >>> >>> On Sun, Jun 21, 2020 at 1:14 PM Alvaro Cornejo <cornejo.alvaro(a)gmail.com >>> > >>> wrote: >>> >>> > Hi Craig >>> > >>> > You can do it either way >>> > >>> > However, it is always better to avoid modifying koha code to avoid >>> > conflicts when upgrading/updating koha versions. >>> > >>> > Regards, >>> > >>> > Alvaro >>> > >>> > >>> > >>> |----------------------------------------------------------------------------------------| >>> > Stay safe / Cuídate/ Reste sécurisé >>> > *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur >>> et à >>> > mesure. >>> > *q *Recycle always / Recicla siempre / Recyclez toujours >>> > P Print only if absolutely necessary / Imprime solo si es necesario / >>> > Imprimez seulement si nécessaire >>> > >>> > >>> > Le dim. 21 juin 2020 à 11:06, Craig Butosi <cbutosi(a)gmail.com> a >>> écrit : >>> > >>> >> Hi all, >>> >> Running Koha 20.05 on Ubuntu 18.04 (Bionic). >>> >> >>> >> I was interested in adding a description meta tag in my instance of >>> >> Koha for Google indexing reasons. It looks like the included meta >>> >> tags as part of a Koha package install are located here: >>> >> >>> >> >>> /usr/share/koha/htdocs/opac-tmpl/bootstrap/en/includes/doc-head-close.inc >>> >> >>> >> Would it be better to inject the description meta tag using a jQuery >>> >> stanza in OpacUserJs, or edit the doc-head-close.inc file directly? >>> >> >>> >> Many thanks, >>> >> >>> >> Craig Butosi, MA, MLIS, B Mus (Hons) >>> >> Library: library.craigbutosi.ca >>> >> _______________________________________________ >>> >> >>> >> Koha mailing list http://koha-community.org >>> >> Koha(a)lists.katipo.co.nz >>> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> >>> > >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >>

1 0

koha-US January 2021 Meetings & Events
by Jason Robb 04 Jan '21

04 Jan '21

koha-US online meetings and events are free and open to all. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus See our calendar for a full list: http://koha-us.org/calendar/ *Meetings* Board Meeting - Wednesday, January 6th @ 8:30a PT / 11:30a ET / 4:30p UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/15J5J3eEa6P_73-RfIcMa1Zzb5lEZogTXSgJbQoG… General Meeting - Wednesday, January 13th @ 8:30a PT / 11:30a ET / 4:30p UTC *Special Interest Groups* Cataloging - Thursday, January 7th @ 8:00a PT / 11:00a ET / 4:00p UTC System Administration - Tuesday, January 12th @ 9:00a PT / 12:00p ET / 5:00p UTC User Services - Monday, January 18th @ 12:00p PT / 3:00p ET / 8:00p UTC Acquisitions - Tuesday, January 19th @ 9:00a PT / 12:00p ET / 5:00p UTC Web Development - Thursday, January 21st @ 10:00a PT / 1:00p ET / 6:00p UTC Books & Crafts - Wednesday, January 27th @ 5:00p PT / 8:00p ET / 1:00a UTC Special interest groups strive to encourage discussion on specific modules and areas of Koha. Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topics that interest you! Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Plugin for place of Publication
by Himanshu Aggarwal 01 Jan '21

01 Jan '21

Is there any way that one can search for Place of Publication as we can do using the plugin for 260$b that is for Publisher -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)

2 1

Koha Community Newsletter: December 2020
by Koha Newsletter 01 Jan '21

01 Jan '21

Happy New Year! The Koha Community Newsletter for December 2020 is here: https://koha-community.org/koha-community-newsletter-december-2020/ Many thanks to everyone who submitted articles and news to last month's newsletter. Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Searchable list archive?
by Bales (US), Tasha R 30 Dec '20

30 Dec '20

Good afternoon, in order that I can best help myself to answer questions, and avoid annoying others, I just want to ask if there is a searchable archive for this Koha list, or a way to accomplish the same. I find I just have to go month by month (at https://lists.katipo.co.nz/pipermail/koha/) and scan subjects to try to find information. Perhaps I've missed something. Note, the following link to "search through the mailing list archive" (per my initial mailing list welcome) fails to open, with an Error 522: http://dir.gmane.org/gmane.comp.misc.koha Thanks for your time! Tasha R. Bales | Technology Integration Team Information Services | Enterprise Services Enterprise Operations, Finance and Sustainability (480) 509-5415 https://is.web.boeing.com

4 3

Need help regarind adding search option in 260a and b
by Himanshu Aggarwal 30 Dec '20

30 Dec '20

Can someone please help how to activate a search option in 260$a and b by using plugins? -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)

2 1