- Koha - lists.katipo.co.nz

Failed to upgrade koha 3.09.00050
by A.K.M. Nurul Alam 11 Nov '22

11 Nov '22

Dear Community,I am trying to upgrade koha 3.09.00050. Since it's very old version, I installed Koha 16.05 and run upgrade command. It shows failed message like mentioned at the bottom of this message. I have manually deleted 'aqinvoices' table and inserted 'booksellerinvoicenumber' under 'aqorders' table. It works fine and upgraded successfully to 16.05 version. But while exporting to marc file, a number of record is found missing. Now, what is the best way to upgrade this ancient version of Koha 3.0.00050? And if my way was correct, how to export all marc data? Thank you. Nurul Alam Failed message:sudo koha-upgrade-schema library Upgrading database schema for library DBD::mysql::db do failed: Table 'aqinvoices' already exists [for Statement " CREATE TABLE aqinvoices ( invoiceid int(11) NOT NULL AUTO_INCREMENT, invoicenumber mediumtext NOT NULL, booksellerid int(11) NOT NULL, shipmentdate date default NULL, billingdate date default NULL, closedate date default NULL, shipmentcost decimal(28,6) default NULL, shipmentcost_budgetid int(11) default NULL, PRIMARY KEY (invoiceid), CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5915. DBD::mysql::st execute failed: Unknown column 'aqorders.booksellerinvoicenumber' in 'field list' [for Statement " SELECT aqorders.booksellerinvoicenumber AS invoicenumber, aqbasket.booksellerid, aqorders.datereceived FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno WHERE aqorders.booksellerinvoicenumber IS NOT NULL AND aqorders.booksellerinvoicenumber != '' GROUP BY aqorders.booksellerinvoicenumber "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5940. Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.

1 0

Poll for a patch testing session to help enhancements and bug fixes to be released
by Victor Grousset/tuxayo 11 Nov '22

11 Nov '22

Hi :) To be forwarded to librarians, system librarians, educators, devs, sysadmins and other people that could be interested in contributing to Koha. Here is the poll: https://date.chapril.org/lauHXUSh6dcAV865 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

Ideas wanted for cataloging QA utilities
by Bales (US), Tasha R 10 Nov '22

10 Nov '22

Good morning, I'm interested to know if anyone has developed tools to help copy catalogers quality check their work in real time. For example, at a long-ago conference, I saw a librarian present Windows batch scripts they'd created to check cataloging in Millennium. I don't recall the specifics, but for my purposes, I'd be interested in doing checks such as the following: * Compare 260 to 008 * Check for the presence or absence of important fields in both bib and item record * Check for agreement between item type and notforloan value I could do the above with SQL, but I'm trying to get closer to first-time quality by catching the errors as they occur (maybe I could use jQuery to link a prebuilt report that would check the bib I'm currently viewing?). Options might be Jupyter notebooks, or jQuery. This is my first time working with a staff client that is a web application, so I'm not sure what is realistically possible or what anyone has already come up with (Google is not helping). Any food for thought is welcome. Even if I only "caught" errors such as impossible publication dates (e.g., 2039, 202, etc.), that would be a help. Thanks for your time and consideration, Tasha Bales

3 4

Roles for 23.05 + next development IRC meeting
by David Nind 10 Nov '22

10 Nov '22

"Today's" development IRC meeting was not held/postponed - on the agenda was voting on roles for 23.05. This means that: - The voting on roles for 23.05 will now take place at the Development IRC Meeting now rescheduled for 16 November 2022 <https://wiki.koha-community.org/wiki/Development_IRC_meeting_16_November_20…> . - You now have a bit more time to add your interest to the Roles for 23.05 <https://wiki.koha-community.org/wiki/Roles_for_23.05> (see the previous email <https://lists.katipo.co.nz/pipermail/koha/2022-November/058629.html> for more information). David Nind | david(a)davidnind.com New Zealand

1 0

koha-US General Meeting Minutes - November 9, 2022
by Jennifer Marlatt 09 Nov '22

09 Nov '22

Hello, Here's a link to the minutes from the koha-US general meeting today - https://docs.google.com/document/d/1MDOwgaTjFEkvAzq0BubcFH88nxRC0-VOqW_JjYG… koha-US meetings are open to all! General meetings are held on the second Wednesday of each month at 8:30 PT / 9:30 MT / 10:30 CT / 11:30 ET. Jennifer Marlatt koha-US Secretary <secretary(a)koha-us.org>secretary(a)koha-us.org

1 0

koha-US General Meeting reminder: Wednesday, November 9, 2022
by Jennifer Marlatt 08 Nov '22

08 Nov '22

