Hi everyone, I am also facing the same problem. Koha z39.50 was working until I upgraded to koha 2.2.9. I am running redhat enterprise linux as3, using npl template, metric date system and the error log looks like the following: DBD::mysql::st execute failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 144. DBD::mysql::st execute failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 149. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 150. Regards, Mulu Gebreegziabher Head Librarian, College of Telecommunications & Information Technology Ethio-China Road, Near Ibex Hotel, P.O. Box:27160/1000 Addis Ababa, Ethiopia Tel.: [251-11] 466-5161 Mobile. [251-91] 125-6500 Fax: [251-11] 466-7679 Email: mulu@gstit.edu.et or mulugt@ethionet.et -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Henri-Damien LAURENT Sent: Thursday, May 10, 2007 11:23 AM To: daehenoc@optusnet.com.au Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Date problem (still broken) Greg Vickers a écrit :

Hi all,

Greg Vickers wrote:

...

Hi all,

After the upgrade from 2.2.5 to 2.2.9, we are having the same or similar problems to this thread: http://lists.katipo.co.nz/public/koha/2007-April/011491.html

Anne wrote: I've been having a real problem with the members page of the system tonight. Every time I added a new member to the library it was okay... but then when I went to "issue books" it came up in red saying "Borrower will leave soon" and refused to let me issue them anything. I am thoroughly confused! This happened with (two users). Do you know what was happening?

John wrote: I attempted to manually add an expiry date to the record for xxxxxxx but it still doesn't have an entry date.

Now according to that thread, Date::Calc and/or Date::Manip should be installed, Date::Calc was installed but Date::Manip was not installed, I have installed Date::Manip and asked the librarians to test it. Does anyone have any other tips I could try?

After installing Date::Manip, the problem is not resolved. I would gratefully accept any suggestions or assistance.

Thanks, Greg We tested it on our boxes both in npl and in default templates.

And it worked. It may come out from 2 things : - your system preference date is not correctly set (metric us or iso) - you enter date in a special way. a)send me your log file (koha-error_log in /usr/local/koha/log usually... Please, only the part of what you think has to cope with this error) b) tell me which template/which date system you use. c) please send me a data set you type in i shall tell you what this error comes from. -- Henri-Damien LAURENT _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Hi Henri-Damien, Henri-Damien LAURENT wrote:

Greg Vickers a écrit :

...

Hi all,

Greg Vickers wrote:

...

Hi all,

After the upgrade from 2.2.5 to 2.2.9, we are having the same or similar problems to this thread: http://lists.katipo.co.nz/public/koha/2007-April/011491.html

Anne wrote: I've been having a real problem with the members page of the system tonight. Every time I added a new member to the library it was okay... but then when I went to "issue books" it came up in red saying "Borrower will leave soon" and refused to let me issue them anything. I am thoroughly confused! This happened with (two users). Do you know what was happening?

John wrote: I attempted to manually add an expiry date to the record for xxxxxxx but it still doesn't have an entry date.

Now according to that thread, Date::Calc and/or Date::Manip should be installed, Date::Calc was installed but Date::Manip was not installed, I have installed Date::Manip and asked the librarians to test it. Does anyone have any other tips I could try?

After installing Date::Manip, the problem is not resolved. I would gratefully accept any suggestions or assistance.

Thanks, Greg We tested it on our boxes both in npl and in default templates.

And it worked.

It may come out from 2 things : - your system preference date is not correctly set (metric us or iso) - you enter date in a special way.

a)send me your log file (koha-error_log in /usr/local/koha/log usually... Please, only the part of what you think has to cope with this error) b) tell me which template/which date system you use. c) please send me a data set you type in

i shall tell you what this error comes from.

OK, here's the extract from koha-error.log: X.x.141.186 - - [13/May/2007:20:45:09 +1000] "POST /cgi-bin/koha/members/memberentry.pl HTTP/1.1" 302 16659 X.x.141.186 - - [13/May/2007:20:45:10 +1000] "GET /cgi-bin/koha/members/moremember.pl?bornum=953 HTTP/1.1" 200 17468 Our host is a Debian Sarge (3.x) system, and we use ISO date format. I create a new user with the following fields: Card number: dmn01 Given Names: Delete Me Surname: Now Postal Address: somewhere Town: Else Click Save and a Membership record is created but the Joined Date is a ',' character and the Expires date is blank. Looks like the code in the new version is catching a ',' character somewhere instead of the correct field. With the previous version 2.2.5, we could leave the Joining date and Expiry date blank and they would be automatically calculated. If anyone knows what is causing this problem and how to fix it, that would be great! Thanks, Greg

Hi Greg, I took a look at this and found here -> http://search.cpan.org/dist/Date-Calc/Calc.pod and found this: |if (($year,$month,$day) = Parse_Date($string))| This function is useful for parsing dates as returned by the UNIX "|date|" command or as found in the headers of e-mail (in order to determine the date at which some e-mail has been sent or received, for instance). So I tried this: !/usr/bin/perl -w use Date::Manip; use Date::Calc qw(Parse_Date Decode_Date_EU Decode_Date_US Time_to_Date check_date); $date = ParseDate('today'); print $date."\n"; $date2 = 'Thu May 17 09:35:43 NZST 2007'; print $date2."\n"; my ($year,$month,$day)=Parse_Date($date); print "Year: $year\n"; print "Month: $month\n"; print "Day: $day\n"; my ($year2,$month2,$day2)=Parse_Date($date2); print "Year: $year2\n"; print "Month: $month2\n"; print "Day: $day2\n"; which gave me this: 2007051709:38:42 Thu May 17 09:35:43 NZST 2007 Use of uninitialized value in concatenation (.) or string at test.pl line 13. Year: Use of uninitialized value in concatenation (.) or string at test.pl line 14. Month: Use of uninitialized value in concatenation (.) or string at test.pl line 15. Day: Year: 2007 Month: 5 Day: 17 So it looks as if the date being passed to the Parse_Date() may be in the wrong format Bob Greg Vickers wrote:

