Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Jonathan Druart
For all our customers that are hosted on our servers, only one has one >>> patron with dateexpiry = "-00-00" >>> >>> Regards >>> >>> S. Meynieux >>> >>> -- >>> Responsable support >>> BibLibre+ 33 (0)

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Tomas Cohen Arazi
ommunity.org> namens Jonathan Druart < >> jonathan.dru...@bugs.koha-community.org> >> *Verzonden:* woensdag 14 februari 2018 16:41 >> *Aan:* koha-devel@lists.koha-community.org >> *Onderwerp:* Re: [Koha-devel] -00-00 is expired? >> >> Great news then :) >>

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Jonathan Druart
; *Van:* koha-devel-boun...@lists.koha-community.org < > koha-devel-boun...@lists.koha-community.org> namens Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> > *Verzonden:* woensdag 14 februari 2018 16:41 > *Aan:* koha-devel@lists.koha-community.org > *Onderwerp:

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Marcel de Rooy
-community.org Onderwerp: Re: [Koha-devel] -00-00 is expired? Great news then :) Sophie and Bob, could you determine what means this value? Would it make sense to update it with -12-31 and consider it as "will never expired"? On Wed, 14 Feb 2018 at 12:13 Tomas Cohen Arazi mail

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Jonathan Druart
ischer a écrit : >> >> I've also checked our oldest 5 - didn't find any patrons with dateexpiry >> 0000-00-00. >> >> *Gesendet:* Mittwoch, 14. Februar 2018 um 08:18 Uhr >> *Von:* "Magnus Enger" >> *An:* koha-devel@lists.koha-communit

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Tomas Cohen Arazi
t; I've also checked our oldest 5 - didn't find any patrons with dateexpiry > -00-00. > > *Gesendet:* Mittwoch, 14. Februar 2018 um 08:18 Uhr > *Von:* "Magnus Enger" > *An:* koha-devel@lists.koha-community.org > *Betreff:* Re: [Koha-devel] -00-00 i

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Sophie Meynieux
cked our oldest 5 - didn't find any patrons with dateexpiry -00-00. *Gesendet:* Mittwoch, 14. Februar 2018 um 08:18 Uhr *Von:* "Magnus Enger" *An:* koha-devel@lists.koha-community.org *Betreff:* Re: [Koha-devel] -00-00 is expired? Hiya! On 13 February 2018 at 20:06, Jona

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-14 Thread Katrin Fischer
I've also checked our oldest 5 - didn't find any patrons with dateexpiry -00-00.   Gesendet: Mittwoch, 14. Februar 2018 um 08:18 Uhr Von: "Magnus Enger" An: koha-devel@lists.koha-community.org Betreff: Re: [Koha-devel] 0000-00-00 is expired? Hiya! On 13 February 201

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-13 Thread Magnus Enger
Hiya! On 13 February 2018 at 20:06, Jonathan Druart wrote: > It would be useful to know the return of > SELECT COUNT(*) FROM borrowers where dateexpiry="-00-00" > on old installations. I just checked my 5 oldest instances (upgraded regularly since 2009/2010) and none of them had any users

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-13 Thread Bob Birchall
Hi Jonathan, We have a number of old installations. They are all running 17.05 today. I checked about eight DBs and found only one record with dateexpiry = "-00-00". The record was created in 2012. Bob On 14/02/18 06:06, Jonathan Druart wrote: "Enrollment period" is mandatory when creatin

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-13 Thread Jonathan Druart
"Enrollment period" is mandatory when creating/updating a patron category, dateexpiry will be calculated when a patron is created. So, at least with new versions, this field should never be set to -00-00 (at least using the interface). We will need to take a decision at some point, either updat

Re: [Koha-devel] 0000-00-00 is expired?

2018-02-06 Thread Katrin Fischer
Hm, I don't remember a special use case for -00-00. My impression was that it is impossible to have a patron without a valid dateexpiry date. On 06.02.2018 17:10, Jonathan Druart wrote: Hi devs, I have just caught that: Koha::Patron->is_expired returns  0 if $self->dateexpiry eq '-0