The next koha-US general meeting is *tomorrow, *Wednesday, November 9, 2022 When: 8:30a PT / 11:30a ET / 16:30 UTC (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+March+Gen…> ) Where: https://us02web.zoom.us/j/648572897?pwd=TUpsRE1TYlFPWWxTWFl4TVovSTJ3Zz09 Agenda: https://docs.google.com/document/d/1gybDVT1mkB1RALNsFzLM7mMQEaDvrkP_MTENwkG… If you have additional topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Jennifer Marlatt koha-US Secretary secretary(a)koha-us.org

1 0

KOHA not getting install old or new version
by shailendra arora 08 Nov '22

08 Nov '22

I have formatted the pc and installed ubuntu and followed all the process but koha is not getting installed, not even creating a koha directory. I somehow installed koha on vm on laptop after lots of trying but now I am trying to install a fully formatted system PC but it is not happening. some perl file showing issue but perl is installed and updated too. Thank's & Regards Shailendra Arora *( 3D Artist ,Modeler, 3D Animator , Designer,Instructor, PhotoGrapher )* e-mail:- *shailendraarora3d(a)gmail.com <shailendraarora3d(a)gmail.com>* Mobile :- *9887503892*

4 5

Error with installing koha with docker
by Mathieu Saby 07 Nov '22

07 Nov '22

Hi I am trying to install Koha with docker on a Ubuntu 22.04 machine I have followed the instructions at https://gitlab.com/koha-community/koha-testing-docker/-/tree/master but the "ktd up" command gives me an error, and Koha fails to run. Could someone please give me some advice ? The error : koha-koha-1 | Cannnot open file No such file or directory at /kohadevbox/misc4dev/cp_debian_files.pl line 35. koha-koha-1 exited with code 2 The git repo for koha testing docker is downloaded in a /home/msaby/projets/koha-testing-docker my ~/.bashrc contains : export PROJECTS_DIR=/home/msaby/projets export SYNC_REPO=$PROJECTS_DIR/koha export KTD_HOME=$PROJECTS_DIR/koha-testing-docker export PATH=$PATH:$KTD_HOME/bin export LOCAL_USER_ID=$(id -u) Regards, -- Mathieu Saby

3 5

Koha OPAC login
by Ravinder Pallikonda 07 Nov '22

07 Nov '22

Hi there How do you know if a patron has logged into Koha OPAC (not doing any transactions), either through log files or any other method. Any suggestions please. Thank you & regards Ravi ________________________________ DISCLAIMER: This email and any attachments may contain information that is confidential and subject to legal privilege. If you are not the intended recipient, any use, dissemination, distribution or duplication of this email and attachments is prohibited. If you have received this email in error please notify the author immediately and erase all copies of the email and attachments. The Ministry of Education accepts no responsibility for changes made to this message or attachments after transmission from the Ministry.

3 3

Koha 20.05 error rebuilding Zebra biblio indices
by Curt & Penny Murley 07 Nov '22

07 Nov '22

Hi Koha Discussion List, Introduction ============ My name is Curt Murley and I provide tech support for a small public library in Casco, ME USA. We are a long time Koha user starting with Koha 2.2 in 2007. Environment =========== Our production server is running Koha 20.05.18 installed from a Debian package on Debian Stretch. I have set up a new backup server running Debian Buster using the 20.05.x Debian package and loaded it using a mysqldump from the production server. With the exception of catalog searches the backup server seems to run fine, however the catalog cannot be searched. Problem ======= When I try to rebuild the zebra indices using #/sbin/koha-rebuild-zebra -f -v -b cpl (cpl is the instance name) I get the following error and of course the Zebra biblios indices are not rebuilt. I get the same error for authorities but the authorities indices are rebuilt. Error ===== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/cpl/biblios Zebra authorities directory = /var/lib/koha/cpl/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/cpl/rebuild/rebuild..LCK Use of uninitialized value $biblionumbertagfield in concatenation (.) or string at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 219. Use of uninitialized value $biblionumbertagsubfield in concatenation (.) or string at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 219. BIBLIONUMBER in : $ Use of uninitialized value $biblioitemnumbertagfield in concatenation (.) or string at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 220. Use of uninitialized value $biblioitemnumbertagsubfield in concatenation (.) or string at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 220. BIBLIOITEMNUMBER in : $ ================================ Then for every biblionumber exported the following error occurs: error retrieving biblio N at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 681 Additional Information ====================== 1) I have checked that both kohafield='biblio.biblionumber' and kohafield='biblioitems.biblioitemnumber' have the correct values in the marc_subfield_structure table for all the framework codes in the cpl instance, i.e. 999c and 999d. 2) I have checked the cpl Koha logs in /var/log/koha/cpl and found nothing that will help me solve this problem. Question ======== Does anyone have any ideas how to fix this?

2 1