- Koha - lists.katipo.co.nz

koha-US General Meeting Minutes for Wednesday, June 05, 2024
by Kristi Krueger 06 Jun '24

06 Jun '24

Hello, Here's a link to the minutes from the koha-US General Meeting held on Wednesday, June 05, 2024- https://docs.google.com/document/d/1PtN5gTK_bAUcCEGXqFKM6QZ4fomzfpTbGU6ZFmJ… The recording for the general meeting has been posted; there's a link to the recording in the minutes. koha-US meetings are open to all! The next general meeting will be on Wednesday, 03 July, 2024 at 8:30 am PT / 9:30 am MT / 10:30 am CT / 11:30 am ET. The next board meeting will be on Wednesday, 08 May, 2024 at 8:30 am PT / 9:30 am MT / 10:30 am CT / 11:30 am ET. Kristi Krueger koha-US Secretary secretary(a)koha-us.org

1 1

koha-US General Meeting reminder: Wednesday, June 05 , 2024
by Kristi Krueger 30 May '24

30 May '24

Hello! The next koha-US General Meeting is Wednesday, June 05, 2024. When: 8:30a PT / 11:30a ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) Where*: https://us02web.zoom.us/j/648572897?pwd=TUpsRE1TYlFPWWxTWFl4TVovSTJ3Zz09 Agenda: https://docs.google.com/document/d/1zorjkZ3IUJWW6ahTyIxd76hH9s6_lxGiPVGp_LO… ***Our guest speaker in June will be Andrew Auld, the Commercial Director of PTFS Europe. He will be joining us to discuss the increase in PTFS' role in development work in partnership with PTFS Europe, as well as the development priorities for United Kingdom libraries using Koha.*** 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. Kristi Krueger koha-US Secretary secretary(a)koha-us.org *If you have bookmarked the zoom link in your calendar, you may need to update to the link above.

1 0

Re: [Koha] Database increment error returned 23.11
by Katrin Fischer 30 May '24

30 May '24

Hi, I didn't realize that it was the same installation/library. What I was trying to find out with the test was if this was the old issue or a new one. If the test didn't result in a doubled up itemnumber, this might be something else. Maybe someone else has an idea how this could happen. As the itemnumber is set by the database, I am not sure how it's possible. Re-adding the mailing list. Katrin On 30.05.24 17:00, City & Guilds of London Art School Admin wrote: > Hi Katrin, > > /> in this case I think it would be good to have the exact Koha > version and the DBMS version.../ > > I begin my email with that information. > > /> resetting the PK counters on MySQL restart might be good. > / > > Do you mean resetting the auto increment count? > > /> What you can do.../ > > Yes, I can test that the documented fix works as you decribe, but > that's not the concern either Christina or myself have raised. Which > is more about understanding why the issue has re-occured in an > installation with that fix applied following an update, and > understanding if that documented fix is still relevant. > > All the best, > > Chris > > > On Thu, May 30, 2024 at 1:37 PM Katrin Fischer > <katrin.fischer.83(a)web.de> wrote: > > Hi Chris, > > in this case I think it would be good to have the exact Koha > version and the DBMS version to be able to investigate further. > > Also verifying if the script does what it's supposed to - > resetting the PK counters on MySQL restart might be good. > > What you can do: > > * Create an item, note the itemnumber > * Delete it > * Restart MySQL > * Create a new item > * Verify the itemnumber - if it's the same as the deleted item, > something is not right yet. > > Hope that helps, > > Katrin > > On 30.05.24 14:27, City & Guilds of London Art School Admin wrote: >> Hi Katrin, >> >> These points are addressed in the email Christina sites: >> https://lists.katipo.co.nz/public/koha/2023-December/060411.html >> >> The problem is exactly recurrence of the issue, after the fix >> described in the Wiki had been applied, and with a more recent >> version of the db. >> >> All the best, >> >> Chris >> >> >> On Thu, May 30, 2024 at 1:12 PM Katrin Fischer >> <katrin.fischer.83(a)web.de> wrote: >> >> Hi Christina, >> >> did you see the wiki page about the issue? >> >> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix >> >> It should only appear with certain older versions of DBMS. So >> this would >> be a first thing to check. >> >> If you happen to use one of the older versions, maybe >> consider updating. >> Otherwise you will have to implement the script described in >> the wiki. >> >> Hope this helps, >> >> Katrin >> >> On 28.05.24 10:00, Fairlamb, Christina wrote: >> > Morning, >> > >> > I just upgraded to 23.11 today and have come across the >> same issue as >> > another user back in december. >> > >> > Database discrepancy flagged after Koha upgrade: >> > >> > >> https://lists.katipo.co.nz/public/koha/2023-December/060411.html >> > >> > I've done the same routine as the last time this cropped up a >> > few major versions ago and I've deleted the entries in the >> > deletedbiblioitems table, but I'm also worried that this >> issue is back. >> > >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>

