Time Nick Message
06:47 reiveune hello
06:52 * magnuse waves
06:59 alex_a bonjour
07:06 * magnuse looks forward to https://en.wikipedia.org/wiki/Marseille_%28TV_series%29
07:35 * pj- slaps mtj around a bit with a large fishbot
07:35 pj- G'day Mason
07:36 irma_ thanks mtj
07:37 pj- Hi Irma, I can see you now : )
07:52 irma_ hi all in #koha :-)
11:35 teyekea hello there, i've live koha. And when i search for item it only brings itmes before some years back. I tried "rebuild_zebra.pl -v -b -r -a -run-as-root" and it shows me"authority exported 3000 biblio exported 5000" and [warn] Record didn't contain match fields in (bib1,Local-number)
11:36 teyekea and the search is still the same
11:36 teyekea oh and before warning it also shows zebraidx(13000)
11:37 teyekea and the mode is "dom"
11:38 triveni hi
11:50 teyekea any idea?
11:52 teyekea is there any other way to reindex everything??
11:57 cait you shouldn't runadroot
11:57 cait usually
11:57 cait how did you install koha?
11:57 cait it can mess up the permissions of the index files and cause a lot of problems
11:58 teyekea cait: its already installed by some other person. is there any way i can check?
11:59 cait hm
11:59 cait you can find your version on the about page
11:59 cait maybe let's start there
12:01 teyekea it is 3.16.04.000
12:04 teyekea cait: ok i checked the owner of the koha's file and changed into that and now running the rebuiled again
12:05 cait run it as your koha user without the run-as-root
12:06 teyekea ok am doing that.. it exporting , will let u know the result
12:11 teyekea cait: i just found on koha-community site "you should export two env variable PERL5LIB=/path/to/koha KOHA_CONF=/path/to/koha-conf.xml" but i did only PERL5LIB=/path/to/koha/lib does it going to affect the indexing?
12:12 teyekea its on progress reindexing zebra
12:15 tcohen goedemorgen #koha
12:15 marcelr hi tcohen: your dutch is fine today
12:15 tcohen heh
12:16 marcelr tcohen: what is the status of bug 16155
12:16 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16155 enhancement, P5 - low, ---, m.de.rooy, Passed QA , Composite keys in TestBuilder and more
12:16 marcelr did you have tests failing?
12:16 tcohen to me is passed QA
12:16 marcelr :)
12:16 tcohen i didn't find anything broken by that patches
12:16 tcohen i worked on batch.t
12:17 marcelr it should reveal faster if we forgot some dbix update
12:17 marcelr only
12:17 tcohen on retrying 16155 because i noticed it was failing since ages
12:17 marcelr it works for me batch.t
12:17 marcelr but wait for bernardo
12:18 teyekea cait: ok it finished, but same thing zebraidx(5343) [warn] Record didn't contain match fields in (bib1,Local-number)
12:18 teyekea and the items are not shown on search result
12:21 teyekea anything i should check?
12:25 teyekea any suggestion???
12:26 kidclamp Joubu++
12:26 kidclamp testing patron import now
12:26 Joubu kidclamp: please test to widely :)
12:26 Joubu test it*
12:29 teyekea sorry cait: to bothering you but could you help me with this? or any other member..
12:29 gaetan_B hello
12:32 teyekea btw it works for items before some years back. what i can't include in the search result is the new items starting of 2015. even after i run rebuild_zebra.pl -v -b -r -a
12:33 teyekea is there next step after that?
12:33 tcohen kidclamp: bug #?
12:33 tcohen hi Joubu
12:35 kidclamp bug 16429
12:35 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16429 minor, P5 - low, ---, kyle, Needs Signoff , Going to circulation from notice triggers may change logged in branch
12:35 kidclamp oops, nope, 16426 tcohen
12:35 kidclamp bug 16426
12:35 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16426 major, P3, ---, jonathan.druart, Needs Signoff , Import borrowers tool warns for blank and/or existing userids
12:37 teyekea [warn] Record didn't contain match fields in (bib1,Local-number). why i get this??
12:42 teyekea hello everybody please give me a hand on this
12:57 oleonard teyekea: Did you say you were using DOM indexing?
12:58 oleonard teyekea: Did you change your Koha to MARC mapping from the defaults?
12:59 teyekea yes oleonard: am using DOM
13:00 teyekea my config says <zebra_bib_index_mode>dom</zebra_bib_index_mode><zebra_auth_index_mode>dom</zebra_auth_index_mode>
13:01 teyekea where can i check koha /MARC i didn't change it but it might be changed before
13:01 oleonard It's under Administration in the Koha staff client
13:04 teyekea oleonard: is that in Koha to MARC mapping?
13:04 oleonard teyekea: Yes I'm wondering if you changed the settings in Koha to MARC mapping before the problem arose.
13:05 oleonard teyekea: I'm looking through the mailing list archive at previous reports of this problem and it looks like it is probably a configuration issue
13:05 oleonard teyekea: https://lists.katipo.co.nz/pipermail/koha/2014-November/041221.html
13:05 oleonard teyekea: But I don't have a good understanding of indexing, so I'm just passing on what looks like it might be relevant
13:06 teyekea thanks oleonard that helps too
13:09 teyekea i checked the mailing list you sent me. but i didn't get such errors, in my case it exporting biblio and authority without a problem then it says reindexing zebra after some min it shows me zeberaidx(7322) [warn record didn't contain match fields in (bib1,local-number)]
13:12 teyekea oleonard: btw zeberaidx(##) the number varies every time i run rebuild_zebra
13:13 khall Joubu: take a look at bug 16430, the root cause is a change form bug 13601
13:13 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16430 critical, P5 - low, ---, kyle, Needs Signoff , Mainpage.pl dies if library is not set
13:13 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13601 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Get rid of DateTime::Format::DateParse
13:14 khall @later tell Joubu take a look at bug 16430, the root cause is a change form bug 13601
13:14 huginn khall: The operation succeeded.
13:14 Joubu khall: I am here :)
13:14 khall heh ; )
13:14 Joubu was reading the patch
13:14 Joubu not sure we should remove the die
13:15 Joubu khall: there is a big todo on dates (again)
13:15 Joubu we should not use output_pref( .* dt_from_string .*)
13:16 Joubu but instead use:
13:16 Joubu output_pref({ str => $date })
13:17 teyekea oleonard: any suggestion
13:19 lari Hey, I have a problem with searching. We have some records with lots of items (1000+) and it no longer displays in search results. When i deleted some of the items, it starts to display just fine again. We are running 3.16 here but i managed to duplicate this problem also in master version by adding 2000 items. Anyone else experienced this?
13:21 kidclamp lari: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15399
13:21 huginn 04Bug 15399: normal, P5 - low, ---, gmcharlt, NEW , MARCXML records larger than 1 MB (1048576 bytes) are not searchable.
13:21 Joubu kidclamp: about bug 16426, if it's not related to the bugfix, I'd say it's better to open new reports
13:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16426 major, P3, ---, jonathan.druart, Needs Signoff , Import borrowers tool warns for blank and/or existing userids
13:22 kidclamp can do joubu, wasn't sure if they were considered related
13:25 teyekea oleonard: in Koha to MARC mapping timestamp and datecreated are blank on Tag,subfield and Lib. the problem could be that??
13:26 Joubu kidclamp: if it was the behavior before 15840, please open new reports
13:28 oleonard teyekea: You could check your settings against those in the ByWater demo: http://intranet.bywatersolutions.com/cgi-bin/koha/admin/koha2marclinks.pl
13:28 oleonard I assume they reflect the defaults
13:30 teyekea so if there is deference shall i make it as the default? cause its on production ..nothing will be affected? and after i rest to the default the only thing i should do is rebuild the zebra ?
13:30 oleonard teyekea: Do you have different settings?
13:32 teyekea sorry what was the user name and password for the ByWater demo?
13:32 kidclamp bywater/bywater
13:32 teyekea k tnx
13:34 teyekea oleonard:its the same
13:36 oleonard Sorry teyekea I don't know what to suggest next.
13:36 teyekea oleonard: thank you very much for ur help
13:37 teyekea can anyone help me on the issue please??
13:45 * magnuse waves again
14:15 oleonard I do not like the feeling that I have a git branch somewhere which modifies the file I am about to change.
14:15 oleonard Did I already fix this?
14:17 Joubu oleonard: if you submitted the patch, you can find it using splitter.koha-community.org
14:20 Joubu khall: I don't get the date error. I have created a new empty DB, got the installer, then log in with the DB user
14:20 Joubu and I can see Web installer › Step 1
14:21 Joubu sorry
14:21 Joubu read again the test plan, I need to install all the sample data
14:27 Joubu khall: same with all sample data, I have selected marcflavour=marc21, and dateformat is set to "us"
14:30 Joubu khall: Ha, did you correct the sysprefs.sql file?
14:30 khall Joubu: no, I got distracted, which syspref was that?
14:30 Joubu bug 16418
14:31 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16418 major, P5 - low, ---, jonathan.druart, Signed Off , EnhancedMessagingPreferencesOPAC appears twice in sysprefs.sql
14:31 Joubu it you didn't, the sysprefs files is not inserted
14:31 Joubu and then you do not have the dateformat pref defined, but none of the others neither :)
14:33 khall ah!
14:36 reza Hello
14:37 reza I am getting this error for every search from opac side. it has been logged and made a huge file
14:37 reza opac-search.pl: Use of uninitialized value in string comparison (cmp) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 248.
14:41 bag morning
14:43 reza morning
14:44 reza it's 10:44pm here in Malaysia :)
14:46 huginn New commit(s) kohagit: Bug 16418: Remove duplicate of EnhancedMessagingPreferencesOPAC <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=62231de7f23c0d0d93dbd2cd4bf6541d450f4008>
14:57 reza I am getting this error for every search from opac side. it has been logged and made a huge file/ opac-search.pl: Use of uninitialized value in string comparison (cmp) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 248.
15:00 reiveune bye
15:06 huginn New commit(s) kohagit: Bug 16170 - DBRev 3.23.00.061 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e7eac39e96a239d9f678931c6c12b80742454120> / Bug 16170: [QA Follow-up] Fix embeded typos <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6e0b6ecf1347a91c2d324abc08e76f1cd8d9ffd0> / Bug 16170: [QA Follow-up] Adjust Items.t <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1608b89b7ff90ae1cc307d9f096dd
15:06 magnuse reza: which version of koha are you using?
15:06 magnuse bag: HI
15:06 bag magnuse: hello!
15:26 huginn New commit(s) kohagit: Bug 16403: Remove unnecessary undef param <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=27b2f04ad908527efe57599ed4dc052f1b5b0022> / Bug 16403: Fix holds.t (tests 9 and 39) <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=073a6bda1111668a9eb2f5b8a66b58bea99b2b61> / Bug 16396: Update package version for master packages <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7a5c1ea1
15:36 huginn New commit(s) kohagit: Bug 16423: [QA Follow-up] Remove $opac <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3c67f1d9a56e22a548e8f2a37ce79e54692eaa90> / Bug 16423: (followup) Add more tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=05bab15841b16a0fe9dfc4de7ff6d9b6d2b66a71> / Bug 16423: Fix t/db_dependent/www/batch.t so it matches new layout <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6
15:46 huginn New commit(s) kohagit: Bug 16398: Keep the expanded view after clearing the search form <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7a58f14bfc4e774033e215ffe1cd54caf206a3b5> / Bug 16384: Fix cancel link for 'Edit basket' <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e35b310a1e40bc9ee267c88caeca4a56ffbb4636>
15:56 huginn New commit(s) kohagit: Bug 16408: Fix UsageStats.t <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5657e262b7b57c1477210d6cbd11095538f07268>
16:24 oleonard Why do we have acqui/tables/members_results.tt, patroncards/tables/members_results.tt, and serials/tables/members_results.tt. Are they really so different that they have to be separate files?
16:27 gaetan_B bye
16:33 drab hi there
16:35 tonyhhyip hi
16:39 drab I think I found a pretty nasty problem, but in the past when I thought as much ppl here were quick to point out I was missing something so I thought I'd ask before reporting it on the tracker
16:39 drab the problem is with the backups and the koha-dump script
16:40 drab specifically https://github.com/Koha-Community/Koha/blob/da21ad065939d0789bb90d8fd6d088b781688aa3/debian/scripts/koha-dump#L72
16:40 drab or more precisely the | gzip > "$dbdump"
16:41 drab and how that script works in conjuction with koha-run-backups
16:41 drab basically I had a partial disk failure that corrupted mysql, which in turn would not start
16:41 drab the problem: when that mysqldump | gzip runs the file is created regardless of the fact that the dump succeeded or not
16:42 drab in my case it didn't so what gzip created was an empty 20yte file
16:42 drab unfortunately koha-run-backups rotates the backups by default every 2 days, long story short the good backups have been rotated out and replaced with faulty empty backups
16:45 drab unless I'm missing something, it seems to me that maybe koha-dump should check for errors of mysqldump and/or check that mysql is working first
16:49 pianohacker that's... probably a very good idea, drab
17:43 tcohen hi, back
18:17 magnuse @later tell drojf hiya! trying to renew a letsencrypt cert for koha i get "conf files with multiple vhosts are not yet supported" - have you found a workaround for that?
18:17 huginn magnuse: The operation succeeded.
18:19 tcohen khall: tcohen@bibliotecas-1:koha-community-src(clean_master)$ dbic
18:19 tcohen ERROR 1171 (42000) at line 1428: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
18:20 khall tcohen: which table is that referencing?
18:22 tcohen how should I know ? :-P
18:22 tcohen that loading kohastructure.sql
18:22 tcohen *ẗhat's
18:23 tcohen I was trying to see what is making all those tests fail due to out of date schemas
18:23 tcohen ah
18:23 tcohen I'm on Ubuntu 16.04, then might be the mysql version
18:27 tcohen khall: bummer, it works ok on debian 8
18:55 khall odd
18:56 tcohen 16.04 includes MySQL 5.7
19:10 tcohen khall: it is actually all green with those!
19:11 khall awesome!
19:12 magnuse \o/
19:13 tcohen @later tell Joubu they both look ok to me :-D
19:13 huginn tcohen: The operation succeeded.
19:14 tcohen khall_away: find t/db_dependent/ -name '*.t' | grep -v -e 00-strict | xargs prove
19:21 liw find t/db_dependent/ -name '*.t' ! -name '*00-strict*' -print0 | xargs -0 prove
19:21 liw that should work as well
19:24 tcohen liw: true
19:44 Karl_H magnuse: couldn't you use separate SSL certs for the OPAC and the staff mode?
19:48 Karl_H I guess I probably shouldn't comment, we just buy our SSL certs
19:53 drab is it normal/ok/harmless to get a lot of errors like this during a migration to 3.4?
19:53 drab ERROR in _koha_modify_biblioitem_nonmarc UPDATE biblioitems
19:53 drab DBD::mysql::st execute failed: Data too long for column 'isbn' at row 1 [for Statement "UPDATE biblioitems
19:53 drab all of them failed that same way
19:55 cait hm
19:55 cait i think it might mean that not all data could be stored/might be cut off
19:55 cait are you migrating from anoter koha?
19:55 cait how are you loading the data?
19:56 cait and why... are you migrating to 3.4?
19:57 drab had a 3.2 koha on ubuntu 14.04, machine died, went with ubuntu 16.06, which installed 3.4, restored backup and ran migration
19:58 drab everything completed fine minus those errors
19:58 drab actually, uhm, about koha says 3.22
19:59 drab confused now, thought it installed 3.4
19:59 cait 3.4 would be really old
19:59 cait 3.22 is probably better
19:59 cait it's the current stable version
19:59 drab nope, pkg defo says 3.22, guess I've misread
20:00 cait did you just load the database in and ran the installer?
20:00 cait or how did you do it?
20:01 drab bah, totally misread, I meant to run koha-upgrade-schema. meh, time to restore again
20:01 cait the isbn column should be big enough in a current version... that#s what has mewondering
20:01 drab koha-craete --create-db library ; restored config ; restored mysql dump ; logged through the web console and finished install
20:01 cait it used to be a small datatype, but we changed that at some point
20:02 cait what do you mean by restored config?
20:02 drab copied /etc/koha/koha-sites.conf over
20:02 cait hm
20:03 cait hm
20:03 drab with the right domain basically, that's really the only setting in there I touched
20:03 cait i wonder, are you sure you are updating from 3.2?
20:03 cait not sure we had packages back then
20:03 cait and probably some changes to any conf file....
20:05 drab I was on 3.22, I misread versions, dots to be precise, thought I was on 3.2.2, that's why it made sense to migrate to 3.4, but I misread the whole thing
20:11 drab ok, just restored and went through th admin panel and it actually did the schema upgrade through that, all good, thank you
20:14 cait yay 1
20:14 cait glad it worked :)
20:27 tcohen hi
20:28 cait hi
20:36 tcohen hi cait
20:37 cait :)
22:42 wizzyrea hi
23:46 rangi hmm
23:47 rangi @later tell eythian yeah thats fine
23:47 huginn rangi: The operation succeeded.