Time Nick Message 00:19 jharrisonstp I was wondering if someone could help me with an error when checking in books. Under data problems I have the following error: 00:19 jharrisonstp Some of your tables have problems with their auto_increment values which may lead to data loss. You should not ignore this warning. The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup the auto_increment values are set to max(table.id)+1. 00:19 jharrisonstp I then have errors on multiple tables that look like this: 00:19 jharrisonstp The following ids exist in both issues and old_issues tables: 14172, 14161, 14176, 14170, 14169, 14165, 14166, 14174, 14173, 14164, 14167, 14171, 14162, 14163, 14168, 14175 04:18 nyogtang hello 04:20 nyogtang i am having a problem regarding "Can't locate Koha/Caches.pm in @INC ". I have setup my crontab job but it doesnot execute. When i execute it individually, this is the error i get. Please help me 06:06 * magnuse waves 06:14 me Hey I am new to koha. Setting up my cron jobs. I am confused between the PERL5LIB and koha-conf.xml file. Can you explain this to me? 06:18 cait how are you setting up Koha? 06:19 cait me: if you are using packages, you might be not looking at the right files - it should not be needed to change anything 06:19 cait sorry, have to run 06:21 me its says unable to locate koha-conf.xml file 06:24 fridolin hie there 06:29 magnuse me: could you give us some more details about how you installed koha, what cronjobs you are setting up and how you are setting them up? 06:29 magnuse bonjour paul_p et fridolin 06:30 paul_p 'morning magnuse 06:31 me Yes Sure. I followed this link to install Koha https://wiki.koha-community.org/wiki/Koha_on_Debian. I am settinh up Cart_to_Shelf.pl cronjob. 06:32 magnuse kia ora wizzycray 06:33 reiveune hello 06:33 wahanui privet, reiveune 06:34 magnuse bnojour reiveune 06:34 magnuse well, almost 06:34 magnuse @wunder marseille 06:34 huginn magnuse: Error: No such location could be found. 06:37 me i exported PERL5LIB="usr/share/koha/lib". i am confused about this path? 06:40 alex_a bonjour 06:41 me bonjour 06:45 marcelr hi #koha 06:55 magnuse me: that should be PERL5LIB="/usr/share/koha/lib - notice the slash at the start 06:55 magnuse that is where Koha keeps it's libraries/.pm files 06:55 magnuse scripts need to find them to be able to use the functions they provide 06:57 magnuse in order to run Koha scripts from cron you either need to use some of the koha-* scripts, like koha-foreach (this is what the crons set up by koha does) or you need to set PERL5LIB and KOHA_CONF 06:57 magnuse this is so that the scripts can find and use the Koha modules and the config file, respectively 07:06 me great thanks 07:06 me i have set up PERL5LIB and KOHA_CONF in the crontab 07:15 gaetan_B hello 07:21 magnuse bonjour gaetan_B 07:24 mveron Good morning / daytime #koha 07:25 * mveron waves to marcelr 07:25 marcelr hi mveron 07:26 mveron marcelr++ for Bug 18541, I really appreciate 07:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18541 enhancement, P5 - low, ---, veron, Passed QA , Patron card creator: Add a grid to support layout design 07:26 marcelr np 07:26 marcelr it got time 07:26 mveron time is what I'm lacking atm... 07:26 marcelr yeah who does not ? 07:27 mveron :-) 09:06 gaetan_B i haven't received a single email from koha-devel since the 1st of september, this seems a bit suspicious, am i the only one in this situation ? is it really quiet or is there something wrong ? 09:33 mveron gaetan_B: Latest I got from koha-devel is Wed, 06 Sep 2017 15:21:34 +0000 09:34 gaetan_B thanks, so something's wrong on my side then 09:41 marcelr kidclamp_DND: hi there, did you finish qa on bug 17380 ? 09:41 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17380 normal, P5 - low, ---, m.de.rooy, Signed Off , Resolve several problems related to Default authority framework 09:42 kidclamp_DND yup, lemme sign off your patches 09:43 marcelr thx 11:42 * LeeJ waves 11:42 LeeJ hi #koha 11:50 oleonard Hi all 11:54 LeeJ hi oleonard 11:54 wahanui hi olé onard 11:54 LeeJ haha 12:08 gveranis ok but it is not a bug ( almost ) 12:23 LeeJ gveranis: ? 12:23 gveranis yes? 12:23 gveranis sorry for the above message 12:23 LeeJ make progress? 12:24 gveranis yes I solved it 12:24 LeeJ what happened? 12:24 gveranis for some reason this instance has wrong foreign key on old_issues table 12:24 LeeJ huh. 12:24 gveranis to another table which created when systme upgraded to 3.6 version 12:25 LeeJ glad it worked out for you 12:25 gveranis this instance is from 3.2 version 12:25 gveranis yes the problem was that the code in koha just try to catch any error 12:25 gveranis on function AddReturn 12:26 gveranis if something happen -anything - inside that then show that message for data problems 12:26 gveranis and give one solution only ;) 12:27 gveranis and in my case that solution not worked but now it is ok 12:27 LeeJ ahh...so the "data problems catch" couldn't express the problem 13:01 Joubu oops, I missed the meeting yesterday 13:01 marcelr hi Joubu 13:15 tcohen morning 13:16 Joubu gveranis: could you detail what was the problem raised by AddReturn? 13:17 tcohen hi Joubu 13:20 Joubu hola tcohen 13:21 Joubu could someone try "show create table overduerules_transport_types" on a DB that existed prior to 3.23.00.007? 13:22 Joubu then see bug 19259 13:22 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19259 blocker, P5 - low, ---, koha-bugs, NEW , Overdue rules do not save 13:24 tcohen Joubu: there's quorum for a hackfest in buenos Aires 13:26 Joubu I did not receive any answer 13:26 Joubu s 13:26 tcohen I know, not sure why, but people hit reply and you address gets filtered 13:27 Joubu yes, people hit reply, not reply to all... 13:28 tcohen when do you want to do it :-D 13:28 Joubu can you fwd me the answers? :) 13:28 tcohen :/ 13:29 tcohen yes 15:05 reiveune bye 16:40 LeeJ Joubu: the problem that gveranis is explained in the logs from last night http://irc.koha-community.org/koha/2017-09-06 16:41 LeeJ Joubu: gveranis joined IRC at 21:30 17:34 cait khall: around? 18:08 huginn New commit(s) kohagit: Bug 19256: (QA followup) Add missing POD <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b4653629f63d410326036cef5aa8a70c55d17f45> / Bug 19256: (QA followup) Remove warn from unit test <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ad9f89c6c32ba8e8fc52566d5e8c7e5b8c9d43e9> / Bug 19256: Make Koha::Acq::Order using Koha::Object <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h 20:17 jenkins Project Koha_Master_D8 build #252: UNSTABLE in 2 hr 4 min: https://jenkins.koha-community.org/job/Koha_Master_D8/252/ 20:17 jenkins * Jonathan Druart: Bug 15339: TestBuilder warnings (code) 20:17 jenkins * Jonathan Druart: Bug 15339: TestBuilder warnings (tests) 20:17 jenkins * Jonathan Druart: Bug 15339: Improve parameter validation 20:17 jenkins * Jonathan Druart: Bug 15339: [QA Follow-up] Add a warning too when source is not supplied 20:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15339 enhancement, P5 - low, ---, xarragon, Pushed to Master , TestBuilder build parameter warnings 20:17 jenkins * Jonathan Druart: Bug 15339: Remove extra 'my' 20:17 jenkins * Jonathan Druart: Bug 19268: Fix TestBuilder parameter in C/Branch.t and K/P/Messaging.t 20:17 jenkins * Jonathan Druart: Bug 19229: Return to course when cancelling out of edit form 20:17 jenkins * Jonathan Druart: Bug 19228: Trigger confirm delete when removing item from course 20:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19268 normal, P5 - low, ---, m.de.rooy, Pushed to Master , Fix wrong TestBuilder parameter in few unit tests 20:17 jenkins * Jonathan Druart: Bug 12691: Use Koha.Preference in Self-Checkout 20:17 jenkins * Jonathan Druart: Bug 17893 - Move JavaScript to the footer on staff client catalog pages 20:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19229 minor, P5 - low, ---, aleisha, Pushed to Master , Clicking Cancel when editing course doesn't take you back to the course 20:17 jenkins * Jonathan Druart: Bug 19214: Prevent crash if ->club or ->patron is called in list context 20:17 jenkins * Jonathan Druart: Bug 19214: prevent crash if club_template_field is called in list 20:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19228 minor, P5 - low, ---, aleisha, Pushed to Master , Confirm delete doesn't show when deleting an item from course 20:18 jenkins * Jonathan Druart: Bug 18921: Resolve a few warnings in C4/XSLT.pm 20:18 jenkins * Jonathan Druart: Bug 19257: Prevent warn when reopening a basket 20:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12691 enhancement, P5 - low, ---, aleisha, Pushed to Master , Use Koha.Preference for calls to SCOUserJS, SCOUserCSS, OPACUserCSS, opacuserjs, etc in Self-Checkout 20:18 jenkins * Jonathan Druart: Bug 19258: Prevent warn when paying a fine or charge 20:18 jenkins * Jonathan Druart: Bug 19258: Prevent warns when writing off an individual fine 20:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17893 enhancement, P5 - low, ---, oleonard, Pushed to Master , Move JavaScript to the footer on staff client catalog pages 20:18 jenkins * Jonathan Druart: Bug 19258: Preventing warns when paying a fine or charge from Pay 20:18 jenkins * Jonathan Druart: Bug 19258: Prevent warn when reversing a payment 20:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19214 blocker, P5 - low, ---, aleisha, Pushed to Master , Patron clubs: Template process failed: undef error - Cannot use "->find" in list context 20:18 jenkins * Jonathan Druart: Bug 19256: Make Koha::Acq::Order using Koha::Object 20:18 jenkins * Jonathan Druart: Bug 19256: (QA followup) Remove warn from unit test 20:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18921 trivial, P5 - low, ---, m.de.rooy, Pushed to Master , Resolve a few warnings in C4/XSLT.pm 20:18 jenkins * Jonathan Druart: Bug 19256: (QA followup) Add missing POD 20:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19257 enhancement, P5 - low, ---, aleisha, Pushed to Master , Warn when reopening a basket 20:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19258 enhancement, P5 - low, ---, aleisha, Pushed to Master , Warn when paying or writing off a fine or charge 20:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19256 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Koha::Acquisition::Order should use Koha::Object 22:05 pianohacker hi all. 22:08 wizzycray hi 22:11 pianohacker ... hi wizzycray :)