Hi all,

I'm trying to find where Koha 2.2.9 is failing when we create a new user. I'm going to trace it through from the HTML page right through the perl files that get called. I'll document my progress in this email and I'll find the problem (eventually) or someone will be able to give me a helping hand.

OK, logging on to Koha and going Members -> Add Members (http://<sanitized>/cgi-bin/koha/members/memberentry.pl?actionType=Add)

Entering: Member#: dmn01 Given Names: Delete Me Surname: Now Postal Address: somewhere Town: Else

Leaving all other fields blank and clicking the 'Save' button gives: Card number: dmn01 ... Joined: , Expires:

Joined and Expires dates are not automatically calculated. Librarians can manually enter these fields but it's a pain since the system used to automatically calculate them.

Even if I manually enter a date into Joined when creating a new member, the Expires field is still blank after the user is created.

Tracing through memberentry.pl, so long as $nok remains undefined then we get to here: my $query="Select * from borrowers where borrowernumber=?"; my $sth=$dbh->prepare($query); $sth->execute($data{'borrowernumber'}); if (my $data2=$sth->fetchrow_hashref){ &modmember(%data); }else{ $borrowernumber = &newmember(%data); }

So I assume that $data2 is undefined when creating a new member and we call newmember with the array %data. Which is newmember.pl in the same directory as memberentry.pl ... bla bla bla ...

Following newmember.pl we get to this: if ($data{'joining'} eq ''){ $data{'joining'}=ParseDate('today'); $data{'joining'}=format_date($data{'joining'}); }

Running this line at the command prompt: perl -MDate::Manip -e 'print(ParseDate('today'));' spits out this string: 2007051622:19:35

So ParseDate appears to return a string, but I don't know if it is in the correct format.

BTW our Koha system preference for date is set to ISO.

Digging through the Koha module C4::Date (intranet/modules/C4/Date.pm) to see how format_date works, we get this: my ($year,$month,$day)=Parse_Date($olddate);

Now Parse_Date in C4::Date comes from: use Date::Calc qw(Parse_Date Decode_Date_EU Decode_Date_US Time_to_Date check_date);

Reading the Perl CPAN page about Parse_Date I wrote this code:

~ cat runme.pl #!/usr/bin/perl -w

use Date::Manip; use Date::Calc qw(Parse_Date Decode_Date_EU Decode_Date_US Time_to_Date check_date);

$date = ParseDate('today'); print $date."\n";

my ($year,$month,$day)=Parse_Date($date); print "Year: $year\n"; print "Month: $month\n"; print "Day: $day\n";

And surprise, surprise, we get the following output: ./runme.pl 2007051622:29:53 Use of uninitialized value in concatenation (.) or string at ./runme.pl line 10. Year: Use of uninitialized value in concatenation (.) or string at ./runme.pl line 11. Month: Use of uninitialized value in concatenation (.) or string at ./runme.pl line 12. Day:

Bastard. $year, $month and $day are all undefined. So Parse_Date is failing to parse 2007051622:29:53 correctly. What the feck do I do to correct it? Any suggestions about the best course of attack? I could just go in with a crowbar but I'd like some suggestions first :)

Anyway, I'm going to bed now :)

Thanks, Greg

_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

-- Robert Lyon Katipo Communications

Hi Mike, Mike Dalgity wrote:

The comma that you're seeing in the Joined field is coming from the template. Should be a quick fix to edit that out.

Yes, thanks - I figured that out but forgot to take it out of the email, it looks like the comma is mean to be there in the template and does not affect the problem that we are having. Thanks, Greg

-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz]On Behalf Of Greg Vickers Sent: May 16, 2007 5:20 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Date problem - tracing from HTML through perl files

Hi all,

bla bla bla

Hi, Henri-Damien LAURENT wrote:

Greg Vickers a écrit :

...

Hi Mike,

Mike Dalgity wrote:

...

The comma that you're seeing in the Joined field is coming from the template. Should be a quick fix to edit that out.

Yes, thanks - I figured that out but forgot to take it out of the email, it looks like the comma is mean to be there in the template and does not affect the problem that we are having.

Thanks, Greg

Thanks for your details. My problem is that everything goes OK here. So I have problems tracing a problem I donot have.

you are not right when you say newmember on memberentry calls to newmember.pl Indeed, it calls newmember sub in Members.pm. And this procedure works as this :

<snip>

(Extract of C4::Members.pm from line 130 to line 150) using only Date::Calc module as you can see, and format_date_in_iso and not format_date or ParseDate.

... right, I'll check what I read, I may have traced the problem incorrectly.

What you pointed at can be a source of problems, I can fix it. But I have seen no code using newmember.pl. Are you creating a peculiar type of member (institution or child) ?

Creating an ordinary borrowing member. Thanks, Greg