Hello, I am using Koha 2.2.9 with Windows along with apache_2.2.8-win32-x86-no_ssl, mysql 5.0 and ActivePerl 5.8.8. Everything is going well except for the fact that not matter what I do, I can't add a member. I have been filling out all of the needed fields, but once I go to save the member record, none of the information saves and I get a record full of commas. I have been desperately searching for answers to this problem in the archives...it seems others have had the same problem, but no solution has been posted. Any assistance is greatly appreciated. Thank you! Katie -- View this message in context: http://www.nabble.com/Problems-Adding-Members-tp16924520p16924520.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Can you see if there is anything in the apache error logs pertaining to this? -- Jesse
Here is the error log....hope this helps. Thank you!!! arent: Received restart signal -- Restarting the server. [Sat Apr 26 18:45:38 2008] [notice] Child 372: Exit event signaled. Child process is ending. [Sat Apr 26 18:45:38 2008] [notice] Apache/2.2.8 (Win32) configured -- resuming normal operations [Sat Apr 26 18:45:38 2008] [notice] Server built: Jan 18 2008 00:37:19 [Sat Apr 26 18:45:38 2008] [notice] Parent: Created child process 5724 [Sat Apr 26 18:45:38 2008] [notice] Child 5724: Child process is running [Sat Apr 26 18:45:39 2008] [notice] Child 372: Released the start mutex [Sat Apr 26 18:45:39 2008] [notice] Child 5724: Acquired the start mutex. [Sat Apr 26 18:45:39 2008] [notice] Child 5724: Starting 250 worker threads. [Sat Apr 26 18:45:40 2008] [notice] Child 372: All worker threads have exited. [Sat Apr 26 18:45:40 2008] [notice] Child 372: Child process is exiting [Sat Apr 26 18:45:40 2008] [notice] Child 5724: Starting thread to listen on port 80. -- View this message in context: http://www.nabble.com/Problems-Adding-Members-tp16924520p16945654.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Hmm, there's nothing that seems to mention your particular problem. The log entries you're looking for will mention files ending in .pl, and look something like this: [Thu Feb 14 09:24:26 2008] [error] [client 127.0.0.1] Premature end of script headers: barcodesGenerator.pl, referer: http://localhost:8000/* cgi-bin/koha/members/memberentry.pl*<http://localhost:8000/cgi-bin/koha/barcodes/barcodes.pl> If you can find log entries like this (and the text around them) anywhere in your error logs, it will help us solve your problem. -- Jesse
Sorry about that. I'm completely new to this whole thing and was not accessing the intranet log. Thanks so much for your patience. Here, this is what I think you are looking for: [Mon Apr 28 13:53:43 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect date value: '' for column 'expiry' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add [Mon Apr 28 14:19:40 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect date value: '' for column 'expiry' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add [Mon Apr 28 14:20:31 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect date value: '' for column 'expiry' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add [Mon Apr 28 19:51:14 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect date value: '0000-2008050100-00' for column 'expiry' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add [Mon Apr 28 19:57:47 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect date value: '' for column 'expiry' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add [Mon Apr 28 19:59:16 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect date value: '' for column 'dateofbirth' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add [Mon Apr 28 20:00:12 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect integer value: '' for column 'gonenoaddress' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add [Mon Apr 28 20:01:06 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect integer value: '' for column 'gonenoaddress' at row 1 at c:/usr/koha229/intranet/modules/C4/Members.pm line 155., referer: http://intranet/cgi-bin/koha/members/memberentry.pl?actionType=Add -- View this message in context: http://www.nabble.com/Problems-Adding-Members-tp16924520p16951426.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
That's exactly what I needed. Thanks! I recognize that error, too. I can send you a patch (along with instructions for applying it) that will fix it as soon as I get to work this wednesday. -- Jesse
participants (2)
-
Jesse -
KatieR