← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 01:06 | * kidclamp_away | hides the paint from dcook |
| 01:07 | dcook | :P |
| 02:55 | irma joined #koha | |
| 03:53 | irma joined #koha | |
| 04:19 | Francesca joined #koha | |
| 06:22 | drojf joined #koha | |
| 06:22 | drojf | morning #koha |
| 06:29 | Francesca joined #koha | |
| 06:34 | bag | hiya drojf |
| 06:35 | drojf | hi bag |
| 06:36 | how aree things? | |
| 06:36 | *are | |
| 06:41 | laurence joined #koha | |
| 06:41 | bag | going well :) I have so many thougts going through my mind - I am in writing things down mode |
| 06:42 | drojf | sounds awesome |
| 06:42 | bag | good thoughts ;) fundraising for Koha thoughts |
| 06:42 | drojf | cool |
| 06:42 | bag | :D |
| 06:42 | how about you drojf ? how’s things | |
| 06:43 | drojf | good. lots of work but i hope i can work more on koha again |
| 06:43 | got the first package into debian for elasticsearch | |
| 06:46 | started backporting stuff for the unstable repo to see what else needs to go in debian first. i hope it's only one more package to submit | |
| 06:47 | irma joined #koha | |
| 06:52 | LibraryClaire joined #koha | |
| 06:53 | bag | sweet drojf |
| 06:53 | LibraryClaire | morning #koha |
| 06:53 | bag | hi there LibraryClaire |
| 06:53 | LibraryClaire | hey bag |
| 06:53 | how's the foot? | |
| 06:53 | drojf | hi LibraryClaire |
| 06:53 | LibraryClaire | moin drojf |
| 06:53 | bag | hurting ;) |
| 06:53 | LibraryClaire | aw :( |
| 06:53 | bag | how you doing? |
| 06:55 | LibraryClaire | alright thanks, hip seems to not be hurting much now |
| 06:55 | hpefully will run at the weekend :) | |
| 06:56 | bag | excellent :) |
| 06:57 | whens the race date again? | |
| 07:01 | liw | @wunder helsinki |
| 07:01 | huginn | liw: The current temperature in Helsinki, Finland is 0.0°C (8:50 AM EET on January 27, 2017). Conditions: Fog. Humidity: 100%. Dew Point: 0.0°C. Pressure: 30.12 in 1020 hPa (Steady). |
| 07:02 | LibraryClaire | sorry went to grab breakfast from teh breakfast lady |
| 07:02 | bag: err, Sunday after Easter 23rd ish of April | |
| 07:02 | I think | |
| 07:03 | @wunder konstanz | |
| 07:03 | huginn | LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is -2.1°C (7:57 AM CET on January 27, 2017). Conditions: Clear. Humidity: 84%. Dew Point: -4.0°C. Windchill: -2.0°C. Pressure: 30.15 in 1021 hPa (Steady). |
| 07:03 | bag | hmm.. I need a breakfast person |
| 07:03 | that sounds perfect | |
| 07:04 | LibraryClaire | she is here between 7:55 and like five or ten past 8 |
| 07:04 | bag | @wunder pdx |
| 07:04 | huginn | bag: The current temperature in Portland, Oregon is 3.0°C (10:53 PM PST on January 26, 2017). Conditions: Clear. Humidity: 93%. Dew Point: 2.0°C. Pressure: 30.61 in 1036 hPa (Rising). Winter Weather Advisory in effect until 1 PM PST Wednesday... |
| 07:04 | LibraryClaire | then she drives off |
| 07:05 | cait joined #koha | |
| 07:05 | * LibraryClaire | goes to find tea |
| 07:06 | * liw | sips the first cuppa |
| 07:06 | bag | aloha cait |
| 07:10 | * LibraryClaire | burns her mouth on tea |
| 07:21 | * magnuse | waves |
| 07:21 | magnuse | bag: HI |
| 07:21 | LibraryClaire | hei magnuse |
| 07:21 | bag | magnuse: knuckles |
| 07:21 | magnuse | guten morgen BüchereiKlara |
| 07:21 | bag: knuckles! | |
| 07:22 | bag | @wunder boo |
| 07:22 | huginn | bag: Error: No such location could be found. |
| 07:22 | bag | @wunder bodo |
| 07:22 | huginn | bag: Error: No such location could be found. |
| 07:22 | bag | ahh I can’t remember the correct one |
| 07:22 | magnuse | @wunder enbo |
| 07:22 | bag | @wunder bod |
| 07:22 | huginn | bag: Error: No such location could be found. |
| 07:22 | drojf | hei magnuse |
| 07:22 | huginn | magnuse: The current temperature in Bodo, Norway is 5.0°C (7:50 AM CET on January 27, 2017). Conditions: Clear. Humidity: 81%. Dew Point: 2.0°C. Windchill: 1.0°C. Pressure: 29.92 in 1013 hPa (Steady). |
| 07:22 | drojf | @wunder berlin, germany |
| 07:23 | huginn | drojf: The current temperature in Berlin, Berlin, Germany is -4.6°C (8:22 AM CET on January 27, 2017). Conditions: Clear. Humidity: 96%. Dew Point: -5.0°C. Windchill: -5.0°C. Pressure: 30.27 in 1025 hPa (Steady). |
| 07:23 | bag | ah!!! magnuse knows |
| 07:23 | drojf | norwegian summer |
| 07:23 | magnuse | it used to be boo |
| 07:23 | yeah. we had 8 yesterday | |
| 07:23 | drojf | global warming is a lie :P |
| 07:23 | LibraryClaire | hah, northern Germany is now colder than the south |
| 07:23 | magnuse | heh |
| 07:23 | drojf | i thought that is the usual |
| 07:24 | eythian | @wunder ams |
| 07:24 | huginn | eythian: The current temperature in Amsterdam, Netherlands is -4.0°C (7:55 AM CET on January 27, 2017). Conditions: Clear. Humidity: 86%. Dew Point: -6.0°C. Windchill: -8.0°C. Pressure: 29.98 in 1015 hPa (Falling). |
| 07:24 | LibraryClaire | yeah, but hasn't been in the last week or two |
| 07:24 | I heard rumours we were gonna get plus temps :O | |
| 07:24 | eythian | We're supposed to get 10 next week! |
| 07:25 | * LibraryClaire | sunbathes |
| 07:25 | eythian | Huh, 7 today |
| 07:25 | That'll be a change from -4 | |
| 07:25 | I should wear shorts | |
| 07:26 | drojf | i used all sun yesterday, it's dead now |
| 07:26 | LibraryClaire | we haven't had sun for a few days now at least, just thie kind of fog |
| 07:27 | drojf | you live in a foggy place |
| 07:27 | LibraryClaire | in the UK we just called it winter |
| 07:27 | drojf | hah just wanted to say, it's kind of a british thing, right? |
| 07:27 | LibraryClaire | british winter is generally just days and days of grey, kind of cold and damp but not mega cold, and some rain |
| 07:28 | sometimes it gets cold enough for the south to have snow. Then all the infrastructure breaks and everyone buys all the bread | |
| 07:29 | eythian | We've had some serious fog here too lately |
| 07:29 | drojf | yay hamsterkauf. like every day before a holiday in germany |
| 07:30 | LibraryClaire | which is funny, cos they should be used to Sundays by now... so surely it's the same :P |
| 07:30 | drojf | it's a deep trauma caused by closed shops on sundays i guess |
| 07:31 | magnuse | hamsterkauf - that's funny |
| 07:32 | LibraryClaire | i've not heard that phrase before |
| 07:32 | drojf | we buy all the hamsters and then eat them when the shops are close |
| 07:32 | d | |
| 07:32 | * LibraryClaire | moves across the border to Switzerland |
| 07:33 | drojf | no, actually just carry our groceries home in the mouth |
| 07:33 | *we | |
| 07:33 | also, swiss people do hamsterkauf in konstanz every day. not sure if that is where to go | |
| 07:34 | LibraryClaire | they come and buy our cheap toilet paper :P |
| 07:34 | drojf | oh, sun |
| 07:35 | * drojf | can't see anything |
| 07:35 | drojf | but it feels good |
| 07:37 | * LibraryClaire | wonders if it is possible to be higher than the fog |
| 07:38 | eythian | In Wellington, I lived above the fog some days. |
| 07:38 | LibraryClaire | I bet the sun is up there |
| 07:38 | paul_p joined #koha | |
| 07:38 | marcelr joined #koha | |
| 07:38 | marcelr | hi #koha |
| 07:39 | reiveune joined #koha | |
| 07:39 | eythian | Morgen marcelr |
| 07:39 | marcelr | eythian! |
| 07:39 | wahanui | eythian is Time's Person of the Year for 2006. |
| 07:39 | reiveune | hello |
| 07:39 | wahanui | kia ora, reiveune |
| 07:39 | LibraryClaire | hey marcelr |
| 07:40 | marcelr | hi reiveune and LibraryClaire |
| 07:40 | LibraryClaire | salut reiveune |
| 07:40 | drojf | hi marcelr |
| 07:41 | marcelr | hi drojf |
| 07:43 | alex_a joined #koha | |
| 07:44 | alex_a | hello |
| 07:44 | wahanui | hola, alex_a |
| 07:54 | ashimema joined #koha | |
| 07:57 | papa joined #koha | |
| 08:11 | AndrewIsh joined #koha | |
| 08:12 | fridolin joined #koha | |
| 08:12 | fridolin | hie ther |
| 08:15 | cait joined #koha | |
| 08:15 | gaetan_B joined #koha | |
| 08:15 | bag | heya fridolin |
| 08:15 | wahanui | fridolin is busy at the moment, I asked him to backport the bug fix |
| 08:15 | gaetan_B | hello |
| 08:15 | bag | aloha gaetan_B |
| 08:16 | LibraryClaire | hi fridonlin |
| 08:16 | close... fridolin | |
| 08:17 | hi gaetan_B | |
| 08:17 | fridolin | bag: LibraryClaire : and others : le Bonjour |
| 08:17 | paul_p_ joined #koha | |
| 08:17 | LibraryClaire | o/ |
| 08:17 | Joubu | hi #koha |
| 08:17 | LibraryClaire | bonjour Joubu |
| 08:18 | cait | morning #koha :) |
| 08:18 | @wunder Konstanz | |
| 08:18 | huginn | cait: The current temperature in Mainaustraße, Konstanz, Germany is -2.1°C (9:15 AM CET on January 27, 2017). Conditions: Clear. Humidity: 84%. Dew Point: -4.0°C. Windchill: -2.0°C. Pressure: 30.15 in 1021 hPa (Steady). |
| 08:22 | sophie_m joined #koha | |
| 08:28 | Joubu | Could some of you answer on bug 17793 comment 16? |
| 08:28 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17793 enhancement, P5 - low, ---, aleishaamohia, In Discussion , Make sysprefs search show on all Administration pages |
| 08:28 | Joubu | I'd like to get more opinions before passing QA on it |
| 08:29 | The question is: "Do you agree to remove the 'check in' and 'renew' tab from the header search of the administration module and replace them with a 'syspref search' tab which would be the default?" | |
| 08:31 | marcelr | will have a look |
| 08:34 | papa joined #koha | |
| 08:39 | Francesca joined #koha | |
| 08:44 | paul_p joined #koha | |
| 08:44 | sophie_m1 joined #koha | |
| 08:59 | cait | Joubu: can we quickly summarize what remains? just looking at the bug |
| 09:00 | drojf joined #koha | |
| 09:01 | drojf | @wunder berlin, germany |
| 09:01 | huginn | drojf: An error has occurred and has been logged. Please contact this bot's administrator for more information. |
| 09:01 | drojf | :'( |
| 09:01 | @wunder berlin, germany | |
| 09:01 | huginn | drojf: The current temperature in Berlin, Berlin, Germany is -3.4°C (9:59 AM CET on January 27, 2017). Conditions: Clear. Humidity: 95%. Dew Point: -4.0°C. Windchill: -3.0°C. Pressure: 30.27 in 1025 hPa (Steady). |
| 09:02 | sophie_m joined #koha | |
| 09:04 | Joubu | cait: what do you mean? |
| 09:06 | drojf | @later tell rangi thanks! |
| 09:06 | huginn | drojf: The operation succeeded. |
| 09:06 | cait | which tabs will show after patch is pushed |
| 09:07 | i am pro syspref search, but we can't make it too crowded up there :) | |
| 09:07 | eythian | http://devopsreactions.tumblr.[…]otype-good-enough |
| 09:09 | Joubu | cait: will be syspref|checkin|catalog search |
| 09:09 | iirc | |
| 09:09 | Francesca joined #koha | |
| 09:09 | Joubu | instead of checkout|renew|catalog search |
| 09:26 | bag | hi Joubu |
| 09:27 | Joubu | hi bag! |
| 09:29 | fridolin: would you know why deletedborrowers.borrowernumber is not a PK? | |
| 09:30 | fridolin: Do you think about a situation to have it? | |
| 09:34 | fridolin | Joubu: yes, deleted tables should not have a PK since they are composed of real data that use to have a PK |
| 09:34 | Joubu | Could someone with a big and old DB execute: select count(*) as nb, borrowernumber from deletedborrowers group by borrowernumber having nb > 1; |
| 09:34 | fridolin | yep in theory |
| 09:34 | Joubu | fridolin: I do not understand your assertion |
| 09:34 | fridolin | the pb is that borrowernumber is autogenrated |
| 09:34 | Joubu | it can be a PK and not AI |
| 09:35 | then what is wrong with having deletedborrowers.borrowernumber a primary key, not AI ? | |
| 09:35 | fridolin | if a borrower is deleted there is a chance another new borrower gets the same id |
| 09:36 | Joubu | As long as we have AI on borrowers.borrowernumber, we should not have twice the same is |
| 09:36 | fridolin: how? | |
| 09:36 | fridolin | but for that the autogenrated must be reset, it happens only when table is empty and database is rebooted |
| 09:36 | this pb can exist for reserves and issues | |
| 09:36 | Joubu | AI is 42, add a patron, will be 42. AI is now 43. Delete it via the cli, AI is still 43 |
| 09:37 | if the table is empty and the DB is rebooted, the AI is reset? | |
| 09:37 | fridolin | it will rare to empty borrowers table but the case exists |
| 09:38 | "if the table is empty and the DB is rebooted, the AI is reset?" in MySQL / MariaDB yes im pretty sure | |
| 09:38 | i remember it is not the case in Oracle ... | |
| 09:38 | in the end, deletedborrowers is only for statistics, a simple index on borrowernumber should be enought | |
| 09:39 | and regular delete of old entries | |
| 09:39 | Joubu | fridolin: we need a PK for DBIC |
| 09:39 | fridolin | Joubu: ahhh always |
| 09:39 | then create a new column I-d say : deletedborrowernumber PK AI | |
| 09:40 | how are old_issues and old_reserves ? | |
| 09:40 | Joubu | yes but I would make sure it's needed first |
| 09:40 | no PK atm | |
| 09:43 | indeed the AI is reset if the table is empty and the dbms is restart | |
| 09:43 | I guess it's a... feature | |
| 09:44 | cait | Joubu: checkin makes no sense for me |
| 09:44 | Joubu: i think better have patron and checkout or so | |
| 09:46 | fridolin | Joubu: i'm not a DB expert, i just know the AI reset issue can be very hard to detect |
| 09:46 | Joubu | fridolin: so the only case it could happen is if you remove all the patrons of your DB but you have deleted patrons |
| 09:46 | fridolin | the SQL just failes on existing PK |
| 09:46 | Joubu | that's a weird case |
| 09:46 | fridolin | indeed |
| 09:47 | cait | reading back - what happens when you delete the last borrower added and then restart? |
| 09:47 | will it reset the AI then too? | |
| 09:48 | fridolin | Joubu: yes but if you must do something for old_issues/reservers, do the same for deleted* no ? |
| 09:48 | KISS | |
| 09:48 | #KISS | |
| 09:48 | Joubu | the problematic use case: 1. install Koha, 2. Create a test patron, 3. Delete it. 4. Next day Create a patron => boom |
| 09:48 | fridolin | before 4 reboot the server |
| 09:48 | Joubu | well not boom yet, but when you will delete your first patron |
| 09:48 | fridolin | i think you must empty RAM |
| 09:49 | yep 5. delete the new patron | |
| 09:49 | if the borrowernumber is the same boom | |
| 09:49 | Joubu | so yes, that sucks |
| 09:49 | fridolin | the new PK will seem useless but there are a lot, just there to id the line |
| 09:50 | the row i mean | |
| 09:50 | maybe having deleted data tables is not a good idea in SQL | |
| 09:51 | relationnal DB | |
| 09:52 | Joubu | yes I know... |
| 09:52 | opened this discussion one year ago, nobody cared about | |
| 09:52 | Barrc joined #koha | |
| 09:53 | Joubu | cait: it's checkout indeed, not checkin! |
| 09:54 | so with the patch: "syspref | checkout | search cat" | |
| 09:54 | * ashimema | hasn't read all the way back.. but points out you can have a dbic primary key defined that's not actually a real primary key in the database |
| 09:54 | Joubu | without the patch (master): checkout|checkin|renew|search cat |
| 09:55 | ashimema: how does dbic handle that? | |
| 09:55 | if you call ->find on the pk? :) | |
| 09:56 | ashimema | you just tell it in the resultclass what field your treating as the primary key |
| 09:56 | in a meeting right now | |
| 09:56 | Joubu | https://bugs.koha-community.or[…]ment.cgi?id=59583 |
| 09:56 | ashimema | will reply proper in a few minutes |
| 09:56 | Joubu | What khall suggested to do. It was me that asked if it was not better to have the constraint set at the DB level |
| 09:56 | ok thanks! | |
| 10:07 | cait | Joubu: ok with me then :) |
| 10:07 | @later tell khall ping me when you are around? | |
| 10:07 | huginn | cait: The operation succeeded. |
| 10:13 | ashimema | 10 minutes to the next call |
| 10:13 | busy day for calls :( | |
| 10:13 | so yeah.. khall has suggested what I was suggesting | |
| 10:14 | back to the why it's not in the db.. I can't remember.. I'll ask a colleague.. I'm sure he had issue with it at some point | |
| 10:22 | Joubu | ashimema: just try kyle's patch: |
| 10:22 | tried* | |
| 10:22 | if there is only 1 matching row, the find works | |
| 10:22 | but if there are 2, I get a warning: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at t.pl line 584 | |
| 10:22 | and the last matching row is picked | |
| 10:22 | nope, the first matching row! | |
| 10:24 | alex_a_ joined #koha | |
| 10:25 | cait | in theory... that shouldn't happen |
| 10:25 | could we only set the column to unique? | |
| 10:25 | without primary? | |
| 10:25 | so have it unique and then the PK definition in the DBIX config? | |
| 10:26 | ashimema | so yeah.. the issue is why wuold you ever need/want duplicate borrowernumbers? |
| 10:26 | in the deleted_borrowers table | |
| 10:26 | are you thinking people should be able to re-use borrowernumbers once the original user with that number has been deleted | |
| 10:26 | Joubu | I do not want or need, but it can happen |
| 10:27 | ashimema | how can it happen |
| 10:27 | * ashimema | thinks he may have seen it.. but can't understand where it came from |
| 10:27 | cait | no |
| 10:27 | ashimema: cardnumbers - yes, but not borrowernumbers | |
| 10:27 | Joubu | the problematic use case: 1. install Koha, 2. Create a test patron, 3. Delete it. 4. Next day (after server reboot) Create a patron (get the same borrowernumber as the first one), 5. Delete it => boom |
| 10:28 | ashimema | primary key should be borrowernumber :) |
| 10:28 | i can totally understand re0using cardnumbers | |
| 10:28 | Joubu | yes, it is |
| 10:28 | ashimema | erm |
| 10:28 | after a server reboot | |
| 10:28 | is mysql that bad | |
| 10:28 | Joubu | borrowernumber is the PK, but the fact that it is automatically set by AI will cause this problem |
| 10:29 | ashimema | I thought it was an auto_increment primary key |
| 10:29 | AI? | |
| 10:29 | wahanui | AI is 42, add a patron, will be 42. AI is now 43. Delete it via the cli, AI is still 43 |
| 10:29 | Joubu | if mysql is restart and the table is empty, AI is reset |
| 10:29 | auto increment | |
| 10:29 | forget AI | |
| 10:29 | wahanui | Joubu: I forgot ai |
| 10:29 | Joubu | AI is Auto Increment |
| 10:29 | ashimema | oh god.. AI is horrible in mysql |
| 10:30 | that wouldn't happen in postgres | |
| 10:30 | it's ai is 'safe' | |
| 10:30 | you have to work really hard in postgres to get such a cock up | |
| 10:31 | Joubu | we could deal with that at code level I guess, and force the borrowernumber when inserting it, if already exist in deletedborrowers |
| 10:31 | but that is awful | |
| 10:32 | ashimema | yeah.. that's not nice at all |
| 10:33 | ack.. i can't think of a nice way around this then :( | |
| 10:34 | I wonder if ribasushi has ever come up against this sort of issue? | |
| 10:34 | we 'could' use guid's | |
| 10:35 | but that sorta feels really nasty too | |
| 10:39 | tcohen joined #koha | |
| 10:39 | tcohen | morning |
| 10:40 | @wunder anisacate, argentina | |
| 10:40 | huginn | tcohen: Error: HTTP Error 404: Not Found |
| 10:40 | drojf | hi tcohen and ashimema |
| 10:40 | magnuse | ¡hola tcohen! |
| 10:40 | @wunder enbo | |
| 10:40 | tcohen | hola magnuse drojf and ashimema |
| 10:40 | huginn | magnuse: The current temperature in Bodo, Norway is 7.0°C (11:20 AM CET on January 27, 2017). Conditions: Scattered Clouds. Humidity: 81%. Dew Point: 4.0°C. Windchill: 2.0°C. Pressure: 29.95 in 1014 hPa (Steady). |
| 10:40 | magnuse | \o/ |
| 10:40 | * ashimema | is in his next call |
| 10:41 | tcohen | ashimema: YAY |
| 10:41 | drojf | yay calls. i did that yesterday, like half the day |
| 10:41 | tcohen | @wunder ARXX1831 |
| 10:41 | huginn | tcohen: Error: HTTP Error 404: Not Found |
| 10:41 | tcohen | ok |
| 10:41 | @wunder cordoba, argentina | |
| 10:41 | huginn | tcohen: The current temperature in Cordoba, Argentina is 11.0°C (7:00 AM ART on January 27, 2017). Conditions: Clear. Humidity: 88%. Dew Point: 9.0°C. Pressure: 30.18 in 1022 hPa (Steady). |
| 10:41 | drojf | heh huginn is not happy today |
| 10:43 | Joubu | ashimema, and for the record: bug 18003 |
| 10:43 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18003 enhancement, P5 - low, ---, gmcharlt, NEW , Should deletedborrowers.borrowernumber be a primary key? |
| 10:46 | Joubu | alex_a_: you could have found a more exiting bug for 18000! |
| 10:47 | ashimema | we 'could' mark borrowers in the borrowers table as deleted instead of having a deleted_borrowers table at all.. that would maintain integrity? |
| 10:47 | but it's a fairly drastic change | |
| 10:48 | I'm not fully in the loop on why we're worrying about it all right now ;) | |
| 10:48 | Joubu | ashimema: I have brought this discussion last year, it did not interest lot of people |
| 10:51 | ashimema: I have explained on 18003 the problem and the different solutions I have in mind. I have also attached an example of why we need it | |
| 10:52 | alex_a_ | Joubu: we make great a thing by doing many small ones |
| 10:52 | -a | |
| 10:53 | marcelr | bug 18000 |
| 10:53 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18000 enhancement, P5 - low, ---, alex.arnaud, Needs Signoff , Add --tablename option to misc/devel/update_dbix_class_files.pl script |
| 10:53 | marcelr | aiming for bug 20000 |
| 10:53 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=20000 could not be retrieved: InvalidBugId |
| 10:55 | marcelr | who is signing off this trivial one: bug 17982 |
| 10:55 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17982 minor, P5 - low, ---, m.de.rooy, Needs Signoff , Fix the use of uniq in sub themelanguage |
| 10:55 | tcohen | alex_a_: hehe |
| 10:55 | Joubu, regarding 13757 | |
| 10:55 | my work was to resurrect that work | |
| 10:55 | the plan to refactor some controller scripts and templates was left for later on purpose | |
| 10:56 | marcelr | @later tell kidclamp: please try bug 17980 for me |
| 10:56 | huginn | marcelr: The operation succeeded. |
| 10:56 | Joubu | tcohen: yep, seen your answer :) |
| 10:56 | tcohen: is it on your todolist? :D | |
| 10:57 | tcohen | of course |
| 10:57 | I started with CheckUniqueness | |
| 10:58 | alex_a_ | Joubu: What is fixed in new version of DBIx::Class::Schema::Loader ? |
| 10:58 | Never said that there was a bug in DBIx::Class::Schema::Loader | |
| 11:00 | Joubu | alex_a_: it will not modify the timestamp and so the md5sum unless modified |
| 11:00 | so you won't see all the schema files on git status | |
| 11:08 | tcohen: found a bug, must be trivial to fix | |
| 11:08 | tcohen | Joubu: tell me |
| 11:09 | Joubu | tcohen: I let a comment |
| 11:09 | tcohen | Joubu: thanks! |
| 11:10 | most issues are related to how tied is the data model to the page structure | |
| 11:10 | that's why this deserves to be rewritten on top of the REST api IMHO | |
| 11:11 | Barrc left #koha | |
| 11:20 | kmlussier joined #koha | |
| 11:37 | Joubu | khall: Hi! Can I get your opinion on bug 15545 please? See last comment |
| 11:37 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=15545 enhancement, P5 - low, ---, m.de.rooy, Signed Off , Optionally make hold notes required when placing a hold (via Koha::Plugin) |
| 11:37 | khall | sure! |
| 12:03 | rsantellan joined #koha | |
| 12:13 | marcelr joined #koha | |
| 12:26 | paul_p joined #koha | |
| 12:39 | tcohen | oleonard++ |
| 12:39 | tcohen1 joined #koha | |
| 12:39 | * tcohen1 | loves to see more people contributing to make kohadevbox better |
| 12:44 | oleonard joined #koha | |
| 12:47 | tcohen | hi oleonard, thanks for taking care of README.md |
| 12:48 | oleonard | Sure, thanks for the instructions on filing an issue. |
| 12:48 | tcohen | ha |
| 12:48 | I think it might be time to move kohadevbox into the koha repositories now that some people use it | |
| 12:48 | and have a more koha-ish qa workflow | |
| 12:49 | * tcohen | loves superpowers, though |
| 12:49 | oleonard | :D |
| 12:49 | Oh cool, updated VirtualBox Guest Additions getting installed automatically | |
| 12:50 | * cait | loves kohadevbox :) |
| 12:51 | tcohen | finally! |
| 12:52 | meliss joined #koha | |
| 12:52 | cait | :P |
| 12:54 | * oleonard | brb |
| 12:54 | oleonard | quit |
| 12:56 | jzairo joined #koha | |
| 13:04 | tcohen1 joined #koha | |
| 13:07 | alex_a joined #koha | |
| 13:14 | marcelr | khall: not sure if i understand your comments on bug 15545 about odd behavior |
| 13:14 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=15545 enhancement, P5 - low, ---, m.de.rooy, Signed Off , Optionally make hold notes required when placing a hold (via Koha::Plugin) |
| 13:15 | khall | marcelr: as in the change is very very specific, and not general. It decides if one hold field is required, rather than all hold fields in general |
| 13:16 | marcelr | yes, so a good reason for a plugin, yes? |
| 13:18 | misilot joined #koha | |
| 13:18 | khall | marcelr: pluggability should be for the controlling behavior, not for the action imo. I'm trying to say if the plugin hook could be used to decide if any given hold form field should be required it would make more sense to me. That being said, I'm not opposed to it the way it works atm. I'm wondering if maybe HEA should be able to track installed plugins, that would be useful |
| 13:18 | marcelr | ok thx |
| 13:19 | cait | plugin popularity - dokuwiki does that |
| 13:23 | mtompset_testing joined #koha | |
| 13:23 | cait | it's helpful when seleting a new plugin you want to use |
| 13:23 | magnuse | plugins++ |
| 13:24 | mtompset | @seen tcohen |
| 13:24 | huginn | mtompset: tcohen was last seen in #koha 33 minutes and 2 seconds ago: <tcohen> finally! |
| 13:24 | mtompset | Greetings, #koha. |
| 13:27 | oleonard joined #koha | |
| 13:30 | edveal joined #koha | |
| 13:30 | edveal | Hello |
| 13:30 | wahanui | salut, edveal |
| 13:32 | tcohen | hi mtompset |
| 13:33 | mtompset | I'm just looking at your comment on the kohadevbox issue, tcohen |
| 13:33 | Personally, I'd just perfer a way to install the latest JRE as needed. The whole xenial/!xenial split is too rigid. | |
| 13:34 | ^perfer^prefer^ | |
| 13:35 | tcohen joined #koha | |
| 13:37 | edveal | Happy Friday! |
| 13:38 | magnuse | \o/ |
| 13:38 | nengard joined #koha | |
| 13:39 | * LibraryClaire | does a Friday dance |
| 13:40 | tcohen | mtompset: for ES 2.x+ we are pulling the Oracle Java runtime |
| 13:40 | * mtompset | frowns. |
| 13:40 | mtompset | Sorry, different context. |
| 13:40 | I can't sudo apt-get upgrade my kohadevbox. | |
| 13:41 | it keeps barfing on koha-common | |
| 13:44 | NateC joined #koha | |
| 13:55 | paul_p joined #koha | |
| 14:06 | misilot_ joined #koha | |
| 14:06 | misilot__ joined #koha | |
| 14:06 | kellym joined #koha | |
| 14:14 | pastebot | "mtompset" at 127.0.0.1 pasted "Current 'vagrant up xenial' failure" (2 lines) at http://paste.koha-community.org/284 |
| 14:15 | tcohen | mtompset: i got the same |
| 14:15 | vagrant xenial provision | |
| 14:15 | should make it continue | |
| 14:17 | mtompset | Hmm... it had a skipping on that step this time. I'll have to check when it is finished. |
| 14:18 | JoshB joined #koha | |
| 14:18 | kholt joined #koha | |
| 14:28 | mtompset | Hmmm.. same problem for Jessie. |
| 14:29 | When is the last time someone actually tried koha-create on a normal git clone? | |
| 14:29 | tcohen | something changed in the return value for koha-create |
| 14:29 | mtompset | Yep. About to try to track that down. |
| 14:36 | kmlussier joined #koha | |
| 14:44 | Joubu | Is the pagination of the search result broken on the staff interface? |
| 14:44 | master | |
| 14:45 | cait | can't test right now |
| 14:45 | Joubu | ha that may be caused by bootstrap3 |
| 14:45 | I get 1 page per line, it's ugly | |
| 14:45 | cait | lucky we pushed early |
| 14:46 | LibraryClaire | Joubu me too |
| 14:47 | Joubu | ok confirmed it's bootstrap |
| 14:48 | josef_moravec: any chances you could take a lookt? | |
| 14:48 | bug 18005 | |
| 14:48 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18005 major, P5 - low, ---, gmcharlt, NEW , Pagination of the search result displayed wrong |
| 14:50 | gaetan_B joined #koha | |
| 14:52 | jac joined #koha | |
| 14:54 | drojf | is it possible to get item info in OAI? |
| 14:54 | tcohen | yes |
| 14:55 | in extended mode | |
| 14:55 | https://perldoc.koha-community.org/opac/oai.html | |
| 14:55 | it is not properly documented | |
| 14:56 | drojf | i found bug 12252 |
| 14:56 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=12252 enhancement, P5 - low, ---, robin, CLOSED FIXED, OAI-PMH GetRecord result doesn't include item data |
| 14:56 | drojf | thanks, will have a look |
| 14:58 | tcohen | include_items: 1 |
| 14:58 | we should definitely ship a sample extended configuration file | |
| 14:59 | Joubu | Is bug 17978 a bug? |
| 14:59 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17978 major, P5 - low, ---, koha-bugs, REOPENED , Circ rules will not limit holds |
| 14:59 | Joubu | placerequest is added reserve without checking if the patron can still place a hold |
| 14:59 | misilot joined #koha | |
| 14:59 | Joubu | So if you are placing several holds in once row, there is no check... |
| 15:00 | well, there is 1 check. So if the patron can place 1 hold, he is able to place X holds | |
| 15:00 | I guess it's a long standing bug | |
| 15:01 | mtompset | tcohen: I think it is the koha-start-zebra that is the broken this, not the create. |
| 15:01 | I vaguely recall worrying about that return 0 || return 1 mess. | |
| 15:02 | eythian | what is that? |
| 15:02 | no one should ever write return 0 || return 1 I'm sure | |
| 15:02 | tcohen | mtompset: did you sign my patches removing koha-start-zebra already=? |
| 15:03 | mtompset | don't recall anything. :) |
| 15:03 | just looking at the debian scripts file. | |
| 15:04 | eythian: koha-start-zebra | |
| 15:04 | pastebot | "mtompset" at 127.0.0.1 pasted "yuckiness" (15 lines) at http://paste.koha-community.org/285 |
| 15:05 | eythian | ah |
| 15:05 | that's legit | |
| 15:05 | it's not nice, but it's legit | |
| 15:05 | drojf | beer o'clock |
| 15:05 | wahanui | rumour has it beer o'clock is a vital part of the Koha development process |
| 15:06 | tcohen | mtompset: bug 17467 |
| 15:07 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17467 enhancement, P5 - low, ---, tomascohen, Needs Signoff , There should be a koha-zebra script to handle Zebra daemons for instances |
| 15:07 | mtompset | So daemon returns non-zero and the && return 0 || return 1 toggles the value to a success (0) or failure (1) |
| 15:07 | ? | |
| 15:12 | eythian | yeah, it's left-associative. So if the daemon call is successful, it returns 0, else returns 1. |
| 15:12 | I'd probably put it in an if for clarity myself. | |
| 15:14 | mtompset | Why if? Why not return $?; |
| 15:14 | Dyrcona joined #koha | |
| 15:17 | LibraryClaire left #koha | |
| 15:17 | tcohen | mtompset: you provided a followup for 17467, do u plan to sign it? |
| 15:18 | eythian | if you could return $?, then you wouldn't need the && || stuff anyway, you'd just return the value from daemon. |
| 15:19 | you could put an if catching $?, that's probably not terrible. | |
| 15:19 | I'd just move everything to systemd units myself :) | |
| 15:23 | mtompset | tcohen: probably not? my kohadevboxes are down.. it will take 3 hours to get them back. |
| 15:24 | cait | looking at indicators for http://www.loc.gov/marc/bibliographic/bd246.html |
| 15:24 | how do you interpret 3? | |
| 15:24 | 'no note, added entry'? | |
| 15:24 | "Whether a note and/or an added entry is generated from the field." not sure what that means really | |
| 15:25 | fridolin left #koha | |
| 15:36 | tcohen1 joined #koha | |
| 15:36 | tcohen1 | cait: that's left to the readers interpretation |
| 15:40 | alex_a joined #koha | |
| 15:40 | drojf | MARCfight! |
| 15:40 | * drojf | throws MARC at cait |
| 15:41 | alex_a joined #koha | |
| 15:42 | drojf | have a nice weekend #koha |
| 15:45 | cait | tcohen: afraid so |
| 15:45 | tcohen | you are the reader this time, sorry |
| 15:58 | TGoat joined #koha | |
| 15:58 | LibraryClaire joined #koha | |
| 16:04 | reiveune | bye |
| 16:04 | reiveune left #koha | |
| 16:05 | * ashimema | sits back to watch the MARC fight progress |
| 16:06 | wonders if there's popcorn available ;) | |
| 16:14 | mtompset | Hmm... what is the difference between 2 and 3, cait? |
| 16:15 | cait | no idea |
| 16:15 | tcohen | mtompset: 1 |
| 16:15 | mtompset | Okay, re-reading it again... tcohen this is the MARC mess. |
| 16:16 | It seems to me that 0 and 2 must always have a second indicator of #. | |
| 16:16 | tcohen | 3 - 2 = 1 |
| 16:17 | mtompset | Where as 1 and 3 -- yes, yes, I got that, but that's not relevant to the context I'm thinking -- must have something saying what kind of title is generated. |
| 16:17 | cait | like a $i? |
| 16:17 | where are you getting this from? | |
| 16:18 | mtompset | I'm just reading the link you gave. |
| 16:19 | I'm not a librarian, so I don't know. | |
| 16:19 | cait | hm When displayed/printed as a note, varying forms of titles are usually preceded by an introductory term or phrase that is generated as a display constant based on the second indicator value. |
| 16:19 | but that's 0 and 1 | |
| 16:20 | and there is an example of 3 with the second indicator set | |
| 16:20 | mtompset | Oh, 245 isn't repeatable. |
| 16:21 | I would treat 246 like 245's if they could repeat. :) | |
| 16:21 | But remember, I'm not a librarian, so I know squat in MARC. :) | |
| 16:21 | tcohen | can we invoke jcamins? |
| 16:22 | mtompset | Oooo.... jcamins the demi-god of cataloguing. |
| 16:24 | tcohen | need to spell his name three times I think |
| 16:26 | * druthb | invokes the jcamins |
| 16:26 | * oleonard | sets out a plate of freshly-baked cookies to lure jcamins |
| 16:27 | tcohen | jcamins |
| 16:28 | jcamins | |
| 16:28 | jcamins | |
| 16:29 | jbeno joined #koha | |
| 16:30 | mtompset | I even posted on FB. :P |
| 16:31 | * tcohen | is parsing the telephatic answer from Jared |
| 16:31 | * mtompset | grins. |
| 16:31 | tcohen | "The title entered is searchable but will not be shown. |
| 16:31 | For example: | |
| 16:31 | 245 10 $a Apples & bears | |
| 16:31 | 246 33 $a Apples and bears | |
| 16:31 | That is a made up example, of course. | |
| 16:31 | " | |
| 16:31 | cait ^^^ that's for you | |
| 16:34 | cait | ah |
| 16:34 | is that in the docs somewhere that it should not be shown? | |
| 16:34 | I'd file a bug then | |
| 16:38 | tcohen | that's Jared's understanding |
| 16:38 | cait | ok |
| 16:38 | that suits me fine actually :) | |
| 16:39 | is that for indicators 3 and 5? | |
| 16:39 | 3 and 4? | |
| 16:39 | wahanui | 7 |
| 16:39 | cait | or only for 3? |
| 16:40 | hm think only 3 | |
| 16:42 | oh | |
| 16:42 | barton | I have a yaz-client question -- the syntax for specifying a server, either on the command line or with 'open', is [(tcp|ssl|unix|http)':']host [:port][/base] ... but when connecting to a unix socket, the '/base' part (e.g. /biblios) isn't distinguishable from part of the socket path. yaz-client unix:/var/run/koha/switch/bibliosocket/biblios doesn't work. |
| 16:42 | cait | bug 18000 |
| 16:42 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18000 enhancement, P5 - low, ---, alex.arnaud, Needs Signoff , Add --tablename option to misc/devel/update_dbix_class_files.pl script |
| 16:42 | cait | not very spectacular :) |
| 16:43 | but nice anyway | |
| 16:43 | wahanui | nice is perhaps not as enthusiastic of a word as I meant |
| 16:43 | cait | bug 18006 |
| 16:43 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18006 enhancement, P5 - low, ---, gmcharlt, NEW , MARC21: Don't show 246 when 1st indicator = 3 |
| 16:44 | oleonard | On to 19000 |
| 16:44 | barton | is there a way of specifying the database to connect to in yaz-client when we're using sockets? |
| 16:45 | I tried yaz-client unix:/var/run/koha/switch/bibliosocket /biblios, but that caused unhappiness. | |
| 16:46 | I figured if I left an empty port, the colon would act as a delimiter: | |
| 16:46 | yaz-client unix:/var/run/koha/switch/bibliosocket:/biblios didn't work either. | |
| 16:52 | CrispyBran joined #koha | |
| 16:54 | kellym joined #koha | |
| 16:55 | sophie_m joined #koha | |
| 17:01 | rocio joined #koha | |
| 17:03 | kidclamp | @wunder 05001 |
| 17:03 | huginn | kidclamp: The current temperature in Wilder Street, Hartford, Vermont is 3.4°C (12:02 PM EST on January 27, 2017). Conditions: Overcast. Humidity: 54%. Dew Point: -5.0°C. Windchill: 3.0°C. Pressure: 29.39 in 995 hPa (Falling). |
| 17:05 | oleonard | Hi kidclamp |
| 17:06 | kidclamp | hi oleonard |
| 17:06 | wahanui | hi olé onard |
| 17:12 | josef_moravec left #koha | |
| 17:14 | cait joined #koha | |
| 17:17 | abbfla66 joined #koha | |
| 17:18 | * mtompset | curses apparmour and mysql not playing nice. |
| 17:28 | kellym joined #koha | |
| 18:10 | laurence left #koha | |
| 19:01 | talljoy joined #koha | |
| 19:28 | oleonard | Oh hey look Bug 17942 still needs a signoff. |
| 19:28 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17942 enhancement, P5 - low, ---, oleonard, Needs Signoff , Update style of the web installer with Bootstrap 3 |
| 19:55 | mtompset | oleonard: I get a conflict |
| 19:55 | oleonard | Dang. |
| 19:56 | mtompset | oops... |
| 19:56 | typo | |
| 19:56 | That's why. | |
| 19:56 | Sorry for the heart attack. ;) | |
| 20:14 | eythian | @later tell drojf weirdos: http://www.atlasobscura.com/ar[…]fore-world-war-ii |
| 20:14 | huginn | eythian: The operation succeeded. |
| 20:17 | eythian | bag: a correction about your Let's Encrypt press release: you're hopefully using TLS and not SSL. |
| 20:17 | bag | :) |
| 20:18 | I wasn’t sure all the readers understood TLS so I went simple | |
| 20:18 | that was probably my mistake | |
| 20:19 | eythian | But wrong to us pedants! Boo! Hiss! ;) |
| 20:22 | mtompset | Okay, eythian edumacate me. TLS != SSL, explain the diff. |
| 20:24 | eythian | You'd be better to look them up, my explanation will be a bit half arsed. The essence is that TLS is similar to, and the successor to, SSL. I think mostly SSL isn't able to do certain things that TLS can. |
| 20:25 | (I want to say SNI is one of those, but I'm not sure.) | |
| 20:25 | mtompset | And potential legal issues with Netscape having SSL trademark or something? |
| 20:26 | eythian | Not at all to my knowledge. |
| 20:26 | But my knowledge isn't great on this. | |
| 20:26 | I should learn about it. | |
| 20:27 | mtompset | ""SSL" means "Secure Sockets Layer". This was coined by the inventors of the first versions of the protocol, Netscape (the company was later bought by AOL)." (http://security.stackexchange.[…]sl-tls-and-https) |
| 20:29 | eythian: You got a Xenial Kohadev box? :) | |
| 20:29 | eythian | I have no koha dev box at the moment |
| 20:30 | mtompset | *gasp* I was curious if you could play with bug 17260, as it seems to make the installation process succeed for the Xenial Kohaev box. :) |
| 20:30 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17260 major, P5 - low, ---, philippe.blouin, Needs Signoff , updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns |
| 20:30 | eythian | I'm building a cluster, and when I get the infrastructure sorted, I'm going to have a go at splitting koha up to fit in it. |
| 20:31 | mtompset | splitting, as in putting the DB on a different machine? |
| 20:31 | eythian | Putting everything that can be separated on a different machine. |
| 20:31 | My cluster is built of tiny machines | |
| 20:31 | mtompset | ooo... in that case, do I have a bug for you! |
| 20:31 | bug 16690 | |
| 20:31 | huginn | 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=16690 minor, P5 - low, ---, mtompset, Needs Signoff , Installing DB on remote server fails without *.* permissions |
| 20:33 | eythian | Hmm, that looks like a problem. That'll hit many people. |
| 20:34 | mtompset | And yet, no one has signed off for months. :( |
| 20:34 | eythian | Well, I'll look at it if I get my system properly designed and built any time soon :) |
| 20:37 | bag | yeah we do that eythian |
| 20:37 | mtompset | That would make me happy. :) |
| 20:38 | bag | currently zebra is a bit of a limitation in clustering and plack… you need plack for every instance so you sort of suck up memory… We need the single plack for multiple instances |
| 20:38 | can’t wait for ES - then clustering will be loads of fun ;) | |
| 20:40 | mtompset | Have a great day, #koha bag eythian |
| 20:40 | eythian | bag: catalyst too (unless things have changed, but I doubt it.) |
| 20:41 | Yeah, the namespacing of instances needs to be moved more into koha itself to solve that. | |
| 20:41 | Not impossible. | |
| 20:42 | * eythian | has moved into the team building the new highly containered Perl infrastructure at work, and is starting to develop Opinions on it. |
| 20:43 | eythian | It's a crazy world at huge scale. |
| 21:04 | misilot_ joined #koha | |
| 21:33 | sdlib joined #koha | |
| 21:34 | sdlib | how long does it take a quick slip update to take effect? |
| 21:36 | tried to edit 'issue quick slip' (print) and it did nothing, that was 2 hours ago | |
| 21:40 | bag | you probably have to restart memcached |
| 21:40 | sdlib | ?? |
| 21:41 | bag | sdlib: is this san diego law library? |
| 21:41 | sdlib | no |
| 21:41 | south dakota | |
| 21:42 | bag | ah SD cool - welcome |
| 21:42 | sdlib | what is memchached, where is it, how do i restart it? |
| 21:42 | bag | from the commandline on your server |
| 21:43 | sdlib | hmm.... i am not sure i have access to that |
| 21:44 | our library's server? | |
| 21:44 | bag | yes where is koha hosted for you? |
| 21:45 | sdlib | good question. so, basically i find out where koha is hosted for us and if it's something i have access to i restart memcached and if not i ask the people who host it for us to do it. |
| 21:45 | bag | yes :) |
| 21:45 | sdlib | i *think* we go through people called bywater solutions but idk if they do the actual hosting or not |
| 21:46 | bag | cool yeah that’s us |
| 21:46 | sdlib | i will find out. thanks! |
| 21:46 | kidclamp | have a great weekend #koha |
| 21:46 | bag | which library are you at now sdlib |
| 21:46 | I can get someone on that right away for you if you’re with bywater sdlib | |
| 21:47 | sdlib | Grace Balloch |
| 21:48 | bag | perfect - yes you’re with us |
| 21:48 | we’ll get someone on that for you | |
| 21:48 | sdlib | thanks! |
| 21:48 | bag | give me about 10 minutes and you should now see your changes |
| 21:50 | sdlib: restarted | |
| 21:51 | sdlib | ok i'll give it a few and see if i get the changes |
| 21:52 | JoshB left #koha | |
| 21:58 | sdlib | so is it configured to update after a certain amount of time or is it a manual thing? i think i changed the slips before several months ago and changes went through almost immediately |
| 22:06 | still no change | |
| 22:30 | edveal left #koha | |
| 22:36 | eythian | @later tell LibraryClaire https://www.mcsweeneys.net/art[…]ave-a-single-word |
| 22:36 | huginn | eythian: The operation succeeded. |
| 22:44 | kmlussier joined #koha | |
| 22:50 | * eythian | wishes to remind you that the CPAN testing system is called CPANTS |
| 22:50 | eythian | Because it's funny |
| 23:18 | jbeno_away joined #koha |
← Previous day | Today | Next day → | Search | Index