- Koha-devel - lists.koha-community.org

Hackfest in Marseille in October
by Paul Poulain 04 May '16

04 May '16

Hello koha-developers, For the 5th year, BibLibre is happy to welcome in Marseille anyone wanting to hack Koha. Because the KohaCon is in June, the Marseille hackfest has been switched to fall. We are waiting for you in October, 10th - 14th ! Some people have already told they'll be here. Kohala, the french NPO, and BibLibre have decided to sponsor Owen, so he'll be with us. Thanks to NPL for letting him come ! I also know that our loved RM will be here too. If you plan to join us, just drop me an email ! PS: for those who came previous years: we have a new NPO as neighbors. They've a large meeting room, that can host 15+ ppl we already have booked, plus a small one with sofas. So we have space for 70+ persons ! -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

1 0

Dev a app with android studio
by dave_meyer＠web.de 04 May '16

04 May '16

1 0

Searching with the question mark wildcard
by Francois Charbonnier 04 May '16

04 May '16

Hello, Has anyone tried to implement the question mark (?) wildcard ? The documentation says "Two of the wildcard characters that can be used in Koha searches are the asterisk ('*') and the percent sign ('%'). However, these two characters act differently when used in searching." (http://manual.koha-community.org/3.22/en/searchfaq.html) But, CQL also supports the question mark wildcard "? : Matches any single character, so that c?t will match any of the words cat, cot or cut, but /not/ coat or indeed ct." (http://zing.z3950.org/cql/intro.html#6) We are currently evaluating this implementation. If you already tried, your feebacks will be appreciated. And, any advice on how you'll do it will be welcome as well! Thanks! -- François Charbonnier, Bibl. prof. / Chef de produits Tél. : (888) 604-2627 francois.charbonnier(a)inLibro.com <mailto:francois.charbonnier@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>

1 0

Password stored in borrowers
by yash verma 03 May '16

03 May '16

I need to retrieve the data from the borrowers table, but the password is encrypted. How do I decrypt it in MySQL?

3 4

Test Suite
by Marcel de Rooy 02 May '16

02 May '16

Thanks for some extensive pushing, Kyle and Brendan. We still have some tests failing. I resolved a few trivial ones: bug 16403, 16404, 16405, 16407 (hardcoded borrowers), 16408 16406 Context.t is a harder one (it should not fail only for not having a cache). I also tested on top of bug 16155. Note that we probably still need some DBIx updates ! With DBIx update and some of the above fixes all TestBuilder related tests pass: All tests successful. Files=69, Tests=1929, 85 wallclock secs ( 0.53 usr 0.13 sys + 75.33 cusr 5.92 csys = 81.91 CPU) Result: PASS And finally what about: Can't locate Catmandu/Importer/MARC.pm Can't locate object method "_convert_marc_to_json" Can't locate Catmandu/Store/ElasticSearch.pm Marcel

2 1

Koha Community Newsletter: April 2016
by kohanews 30 Apr '16

30 Apr '16

Fellow Koha users: The Koha Community Newsletter for April 2016 is here: https://koha-community.org/koha-community-newsletter-april-2016/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Frameworks / DB constraints
by Tomas Cohen Arazi 29 Apr '16

29 Apr '16

Hi fellows, I noticed (in a production server) that a cataloguing framework was deleted by a user. This raised a problem with records that used that framework: trying to look at the record's detail page ended up in a fatal error. Currently, the framework code is not a FK, so we don't enforce it at DB level. A possible solution is to just add it as a FK, another option would be to fallback to the default framework in the relevant function. Jesse proposed on IRC creating the foreign key with ON DELETE SET NULL. We need to fix this, so: ideas? preferences? vote? -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

5 6

Re: [Koha-devel] Invalid local time for date in time zone: America/Santiago
by Larry Letelier 28 Apr '16

28 Apr '16

David, I will review the data on date_due field. Thanks!! for your time ! LOL time.. ;-) tomorrow --Larry 2016-04-28 0:35 GMT-03:00 David Cook <dcook(a)prosentient.com.au>: > Hi Larry, > > > > I find time fascinating, so happy to help : ). > > > > Thanks for that pastebin. That’s really helpful. > > > > We can see the problem is with the following call: > > > > $calendar->days_between( dt_from_string($data->{date_due}),$date_to_run ); > > > > If I follow correctly, $date_to_run should be the time when you run the > script in America/Santiago time. > > > > $data->{date_due} will be from the database… probably the issues table I > think… and I think that’s looking OK, since the following line appears in > the debugger: > > > > Koha::Calendar::days_between('Koha::Calendar=HASH(0x65dcf80)', > 'DateTime=HASH(0x6507b38)', 'DateTime=HASH(0x64e7848)') > > > > We’d have an error earlier if those dates were the ones causing problems… > so I think they’re OK since they’ve been created into objects as evidenced > above. > > > > However… 'DateTime=HASH(0x6507b38)' is cloned in > Koha::Calendar::days_between() and has Koha::Calendar::is_holiday() run on > it… > > > > -- > > > > I have an urgent matter now, but that’s part of the way there. I’m > thinking the problem is with the “date_due” from one of the overdue items! > Possibly something from September if the debug message is correct… > > > > > > David Cook > > Systems Librarian > > > > Prosentient Systems > > 72/330 Wattle St > > Ultimo, NSW 2007 > > > > Office: 02 9212 0899 > > Direct: 02 8005 0595 > > > > *From:* Larry Letelier [mailto:larry@opengeek.cl] > *Sent:* Thursday, 28 April 2016 1:05 PM > *To:* David Cook <dcook(a)prosentient.com.au> > *Cc:* koha-devel(a)lists.koha-community.org > *Subject:* Re: [Koha-devel] Invalid local time for date in time zone: > America/Santiago > > > > Hi David, > > > > Thanks for you reply, > > > > yes your are right, Chile abolished dst, we have a minister with many > earthquakes in him head. > > So, > > > > Here is the “perl -d overdue_notices.pl -t" using "n": > > http://pastebin.com/ZxHkNCK3 > > > > If i run again : > > > > perl overdue_notices.pl -t > > Invalid local time for date in time zone: America/Santiago > > > > Thanks in advance guys, > > > > > *-- Larry Letelier N.* > > *F: **+56 2 3205 2737* > > *F: * > *+56 9 7589 6842* > > > > 2016-04-27 23:53 GMT-03:00 David Cook <dcook(a)prosentient.com.au>: > > Oh, that’s interesting. > > > > I’ve seen this happen on other Perl projects during daylight savings time > changes. > > > > For instance, try the following Perl code: > > > > use DateTime; > > my $dt = DateTime->new( > > year => 2015, > > month => 10, > > day => 4, > > hour => 2, > > minute => 0, > > second => 0, > > time_zone => 'Australia/Sydney', > > ); > > > > You’ll get the message: > > > > “Invalid local time for date in time zone: Australia/Sydney” > > > > If I recall correctly, it’s because 4 October 2015 2:00am Australia/Sydney > didn’t exist. When that time was reached, the clock actually skipped > forward, and it became 4 October 2015 3:00am Australia/Sydney. In effect, > local time went from 1:59:59 to 3:00:00. 2:00:00 through 2:59:59 never > existed. Fascinating, no? > > > > Wikipedia says that Chile stopped observing DST in 2015: > https://en.wikipedia.org/wiki/Daylight_saving_time_in_the_Americas#Chile. > However, I’m guessing that perhaps your server/the Perl module doesn’t know > that? > > > > “Chile currently observes Daylight Saving Time (DST). Instead of turning > the clocks back one hour on Sunday, April 26, 2015 as previously planned, > the Chilean Government has decided to make no further changes to the clock > in future years.” ( > http://www.timeanddate.com/news/time/chile-abolishes-dst-2015.html) > > > > Hmm… I don’t know what date is the problem… > > > > Could you run “perl -d overdue_notices.pl -t" again, but use “n” instead > of “c”? That way, you’ll be able to see what exact call is generating this > error. > > > > I’m guessing it might be one of the lines: > > > > my $today = DateTime->now(time_zone => C4::Context->tz ); > > > > But that’s just a guess. What happens if you try running your overdues > again? You might have had the misfortune of the overdues just running at > the wrong time on the wrong day. > > > > Curious to hear how you go! > > > > David Cook > > Systems Librarian > > > > Prosentient Systems > > 72/330 Wattle St > > Ultimo, NSW 2007 > > > > Office: 02 9212 0899 > > Direct: 02 8005 0595 > > > > *From:* koha-devel-bounces(a)lists.koha-community.org [mailto: > koha-devel-bounces(a)lists.koha-community.org] *On Behalf Of *Larry Letelier > *Sent:* Wednesday, 27 April 2016 3:09 PM > *To:* koha-devel(a)lists.koha-community.org > *Subject:* [Koha-devel] Invalid local time for date in time zone: > America/Santiago > > > > Hi people, > > > > We have a 'little' issue with the overdue aka notifications process. > > > > # pwd > > /usr/share/koha/bin/cronjobs > > > > # ./overdue_notices.pl -t > > Invalid local time for date in time zone: America/Santiago > > > > perl -d overdue_notices.pl -t > > > > Loading DB routines from perl5db.pl version 1.33 > > Editor support available. > > > > Enter h or `h h' for help, or `man perldebug' for more help. > > > > main::(overdue_notices.pl:278): my $dbh = C4::Context->dbh(); > > DB<1> c > > > > Invalid local time for date in time zone: America/Santiago > > > > at /usr/share/perl5/DateTime/TimeZone.pm line 198 > > > DateTime::TimeZone::_span_for_datetime('DateTime::TimeZone::America::Santiago=HASH(0x60cfce8)', > 'local', 'DateTime=HASH(0x617e938)') called at > /usr/share/perl5/DateTime/TimeZone.pm line 157 > > > DateTime::TimeZone::offset_for_local_datetime('DateTime::TimeZone::America::Santiago=HASH(0x60cfce8)', > 'DateTime=HASH(0x617e938)') called at /usr/lib/perl5/DateTime.pm line 930 > > DateTime::_offset_for_local_datetime('DateTime=HASH(0x617e938)') > called at /usr/lib/perl5/DateTime.pm line 375 > > DateTime::_calc_utc_rd('DateTime=HASH(0x617e938)') called at > /usr/lib/perl5/DateTime.pm line 263 > > DateTime::_new('DateTime', 'hour', 20, 'second', 0, 'month', 9, > 'locale', 'DateTime::Locale::en_US=HASH(0x1e7eac8)', ...) called at > /usr/lib/perl5/DateTime.pm line 299 > > DateTime::_new_from_self('DateTime=HASH(0x6183808)', 'hour', 0, > 'minute', 0, 'second', 0, 'month', 9, ...) called at > /usr/lib/perl5/DateTime.pm line 1933 > > DateTime::truncate(undef, 'to', 'day') called at > /usr/share/koha/lib/Koha/Calendar.pm line 214 > > Koha::Calendar::is_holiday('Koha::Calendar=HASH(0x619bc20)', > 'DateTime=HASH(0x6192ad0)') called at /usr/share/koha/lib/Koha/Calendar.pm > line 290 > > Koha::Calendar::days_between('Koha::Calendar=HASH(0x619bc20)', > 'DateTime=HASH(0x61a5b90)', 'DateTime=HASH(0x60a7ce0)') called at > overdue_notices.pl line 538 > > Debugged program terminated. Use q to quit or R to restart, > > use o inhibit_exit to avoid stopping after program termination, > > h q, h R or h o to get additional info. > > DB<1> q > > > > This is a Koha 3.2008000 > > > > In MySQL and in enviroment, tzdata, TZ='America/Santiago' is set. > > > > > > Any idea with this ? > > > > Thanks for read this, > > -Larry > > > > >