1 0

Staff client not showing holdings
by Beda Szukics 30 May '24

30 May '24

Hi If I display a record in the staff client the data oft he holdings are not displayed (the number of holdings are shown). Koha version 25.04 Greetings Beda

1 0

The new cataloging feature (Record sources)
by Sami M. Rasheed 30 May '24

30 May '24

Dears, Hello To test the new cataloging feature (Record sources), we upgraded Koha from 23.11 to 24.05; unfortunately, clicking on Record source redirects users to the Search System preferences page. Regards.

2 2

404 Error after upgrading to 25.04
by Beda Szukics 30 May '24

30 May '24

Hi After Upgrading to 25.04 I get a strange error: Selecting an entry in a list of results the record is displayed but a small window pops up on top oft he record displayed: Something went wrong when loading the table. 404: Not Found. But I can work on the record and there is no other problem. This happens only in the staff interface. The opac is not affected. Greetings Beda

2 3

koha opac custom interfaces
by George Mikuchadze 30 May '24

30 May '24

Dear colleagues, I am searching for visually attractive and useful OPAC custom interfaces. Can someone please share the URL(s) of such sites? Many thanks for considering my request. George Mikuchadze

3 3

Re: [Koha] 404 Error after upgrading to 25.04
by Katrin Fischer 30 May '24

30 May '24

Hi Beda, it means that the REST API in general is not working for you. Maybe this is a good starting point for you: https://wiki.koha-community.org/wiki/REST_API_Debug Hope it helps, Katrin On 30.05.24 15:12, Beda Szukics wrote: > Hi Katrin > > Can you verify: > > * Does the table of libraries on Administration > libraries load correctly for you? > No > > * Does patron search work? > No > > * If you can check: is there an error in the logs when you load a record detail page? > plack.log has an entry: > > 195.39.250.59 - - [30/May/2024:15:08:12 +0200] "GET /intranet/catalogue/detail.pl?biblionumber=4570 HTTP/1.1" 200 139788 "https://musikbibliotheksverwaltung.muri-gries.it/cgi-bin/koha/tools/invento…" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0" > 195.39.250.59 - - [30/May/2024:15:08:14 +0200] "GET /api/v1/app.pl/api/v1/biblios/4570/items?&_page=1&_per_page=20&_match=contains&_order_by= HTTP/1.1" 404 - "https://musikbibliotheksverwaltung.muri-gries.it/cgi-bin/koha/catalogue/det…" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0" > > Does this help? > > Beda >

1 0

Database increment error returned 23.11
by Fairlamb, Christina 30 May '24

30 May '24

Morning, I just upgraded to 23.11 today and have come across the same issue as another user back in december. Database discrepancy flagged after Koha upgrade: https://lists.katipo.co.nz/public/koha/2023-December/060411.html I've done the same routine as the last time this cropped up a few major versions ago and I've deleted the entries in the deletedbiblioitems table, but I'm also worried that this issue is back. -- Christina

3 3

Failed update to Koha 24.05.00: Unknown column 'item_id' in 'bookings'
by Michael Kuhn 30 May '24

30 May '24

Hi I just tried to update my Koha demo installation from 23.11.00 to 24.05.00 but the process failed with the following message: Upgrade to 23.12.00.044 [13:48:09]: Bug 36120 - Add pickup location to bookings ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Unknown column 'item_id' in 'bookings' at /usr/share/koha/lib/C4/Installer.pm line 741 How can this problem be solved? In Koha 23.11 the new table "bookings" looks as follows: MariaDB [koha_koha]> describe bookings; +----------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+----------------+ | bookingid | int(11) | NO | PRI | NULL | auto_increment | | borrowernumber | int(11) | NO | MUL | NULL | | | roomid | int(11) | NO | MUL | NULL | | | start | datetime | NO | | NULL | | | end | datetime | NO | | NULL | | | blackedout | tinyint(1) | NO | | 0 | | +----------------+------------+------+-----+---------+----------------+ But https://schema.koha-community.org/23_11/tables/bookings.html shows a quite different configuration using some different column names. There ist no https://schema.koha-community.org/24_05/tables/bookings.html yet. For now I have rolled back the snapshot I have taken before trying the update. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

1 0