Hi Jesse, Could you help me out with this error as well. The intranet log, shows an error very similar to the one posted earlier. [Mon Mar 09 14:25:59 2009] [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 amadeus Jesse-34 wrote:
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
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Problems-Adding-Members-tp16924520p22409358.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Thank you Jesse for the patched Date.pm file. Unfortunately, that didn't help and I continue to get the same error. Any idea why? amadeus. Hi Jesse, Could you help me out with this error as well. The intranet log, shows an error very similar to the one posted earlier. [Mon Mar 09 14:25:59 2009] [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 amadeus -- View this message in context: http://www.nabble.com/Problems-Adding-Members-tp16924520p22470207.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Thanks again for new file. That seemed to have solved the problem. But, a new error has cropped up %-O . I still cant add members. Extract from log: [Fri Mar 13 09:38:10 2009] [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 What now? Could you please help me out on this one as well? -- View this message in context: http://www.nabble.com/Problems-Adding-Members-tp16924520p22490014.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
I fixed it ! =^D I don't know any perl, but with my basic understanding of programming concepts, I tried to debug the members.pl file. It so happens that the module to add new members tries to insert data for the flag 'gonenoaddress' into the wrong location. I had to just correct that. replaced $data{'gonenoaddress} with $data{'gna'}. I managed to sucessfully add one member-myself ! Hope to add more. I hope, I'll continue to receive help from you, if needed. With minimal programming knowledge (hope to change that) and no library science background, I could use any help I can get! amadeus amadeus wrote:
Thanks again for new file. That seemed to have solved the problem. But, a new error has cropped up %-O . I still cant add members. Extract from log: [Fri Mar 13 09:38:10 2009] [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
What now? Could you please help me out on this one as well?
-- View this message in context: http://www.nabble.com/Problems-Adding-Members-tp16924520p22490380.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (1)
-
amadeus