1 0

Invalid local time for date in time zone: America/Santiago
by Larry Letelier 28 Apr '16

28 Apr '16

Hi people, We have a 'little' issue with the overdue aka notifications process. # pwd /usr/share/koha/bin/cronjobs # ./overdue_notices.pl -t Invalid local time for date in time zone: America/Santiago perl -d overdue_notices.pl -t Loading DB routines from perl5db.pl version 1.33 Editor support available. Enter h or `h h' for help, or `man perldebug' for more help. main::(overdue_notices.pl:278): my $dbh = C4::Context->dbh(); DB<1> c Invalid local time for date in time zone: America/Santiago at /usr/share/perl5/DateTime/TimeZone.pm line 198 DateTime::TimeZone::_span_for_datetime('DateTime::TimeZone::America::Santiago=HASH(0x60cfce8)', 'local', 'DateTime=HASH(0x617e938)') called at /usr/share/perl5/DateTime/TimeZone.pm line 157 DateTime::TimeZone::offset_for_local_datetime('DateTime::TimeZone::America::Santiago=HASH(0x60cfce8)', 'DateTime=HASH(0x617e938)') called at /usr/lib/perl5/DateTime.pm line 930 DateTime::_offset_for_local_datetime('DateTime=HASH(0x617e938)') called at /usr/lib/perl5/DateTime.pm line 375 DateTime::_calc_utc_rd('DateTime=HASH(0x617e938)') called at /usr/lib/perl5/DateTime.pm line 263 DateTime::_new('DateTime', 'hour', 20, 'second', 0, 'month', 9, 'locale', 'DateTime::Locale::en_US=HASH(0x1e7eac8)', ...) called at /usr/lib/perl5/DateTime.pm line 299 DateTime::_new_from_self('DateTime=HASH(0x6183808)', 'hour', 0, 'minute', 0, 'second', 0, 'month', 9, ...) called at /usr/lib/perl5/DateTime.pm line 1933 DateTime::truncate(undef, 'to', 'day') called at /usr/share/koha/lib/Koha/Calendar.pm line 214 Koha::Calendar::is_holiday('Koha::Calendar=HASH(0x619bc20)', 'DateTime=HASH(0x6192ad0)') called at /usr/share/koha/lib/Koha/Calendar.pm line 290 Koha::Calendar::days_between('Koha::Calendar=HASH(0x619bc20)', 'DateTime=HASH(0x61a5b90)', 'DateTime=HASH(0x60a7ce0)') called at overdue_notices.pl line 538 Debugged program terminated. Use q to quit or R to restart, use o inhibit_exit to avoid stopping after program termination, h q, h R or h o to get additional info. DB<1> q This is a Koha 3.2008000 In MySQL and in enviroment, tzdata, TZ='America/Santiago' is set. Any idea with this ? Thanks for read this, -Larry

2 2

Sign off request...
by Mark Tompsett 26 Apr '16

26 Apr '16

Greetings, A pretty simple sign off: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15086 GPML, Mark Tompsett

1 0