| Time |
S |
Nick |
Message |
| 00:02 |
|
|
fridolin joined #koha |
| 01:03 |
|
koha-jenkins |
Yippee, build fixed! |
| 01:03 |
|
koha-jenkins |
Project Koha_21.05_D11 build #220: FIXED in 59 min: https://jenkins.koha-community[…]ha_21.05_D11/220/ |
| 01:03 |
|
wahanui |
Congratulations! |
| 01:56 |
|
koha-jenkins |
Project Koha_20.11_D11 build #246: SUCCESS in 53 min: https://jenkins.koha-community[…]ha_20.11_D11/246/ |
| 02:15 |
|
|
vegasjoe joined #koha |
| 02:16 |
|
vegasjoe |
Hello all. I am running into this error https://bugs.koha-community.or[…]_bug.cgi?id=30912 |
| 02:16 |
|
huginn |
Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 |
| 02:24 |
|
|
vegasjoe joined #koha |
| 04:21 |
|
|
Oak joined #koha |
| 04:22 |
|
|
Oak joined #koha |
| 04:52 |
|
|
fridolin joined #koha |
| 05:44 |
|
|
reiveune joined #koha |
| 05:44 |
|
reiveune |
hello |
| 05:50 |
|
Oak |
hello |
| 05:50 |
|
wahanui |
hi, Oak |
| 06:03 |
|
|
Oak joined #koha |
| 06:18 |
|
magnuse |
\o/ |
| 06:44 |
|
|
cait joined #koha |
| 06:45 |
|
|
lds joined #koha |
| 06:48 |
|
|
cait1 joined #koha |
| 06:56 |
|
|
alex_ joined #koha |
| 06:56 |
|
alex_ |
Bonjour |
| 06:56 |
|
wahanui |
niihau, alex_ |
| 07:01 |
|
|
Oak joined #koha |
| 07:13 |
|
magnuse |
is it possible to write a report that shows all patron in a patron category and one patron attribute, if they have it or not? i was thinking this, but it only gives the ones that have the attribute, not the ones that don't have it: |
| 07:13 |
|
magnuse |
SELECT b.borrowernumber, ba.attribute AS attribute FROM borrowers b LEFT JOIN borrower_attributes ba ON b.borrowernumber = ba.borrowernumber WHERE ba.code = 'SOMETHING' AND b.categorycode = 'X' |
| 07:17 |
|
cait1 |
it is definitely possible |
| 07:17 |
|
cait1 |
hm let me check something |
| 07:18 |
|
cait1 |
instead of a left join I have used |
| 07:20 |
|
cait1 |
where borrowernumber not in (select borrowernumber from borrower_attributes where code = "X" and attribute is not null) ? |
| 07:20 |
|
cait1 |
the report ist actually a little different |
| 07:20 |
|
cait1 |
is the entry there in attributes as NULL or is it missing? |
| 07:20 |
|
cait1 |
magnuse: ^^ |
| 07:21 |
|
magnuse |
it is missing |
| 07:22 |
|
cait1 |
ok, so you could create a list of borrowernumber that have it and compare that to your list |
| 07:22 |
|
magnuse |
only a few patrons have the attribute, and i want to see all patrons based on some criteria, e.g. categorycode, and then i want to see if they have the attribute set or are missing it completely |
| 07:22 |
|
cait1 |
i think |
| 07:23 |
|
cait1 |
I'll paly a little |
| 07:26 |
|
cait1 |
select cardnumber, surname, |
| 07:26 |
|
cait1 |
(select attribute from borrower_attributes ba where code = "X" and ba.borrowernumber = b.borrowernumber ) |
| 07:26 |
|
cait1 |
from borrowers b |
| 07:26 |
|
cait1 |
this works for me |
| 07:28 |
|
cait1 |
magnuse: ^ :) |
| 07:29 |
|
magnuse |
interesting! |
| 07:29 |
|
Oak |
magnuse |
| 07:29 |
|
Oak |
Hi cait1 |
| 07:30 |
|
magnuse |
Oak |
| 07:30 |
|
Oak |
\o/ |
| 07:33 |
|
dcook |
Just about to run but had fun with bug 30962 and bug 17004 today |
| 07:33 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=30962 enhancement, P5 - low, ---, koha-bugs, NEW , REST API: Add endpoint /patrons/:patron_id/check_password |
| 07:33 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=17004 enhancement, P3, ---, koha-bugs, In Discussion , REST API: add route to authenticate patron (Single Sign On - SSO) |
| 07:33 |
|
* dcook |
runs away on that note |
| 07:33 |
|
magnuse |
dcook++ |
| 07:33 |
|
magnuse |
run dcook run |
| 07:34 |
|
Oak |
dcook++ |
| 07:35 |
|
magnuse |
cait1: it totally works and you are a star! i would never in a million years have figured out to do it that way |
| 07:35 |
|
magnuse |
cait++ |
| 07:35 |
|
magnuse |
@karm |
| 07:35 |
|
huginn |
magnuse: downloading the Perl source |
| 07:35 |
|
magnuse |
@karma |
| 07:35 |
|
huginn |
magnuse: Highest karma: "Joubu" (1107), "cait" (893), and "ashimema" (711). Lowest karma: "-" (-77), "failed" (-52), and "ie" (-40). You (magnuse) are ranked 18 out of 1167. |
| 08:24 |
|
|
Oak joined #koha |
| 09:06 |
|
cait1 |
magnuse: i like sub queries |
| 09:06 |
|
cait1 |
:) |
| 09:06 |
|
magnuse |
:-) |
| 09:07 |
|
magnuse |
i should use them more |
| 09:57 |
|
fridolin |
magnuse: we have a help doc for a SQL query on patrons with an attribute : https://pastebin.com/S7gXt3A4 |
| 09:58 |
|
paxed |
how do cataloguers handle creating 001 when cataloguing a new record? |
| 10:01 |
|
|
cait1 left #koha |
| 10:01 |
|
paxed |
our old koha had a local change to automatically add 001 if it was missing, so i created a plugin to do that |
| 10:02 |
|
paxed |
really liking the plugin system |
| 10:05 |
|
magnuse |
plugins++ |
| 10:06 |
|
paxed |
just need more hooks... |
| 10:12 |
|
magnuse |
hook all the things! |
| 10:25 |
|
|
oleonard joined #koha |
| 10:39 |
|
|
m23 joined #koha |
| 10:40 |
|
|
m23_ joined #koha |
| 10:41 |
|
|
m23__ joined #koha |
| 10:42 |
|
|
m23___ joined #koha |
| 10:45 |
|
|
oleonard joined #koha |
| 10:50 |
|
|
m23 joined #koha |
| 11:09 |
|
|
marcelr joined #koha |
| 11:09 |
|
marcelr |
hi #koha |
| 11:26 |
|
tcohen |
ah, random test failures, who doesn't love them |
| 11:26 |
|
ashimema |
hugs |
| 11:28 |
|
|
Oak joined #koha |
| 11:58 |
|
oleonard |
Anyone around who uses the "git so" command in ktd? I'm curious about the warning message git is showing now |
| 12:00 |
|
pastebot |
"oleonard" at 127.0.0.1 pasted "When using the "git so" command in KTD" (7 lines) at https://paste.koha-community.org/10062 |
| 12:01 |
|
magnuse |
looks like https://paste.koha-community.org/ needs an updated cert? |
| 12:03 |
|
kidclamp |
I have just been ignoring it |
| 12:05 |
|
oleonard |
Yes, but kidclamp instead of ignoring it you could obsess over a solution. |
| 12:09 |
|
kidclamp |
that sounds stressful |
| 12:10 |
|
oleonard |
Oh I see, you're on island time now :) |
| 12:16 |
|
* kidclamp |
floats on a mustache shaped island in a sea of clean shaven faces |
| 12:20 |
|
kidclamp |
and now I have 'island boys' stuck in my head |
| 12:34 |
|
|
m23_ joined #koha |
| 12:41 |
|
|
m23 joined #koha |
| 12:55 |
|
|
vegasjoe joined #koha |
| 12:56 |
|
vegasjoe |
Hello. I am struggling on how to recover from this error. https://bugs.koha-community.or[…]_bug.cgi?id=30912 |
| 12:56 |
|
huginn |
Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 |
| 12:57 |
|
|
m23__ joined #koha |
| 12:59 |
|
|
m23___ joined #koha |
| 13:04 |
|
|
Oak joined #koha |
| 13:09 |
|
vegasjoe |
Hello. I have an issue with database conversion. |
| 13:10 |
|
Oak |
What is the issue? |
| 13:10 |
|
wahanui |
i guess the issue is too... thi swould have been better as several bugs |
| 13:16 |
|
vegasjoe |
bug 30912 |
| 13:16 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=30912 blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 |
| 13:17 |
|
vegasjoe |
Database update fails for 21.12.00.016- I am trying to get out of the issue. |
| 13:23 |
|
Oak |
Thanks, have you tried what's described in this comment: https://bugs.koha-community.or[…]g.cgi?id=30912#c5 |
| 13:23 |
|
huginn |
Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 |
| 13:23 |
|
vegasjoe |
How do I apply the patch? |
| 13:24 |
|
vegasjoe |
I am doing something wrong. |
| 13:24 |
|
|
Dyrcona joined #koha |
| 13:27 |
|
|
vegasjoe joined #koha |
| 13:30 |
|
vegasjoe |
Did I miss a comment? |
| 13:33 |
|
|
vegasjoe joined #koha |
| 13:34 |
|
vegasjoe |
From which directory do you run restart_all? |
| 13:35 |
|
vegasjoe |
also updatedatabase |
| 13:44 |
|
vegasjoe |
what is KTD? Is it part of docker? |
| 13:44 |
|
ashimema |
ktd is koha-testing-docker |
| 13:44 |
|
ashimema |
it's a tool we use for development |
| 13:45 |
|
ashimema |
where are you running into this issue.. on a live server.. or whilst developing |
| 13:45 |
|
vegasjoe |
thank you |
| 13:45 |
|
vegasjoe |
Live server |
| 13:46 |
|
vegasjoe |
we did an update using apt and ran into this problem |
| 14:01 |
|
tcohen |
vegasjoe: find the file installer/data/mysql/db_revs/211200016.pl |
| 14:01 |
|
tcohen |
in /usr/share/koha/ |
| 14:01 |
|
tcohen |
make the changes from the patch |
| 14:01 |
|
tcohen |
https://bugs.koha-community.or[…]ent.cgi?id=136029 |
| 14:02 |
|
tcohen |
and run koha-upgrade-schema $(koha-list) |
| 14:02 |
|
tcohen |
if this is a live system |
| 14:02 |
|
tcohen |
otherwise wait around 10 days for the point release to be published |
| 14:05 |
|
vegasjoe |
thank you. I will try it |
| 14:06 |
|
|
FlorianB joined #koha |
| 14:07 |
|
FlorianB |
Hello Koha, quick question : is it possible to create a syspref with multiple booleans in it, or would it not be a good practice? |
| 14:15 |
|
|
lukeg joined #koha |
| 14:15 |
|
lukeg |
hi |
| 14:15 |
|
wahanui |
niihau, lukeg |
| 14:16 |
|
|
lukeg joined #koha |
| 14:17 |
|
|
m23 joined #koha |
| 14:17 |
|
vegasjoe |
thank you that worked |
| 14:19 |
|
tcohen |
vegasjoe: glad to hear |
| 14:22 |
|
|
m23 joined #koha |
| 14:24 |
|
vegasjoe |
tcohen: Now I cannot log in. |
| 14:28 |
|
vegasjoe |
I used the default user name and password in koha-conf.xml and still cannot log in |
| 14:28 |
|
tcohen |
newer Koha doesn't allow db user login |
| 14:28 |
|
tcohen |
you need a *real* user |
| 14:28 |
|
tcohen |
if you don't have one |
| 14:29 |
|
tuxayo |
FlorianB: There can be multiple sysprefs that are displayed in the same place. Look for finesMode and ChargeFinesOnClosedDays for example. |
| 14:29 |
|
vegasjoe |
my *real* user also cannot log in |
| 14:29 |
|
tcohen |
you can create one on the command line, but I don't remember the script name |
| 14:29 |
|
tcohen |
the only thing I can think of |
| 14:29 |
|
tcohen |
are |
| 14:29 |
|
tcohen |
- creashed sessions table |
| 14:29 |
|
|
Dyrcona joined #koha |
| 14:30 |
|
tcohen |
- sessionStorage=tmp and no permissions on the tmp firectory |
| 14:30 |
|
tcohen |
you should check the logs, basically |
| 14:31 |
|
|
m23 joined #koha |
| 14:35 |
|
|
lukeg joined #koha |
| 14:45 |
|
oleonard |
lukeg: Does it look like Bug 27700 is still valid to you? |
| 14:45 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=27700 minor, P5 - low, ---, koha-bugs, NEW , Patron quick add form is a single fieldset and contains no legend or headers |
| 14:46 |
|
oleonard |
It might have been fixed by all the recent accessibility improvements. I see a heading and a legend on the fieldset now. |
| 14:52 |
|
|
Oak joined #koha |
| 14:56 |
|
lukeg |
oleonard: it does still seem valid to me |
| 14:56 |
|
oleonard |
What were you looking for? |
| 14:57 |
|
|
Oak joined #koha |
| 14:57 |
|
lukeg |
IIRC, I got a complaint about it not have the same headings/fieldsets as the normal form |
| 14:58 |
|
oleonard |
Thats kind of the point IMO |
| 14:58 |
|
oleonard |
It's brief. |
| 14:58 |
|
lukeg |
So for example, if you add surname & firstname to the quickaddfields you would see the Patron identity legend and fieldset |
| 14:59 |
|
lukeg |
I don't disagree with you |
| 15:00 |
|
|
bag joined #koha |
| 15:00 |
|
lukeg |
It seems like if we made it work like I just described it would be the SlowAddForm |
| 15:01 |
|
lukeg |
oleonard: I think maybe we should mark it as RESOLVED WORKSFORME ? |
| 15:01 |
|
oleonard |
I get the feeling that what they really wanted was to hide certain fields from the "full" entry form, rather than create a quick one. |
| 15:02 |
|
lukeg |
Right, and that can easily be done. I am going to mark it as resolved |
| 15:02 |
|
oleonard |
Yeah, I would be fine with WORKSFORME if you are |
| 15:46 |
|
|
lukeg1 joined #koha |
| 15:58 |
|
reiveune |
bye |
| 15:58 |
|
|
reiveune left #koha |
| 16:02 |
|
|
reiveune joined #koha |
| 16:08 |
|
|
FlorianB left #koha |
| 16:17 |
|
|
TimothyAlexis joined #koha |
| 16:18 |
|
TimothyAlexis |
I really found this funny https://youtu.be/FCXA4ft5Weo |
| 16:18 |
|
TimothyAlexis |
Didn't know someone could be hypnotized like that |
| 16:30 |
|
|
reiveune left #koha |
| 16:41 |
|
|
cait joined #koha |
| 16:48 |
|
|
fridolin joined #koha |
| 16:56 |
|
koha-jenkins |
Project Koha_22.05_U22 build #9: STILL UNSTABLE in 58 min: https://jenkins.koha-community[…]Koha_22.05_U22/9/ |
| 16:59 |
|
koha-jenkins |
Project Koha_22.05_U20 build #9: STILL UNSTABLE in 1 hr 2 min: https://jenkins.koha-community[…]Koha_22.05_U20/9/ |
| 17:18 |
|
koha-jenkins |
Project Koha_22.05_U18 build #12: STILL UNSTABLE in 1 hr 19 min: https://jenkins.koha-community[…]oha_22.05_U18/12/ |
| 17:19 |
|
tuxayo |
Hi :) Anyone up to signoff bug 30733 ? A second signoff will allow Fridolin (the 1st signoff) to do the QA. |
| 17:19 |
|
tuxayo |
New simpler method to test instead of reviewing hundred of template changes: run the command to update the translations strings before and after the patch and do a diff. I can details for those interested. |
| 17:19 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=30733 enhancement, P5 - low, ---, victor, Patch doesn't apply , Simplify translatable strings |
| 17:20 |
|
tuxayo |
oh, it doesn't apply |
| 17:37 |
|
koha-jenkins |
Project Koha_22.05_D11 build #17: STILL UNSTABLE in 40 min: https://jenkins.koha-community[…]oha_22.05_D11/17/ |
| 17:38 |
|
tuxayo |
tcohen: thanks for the heads up about 30733, it's rebased now. |
| 17:50 |
|
|
lukeg joined #koha |
| 18:12 |
|
koha-jenkins |
Yippee, build fixed! |
| 18:12 |
|
koha-jenkins |
Project Koha_22.05_U20 build #10: FIXED in 54 min: https://jenkins.koha-community[…]oha_22.05_U20/10/ |
| 18:12 |
|
wahanui |
Congratulations! |
| 18:15 |
|
koha-jenkins |
Project Koha_22.05_U22 build #10: FAILURE in 2 min 53 sec: https://jenkins.koha-community[…]oha_22.05_U22/10/ |
| 18:40 |
|
koha-jenkins |
Project Koha_22.05_U18 build #13: STILL UNSTABLE in 1 hr 3 min: https://jenkins.koha-community[…]oha_22.05_U18/13/ |
| 18:40 |
|
koha-jenkins |
Project Koha_Master_D11_MDB_Latest build #958: STILL UNSTABLE in 4 hr 9 min: https://jenkins.koha-community[…]1_MDB_Latest/958/ |
| 19:28 |
|
koha-jenkins |
Yippee, build fixed! |
| 19:28 |
|
koha-jenkins |
Project Koha_22.05_U22 build #11: FIXED in 47 min: https://jenkins.koha-community[…]oha_22.05_U22/11/ |
| 19:28 |
|
wahanui |
Congratulations! |
| 19:34 |
|
koha-jenkins |
Project Koha_22.05_U18 build #14: STILL UNSTABLE in 1 hr 19 min: https://jenkins.koha-community[…]oha_22.05_U18/14/ |
| 19:36 |
|
|
lukeg joined #koha |
| 19:45 |
|
|
Dyrcona joined #koha |
| 19:49 |
|
koha-jenkins |
Project Koha_22.05_D11 build #18: STILL UNSTABLE in 1 hr 9 min: https://jenkins.koha-community[…]oha_22.05_D11/18/ |
| 19:55 |
|
|
davidnind joined #koha |
| 19:56 |
|
|
lukeg joined #koha |
| 21:17 |
|
|
davidnind1 joined #koha |
| 21:21 |
|
|
davidnind2 joined #koha |
| 21:38 |
|
|
davidnind2 left #koha |
| 22:58 |
|
|
lukeg joined #koha |
| 23:01 |
|
|
lukeg1 joined #koha |
| 23:23 |
|
|
alohalog` joined #koha |
| 23:37 |
|
|
lukeg joined #koha |
