Time Nick Message 07:49 cait tuxayo: the follow-up on bug 34833 - not sure htat is right 07:49 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34833 trivial, P5 - low, ---, katrin.fischer, Failed QA , "order number" untranslatable when editing estimated delivery date 07:49 cait we need a space 07:50 cait th eorder number appears after some other text - it't not standalone information 07:50 cait oooh I see it now 07:50 cait I miss a delete functio here for senseless first thing in the morning comments :) you ARE right! tuxayo++ 08:03 * cait has tea now, it might help 08:16 ashimema lol 08:24 PedroAmorim[m] \o 08:34 cait welcome back PedroAmorim[m] 08:34 cait cn you take over for me now? 10:23 oleonard o/ 10:56 magnuse \o 11:00 * cait waves at magnuse and oleonard 11:25 tcohen[m] o/ 11:34 * cait waves 11:34 anke_b[m] cait: 👋 11:35 anke_b[m] (still getting used to the app...) 11:36 * cait waves back (I don't see some smileys in my client, but assume it was a wave) :) 11:52 anke_b[m] It was :-) 11:53 anke_b[m] Now for a question re Koha: Are parts or traces of invoices somewhere else than in aqinvoices? (I have to remove some test invoices directly from the database; had a similar issue with orders recently.) 11:54 cait the invoicenumber is in aqorders - if the invoice is empty (no linked orders) you shoudl beok 11:55 cait hm invoice adjustments, I think, will delete automatically with the invoice (maybe something to check) 11:57 cait bug 34904 11:57 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34904 minor, P5 - low, ---, oleonard, NEW , Shelf browser not accessible when record has a subscription 12:54 aw-bib[m] Hi! I am currently migrating loan data and run into an issue with `renewals_count` from https://schema.koha-community.org/23_05/tables/issues.html I see this is defined as `TINYINT` and it seems to be signed tiny int. Now we have a pretty liberal loan policy (stuff does keep coming back) here on campus so I have a number of items with > 127 renewals... any idea how to handle that? 12:54 aw-bib[m] btw: @cait wrt `koc` as discussed the other day - this is no path indeed, as it basically kills the systems ui. and if I'dd have to write some cli to it, sql is easier indeed. 13:04 cait aw-bib[m]: interesting about the renewals 13:05 cait especially since the GUI probably allows like 999 - maybe worth writing a bug 13:09 aw-bib[m] as of now we just have no limit on renewals. but indeed I'll have to check into this. maybe there is somethign fishy on the old system. 13:09 aw-bib[m] for the koc: I am not sure if it is only the number of items in the list it starts running but no page ever shows up. it may just be that creating it takes to long and gets killed. (but I admit, I threw some 15k at it. most likely beyond the specs of offline circulation ;) 13:17 Shane-NP[m] Not sure how to do this...and I am fine making an SQL line...just not sure where this would originate...so basically, I want to remove ALL non-computers from the Koha DB. I have about 6000 entries, and about 1500 of those are laptops or tablets. When I check the mark records the laptops all have 942c field "Laptop Computers" or "Tablet Devices". Any starting point on how I can do something like remove * from x,y,z, where 942c!="" or 942c!="" 13:17 Shane-NP[m] ? I know that was kind of bad pseudo code 13:18 Shane-NP[m] All that I want to keep^ 13:19 cait sorry Shane-NP[m] you confused me a bit there 13:19 cait what doy ou want to do? 13:19 cait Batch delete? 13:19 caroline 942$c is generally mapped to biblioitems.itemtype and it's the code that you have to use 13:19 Shane-NP[m] Remove EVERYTHING except the few items with 942c field with Laptop Computer or Tablet Device as the type 13:20 caroline If you remove directly from the database, I think you'd have to reindex too... If you remove from the interface that is done for you 13:22 Shane-NP[m] Okay....and I am getting pulled away...I will be back to ask how in there ie record or item, or both 13:24 cait I hink i would not remove with SQL 13:24 cait but use the ebatch delete feature 13:24 caroline IIRC, if you delete the biblio, it will cascade down to biblioitems and items 13:24 cait make a list of biblionumbers 13:25 cait using a report and then batch delete from there. 13:25 caroline ^ that is definitely the safest way to do it, but may require more than one batch 13:26 cait eah, about 1000 each go and some patience 13:28 caroline Here's one that I used in the past delete from biblio where biblionumber in (select biblionumber from biblioitems where itemtype = 'XYZ') and biblionumber not in (select biblionumber from issues left join items using (itemnumber)); 13:28 caroline It was very resource intensive because of the multiple selects... probably not the best way to do it, but it worked so... 13:30 Shane-NP[m] okay so it is asking for a file or list...is the file SQL or just a list a biblio numbers? 13:30 caroline a list of biblionumbers, one per line 13:31 Shane-NP[m] alright, so can I get a list from Koha, or use SQL for that? 13:31 Shane-NP[m] I have no idea WHAT numbers there are, just that we have about 5000 books in here I no longer need 13:31 caroline either. I usually go in reports and do select biblionumber from biblio where ... and download the results (or you can delete right from the reports module) 13:33 Shane-NP[m] Okay, let me try that...select biblionumber from biblioitems where itemtype = 'Book' gave me a nice list in Maria 13:33 Shane-NP[m] However, no clue what 1 and 9 even are :P 13:43 cait the biblionumber is the internal primary key 13:43 cait all your records will have that 13:43 cait do you have items on the records? 13:43 cait then you mght want to use the batch item delete first... and it can also delete the record with the item, but I think you can't batch delet the record with the items 13:43 Shane-NP[m] hmm...Books 6672 via Reports on item types, but my SQL only returned 4591 rows, guessing the items on the records 13:44 Shane-NP[m] my SQL was on biblio 13:44 Shane-NP[m] so I guess I will have to start with items 13:47 Shane-NP[m] I did items with no checkouts...that is a long list...but I can't seem to find a export to csv or anything so I can isolate the barcodes 13:48 caroline hm yeah I don't think there is an export option for that one... :/ 13:50 cait you could do it from the item search 13:50 cait i think that exports a nice barcode list and can also limit on checouts 13:51 Shane-NP[m] let me see cause https://wiki.koha-community.org/wiki/SQL_Reports_Library is not listing anything when I searched "no check" 13:51 cait go to Koha > item search (from the start page) 13:51 cait and then at the bottom of the form 13:51 cait set the checkouts to 0 13:52 cait but if you want to do SQL... something like select * from items where onloan is NULL and itemnumber not in (select itemnumber from old_issues) 13:52 cait onloan = currently checked out have a date 13:52 cait and old_issues for previous checkouts 13:52 Shane-NP[m] I like GUI...I can just do SQL if need be :P 13:52 cait btw we urgently need column configuraiton on the item search table 13:53 cait so try the item search one, export barcode list - use that with the item batch delete feature 13:53 caroline is there a bug for that? 13:54 cait caroline: I bet sec 13:54 cait 23565 13:55 caroline it seems to be blocked... 13:57 cait hm odd 13:57 cait oh, not the bug, but the feature? 13:57 caroline I don't know oleonard says it's more complicated than it seems 13:58 caroline not "BLOCKED" status, just blocked :) 13:58 cait probably because it's server side... but doesn't it work on ILL now? 13:58 cait and patron search? 13:58 cait so maybe we got some examples now 13:58 cait hm this is not API driven... 13:58 cait so different I guess thant he other 2 14:14 afr4z[m] magnuse: where do we change the date_renewed of borrowers? 14:15 cait it changes utomatically to today's date when a membership is renewed - it cannot be edited from within Koha 14:15 afr4z[m] no i was referencing a bug 14:15 afr4z[m] uhm 14:15 * afr4z[m] uploaded an image: (155KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/uZjMzCBkQWjzxQgbigLPVrVy/20230925_194530_4185528289583327337.jpg > 14:15 afr4z[m] do i just run tht command on the mysql? 14:16 afr4z[m] im on koha 23.05.03 14:17 afr4z[m] and when i blank search patrons to get all patrons i get a "500 Internal server error : Month out of range" error 14:22 cait ah, you'd need to run that command in the sql client on your server 14:22 cait you can't do updates from within Koha 14:24 afr4z[m] ok cool thanks 14:25 caroline the how-to page isn't removed when I do `ktd down` is that normal or am I doing something wrong? 14:28 emlam caroline - what do you mean by removed? like, from where? 14:28 caroline from my git 14:29 caroline it isn't part of the koha git as far as I know and it's added when I do `ktd up`, but hen it's not removed when I do `ktd down` 14:29 emlam oh! I don't think it's supposed to be removed from your repository...in fact I *think* they might have made it a permanent part of KTD recently, though I'm not 100% sure 14:29 caroline I mean the koha git, not the ktd git 14:30 caroline It interferes with the translation script and I have to manually delete it everytime in order to run gulp po:update bla bla 14:30 caroline I feel like that isn't normal... 14:31 emlam oh, I see 14:31 emlam yeah, that's not great 14:33 emlam sorry, I'm not sure :( 14:33 caroline no worries, I was asking in case someone knew 14:34 caroline I'm a ktd newbie and don't use it that much in favor of my regular install 14:37 emlam yeah, it's definitely a learning curve 14:37 emlam I think Joubu did the how-to stuff, so I'd ask him when he's around 14:39 Shane-NP[m] so when do enqueued job start? 14:41 emlam usually immediately, unless they get backed up 14:41 Shane-NP[m] I am trying to get these books deleted, but my jobs just say NULL/999, NULL/348, and NULL/748, the 999 was first one I did 14:42 * Shane-NP[m] uploaded an image: (39KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/pkMfJJKEoeVRcCWHPMtmXxNw/image.png > 14:44 Shane-NP[m] Maybe a setting or service I have a change or enable? New Install of 23 last week, and I migrated the DB from 18 14:45 emlam hmmm...as far as I know the background job workers should be running automatically 14:46 emlam I'd uncheck "current jobs only" and "only include jobs..." at the top, to see everything and get a sense of whether nothing's running or if Koha is just backed up 14:46 emlam and check the About page for system status / errors as a starting point 14:48 Shane-NP[m] nothing else comes up, and about has no errors, just warning about no Fast Add framework and no encryption key in koha.conf 14:49 Shane-NP[m] would time zone not being set affect it? 14:50 cait hm maybe the thing for long background jobs is not running 14:50 cait can you try a koha-common restart? 14:51 Shane-NP[m] I just did a full server restart 14:54 Shane-NP[m] how do I get back to jobs...I don't see it under admin or reports 14:55 caroline I think you'll have to relaunch the tasks after the daemons or workers or whatever are started... afaik they don't go check in the db for incomplete jobs 14:55 caroline the jobs should be under Administration > Jobs 14:56 Shane-NP[m] somehow I missed that 14:56 Shane-NP[m] ty, and they are listed as finished now 14:56 Shane-NP[m] let me try a new one 14:56 cait if they are listed as isnished - maybe check if they did work after all? 15:01 Shane-NP[m] Seems to have worked, the few barcodes I put in do not return the book's title, and a search for the title returns similar titles not the exact title 15:01 Shane-NP[m] new job worked 15:21 Shane-NP[m] will batch deletion jobs slow the server down a lot? 15:24 Shane-NP[m] never mind on that question issue was WiFi cut out 15:28 Shane-NP[m] So items batch deletion can I overide if the item is checked out? 15:31 cait no, you need to return first 15:31 emlam .nope - that's something we've been wanting too. If it's only a few items you can check them in manually 15:31 caroline There is a new option in batch modification to return them in batch 15:31 cait a way to do returns is setting it to lost in batch edit - but your lost configuration needs to be so that it gets returned when batch edited 15:31 cait oooh right 15:31 cait new thing 15:31 wahanui well, new thing is hte name showing, right? 15:32 emlam ooh neat! I didn't know about that 15:32 caroline I think it's new from 23.05 15:35 Shane-NP[m] Ah okay Thank you, just a few lingering items, I down to 50 from 6.6K 15:37 Shane-NP[m] hmm..2 left but batch deletion says barcode not found 15:38 caroline are there spaces before or after the barcode maybe? 15:38 caroline you could maybe feed them into the tool with the itemnumber instead of the barcode 15:50 Shane-NP[m] I just manually went to each one, deleted the items and then deleted the record after 15:59 cait caroline++ Shane-NP++ 16:03 Shane-NP[m] Yeah! I have a library with no books! How odd to have that, but hopefully the searching will now be bit faster with only 1500 items. 16:05 caroline So you're the IT dept and loan out computers and other materials is that it? 16:07 cait hm search should not be slow with more 16:07 cait not with your numbers at least 16:10 Shane-NP[m] Yep, this is best method I have found 16:11 caroline I have one or two clients who do this also, they don't complain so I assume everything is going well 16:11 Shane-NP[m] Other either have too much information or they can't bulk check in and out with a barcode. They can do a file, but I put a patron barcode on the back along with a serial number as the barcode and it works great 16:11 Shane-NP[m] speaking of...I have to adjust the barcode length.....not sure if it reset with the migration 16:13 Shane-NP[m] Nice software our there called Snipe-IT its open source, but its dependencies made it hard for me to install...and then trying to collect 300-400 devices in 2-3 days is not easy. I hear it got easier with a bulk option but at this point Koha works fine for me. 16:14 Shane-NP[m] I have been doing Koha since...well...I think it was version 3 or 4 before you went to the yearly version model 16:14 caroline yes 3.16 I think? 16:15 cait there never was a 4 - we switched to the year versions before that 16:16 caroline I started just after the switch, with 16.05 16:17 cait not quite 3.2 for me 16:17 Shane-NP[m] well I just know it was before packages, and then you had packages, and then the version changed. 16:18 cait the first library we migrated started on a dev version a bit before it was released as 3.2 16:18 cait it was an adventure ;) 16:18 Shane-NP[m] I was trying to get Evergreen and Koha up and Everygreen worked first, but it required a windows client, Koha was all web-based...so I kept at it and this IRC chat helped me the most :) so I have been on Koha since 16:19 cait Shane-NP[m]: packages were quite a great innovation - we had all different versions of installing Koha there is I think, but very happy with thepackages now 16:19 cait we also looked at both at the beginning, the help I got here also helped a lot :) trying to pay that back since 16:20 cait but time to leave for now :) bye! 16:20 Shane-NP[m] for a do it all admin like me, packages are a life saver, I COULD dive deep...but I never have the time, I am more a get it working, bandage what I can, hope and pray the damn don't break, and then hope I have downtime to circle back and fix the cracks. 16:22 caroline the last of which never happens of course! lol 16:52 kivilahtio Joubu: thanks! <3 17:43 fridolin yellow 18:35 tcohen[m] hi fridolin 18:44 * fridolin waves 18:49 fridolin tcohen any idea on Jenkins Koha_23.05_D11 ? 18:49 fridolin i really dont know how this works ;) 18:49 tcohen[m] oh, right 18:50 tcohen[m] selenium tests are fragile to UI changes 18:50 tcohen[m] I haven't looked at that specific failure 18:50 tcohen[m] D11 is the only 23.05 task on jenkins that runs jenkins 18:50 tcohen[m] that runs Selenium tests I think 18:51 tcohen[m] master is not failing for that particular test 18:51 tcohen[m] so I guess you're missing a follow-up or smth 18:51 tcohen[m] do you pick commits from master, or from BZ? 18:59 fridolin from master 19:00 fridolin gi tcherry-pick 19:00 tcohen[m] ok 19:00 tcohen[m] I cannot check right now 19:00 fridolin no pb 19:00 tcohen[m] and master has its own selenium failure 19:00 fridolin i'll try to monitor it 19:00 tcohen[m] is it random? 19:01 fridolin looks like note 19:01 fridolin not