Time Nick Message 23:47 huginn rangi: The operation succeeded. 23:47 rangi @later tell eythian yeah thats fine 23:46 rangi hmm 22:42 wizzyrea hi 20:37 cait :) 20:36 tcohen hi cait 20:28 cait hi 20:27 tcohen hi 20:14 cait glad it worked :) 20:14 cait yay 1 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: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:03 cait and probably some changes to any conf file.... 20:03 cait not sure we had packages back then 20:03 cait i wonder, are you sure you are updating from 3.2? 20:03 drab with the right domain basically, that's really the only setting in there I touched 20:03 cait hm 20:02 cait hm 20:02 drab copied /etc/koha/koha-sites.conf over 20:02 cait what do you mean by restored config? 20:01 cait it used to be a small datatype, but we changed that at some point 20:01 drab koha-craete --create-db library ; restored config ; restored mysql dump ; logged through the web console and finished install 20:01 cait the isbn column should be big enough in a current version... that#s what has mewondering 20:01 drab bah, totally misread, I meant to run koha-upgrade-schema. meh, time to restore again 20:00 cait or how did you do it? 20:00 cait did you just load the database in and ran the installer? 19:59 drab nope, pkg defo says 3.22, guess I've misread 19:59 cait it's the current stable version 19:59 cait 3.22 is probably better 19:59 cait 3.4 would be really old 19:59 drab confused now, thought it installed 3.4 19:58 drab actually, uhm, about koha says 3.22 19:58 drab everything completed fine minus those errors 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:56 cait and why... are you migrating to 3.4? 19:55 cait how are you loading the data? 19:55 cait are you migrating from anoter koha? 19:55 cait i think it might mean that not all data could be stored/might be cut off 19:55 cait hm 19:53 drab all of them failed that same way 19:53 drab DBD::mysql::st execute failed: Data too long for column 'isbn' at row 1 [for Statement "UPDATE biblioitems 19:53 drab ERROR in _koha_modify_biblioitem_nonmarc UPDATE biblioitems 19:53 drab is it normal/ok/harmless to get a lot of errors like this during a migration to 3.4? 19:48 Karl_H I guess I probably shouldn't comment, we just buy our SSL certs 19:44 Karl_H magnuse: couldn't you use separate SSL certs for the OPAC and the staff mode? 19:24 tcohen liw: true 19:21 liw that should work as well 19:21 liw find t/db_dependent/ -name '*.t' ! -name '*00-strict*' -print0 | xargs -0 prove 19:14 tcohen khall_away: find t/db_dependent/ -name '*.t' | grep -v -e 00-strict | xargs prove 19:13 huginn tcohen: The operation succeeded. 19:13 tcohen @later tell Joubu they both look ok to me :-D 19:12 magnuse \o/ 19:11 khall awesome! 19:10 tcohen khall: it is actually all green with those! 18:56 tcohen 16.04 includes MySQL 5.7 18:55 khall odd 18:27 tcohen khall: bummer, it works ok on debian 8 18:23 tcohen I'm on Ubuntu 16.04, then might be the mysql version 18:23 tcohen ah 18:23 tcohen I was trying to see what is making all those tests fail due to out of date schemas 18:22 tcohen *ẗhat's 18:22 tcohen that loading kohastructure.sql 18:22 tcohen how should I know ? :-P 18:20 khall tcohen: which table is that referencing? 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:19 tcohen khall: tcohen@bibliotecas-1:koha-community-src(clean_master)$ dbic 18:17 huginn magnuse: The operation succeeded. 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? 17:43 tcohen hi, back 16:49 pianohacker that's... probably a very good idea, drab 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: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:42 drab in my case it didn't so what gzip created was an empty 20yte file 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:41 drab basically I had a partial disk failure that corrupted mysql, which in turn would not start 16:41 drab and how that script works in conjuction with koha-run-backups 16:40 drab or more precisely the | gzip > "$dbdump" 16:40 drab specifically https://github.com/Koha-Community/Koha/blob/da21ad065939d0789bb90d8fd6d088b781688aa3/debian/scripts/koha-dump#L72 16:39 drab the problem is with the backups and the koha-dump script 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:35 tonyhhyip hi 16:33 drab hi there 16:27 gaetan_B bye 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? 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> 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: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: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:06 bag magnuse: hello! 15:06 magnuse bag: HI 15:06 magnuse reza: which version of koha are you using? 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:00 reiveune bye 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. 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:44 reza it's 10:44pm here in Malaysia :) 14:43 reza morning 14:41 bag morning 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:37 reza I am getting this error for every search from opac side. it has been logged and made a huge file 14:36 reza Hello 14:33 khall ah! 14:31 Joubu and then you do not have the dateformat pref defined, but none of the others neither :) 14:31 Joubu it you didn't, the sysprefs files is not inserted 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:30 Joubu bug 16418 14:30 khall Joubu: no, I got distracted, which syspref was that? 14:30 Joubu khall: Ha, did you correct the sysprefs.sql file? 14:27 Joubu khall: same with all sample data, I have selected marcflavour=marc21, and dateformat is set to "us" 14:21 Joubu read again the test plan, I need to install all the sample data 14:21 Joubu sorry 14:20 Joubu and I can see Web installer › Step 1 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:17 Joubu oleonard: if you submitted the patch, you can find it using splitter.koha-community.org 14:15 oleonard Did I already fix this? 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. 13:45 * magnuse waves again 13:37 teyekea can anyone help me on the issue please?? 13:36 teyekea oleonard: thank you very much for ur help 13:36 oleonard Sorry teyekea I don't know what to suggest next. 13:34 teyekea oleonard:its the same 13:32 teyekea k tnx 13:32 kidclamp bywater/bywater 13:32 teyekea sorry what was the user name and password for the ByWater demo? 13:30 oleonard teyekea: Do you have different settings? 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:28 oleonard I assume they reflect the defaults 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:26 Joubu kidclamp: if it was the behavior before 15840, please open new reports 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:22 kidclamp can do joubu, wasn't sure if they were considered related 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: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 15399: normal, P5 - low, ---, gmcharlt, NEW , MARCXML records larger than 1 MB (1048576 bytes) are not searchable. 13:21 kidclamp lari: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15399 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:17 teyekea oleonard: any suggestion 13:16 Joubu output_pref({ str => $date }) 13:16 Joubu but instead use: 13:15 Joubu we should not use output_pref( .* dt_from_string .*) 13:15 Joubu khall: there is a big todo on dates (again) 13:14 Joubu not sure we should remove the die 13:14 Joubu was reading the patch 13:14 khall heh ; ) 13:14 Joubu khall: I am here :) 13:14 huginn khall: The operation succeeded. 13:14 khall @later tell 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=13601 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Get rid of DateTime::Format::DateParse 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 khall Joubu: take a look at bug 16430, the root cause is a change form bug 13601 13:12 teyekea oleonard: btw zeberaidx(##) the number varies every time i run rebuild_zebra 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:06 teyekea thanks oleonard that helps too 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:05 oleonard teyekea: https://lists.katipo.co.nz/pipermail/koha/2014-November/041221.html 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:04 oleonard teyekea: Yes I'm wondering if you changed the settings in Koha to MARC mapping before the problem arose. 13:04 teyekea oleonard: is that in Koha to MARC mapping? 13:01 oleonard It's under Administration in the Koha staff client 13:01 teyekea where can i check koha /MARC i didn't change it but it might be changed before 13:00 teyekea my config says <zebra_bib_index_mode>dom</zebra_bib_index_mode><zebra_auth_index_mode>dom</zebra_auth_index_mode> 12:59 teyekea yes oleonard: am using DOM 12:58 oleonard teyekea: Did you change your Koha to MARC mapping from the defaults? 12:57 oleonard teyekea: Did you say you were using DOM indexing? 12:42 teyekea hello everybody please give me a hand on this 12:37 teyekea [warn] Record didn't contain match fields in (bib1,Local-number). why i get this?? 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:35 kidclamp bug 16426 12:35 kidclamp oops, nope, 16426 tcohen 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 bug 16429 12:33 tcohen hi Joubu 12:33 tcohen kidclamp: bug #? 12:33 teyekea is there next step after that? 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:29 gaetan_B hello 12:29 teyekea sorry cait: to bothering you but could you help me with this? or any other member.. 12:26 Joubu test it* 12:26 Joubu kidclamp: please test to widely :) 12:26 kidclamp testing patron import now 12:26 kidclamp Joubu++ 12:25 teyekea any suggestion??? 12:21 teyekea anything i should check? 12:18 teyekea and the items are not shown on search result 12:18 teyekea cait: ok it finished, but same thing zebraidx(5343) [warn] Record didn't contain match fields in (bib1,Local-number) 12:17 marcelr but wait for bernardo 12:17 marcelr it works for me batch.t 12:17 tcohen on retrying 16155 because i noticed it was failing since ages 12:17 marcelr only 12:17 marcelr it should reveal faster if we forgot some dbix update 12:16 tcohen i worked on batch.t 12:16 tcohen i didn't find anything broken by that patches 12:16 marcelr :) 12:16 tcohen to me is passed QA 12:16 marcelr did you have tests failing? 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 tcohen: what is the status of bug 16155 12:15 tcohen heh 12:15 marcelr hi tcohen: your dutch is fine today 12:15 tcohen goedemorgen #koha 12:12 teyekea its on progress reindexing zebra 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:06 teyekea ok am doing that.. it exporting , will let u know the result 12:05 cait run it as your koha user without the run-as-root 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:01 teyekea it is 3.16.04.000 11:59 cait maybe let's start there 11:59 cait you can find your version on the about page 11:59 cait hm 11:58 teyekea cait: its already installed by some other person. is there any way i can check? 11:57 cait it can mess up the permissions of the index files and cause a lot of problems 11:57 cait how did you install koha? 11:57 cait usually 11:57 cait you shouldn't runadroot 11:52 teyekea is there any other way to reindex everything?? 11:50 teyekea any idea? 11:38 triveni hi 11:37 teyekea and the mode is "dom" 11:36 teyekea oh and before warning it also shows zebraidx(13000) 11:36 teyekea and the search is still the same 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) 07:52 irma_ hi all in #koha :-) 07:37 pj- Hi Irma, I can see you now : ) 07:36 irma_ thanks mtj 07:35 pj- G'day Mason 07:35 * pj- slaps mtj around a bit with a large fishbot 07:06 * magnuse looks forward to https://en.wikipedia.org/wiki/Marseille_%28TV_series%29 06:59 alex_a bonjour 06:52 * magnuse waves 06:47 reiveune hello