IRC log for #koha, 2017-11-07

All times shown according to UTC.

Time S Nick Message
00:12 drojf[m] joined #koha
00:12 khall joined #koha
00:19 kidclamp .
00:19 * kidclamp waves
00:20 caboose joined #koha
00:39 dcook joined #koha
00:45 BobB joined #koha
01:34 caboose joined #koha
01:50 Kafilini joined #koha
01:52 edveal joined #koha
01:56 dilan joined #koha
02:35 edveal joined #koha
02:43 RKL joined #koha
02:44 RKL HI ALL. would like to ask if possible for me to get list of books according to barcode number?
03:11 wizzyrea you mean out of your koha RKL
03:18 kathryn_ joined #koha
03:29 RKL wizzyrea yes
03:29 RKL run report
03:29 wizzyrea select barcode from items
03:30 wizzyrea if you wanted say
03:30 wizzyrea the title
03:30 wizzyrea select biblio.title, biblio.author, items.barcode from biblio join items using(biblionumber)
03:30 wizzyrea RKL ^
04:02 mtompset Have a great day, #koha wizzyrea RKL rangi
04:36 BobB joined #koha
05:13 Kafilini joined #koha
06:14 BobB joined #koha
06:14 dilan joined #koha
06:14 Guest8663 joined #koha
06:14 ibeardslee joined #koha
06:14 cesardv joined #koha
06:14 shakalaka joined #koha
06:14 eythian joined #koha
06:14 ribasushi joined #koha
06:14 chris_n joined #koha
06:14 jeff joined #koha
06:14 JesseM_away joined #koha
06:14 dpk_ joined #koha
06:14 pastebot joined #koha
06:14 pianohacker joined #koha
06:14 wizzyrea joined #koha
06:14 misilot joined #koha
06:16 misilot joined #koha
06:16 wizzyrea joined #koha
06:16 pianohacker joined #koha
06:16 pastebot joined #koha
06:16 dpk_ joined #koha
06:16 JesseM_away joined #koha
06:16 jeff joined #koha
06:16 chris_n joined #koha
06:16 ribasushi joined #koha
06:16 eythian joined #koha
06:16 shakalaka joined #koha
06:16 cesardv joined #koha
06:16 ibeardslee joined #koha
06:16 Guest8663 joined #koha
06:16 dilan joined #koha
06:16 BobB joined #koha
06:16 Joubu joined #koha
06:16 fredericd joined #koha
06:16 jajm joined #koha
06:16 Nemo_bis joined #koha
06:16 kivilahtio joined #koha
06:16 matts joined #koha
06:16 lari joined #koha
06:16 janPasi joined #koha
06:16 jenkins joined #koha
06:16 sonOfRa joined #koha
06:16 mtj joined #koha
06:16 mirkh joined #koha
06:16 rkrimme1_ joined #koha
06:16 Infra_3600 joined #koha
06:16 slef joined #koha
06:16 magnuse joined #koha
06:16 cait joined #koha
06:16 tcohen joined #koha
06:16 drojf[m] joined #koha
06:16 khall joined #koha
06:17 khall joined #koha
06:17 drojf[m] joined #koha
06:17 tcohen joined #koha
06:17 cait joined #koha
06:17 magnuse joined #koha
06:17 slef joined #koha
06:17 Infra_3600 joined #koha
06:17 rkrimme1_ joined #koha
06:17 mirkh joined #koha
06:17 mtj joined #koha
06:17 sonOfRa joined #koha
06:17 jenkins joined #koha
06:17 janPasi joined #koha
06:17 lari joined #koha
06:17 matts joined #koha
06:17 kivilahtio joined #koha
06:17 Nemo_bis joined #koha
06:17 jajm joined #koha
06:17 fredericd joined #koha
06:17 Joubu joined #koha
06:19 khall joined #koha
06:19 drojf[m] joined #koha
06:19 tcohen joined #koha
06:19 cait joined #koha
06:19 magnuse joined #koha
06:19 slef joined #koha
06:19 Infra_3600 joined #koha
06:19 rkrimme1_ joined #koha
06:19 mirkh joined #koha
06:19 Joubu joined #koha
06:19 fredericd joined #koha
06:19 jajm joined #koha
06:19 Nemo_bis joined #koha
06:19 kivilahtio joined #koha
06:19 matts joined #koha
06:19 lari joined #koha
06:19 janPasi joined #koha
06:19 jenkins joined #koha
06:19 sonOfRa joined #koha
06:19 mtj joined #koha
06:30 cait left #koha
06:51 * magnuse waves
07:10 aslak joined #koha
07:12 aslak joined #koha
07:12 dcook_ joined #koha
07:42 AndrewIsh joined #koha
07:47 alex_a joined #koha
07:47 reiveune joined #koha
07:47 alex_a bonjour
07:48 reiveune hello
07:54 fridolin joined #koha
07:55 fridolin hi there
07:55 sophie_m joined #koha
08:06 cait joined #koha
08:11 greenjimll joined #koha
08:13 tuxayo joined #koha
08:14 benjamin joined #koha
08:22 ashimema joined #koha
08:32 cait joined #koha
08:35 gaetan_B joined #koha
08:35 gaetan_B hello
08:46 Kafilini joined #koha
08:51 cait joined #koha
09:03 eythian hi
09:05 * cait waves
09:08 Francesca joined #koha
09:24 gaetan_B joined #koha
09:29 LibraryClaire joined #koha
09:29 LibraryClaire left #koha
09:44 alex_a_ joined #koha
09:45 fredericd joined #koha
10:17 Kafilini joined #koha
10:35 cait joined #koha
11:16 * kidclamp waves
11:16 cait joined #koha
11:29 cait1 joined #koha
11:53 nengard joined #koha
11:55 oleonard joined #koha
12:19 aslak joined #koha
12:22 alex_a_ joined #koha
12:29 meliss joined #koha
12:29 caboose joined #koha
12:50 Nemo_bis joined #koha
12:52 jzairo joined #koha
13:15 marcelr joined #koha
13:15 marcelr hi #koha
13:15 tcohen morning
13:15 marcelr o/
13:31 NateC joined #koha
13:52 Dyrcona joined #koha
13:55 kmlussier joined #koha
13:59 JoshB joined #koha
14:05 kellym joined #koha
14:06 kellym left #koha
14:07 kellym joined #koha
14:21 kholt joined #koha
14:23 Margaret joined #koha
14:45 blovallo joined #koha
14:55 edveal joined #koha
15:03 Margaret joined #koha
15:03 talljoy joined #koha
15:07 ashimema joined #koha
15:08 matts joined #koha
15:11 oleonard In 17.05 Koha no longer removes an item from a patron's account when it is marked lost?
15:11 oleonard Is there a new system preference for that?
15:12 Joubu oleonard: depends on how you mark it as lost...
15:12 oleonard From moredetails.pl
15:12 Joubu should be
15:13 Joubu are you testing 17.05.x?
15:13 Joubu or .05?
15:15 oleonard 17.05.05
15:15 oleonard Out production system was just upgraded and this was an unexpected behavior
15:16 ashimema joined #koha
15:16 Joubu works for me on 17.05.x
15:17 Joubu I check an item out, mark it as lost using the "set status" button on moredetails, the item has been checked in automatically
15:19 oleonard Thanks for checking Joubu. I think something bigger is going on with our upgrade.
15:23 Joubu nothing in the logs?
15:26 jbeno joined #koha
15:32 fiq_ joined #koha
15:33 fiq_ Hi
15:38 Joubu kidclamp and others: I moved tomorrow's dev meeting 1h later (15UTC)
15:38 Joubu so general at 14 and dev at 15, is that ok for you guys?
15:44 oleonard Works for me Joubu
15:59 TGoat joined #koha
16:09 Wildcatter joined #koha
16:09 lari joined #koha
16:12 JesseDhammu joined #koha
16:13 JesseDhammu joined #koha
16:13 Wildcatter Hello, I'm new here. I just migrated from an old Koha server to a new Koha server using Koha 17.05 and now when I try to check out a book, I get the following error: "DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '21' for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121." How can I fix this?
16:22 fridolin see u tomorrow for meeting
16:22 fridolin left #koha
16:23 kidclamp Joubu - works for me
16:23 Wildcatter Hello?
16:25 Joubu Wildcatter: hello
16:26 ashimema joined #koha
16:26 Wildcatter Hello Joubu, can you help me?
16:26 Joubu I do not know, maybe
16:26 Wildcatter I just migrated from an old Koha server to a new Koha server using Koha 17.05 and now when I try to check out a book, I get the following error: "DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '21' for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121." How can I fix this?
16:27 Joubu Wildcatter: You should read that wiki page: https://wiki.koha-community.or[…]uto_increment_fix
16:27 Joubu which version of 17.05 are you using?
16:27 Wildcatter Thank you, I'll go take a look now.
16:27 Wildcatter 17.05.05.000
16:28 Joubu Wildcatter: perfect
16:29 Wildcatter How so? Is there an easy fix?
16:29 Wildcatter Mind you, I'm new to the world of ILS
16:36 Joubu Wildcatter: are you tech?
16:37 Wildcatter Yes and I know my way around Linux
16:39 Wildcatter I see the solution in your link. I'm thinking about attempting it now, but I don't see a [mysqld] section in my my.cnf file. I'm using MaraiaDB, is that why?
16:39 Joubu no
16:40 Joubu /etc/mysql/my.cnf ?
16:40 Wildcatter Yes, that's right.
16:40 Wildcatter I don't see a [mysqld]
16:40 Joubu which OS are you using?
16:40 ashimema joined #koha
16:41 Wildcatter Ubuntu 16.04
16:41 Wildcatter This is what I see in my my.cnf file: [client-server]
16:42 Joubu `grep -r mysqld /etc/mysql` maybe?
16:43 Joubu well, grep [mysqld] maybe
16:43 Joubu sudo grep -r '\[mysqld\]' /etc/mysql
16:44 Joubu Wildcatter: you read the whole wiki page, right?
16:44 Wildcatter aha.../etc/mysql/mariadb.co​nf.d/50-server.cnf:[mysqld]
16:44 Joubu This trick will *not* fix the existing corrupted data
16:44 Wildcatter I see...
16:45 Wildcatter So what are my options?
16:45 Joubu You will have to deal with them before. Take a look at the about page to know how many rows you have
16:45 Joubu or execute the queries from the " Are your data corrupted? " section
16:46 Wildcatter I'm looking at the about page now...
16:46 Wildcatter How do I determine how many rows I have from the about page?
16:49 Joubu on the "system information" tab
16:49 Joubu you should see a table, with a list of IDs
16:50 Wildcatter Aha...this is what I see: "The following ids exist in both holds and old_reserves table: 21"
16:50 Joubu just one, you are lucky then :)
16:50 Wildcatter Yay!
16:50 Joubu do you understand what it means?
16:50 Wildcatter No
16:51 Wildcatter Well, sort of, but not sure what to do about it
16:51 Joubu on the wiki page, section "The problem". Basically the checkout (from the table issues) cannot be checkin (moved to the old_issues table) because a row with the same id already exists
16:52 Joubu due to the primary key constraint, it cannot be moved
16:52 Joubu so, either you do not care and delete the entry from the old_issues table
16:52 Wildcatter I just ran the queries you mentioned. All said "empty set" except for the last one: "1 row in set (0.00 sec) reserve id 21"
16:52 Joubu ha, it's a reserve!
16:52 Joubu sorry
16:53 Wildcatter Okay, so is the solution the same?
16:53 Joubu so it's the same I just told you, but replace checkout/in with "hold"
16:53 Wildcatter Ok...
16:54 Joubu it's more or less the same, if you do not care about the holds history you can remove the row
16:54 Joubu it's the easier solution
16:54 Joubu or... let me check
16:55 Wildcatter Okay. Tell you the truth, I'm not very good with mysql just yet. How do I delete that particular row?
16:55 Joubu are you sure you want to delete it?
16:55 Wildcatter Yes
16:55 Wildcatter This is a new library
16:56 Joubu delete from old_reserves where reserve_id=XXX;
16:56 Joubu with XXX= 21 in your case
16:56 Wildcatter ok
16:56 Joubu From which version did you upgrade?
16:56 Wildcatter Done.
16:57 Wildcatter Umm...trying to remember...
16:57 Wildcatter I was on Ubuntu 14.04...
16:57 Wildcatter Can't remember the Koha version...
16:57 Wildcatter I was running mysql then, but now I'm running MaraiDB
16:59 Wildcatter Hey Joubu, if I could, I would kiss you right now. My problem is resolved. Thank you so very much!!
17:02 tuxayo hi, I've found a documentation issue on the "Clean Patron Records" tool. Both the in-app + online doc mention that:
17:02 tuxayo «patrons with outstanding fines or items checked out not saved» (the rest of the doc confirms that we are talking about removal) → nope (code e
17:02 tuxayo https://koha-community.org/man[…]ymize-bulk-delete
17:02 tuxayo aahhhh!!!
17:02 tuxayo I sent my draft before finishing it T_T sorry for the spam
17:02 talljoy joined #koha
17:03 Joubu Wildcatter: setup the DBMS fix to avoid the problem to appear again!
17:03 Wildcatter How do you mean?
17:04 Joubu the mariadb init file
17:05 Wildcatter Okay
17:09 mtompset joined #koha
17:09 mtompset Greetings, #koha.
17:09 mtompset @seen Joubu
17:09 huginn mtompset: Joubu was last seen in #koha 5 minutes and 1 second ago: <Joubu> the mariadb init file
17:09 mtompset Oooo...
17:09 Joubu hi mtompset
17:09 Margaret joined #koha
17:10 tuxayo So, I think I've found a documentation issue on the "Clean Patron Records" tool. Both the in-app + online doc mention that:
17:10 tuxayo «patrons with outstanding fines or items checked out not saved» (the rest of the doc confirms that we are talking about removal) → nope (code exhibits on demand to avoid spamming the chat)
17:10 tuxayo «The anonymization will fail quietly if AnonymousPatron preference does not contain a valid value.» → nope, according to the UI itself «The AnonymousPatron system preference is not  defined. You can use this feature anyway but NULL will be used to  update the checkout history.»
17:10 mtompset I added a patch to bug 19570, Joubu
17:10 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=19570 is not accessible.
17:12 Wildcatter Joubu: Done, with no errors in the error log :)
17:13 Joubu congrats :)
17:13 maggie joined #koha
17:13 Wildcatter Joubu: Thank you, again. You're a lifesaver!
17:14 Wildcatter Joubu: Have a good one!
17:14 Joubu you are welcome
17:14 Wildcatter left #koha
17:16 Joubu mtompset: yep I have seen your patch yesterday, thanks
17:22 tuxayo Oh I forgot to conclude my message with a question... >_< Where can I report these doc issues, in the issue tracker?
17:26 reiveune bye
17:26 reiveune left #koha
17:29 Joubu tuxayo: either bugzilla or https://gitlab.com/koha-commun[…]s-users/kohadocs/
17:30 Joubu tuxayo: https://wiki.koha-community.or[…]diting_the_manual
17:31 barton|laptop joined #koha
17:31 Joubu tuxayo: if you want to fix it :)
17:32 Joubu tuxayo: we are currently working on the manual to avoid redundancy. The idea is to link the local manual with the online doc
17:33 Joubu So I would suggest to fix the online manual first (only?)
17:51 tuxayo Joubu:Thanks. Unfortunately I only have the resources to report this issue. But I'm keeping the resources so when I'll have the time (and business knowledge) to edit something I could do it right away :)
17:52 mtompset Are there any folks who can make sense of bug 14420 for me? The underlying question I have is why does this person have ISBN1|ISBN2|...|ISBNn in 020$a, when 020 is repeatable?
17:52 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=14420 enhancement, P5 - low, ---, vfernandes, Needs Signoff , bulkmarcimport.pl - Some problems
17:58 tuxayo see you tomorrow all!
17:59 Margaret_ joined #koha
18:02 mtompset Ingat, tuxayo. :)
18:02 mtompset (take care)
18:30 Scott-CSPL joined #koha
18:35 greenjimll Joubu: thanks for the Koha newsletter. I've just tried to take a look at new release notes but https://gitlab.com/joubu/koha-[…]notes_17_06_00.md is throwing up 503 errors. Is it just me?
18:37 greenjimll mtompset: have you seen the state of the "MARC" that comes out of some library systems? :-)
18:40 josef_moravec joined #koha
18:51 jenkins joined #koha
18:57 NateC_ joined #koha
19:10 deb-CSPL joined #koha
19:16 Joubu ashimema: Hi! Are you around?
19:17 Joubu greenjimll: it works for me, could you retry?
19:18 greenjimll Ah, works for me as well now. Obviously gitlab was having a bad day.  Looks good.
19:28 kathryn joined #koha
19:29 bshum joined #koha
19:41 kathryn joined #koha
19:45 kathryn joined #koha
19:47 kmlussier joined #koha
19:58 barton joined #koha
20:08 NateC_ joined #koha
20:11 NateC__ joined #koha
20:34 Kafilini joined #koha
20:46 Joubu Guys... Why are you rebasing/signoffing new enhancement whereas the feature freeze is passed?
20:47 Joubu There are major and critical bugs for everybody
20:48 kathryn joined #koha
21:00 kholt joined #koha
21:07 Margaret joined #koha
21:13 sonOfRa joined #koha
21:19 cait joined #koha
21:19 * cait waves
21:27 eythian cait: I have been very sick. I blame you.
21:28 eythian Where do germs come from, cait? Where do germs come from.
21:29 cait hmpf.
21:29 cait probably deserved you right, because you are always so mean to me :P
21:30 eythian *served
21:30 eythian And, never!
21:30 cait :)
21:42 cait Joubu++
21:46 kholt joined #koha
21:46 kathryn joined #koha
21:51 kathryn joined #koha
22:04 BobB joined #koha
22:06 mtj joined #koha
22:07 Francesca joined #koha
22:13 kathryn joined #koha
22:14 Kafilini joined #koha
22:34 kathryn joined #koha
23:01 kathryn joined #koha
23:30 JoshB left #koha
23:32 kathryn joined #koha
23:40 kathryn joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary