| Time |
S |
Nick |
Message |
| 00:00 |
|
rangi |
first thing they always do is blame everything except themselves |
| 00:04 |
|
CrispyBran |
I am annoyed with reset_all :/ |
| 01:25 |
|
|
librarian joined #koha |
| 03:26 |
|
|
librarian joined #koha |
| 05:13 |
|
|
OpulentGamer joined #koha |
| 05:27 |
|
|
librarian joined #koha |
| 06:36 |
|
|
calire joined #koha |
| 06:41 |
|
|
fridolin joined #koha |
| 06:42 |
|
fridolin |
hi |
| 06:42 |
|
wahanui |
niihau, fridolin |
| 06:42 |
|
fridolin |
yamaha wahanui |
| 06:53 |
|
|
alexbuckley joined #koha |
| 07:28 |
|
|
librarian joined #koha |
| 07:38 |
|
|
AndrewIsh joined #koha |
| 07:41 |
|
|
reiveune joined #koha |
| 07:42 |
|
reiveune |
hello |
| 07:50 |
|
|
alex_a joined #koha |
| 07:51 |
|
alex_a |
bonjour |
| 07:51 |
|
wahanui |
hi, alex_a |
| 07:59 |
|
|
andreashm joined #koha |
| 08:04 |
|
* andreashm |
waves |
| 08:11 |
|
|
sophie_m joined #koha |
| 08:13 |
|
|
josef_moravec joined #koha |
| 08:20 |
|
|
sophie_m joined #koha |
| 08:21 |
|
magnuse |
\o/ |
| 08:22 |
|
|
dersmon joined #koha |
| 08:30 |
|
dersmon |
is somewhere here who could check if i am right about a bug? or should i just create a report? |
| 08:31 |
|
magnuse |
dersmon: nothing wrong about creating a bug report |
| 08:32 |
|
dersmon |
ok |
| 08:32 |
|
magnuse |
if it isn't a bug after all we can just close ut |
| 08:32 |
|
magnuse |
*it |
| 08:33 |
|
dersmon |
ok |
| 08:39 |
|
josef_moravec |
hello #koha |
| 08:46 |
|
|
paul_p joined #koha |
| 08:51 |
|
|
cait joined #koha |
| 08:52 |
|
magnuse |
hiya josef_moravec paul_p cait |
| 08:52 |
|
* cait |
waves |
| 09:01 |
|
cait |
not really here until after christmas ;) |
| 09:01 |
|
ere |
cait: hi cait-not-here |
| 09:02 |
|
cait |
hi ere :) |
| 09:02 |
|
cait |
how's things? |
| 09:03 |
|
ere |
cait: Not bad :) There's always something to fix, but hey, not running out of work to do can be considered good too :) |
| 09:03 |
|
cait |
:) |
| 09:03 |
|
|
theod joined #koha |
| 09:03 |
|
ere |
cait: How about you? Are you on Holiday or just otherwise not here? |
| 09:04 |
|
cait |
on holiday until after christmas |
| 09:04 |
|
ere |
ok |
| 09:04 |
|
ere |
so you can't just stay away? :D |
| 09:04 |
|
paxed |
@wunder joensuu |
| 09:04 |
|
cait |
not really :) |
| 09:04 |
|
huginn |
paxed: Joensuu, Finland :: Mostly Cloudy :: 27F/-3C | Wind Chill: 17F/-8C | Friday: Cloudy with snow developing late. High 28F. Winds SSE at 5 to 10 mph. Chance of snow 60%. Friday Night: Cloudy. Snow likely late. Low around 25F. Winds SSE at 5 to 10 mph. Chance of snow 40%. |
| 09:05 |
|
cait |
but I do try to do some non-Koha things too |
| 09:05 |
|
ere |
cait: Hope you enjoy your holiday, that's the most important part! |
| 09:05 |
|
cait |
so far, it's pretty great |
| 09:06 |
|
cait |
watching my dad decorating christmas cookies |
| 09:06 |
|
ere |
cait: \o/ |
| 09:07 |
|
cait |
:) |
| 09:15 |
|
andreashm |
hi ere & cait |
| 09:16 |
|
cait |
hi andreashm :) |
| 09:23 |
|
ere |
hi andreashm |
| 09:24 |
|
cait |
ashimema: around? |
| 09:28 |
|
|
librarian joined #koha |
| 09:29 |
|
ashimema |
am now |
| 09:32 |
|
ashimema |
though will be multi-tasking as I'm now in my morning meeting |
| 09:39 |
|
dersmon |
i filed the bug: https://bugs.koha-community.or[…]_bug.cgi?id=21972 |
| 09:39 |
|
huginn |
Bug 21972: major, P5 - low, ---, koha-bugs, NEW , Record matching rule for authorities only works for first 20 authority records |
| 09:40 |
|
|
sophie_m left #koha |
| 09:47 |
|
|
cait joined #koha |
| 09:47 |
|
cait |
ashimema: i am tryin gto make the faq page on the website go away (moved everything good to manual) - but it keeps reappearing |
| 09:47 |
|
cait |
maybe if you have a minute later you can take a look? |
| 09:47 |
|
ashimema |
sure |
| 09:47 |
|
cait |
it's gone... i switch pages and then it shows up in navigation again |
| 09:48 |
|
ashimema |
looks like it's a wordpress plugin |
| 09:48 |
|
cait |
i know, it's also a page |
| 09:49 |
|
cait |
the code for display was in the page, i removed that, and trying to hide the page |
| 09:49 |
|
cait |
https://koha-community.org/wp-[…]t=320&action=edit |
| 09:51 |
|
ashimema |
Private: FAQ |
| 09:51 |
|
ashimema |
does the 'Private' perhaps signify it's there but not published |
| 09:52 |
|
ashimema |
yeah.. logout and I can't see it |
| 09:52 |
|
ashimema |
where was it in the navigation ? |
| 09:53 |
|
ashimema |
under documentation right? |
| 09:53 |
|
ashimema |
I certainly can't see it when not logged in |
| 09:53 |
|
cait |
hm i can stil see it |
| 09:53 |
|
cait |
try switching to another page pleas |
| 09:53 |
|
ashimema |
I can use the google search to find it.. but then if I attempt to go to the page it redirects to the home page |
| 09:53 |
|
cait |
i tried archived first... the private is my second attempt |
| 09:53 |
|
cait |
still shows for me here https://koha-community.org/demo/ |
| 09:54 |
|
cait |
after several reloads |
| 09:54 |
|
ashimema |
oh.. |
| 09:54 |
|
ashimema |
I see now |
| 09:54 |
|
ashimema |
how strange |
| 09:54 |
|
cait |
yah :( |
| 09:56 |
|
ashimema |
I've gone through and selected the 'clear the cache' option on each page.. for me that seems to have done the trick |
| 09:56 |
|
ashimema |
think there was some serverside caching going on |
| 09:56 |
|
cait |
aah |
| 09:56 |
|
cait |
where is that? |
| 09:56 |
|
wahanui |
that is wrong - it's about 1/2 that (about 8C) + raining! |
| 09:56 |
|
ashimema |
still seeing the issue cait? |
| 09:57 |
|
ashimema |
when logged in.. go to the site |
| 09:57 |
|
ashimema |
you'll still have the 'admin bar' at the top.. the far right option of the left menu is 'Delete Cache' |
| 09:57 |
|
ashimema |
I presumed it cleared all of it.. but it looks like it's page specific |
| 09:58 |
|
ashimema |
so I just clicked through each of the top level pages in our menu and did the 'Delete Cache' from there |
| 10:00 |
|
ashimema |
and a general cait++ is needed for all the work you're doing tidying up the docs and websites :) |
| 10:00 |
|
ashimema |
@karma cait |
| 10:00 |
|
huginn |
ashimema: Karma for "cait" has been increased 646 times and decreased 0 times for a total karma of 646. |
| 10:02 |
|
magnuse |
cait++ yeah! |
| 10:02 |
|
magnuse |
@karma |
| 10:02 |
|
huginn |
magnuse: Highest karma: "Joubu" (726), "cait" (647), and "tcohen" (380). Lowest karma: "-" (-44), "failed" (-40), and "ie" (-38). You (magnuse) are ranked 15 out of 894. |
| 10:02 |
|
ashimema |
@karma magnuse |
| 10:02 |
|
huginn |
ashimema: Karma for "magnuse" has been increased 115 times and decreased 0 times for a total karma of 115. |
| 10:02 |
|
* magnuse |
blushes |
| 10:06 |
|
cait |
sorry, got a phone call, reading back now |
| 10:17 |
|
cait |
ashimema++ |
| 10:18 |
|
cait |
i think it works now, everyone who still sees an faq appear somewhere, please let me know :) |
| 10:18 |
|
cait |
outside of the manual |
| 10:18 |
|
cait |
bbiab :) |
| 10:46 |
|
cait |
back |
| 10:49 |
|
cait |
fridolin: is the patch on bug 21560 right? becuase it talks about notices but bug is for reports |
| 10:49 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=21560 major, P5 - low, ---, fridolin.somers, Needs Signoff , Optimize ODS export option for reports |
| 10:50 |
|
fridolin |
cait: yep i should rename bug report |
| 10:50 |
|
fridolin |
maybe just Optimize ODS export |
| 10:50 |
|
cait |
ok :) |
| 10:51 |
|
fridolin |
Bug 21560 |
| 11:29 |
|
|
librarian joined #koha |
| 11:40 |
|
|
calire left #koha |
| 11:54 |
|
josef_moravec |
bug 21560 |
| 11:54 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=21560 major, P5 - low, ---, fridolin.somers, Needs Signoff , Optimize ODS exports |
| 12:12 |
|
cait |
bbl :) |
| 12:32 |
|
|
paul_p joined #koha |
| 12:34 |
|
|
oleonard joined #koha |
| 12:34 |
|
oleonard |
Yo |
| 12:38 |
|
|
laurence joined #koha |
| 12:39 |
|
|
laurence left #koha |
| 12:47 |
|
fridolin |
oleonard: we found you where there at the begining of www |
| 12:47 |
|
fridolin |
https://www.w3schools.com/tags/tag_ol.asp |
| 12:47 |
|
fridolin |
when we saw a patch with CSS : ol.class |
| 12:47 |
|
fridolin |
^^ |
| 12:48 |
|
oleonard |
?? |
| 12:56 |
|
Joubu |
Hi #koha |
| 12:56 |
|
Joubu |
ere: did you see bug 21675, last comment? |
| 12:56 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=21675 normal, P5 - low, ---, koha-bugs, REOPENED , Unable to add to a basket with ElasticSearch enabled |
| 13:02 |
|
|
Dyrcona joined #koha |
| 13:04 |
|
ere |
Joubu: Yes, but I've had no chance to check it out. No idea why Sniff wouldn't work, but it might make sense to make it configurable. The 20 records issue could be a general problem with how many candidates are processed. |
| 13:07 |
|
Joubu |
ere: the doc says "The Sniff connection pool should be used when you do have direct access to the Elasticsearch cluster, eg when your web servers and Elasticsearch servers are on the same network." |
| 13:07 |
|
Joubu |
the comment says they are using the Amazon Elastic cluster |
| 13:09 |
|
kohaputti |
Joubu, hmm, just a random thing to try: downgrade Search::Elasticsearch to 5.02 |
| 13:10 |
|
ere |
Joubu: Right, so definitely needs to be configurable |
| 13:18 |
|
Joubu |
I have reported it on bug 21974 |
| 13:18 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=21974 major, P5 - low, ---, koha-bugs, NEW , cxn_pool must be configurable |
| 13:30 |
|
|
librarian joined #koha |
| 13:30 |
|
Joubu |
@later tell marcelr I would prefer to talk with you here, on IRC, instead of through bugzilla comments ;) |
| 13:30 |
|
huginn |
Joubu: The operation succeeded. |
| 13:32 |
|
Joubu |
@later tell marcelr bug 21971 comment 4 - we are talking about tests, that are already existing, I am not creating new code but removing duplication instead. I agree it's not the best wording, but nothing else has been suggesting |
| 13:32 |
|
huginn |
Joubu: The operation succeeded. |
| 13:33 |
|
Joubu |
@later tell marcelr When I disagree on something I usually try to suggest something else, to not block the patches |
| 13:33 |
|
huginn |
Joubu: The operation succeeded. |
| 13:33 |
|
Joubu |
not sure laters are better... |
| 13:38 |
|
|
caroline joined #koha |
| 13:39 |
|
caroline |
hello everyone! |
| 13:39 |
|
* oleonard |
wonders why the expiration date of a hold can't be edited after it has been placed |
| 13:43 |
|
caroline |
Isn't the expiration date for the patron to let the library know they don't need this item after this date? |
| 13:43 |
|
caroline |
If the patron's circumstances change, they might need to change the expiration date |
| 13:44 |
|
|
Archie^ joined #koha |
| 13:46 |
|
Archie^ |
Hi all! |
| 13:47 |
|
caroline |
Hi Archie^! |
| 13:50 |
|
Archie^ |
Hey, so im in the middle of migrating Patrons to koha, and the library FROM which the migration occures has no "home library". I was wondering is there a way to set patron to multiple branches in Koha? |
| 13:50 |
|
caroline |
Archie^: unfortunately, no |
| 13:50 |
|
caroline |
only 1 library per user |
| 13:51 |
|
Archie^ |
ok, but if i have a homebranch, will i be able to checkout books from a different library? |
| 13:51 |
|
caroline |
however, it is possible for users to go to any library |
| 13:51 |
|
caroline |
yes :) |
| 13:51 |
|
Archie^ |
ok, so it's not a big deal then |
| 13:51 |
|
caroline |
Usually the homebranch is the branch where they registered at |
| 13:52 |
|
caroline |
test it before though, because some system preferences may prevent users from loaning out items from other libraries |
| 13:52 |
|
Archie^ |
next question. Im confused as of what is patron lists and patron groups. The library i migrate from have classes like (childern in classes from 1 to 4) etc what should i use in this context |
| 13:52 |
|
caroline |
patron groups? |
| 13:53 |
|
caroline |
do you mean patron categories? |
| 13:53 |
|
Archie^ |
clubs, sorry |
| 13:53 |
|
Archie^ |
lists and clubs |
| 13:53 |
|
Archie^ |
in tools section |
| 13:53 |
|
caroline |
Oh clubs! Those are for like reading clubs and such |
| 13:53 |
|
Archie^ |
also this library has some weird system as you can set a patron as a "teacher" category and they will be able to check out book for 360 days while students can checkout for 1 month etc |
| 13:54 |
|
caroline |
then teacher and student would be patron categories and you can set specific circulation rules for them |
| 13:54 |
|
caroline |
patron lists are mostly used to make bulk changes |
| 13:55 |
|
Archie^ |
basically the checkout duration is HIGHLY configurable and they are pressing on keeping this functionality but AFAK koha has that during installation (they also have the duration confugrated from library to library etc) is it possible in koha? |
| 13:55 |
|
caroline |
yes |
| 13:55 |
|
caroline |
in the circulation rules, you can set rules per patron category, item type and library |
| 13:56 |
|
caroline |
there is also a system preference to let the staff override limits |
| 13:59 |
|
Archie^ |
wait, where can i modify categories? |
| 14:00 |
|
caroline |
Administration > Patron categories |
| 14:00 |
|
|
cait joined #koha |
| 14:01 |
|
oleonard |
Hi cait |
| 14:05 |
|
Joubu |
ere: about your answer on the Cache::Memory thread: did you notice that we already have a L1 cache (in memory)? |
| 14:05 |
|
Joubu |
it is flushed for each request indeed, but there is one :) |
| 14:06 |
|
Joubu |
I am not sure to understand how Cache::Memory can be more useful than that if plack is not running |
| 14:06 |
|
cait |
hi all |
| 14:07 |
|
caroline |
hi cait! |
| 14:07 |
|
cait |
Joubu: bug 21494 - i believe it's a regression, but it came as a change on update from 16.11 to 17.11... so it might be a while |
| 14:07 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=21494 major, P5 - low, ---, koha-bugs, NEW , No checkin notice created for offline circulation checkins |
| 14:08 |
|
cait |
they said they were relying on it and noticed pretty soon after the update |
| 14:08 |
|
cait |
hi caroline :) |
| 14:08 |
|
Joubu |
cait: Hi cait, I do not think it is, ProcessOfflineReturn is the same on 16.11.x |
| 14:09 |
|
cait |
we changed the routines for sending the emails because of the runtime conditions |
| 14:09 |
|
cait |
could ti be related to those changes? |
| 14:09 |
|
Joubu |
runtime conditions? |
| 14:09 |
|
cait |
remember, the checkin notices were not send right |
| 14:09 |
|
cait |
becasue the checkouts were too fast |
| 14:09 |
|
cait |
:) |
| 14:09 |
|
Joubu |
the race conditions? |
| 14:09 |
|
cait |
oh yes, sorry |
| 14:10 |
|
cait |
wrong wrod |
| 14:10 |
|
ere |
Joubu: Oh, I probably mixed up the two in my head! |
| 14:10 |
|
Joubu |
nope, the thing is that CHECKIN is generated from AddReturn, which is never called on ProcessOfflineReturn |
| 14:10 |
|
ere |
Joubu: Sorry about that.. |
| 14:10 |
|
Joubu |
ere: no worries, I wanted to make sure I did not miss something |
| 14:11 |
|
cait |
Joubu: hm can't test right now, so hard to verify |
| 14:11 |
|
cait |
i think it shoud send the emails tho |
| 14:11 |
|
ere |
Joubu: I didn't check to code but relied on memory. My memory. Bad idea. |
| 14:11 |
|
cait |
especially for the offline circs |
| 14:12 |
|
Joubu |
ere: the problem is that Cache::Memory was used as L2 cache, but L2 cache not shared and not flushed is not a good idea if there are several workers :) |
| 14:13 |
|
Joubu |
we have a L1 cac, in memory (so per worker), Koha::Cache::Memory::Lite, that is flushed correctly when a new request is made |
| 14:13 |
|
Joubu |
cache* |
| 14:14 |
|
Archie^ |
hey a quick qustion. Let's say i came to this place in the middle of the project and i have to koha-shell [instance] and i dont know what instances were made when i came here... how would one find out the name of instance? :D |
| 14:14 |
|
Joubu |
cait: yes it should, especially because CHECKOUT are sent! |
| 14:14 |
|
cait |
Joubu: inconsistency-- |
| 14:14 |
|
Joubu |
cait: but not easy to fix. I do not understand why we do not call AddReturn from there |
| 14:15 |
|
cait |
could it have to do with holds? |
| 14:15 |
|
cait |
thinking about it i am not sure what happens if you return an item that should trigger a hold |
| 14:15 |
|
|
Margaret_ joined #koha |
| 14:15 |
|
oleonard |
Archie^: https://wiki.koha-community.or[…]e_Debian_packages |
| 14:15 |
|
oleonard |
Archie^: I think koha-list is what you want |
| 14:17 |
|
|
paul_p joined #koha |
| 14:19 |
|
cait |
jajm: thx for bug 21961 :) |
| 14:19 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=21961 normal, P5 - low, ---, katrin.fischer, Signed Off , Typo in permission keeps Did you mean? config from showing up |
| 14:19 |
|
cait |
pqa? |
| 14:20 |
|
jajm |
cait, yes, i just wanted to add a note before changing status ;) |
| 14:20 |
|
cait |
ah, cool |
| 14:20 |
|
cait |
hope i didn't miss more |
| 14:23 |
|
cait |
jajm: ah! |
| 14:23 |
|
cait |
we can have kidclamp decide :) |
| 14:23 |
|
cait |
i just noticed that hte patrons were also added with the wrong code, didn't check the FK :) |
| 14:25 |
|
Archie^ |
a shit it asks for password :@ |
| 14:26 |
|
jajm |
cait, it is probably safer to have both queries anyway, for instance if for any reason FK are disabled during the updatedb |
| 14:27 |
|
Archie^ |
oleonard: what's the point of koha-reset-passwd instancename username if it asks the same password for the same instance |
| 14:32 |
|
dersmon |
quick question regarding: https://bugs.koha-community.or[…]_bug.cgi?id=21972 - is it possible to check for two subfields in 1 matching point in a matching rule? |
| 14:32 |
|
huginn |
Bug 21972: major, P5 - low, ---, koha-bugs, NEW , Record matching rule for authorities only works for first 20 authority records |
| 14:32 |
|
dersmon |
that would be a workaround for my problem |
| 14:34 |
|
Joubu |
Archie^: koha-reset-passwd does not ask anything, it regenerates a password for a given patron |
| 14:34 |
|
Joubu |
% sudo koha-reset-passwd kohadev koha |
| 14:34 |
|
Joubu |
koha teiph2Ikooqu |
| 14:36 |
|
Archie^ |
i have never been so confused in my entire life. I'll try this, thank you! |
| 15:19 |
|
|
barton joined #koha |
| 15:31 |
|
|
librarian joined #koha |
| 15:33 |
|
|
karusan joined #koha |
| 15:34 |
|
reiveune |
bye |
| 15:34 |
|
|
reiveune left #koha |
| 15:41 |
|
|
josef_moravec joined #koha |
| 15:42 |
|
cait |
caroline: i am updating hte circulation conditions chapter today |
| 15:42 |
|
cait |
some of the options were missing |
| 15:42 |
|
cait |
i don#t have all the bug numbers, should I look for them? |
| 15:43 |
|
caroline |
cait: no don't worry about that |
| 15:43 |
|
cait |
o |
| 15:43 |
|
cait |
k |
| 15:43 |
|
caroline |
Just compare what's in Koha with what's in the manual |
| 15:43 |
|
cait |
i tihnk some were really old, like the third option for on shelf holds |
| 15:43 |
|
cait |
at least 17.11 |
| 15:43 |
|
cait |
ok, working on that :) |
| 15:43 |
|
caroline |
cait: thx! cait++ |
| 16:14 |
|
|
laurence joined #koha |
| 16:30 |
|
|
fridolin left #koha |
| 17:02 |
|
cait |
caroline_lunch: first patch is up :) |
| 17:19 |
|
|
BobB joined #koha |
| 17:19 |
|
|
irma joined #koha |
| 17:20 |
|
|
dj joined #koha |
| 17:27 |
|
|
khall joined #koha |
| 17:30 |
|
* cait |
waves at BobB and irma |
| 17:32 |
|
|
librarian joined #koha |
| 17:41 |
|
cait |
should there be a comma after hold? |
| 17:41 |
|
cait |
efault checkout, hold and return policy |
| 17:41 |
|
cait |
Default checkout, hold and return policy |
| 17:43 |
|
|
Margaret joined #koha |
| 17:43 |
|
cait |
Margaret: will know! |
| 17:43 |
|
cait |
efault checkout, hold and return policy |
| 17:43 |
|
cait |
should there be a comma after hold? |
| 17:43 |
|
Margaret |
Hi, |
| 17:44 |
|
cait |
hm was just googling it and it says it's a stylistic thing |
| 17:44 |
|
Margaret |
so are you looking for "default checkout, hold, and return policy" that would be the way i'd phrase it it if you are talking about 3 separate things |
| 17:45 |
|
Margaret |
but I like oxford commas. |
| 17:45 |
|
cait |
:) |
| 17:47 |
|
cait |
how are you doing? |
| 17:50 |
|
oleonard |
oxford_commas++ |
| 17:53 |
|
cait |
if the and was an or... would i still comma? |
| 17:53 |
|
* cait |
thinks more native speakers needed to write for hte manual :) |
| 17:55 |
|
oleonard |
"Default checkout, hold, or return policy" Yes. |
| 17:55 |
|
|
coyas joined #koha |
| 17:55 |
|
coyas |
hello koha world |
| 18:00 |
|
cait |
oleonard: thx! |
| 18:00 |
|
cait |
oleonard++ Margaret++ |
| 18:01 |
|
|
lukeG joined #koha |
| 18:02 |
|
* Margaret |
would like to write for the manual, once I free us some mental space... |
| 18:03 |
|
Margaret |
cait++ |
| 18:03 |
|
Margaret |
for trying to parse english grammar. |
| 18:09 |
|
|
Margaret joined #koha |
| 18:12 |
|
coyas |
always that i install koha the port 80 from apache is deactivated, why? how can i put it online again? |
| 18:51 |
|
cait |
caroline++ :) |
| 18:57 |
|
cait |
caroline: can i put multiple taiga things in one merge request? |
| 18:57 |
|
cait |
i can... but is that ok for you? |
| 18:57 |
|
caroline |
sure |
| 18:57 |
|
cait |
cool |
| 18:57 |
|
caroline |
maybe different commits? |
| 18:57 |
|
cait |
i tihnk there are some rather small fixes in the enh |
| 18:57 |
|
cait |
yep |
| 18:57 |
|
cait |
i will make different commits, but push them up at once |
| 18:58 |
|
caroline |
sure no problem |
| 19:07 |
|
cait |
looking at column config next :) |
| 19:11 |
|
cait |
hm do we want a list of the tables you can change in column configuration? |
| 19:11 |
|
cait |
the names don't translate, it might be helpful for some |
| 19:12 |
|
cait |
but more to maintain |
| 19:16 |
|
koha-jenkins |
Project Koha_18.05_D8 build #134: STILL UNSTABLE in 25 min: https://jenkins.koha-community[…]oha_18.05_D8/134/ |
| 19:20 |
|
|
laurence left #koha |
| 19:23 |
|
koha-jenkins |
Project Koha_18.05_U18 build #134: STILL UNSTABLE in 31 min: https://jenkins.koha-community[…]ha_18.05_U18/134/ |
| 19:29 |
|
oleonard |
Bye all. Keep your fingers crossed for a visit from the signoff fairy over the weekend! |
| 19:29 |
|
cait |
caroline: ^ :) |
| 19:30 |
|
caroline |
cait: sorry I was on the phone |
| 19:30 |
|
caroline |
There are bugs for each new table added, so we could add them |
| 19:31 |
|
caroline |
the release notes/bugs will keep us updated to what was added |
| 19:31 |
|
|
papa joined #koha |
| 19:31 |
|
cait |
ok, i will try if i can figure out how to format it nicely .) |
| 19:32 |
|
|
librarian joined #koha |
| 19:33 |
|
caroline |
cait: if it's too complicated, don't worry about it |
| 19:34 |
|
cait |
still learning the syntax, it's good |
| 19:37 |
|
|
lukeG joined #koha |
| 19:43 |
|
koha-jenkins |
Project Koha_18.05_D9 build #130: STILL UNSTABLE in 26 min: https://jenkins.koha-community[…]oha_18.05_D9/130/ |
| 19:52 |
|
|
indradg joined #koha |
| 19:56 |
|
|
coyas joined #koha |
| 20:00 |
|
|
indradg_ joined #koha |
| 20:14 |
|
coyas |
ll |
| 20:15 |
|
cait |
caroline: i tihnk I am giving up on the table idea :) |
| 20:17 |
|
caroline |
:) did you think of a reason not to, or it's just getting too complcated? |
| 20:17 |
|
cait |
hm i justthought about another way |
| 20:17 |
|
cait |
i will make something and let you decide :) |
| 20:26 |
|
caroline |
wth does that mean "Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='"? |
| 20:29 |
|
caroline |
A school system asked for a list of series/collections with titles per school. Of course, series and collections are separated between 440 and 490... -_- |
| 20:29 |
|
caroline |
wondering if I can do this without going through a report |
| 20:36 |
|
cait |
i had that happen |
| 20:36 |
|
cait |
let me think |
| 20:36 |
|
cait |
i think i ended up doing a CAST() |
| 20:37 |
|
cait |
are you doing a concat? |
| 20:37 |
|
cait |
want to share the full sql? |
| 20:37 |
|
caroline |
no I'm doing a union, but right now trying to see if I can work out a concat |
| 20:37 |
|
cait |
ah |
| 20:37 |
|
cait |
i think the thing is that the type of the things in the same column doesn't match |
| 20:38 |
|
cait |
so if you have second column an integer in the first is has to be integer in the second part too |
| 20:38 |
|
cait |
or it complains |
| 20:38 |
|
cait |
i wonder why they collate differently... but that's another question |
| 20:39 |
|
pastebot |
"caroline" at 127.0.0.1 pasted "collections with titles (try 1: only 440)" (16 lines) at http://paste.koha-community.org/441 |
| 20:40 |
|
pastebot |
"caroline" at 127.0.0.1 pasted "collections with titles (try 2: only 490)" (16 lines) at http://paste.koha-community.org/442 |
| 20:40 |
|
caroline |
(I just changed all the 440s to 490s in that 2nd try) |
| 20:40 |
|
cait |
does one of htem work already? |
| 20:41 |
|
caroline |
yes, those two work |
| 20:41 |
|
indradg_ |
I´m trying to profile catalogue/search.pl. Running into this when Iḿ trying to generate the report - - ¨NYTProf data format error while reading header at /usr/lib/x86_64-linux-gnu/perl5/5.20/Devel/NYTProf/Data.pm line 87. |
| 20:41 |
|
indradg_ |
¨ |
| 20:41 |
|
cait |
ah cool |
| 20:41 |
|
cait |
ah |
| 20:41 |
|
cait |
you want to union them? |
| 20:41 |
|
caroline |
Now I want to merge the two so the librarians don't have to do two reports |
| 20:42 |
|
caroline |
either by union or concat |
| 20:43 |
|
caroline |
As long as I can order by that first column (which I'm not sure how to do, I've never been able to work out aliases) |
| 20:43 |
|
cait |
hmmm sec |
| 20:45 |
|
pastebot |
"caroline" at 127.0.0.1 pasted "collections with titles (try 3: 440 union 490)" (31 lines) at http://paste.koha-community.org/443 |
| 20:45 |
|
caroline |
this one is the one giving me the collation thing |
| 20:45 |
|
cait |
hm |
| 20:46 |
|
cait |
i don't get the collate problem, not sure why |
| 20:46 |
|
cait |
maybe a db issue |
| 20:46 |
|
caroline |
(in French collation is a snack, and right now it is almost 4pm, a snack would be good) |
| 20:46 |
|
cait |
hehe |
| 20:46 |
|
cait |
this seems ok for me on the sample db data: http://paste.koha-community.org/444 |
| 20:46 |
|
kidclamp |
the collation issue is because of the use of 'parameters' the @Branch := |
| 20:47 |
|
caroline |
kidclamp: it was my next try, thanks! |
| 20:48 |
|
cait |
but some results are missing |
| 20:48 |
|
caroline |
cait: you don't have branches in that query |
| 20:48 |
|
cait |
oh! |
| 20:48 |
|
cait |
yeah right |
| 20:48 |
|
cait |
i killed them because was testing in workbench |
| 20:48 |
|
cait |
caroline: which verion are you testing this on? |
| 20:48 |
|
cait |
you might not need the variable thing |
| 20:48 |
|
kidclamp |
( @EndDate := <<End date|date>> COLLATE utf8_unicode_ci ) |
| 20:48 |
|
kidclamp |
something like that usually works |
| 20:48 |
|
caroline |
their version is 17.05 |
| 20:49 |
|
cait |
hm was fixed 18.05 |
| 20:49 |
|
cait |
so you need it |
| 20:49 |
|
cait |
so try what kidclamp says :) |
| 20:49 |
|
cait |
and... mine is missing some entries i think... so maybe not use that |
| 20:49 |
|
caroline |
ok will try that |
| 20:52 |
|
caroline |
half success : not getting the collation error, but also getting less results than before |
| 20:52 |
|
cait |
so strange |
| 20:53 |
|
cait |
try a UNION ALL |
| 20:53 |
|
cait |
not sure why, but that seems to e complate |
| 20:53 |
|
cait |
complete |
| 20:54 |
|
caroline |
success! |
| 20:54 |
|
caroline |
Now the ordering |
| 20:54 |
|
cait |
order by 1 |
| 20:55 |
|
caroline |
So I can just tell it to order by the column number? That's handy, I didn't know that |
| 20:55 |
|
cait |
yep |
| 20:55 |
|
cait |
just have to remember to update if you add more columns |
| 20:55 |
|
cait |
i usually forget :) |
| 20:57 |
|
caroline |
thx cait++ and kidclamp++ for your help :) |
| 20:57 |
|
cait |
:) |
| 20:59 |
|
cait |
we're a team:) |
| 21:00 |
|
Joubu |
cait++ caroline++ |
| 21:01 |
|
Joubu |
have a great week-end! |
| 21:01 |
|
cait |
you too |
| 21:01 |
|
cait |
! |
| 21:33 |
|
|
librarian joined #koha |
| 21:53 |
|
|
lukeG joined #koha |
| 22:29 |
|
koha-jenkins |
Project Koha_18.05_D8 build #135: STILL UNSTABLE in 23 min: https://jenkins.koha-community[…]oha_18.05_D8/135/ |
| 22:35 |
|
koha-jenkins |
Project Koha_18.05_U18 build #135: STILL UNSTABLE in 28 min: https://jenkins.koha-community[…]ha_18.05_U18/135/ |
| 22:41 |
|
cait |
caroline: i was thinking about adding more of the enh to taiga - something easy for last today - do you know where we stopped? |
| 22:41 |
|
cait |
or want to do it yourself? |
| 22:41 |
|
caroline |
I haven't gotten to the enhancements yet, I'm still in the new features |
| 22:42 |
|
caroline |
(I'm doing 15 things at a time) |
| 22:42 |
|
cait |
i am on vacation - I can take one thing off |
| 22:42 |
|
caroline |
https://koha-community.org/koha-18-11-release/ |
| 22:42 |
|
cait |
:) |
| 22:42 |
|
caroline |
I search for the bug number in taiga |
| 22:42 |
|
cait |
ok |
| 22:43 |
|
caroline |
a lot of them are already there because I tried to follow the release notes updates like Joubu showed me |
| 22:43 |
|
cait |
would enhancements only go into enh or might be elsewhere? |
| 22:43 |
|
caroline |
The last one I looked u was 17282 Ability to create charts for SQL reports |
| 22:44 |
|
caroline |
just put them in enhancements. |
| 22:44 |
|
cait |
ok:) |
| 22:45 |
|
caroline |
I'm thinking for 19.05 to separate by chapter or module, that way, if you're already changing something in admin for example, you can go in and add the other stuff from that chapter |
| 22:45 |
|
caroline |
what do you think? |
| 22:47 |
|
cait |
makes sense |
| 22:47 |
|
cait |
if we separate by chapter |
| 22:48 |
|
cait |
we might also be able to just copy from the release notes |
| 22:48 |
|
cait |
leaving out the module in front? |
| 22:48 |
|
cait |
i was also just wondering - would you mind putting the bug number first? |
| 22:48 |
|
caroline |
no, that's what I started doing |
| 22:48 |
|
cait |
great :) |
| 22:48 |
|
caroline |
module + copy paste the release not title |
| 22:48 |
|
cait |
ok on it |
| 22:49 |
|
cait |
i think new features is complete now - deleted a duplicate one |
| 22:49 |
|
caroline |
cool! |
| 22:50 |
|
cait |
do you add them all or do you sortalready by needed for the manual? |
| 22:50 |
|
caroline |
one less to do haha! |
| 22:50 |
|
cait |
thinkign about things like the about page updates |
| 22:50 |
|
caroline |
If it's obviously not needed for the manual, I don't put it. If I'm not sure I put it anyway and will check later |
| 22:50 |
|
cait |
ok |
| 22:55 |
|
koha-jenkins |
Project Koha_18.05_D9 build #131: STILL UNSTABLE in 25 min: https://jenkins.koha-community[…]oha_18.05_D9/131/ |
| 23:19 |
|
cait |
caroline: it loos like some wrong ubg numbers are in the release notes |
| 23:19 |
|
cait |
[11401] Add support for Norwegian national library card = was actually removed |
| 23:19 |
|
cait |
last chang eon bug is from 2015 |
| 23:31 |
|
caroline |
uhoh |
| 23:32 |
|
caroline |
who /how generates the release notes? |
| 23:34 |
|
|
librarian joined #koha |
| 23:36 |
|
caroline |
I have to go, but we'll investigate that. Let me know if you see other bugs that are there but shouldn't |
| 23:37 |
|
cait |
caroline: i tihnk i have added all enh |
| 23:37 |
|
caroline |
ok cool! |
| 23:37 |
|
cait |
caroline: it's a script, but if the commit has the worng number, that could be a reason |
| 23:38 |
|
caroline |
oh! So a commit for another bug would have this bug's number? |
| 23:38 |
|
cait |
the script gets the bug numbers from git and then pull sthe titles/descriptions from bugzilla |
| 23:38 |
|
cait |
so if the dev makes a typo on the commit message, the release notes can be wrong |
| 23:39 |
|
caroline |
Ok I though the release notes were taken from bugzilla when the bug is pushed to master |
| 23:39 |
|
cait |
it could, but i think it would be less accurate |
| 23:39 |
|
cait |
becuase we have so many status changes, bugs reopened etc |
| 23:40 |
|
caroline |
right |
| 23:40 |
|
caroline |
I don't see the git so I don't even think about it |
| 23:41 |
|
cait |
it should not be a big problem |
| 23:41 |
|
cait |
i put a note on the task |
| 23:42 |
|
cait |
go :) |
| 23:42 |
|
cait |
and have a nice weekend :) |
| 23:42 |
|
caroline |
alright, i'm just tired, it's been a long week.... migration monday that didn't 100% well |
| 23:42 |
|
cait |
:( hope it's better now |
| 23:42 |
|
caroline |
have a good weekend you too! :) |
