Time Nick Message
06:08 liliputech_asu welcome back fridolin :)
06:08 fridolin yoooooo
06:08 fridolin thanks liliputech_asu ;)
06:08 fridolin I'm a little bit rusty
06:09 liliputech_asu u'r welcome! that's why vacation are for ;) hope you had good time :)
06:36 marcelr hi #koha
06:45 * magnuse waves
06:45 * cait waves
06:45 marcelr o/
06:45 cait on trains today and on Thursday, training a library in between
06:46 cait and not sure I will get the QA email out before I got to leave.... maybe later today
06:47 marcelr no worries :)
06:48 cait just shouting into the room, bit frenzy with packing :)
06:51 cait bye all
07:02 alex_a bonjour
08:55 janPasi bugs.koha-community.org certificate has expired on saturday
09:41 fridolin ld
11:20 oleonard Hi #koha
11:31 kidclamp hi oleonard
11:31 wahanui hi oleopard
11:32 oleonard Hi kidclamp. Is it back-to-school time for you?
11:32 kidclamp Tomorrow
11:32 wahanui i think Tomorrow is the hard part - serials and acq
11:33 kidclamp we had an end of summer party last night, the kid gets to enjoy his last sleep in today
11:33 * oleonard feels for the poor guy
11:33 oleonard This is my kids' third day back
11:34 kidclamp how are they taking it?
11:35 oleonard Pretty well. My son started middle school, so that was anxiety-provoking. But so far so good
11:39 kidclamp the most awkward of school
11:58 oleonard vagrant status "gurumeditation" :|
12:02 skimsk hi all! im having problems removing a hold on a book. when i click the red x on the books details page to cancel the hold and 'OK' to confirm the cancellation, it drops me to error page saying 'Software error: Duplicate ID'.
12:02 skimsk in 'intranet-error.log' i found a line like this:
12:02 skimsk [cgi:error] ... request.pl: DBD::mysql::st execute failed: Duplicate entry '1' for key 'PRIMARY' [for Statement "INSERT INTO `old_reserves` ...
12:02 skimsk dont know if its related to this, but after the hold was placed, i dist-updated from 18.05 to 19.05 and kept my old 'koha-sites.conf'.
12:03 skimsk can someone give me any advice how to get this working?
12:06 oleonard skimsk: If you go to About -> System information, do you see any warnings there?
12:09 skimsk oleonard: actually there seems to be this: The following ids exist in both tables reserves and old_reserves: 1, 2, 3
12:09 skimsk should i remove them manually using mysql from command line?
12:11 oleonard In short, yes. Here's more: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
12:12 skimsk i did this once for books, not for holds. it was long time ago, but i expect it to go as smooth as last time. thanks for pointing me to right direction!
12:13 skimsk i report back once i had tried it! :)
12:18 magnuse that problem has nothing to do with the upgrade
12:23 oleonard magnuse: Is that important to know when looking for a solution?
12:25 magnuse nah, just saying
12:26 magnuse well, and indirectly it kind of has. the autoincrement problem occurs when mysql is restarted, and it was probably restarted because of the upgrade?
12:26 oleonard Anyone around who wants to give an opinion about my last comment on Bug 23501?
12:29 magnuse oops, cert on bugzilla expired
12:42 oleonard makes git bz problematic to say the least
13:28 skimsk oujeah!! i got the holds system working! just deleted the conflicting entries from old_reserves table like oleonards link suggested
13:29 skimsk thanks for help with that! also thanks for verifying that the problem was not with the old configs and update
13:29 skimsk you are the best! :)
13:35 oleonard Glad to hear it working skimsk
13:41 tcohen morning
13:41 tcohen magnuse: any clues on how to fix the thumbnails problem?
14:05 skimsk hmm.. now i noticed that my problem didnt quite vanish yet.. there is still two entries in holds queue, that i cant find from reserves or old_reserves. these dont show as reserved in the items details page or anywhere in gui where i could delete them... :/
14:06 skimsk there is no warnings in system information tab
14:06 cait holds queue gets regernated every hour
14:06 cait by a cronjob
14:06 skimsk aah.. oke that explains, thanks again!!
14:06 cait well every hour by default if you haven't changed it
14:07 cait so it might still have the data in its temporary tables - in theory that shoudl clear up by itself
14:07 skimsk ok. i'll wait. thanks
14:11 oleonard Hi cait
14:11 cait hi oleonard :)
14:38 wizzyrea gmaharlt, about?
14:38 talljoy or gmcharlt?
14:38 wahanui i heard gmcharlt was usually lurking much earlier.. hense ashimema's pointing him out
14:38 gmcharlt talljoy: what's up?
14:39 talljoy Wizzyrea has a question re security cert
14:39 talljoy https://bugs.koha-community.org
14:40 wizzyrea yes I do :)
14:40 wizzyrea do you have access there looks like letsencrypt didnt renew
14:41 gmcharlt I do; taking a look now
14:41 wizzyrea gmcharlt++
14:41 wizzyrea oarsome thank you
14:45 oleonard <emoji src="🚣â€â™€ï¸" alt="Woman Rowing Boat" />
14:47 gmcharlt wizzyrea: talljoy: I've updated the certs for bugs.*, splitter.*, and dashboard.*
14:48 oleonard Splitter is working again??
14:49 gmcharlt oleonard: dunno about fully working, but the website is at least up
14:49 oleonard :)
14:53 wizzyrea gmcharlt++ thank you ever so much
14:53 talljoy Thanks!
14:56 tcohen gmcharlt++
15:39 oleonard Anyone around who wants to give an opinion about my last comment on Bug 23501?
15:39 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23501 enhancement, P5 - low, ---, koha-bugs, ASSIGNED , Drag-and-drop hold reordering in the staff client
15:57 wizzyrea oleonard, what about something like the sysprefs have
15:57 wizzyrea (modified)
15:57 wizzyrea to remind you to save
15:57 wizzyrea the wording would be the same as the sysprefs if you tried to navigate away, people will get that
15:58 oleonard I don't think that would work visually inside the table...
15:58 oleonard (I'm also hung up on the fact that technically more than one hold has probably changed priority, but that's pedantic I guess)
16:08 oleonard wizzyrea: This is where I'm at right now: https://zivotdesign.com/p/view.php?p=15668356947248
17:52 kidclamp could you use the API to update the hold immediately oleonard ?
17:52 kidclamp then you wouldn't need the text
17:53 kidclamp http://localhost:8081/api/v1/.html#op-put-holds--hold_id-
17:53 oleonard I did some tests of that over the weekend and it was promising
17:53 oleonard Then I got distracted playing around with DataTables' rowReorder plugin, but that hit a dead end
17:53 oleonard (currently using jQueryUI's Sortable)
17:53 kidclamp that being said, I think the text is fine the way it is
17:54 * kidclamp would buy you a beer forjsut getting thwe drag and drop working, using the API upgrades you to a scorpion bowl
17:55 * oleonard does love himself a bowl full of scorpions
18:00 oleonard kidclamp: Do you happen to know if you can delete a hold through the API the same way?
18:01 kidclamp http://localhost:8081/api/v1/.html#op-delete-holds--hold_id-
18:01 kidclamp it should be possible
18:02 kidclamp that's on master
18:02 oleonard I can't seem to get that link working in my system
18:04 kidclamp kohadevbox? or testing docker?
18:04 oleonard devbox
18:04 kidclamp I wonder if some config files need updating
18:04 * kidclamp summons tcohen
18:05 * oleonard has probably been through this before...
18:05 * kidclamp runs away for now :-)
18:06 tcohen hi kidclamp
18:07 tcohen oleonard: DELETE /api/v1/holds/{hold_id}
18:07 tcohen oleonard: point your browser to http://localhost:8081/api/v1/.html
18:09 oleonard Sorry I'm pretty sure I've asked you all this before.
18:09 oleonard "client denied by server configuration: /usr/share/koha/api/v1/.html"
18:15 tcohen is plack enabled?
18:15 tcohen that's weird!
18:15 tcohen use the same FQDN you usually use?
18:17 oleonard For the staff client, yes
18:18 oleonard plack is enabled
18:25 oleonard It works on our production system (18.11.08) so I can look there tcohen
18:25 tcohen awesome!