Time Nick Message 00:42 wizzyrea we send passwords via email in the clear. 00:42 wizzyrea this is wrong and bad 00:51 rangi what was that syspref called wizzyrea ? 00:57 wizzyrea oh AutoEmailOpacUser 00:57 wizzyrea woooorst 01:05 rangi ahh yes, so its in the template by default 01:05 rangi thats the problem 01:05 rangi http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/mandatory/sample_notices.sql;h=7a5c4da1beb9f99a9fd830211a43808fa712bcb7;hb=790150b31277e6ded86823add0385c5960a4876e#l6 01:05 rangi line 6 02:39 mtompset Have a great day, #koha rangi wizzyrea 11:04 * cait waves 11:15 cait hm does Jon have an IRC nick I can give karma to? :) 11:38 * cait waves at jzairo :) 11:38 jzairo morning cait!! 11:54 * kidclamp waves 11:54 cait hi oleonard and kidclamp 11:54 kidclamp hi cait 11:54 oleonard Hi 11:59 tomascohen hi 12:01 cait ho tomascohen :) 12:05 tomascohen @wunder cordoba, argentina 12:05 huginn` tomascohen: Error: No such location could be found. 12:07 * magnuse waves 12:08 cait hey magnuse 12:08 magnuse kia ora cait! 12:09 magnuse how could i not think about just checking biblio_metadata.timestamp?!? 12:09 magnuse cait++ 12:10 cait hm? 12:14 tomascohen yeah, it makes sense 12:18 magnuse in principle, i agree with tomascohen that biblio, biblioitems and biblio_metadata should bee seen as one entity, but in ptactice it is much easier to add a timestamp to biblio_metadata and just check that 12:20 cait using the database feature is reliable at least 12:20 cait finding every spot we can change something might be harder 12:26 tomascohen cait: I'm not sure we can count MySQL as reliable haha 12:56 cait i guess it's a similar feature in all dbms :) 13:24 marcelr hi #koha 13:25 cait hi marcelr :) 13:25 marcelr o/ 13:33 cait magnuse++ # wiki page about troubleshooting kohadevbox 13:34 magnuse dunno if it is problems others have, but thought i'd put it somewhere 13:34 cait hm is second and first error different? 13:34 cait https://wiki.koha-community.org/wiki/Troubleshooting_KohaDevBox 13:35 magnuse yeah, there are some extra lines in the first one 13:35 magnuse exportfs: duplicated export entries: 13:38 cait ah 13:41 magnuse i made the relevant lines of the output bold now 13:43 cait :) 14:02 magnuse to add a field to table in the db, should i just provide the atomicupdate and leave updatedatabase.pl alone? 14:06 tcohen morning 14:06 tcohen magnuse: yes, cp skeleton.perl bug_xxx.perl 14:07 magnuse thanks! 14:07 magnuse and hiya 14:07 tcohen and make sure you use 14:07 tcohen the helper 14:07 tcohen functions 14:07 tcohen column_exists, index_exists, etc 14:07 tcohen we abandoned teh use of IGNORE 14:15 magnuse but i should still update kohastructure.sql, right? 14:18 tcohen right! 14:19 magnuse thanks, it's been too long... 16:11 * LeeJ waves 16:11 LeeJ hi all 16:19 huginn` New commit(s) kohagit: Bug 17989: (QA follow-up) Replace bad dots in SuggestionEngine_ExplodedTerms.t <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=aa4269777c5893a3f5ecdec65877c2cec88e3ba3> / Bug 17989: Final changes <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=bc0012de2eda1b9f077459df757fd82ea07ca343> / Bug 17989: Resolve "verbatim paragraph in NAME section" warning in C4::Templates <http://git.koha-commun 16:38 LeeJ anyone skilled with excluding DATETIME attributes within a time range in SQL? :D 16:38 kidclamp you mena like DATE() LeeJ ? 16:39 LeeJ kidclamp: the SELECT statement in getAvailableRooms() https://github.com/ldjamison/koha-plugin-room-reservations/blob/master/Koha/Plugin/Com/MarywoodUniversity/RoomReservations/opac/calendar.pl 16:41 LeeJ my goal was to have results in the subquery excluded from the primary query (to prevent duplicate/overlapping entries) but it appears it doesn't exclude properly so I'm thinking I typed something wrong in the subquery 16:43 kidclamp hmmm...I don't think I can see anything at quick glance, for readability I would suggest using '?' placeholders in the query and then passing the variables in when you execute though 16:43 LeeJ I know I should...it's a bad habit haha. I'll probably change it on one of the next pushes 16:44 LeeJ I thought it looked right but I figured I'd check because it's returning results that overlap within the primary select range :( 16:45 kidclamp that doesn't catach one that starts in the range but ends outside 16:45 kidclamp like range of 4-6 - an event from 5-7 won't be caught 16:48 jenkins Project Koha_Master_D8 build #286: SUCCESS in 30 min: https://jenkins.koha-community.org/job/Koha_Master_D8/286/ 16:48 jenkins * Jonathan Druart: Bug 19176: Compare the number of seconds when comparing dates in tests 16:48 jenkins * Jonathan Druart: Bug 19176: Reduce the number of seconds to 5 16:48 jenkins * josef.moravec: Bug 19176: followup - fix POD in t/lib/Dates.pm 16:48 jenkins * julian.maurice: Bug 19176: Fix how t::lib::Dates::compare handle timezone 16:48 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19176 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Dates comparison fails on slow server 16:48 jenkins * Tomás Cohen Arazi: Bug 19539: Fix column index shift in cirulation rules 16:48 jenkins * Jonathan Druart: Bug 19539: (follow-up) Fix column index shift in cirulation rules 16:48 jenkins * Jonathan Druart: Bug 7143: Add a new "Epoch" column to the history.txt 16:48 jenkins * Jonathan Druart: Bug 7143: Add missing entries 16:48 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19539 major, P5 - low, ---, tomascohen, Pushed to Master , Editing rules that contain 'Unlimited' values produces invalid data 16:48 jenkins * Jonathan Druart: Bug 7143: Make about.pl knows about the new epoch column 16:48 jenkins * Jonathan Druart: Bug 7143: Update 'Koha development team' list 16:48 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7143 trivial, P5 - low, ---, koha-bugs, Pushed to Master , Bug for tracking changes to the about page 16:48 jenkins * m.de.rooy: Bug 17989: Centralize bad template check 16:48 jenkins * m.de.rooy: Bug 17989: Extend bad template check 16:48 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17989 enhancement, P5 - low, ---, m.de.rooy, Pushed to Master , Stricter control on source directory for html templates 16:48 jenkins * m.de.rooy: Bug 17989: Include full path logic in _get_template_file 16:48 jenkins * m.de.rooy: Bug 17989: Resolve "verbatim paragraph in NAME section" warning in 16:48 jenkins * m.de.rooy: Bug 17989: Final changes 16:48 jenkins * m.de.rooy: Bug 17989: (QA follow-up) Replace bad dots in