Re: [Koha] Cannot save edited patron info in koha (but I can in mysql)
Hi Marty As usual we also need to the version of Koha you are running, I can confirm editing patrons works fine in 3.2.2 for me. Also check your error logs if it isn't saving there is a good chance a database error is being thrown this will be in the error log. Chris On 27 Dec 2010 08:08, "Marty" <ontariowolf64@yahoo.com> wrote: This might be a permissions thing, but I am not sure. When I edit a patron's information I can change all fields I need to, but after the information has been 'saved' nothing has changed (When I am logged in as a superlibrarian) I can play in mysql and do a 'UPDATE borrowers SET city = 'Keswick' WHERE borrowernumber = 1234; This results in the changes info showing up in Koha, but I need this working in Koha, so the librarians can change patron info. As usual, any ideas are appreciated. Marty _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Sorry, running Koha version: 3.02.00.007 on Debian Lenny I cannot find any errors in /var/log/koha or /var/log/mysql.err I wish there were, then I had something to work with... But as I said, I can change things without any problems directly in mysql with UPDATE table, and these changes show up in Koha, so to me it seems more of a communications problem between Koha and mysql than a mysql problem. But I have been wrong before. Marty --- On Sun, 12/26/10, Chris Cormack <chris@bigballofwax.co.nz> wrote: From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Sunday, December 26, 2010, 3:54 PM Hi Marty As usual we also need to the version of Koha you are running, I can confirm editing patrons works fine in 3.2.2 for me. Also check your error logs if it isn't saving there is a good chance a database error is being thrown this will be in the error log. Chris On 27 Dec 2010 08:08, "Marty" <ontariowolf64@yahoo.com> wrote: This might be a permissions thing, but I am not sure. When I edit a patron's information I can change all fields I need to, but after the information has been 'saved' nothing has changed (When I am logged in as a superlibrarian) I can play in mysql and do a 'UPDATE borrowers SET city = 'Keswick' WHERE borrowernumber = 1234; This results in the changes info showing up in Koha, but I need this working in Koha, so the librarians can change patron info. As usual, any ideas are appreciated. Marty _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On 28 December 2010 05:29, Marty <ontariowolf64@yahoo.com> wrote:
Sorry, running Koha version: 3.02.00.007 on Debian Lenny
I cannot find any errors in /var/log/koha or /var/log/mysql.err I wish there were, then I had something to work with... But as I said, I can change things without any problems directly in mysql with UPDATE table, and these changes show up in Koha, so to me it seems more of a communications problem between Koha and mysql than a mysql problem. But I have been wrong before.
Marty
Hi Marty, Sorry I was unclear I meant the apache logs. When you submit does it take you to the details page showing nothing changed? Chris
Sorry, I was gone for the week. Thanks Chris, Yes, I have errors in the apache error logs (just didn't think to look there) [Sun Jan 2 11:46:11 2011] memberentry.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/SQLHelper.pm line 336. [Sun Jan 2 11:46:11 2011] memberentry.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /usr/share/koha/lib/C4/SQLHelper.pm line 175. Mysql version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 --- On Mon, 12/27/10, Chris Cormack <chris@bigballofwax.co.nz> wrote: From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Monday, December 27, 2010, 1:39 PM On 28 December 2010 05:29, Marty <ontariowolf64@yahoo.com> wrote:
Sorry, running Koha version: 3.02.00.007 on Debian Lenny
I cannot find any errors in /var/log/koha or /var/log/mysql.err I wish there were, then I had something to work with... But as I said, I can change things without any problems directly in mysql with UPDATE table, and these changes show up in Koha, so to me it seems more of a communications problem between Koha and mysql than a mysql problem. But I have been wrong before.
Marty
Hi Marty, Sorry I was unclear I meant the apache logs. When you submit does it take you to the details page showing nothing changed? Chris
I wonder what you have in the record you are trying to save: any special characters or characters that might mean something to the script? (/, *, &, etc) If that's true, then you've found a bug I think. Can you send us (sanitized for privacy, of course, but leave the essential format the same of all field entries) an example of the information you are trying to save in the DB? Liz Rea NEKLS On Jan 2, 2011, at 11:10 AM, Marty wrote:
Sorry, I was gone for the week. Thanks Chris, Yes, I have errors in the apache error logs (just didn't think to look there)
[Sun Jan 2 11:46:11 2011] memberentry.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/SQLHelper.pm line 336. [Sun Jan 2 11:46:11 2011] memberentry.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /usr/share/koha/lib/C4/SQLHelper.pm line 175.
Mysql version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
--- On Mon, 12/27/10, Chris Cormack <chris@bigballofwax.co.nz> wrote:
From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Monday, December 27, 2010, 1:39 PM
On 28 December 2010 05:29, Marty <ontariowolf64@yahoo.com> wrote:
Sorry, running Koha version: 3.02.00.007 on Debian Lenny
I cannot find any errors in /var/log/koha or /var/log/mysql.err I wish there were, then I had something to work with... But as I said, I can change things without any problems directly in mysql with UPDATE table, and these changes show up in Koha, so to me it seems more of a communications problem between Koha and mysql than a mysql problem. But I have been wrong before.
Marty
Hi Marty, Sorry I was unclear I meant the apache logs. When you submit does it take you to the details page showing nothing changed?
Chris
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
(I should add, I just did a test on the very latest head where I put all of the special characters in every field of a patron record and I was able to save and edit the record fine) LR On Jan 3, 2011, at 9:28 AM, Liz Rea wrote:
I wonder what you have in the record you are trying to save: any special characters or characters that might mean something to the script? (/, *, &, etc)
If that's true, then you've found a bug I think. Can you send us (sanitized for privacy, of course, but leave the essential format the same of all field entries) an example of the information you are trying to save in the DB?
Liz Rea NEKLS
On Jan 2, 2011, at 11:10 AM, Marty wrote:
Sorry, I was gone for the week. Thanks Chris, Yes, I have errors in the apache error logs (just didn't think to look there)
[Sun Jan 2 11:46:11 2011] memberentry.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/SQLHelper.pm line 336. [Sun Jan 2 11:46:11 2011] memberentry.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /usr/share/koha/lib/C4/SQLHelper.pm line 175.
Mysql version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
--- On Mon, 12/27/10, Chris Cormack <chris@bigballofwax.co.nz> wrote:
From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Monday, December 27, 2010, 1:39 PM
On 28 December 2010 05:29, Marty <ontariowolf64@yahoo.com> wrote:
Sorry, running Koha version: 3.02.00.007 on Debian Lenny
I cannot find any errors in /var/log/koha or /var/log/mysql.err I wish there were, then I had something to work with... But as I said, I can change things without any problems directly in mysql with UPDATE table, and these changes show up in Koha, so to me it seems more of a communications problem between Koha and mysql than a mysql problem. But I have been wrong before.
Marty
Hi Marty, Sorry I was unclear I meant the apache logs. When you submit does it take you to the details page showing nothing changed?
Chris
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
No, I don't have any special characters so i don't think that's the issue. We are in Canada and not in the French part (dommage, non?) so there is no need for special characters anywhere. Also, it seems to give that error for every patron whose information I try to modify. I will upgrade my test box here and see what it does. Marty --- On Mon, 1/3/11, Liz Rea <lrea@nekls.org> wrote: From: Liz Rea <lrea@nekls.org> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Liz Rea" <lrea@nekls.org> Cc: "Marty" <ontariowolf64@yahoo.com>, "koha koha" <koha@lists.katipo.co.nz> Received: Monday, January 3, 2011, 10:39 AM (I should add, I just did a test on the very latest head where I put all of the special characters in every field of a patron record and I was able to save and edit the record fine) LR On Jan 3, 2011, at 9:28 AM, Liz Rea wrote: I wonder what you have in the record you are trying to save: any special characters or characters that might mean something to the script? (/, *, &, etc) If that's true, then you've found a bug I think. Can you send us (sanitized for privacy, of course, but leave the essential format the same of all field entries) an example of the information you are trying to save in the DB? Liz ReaNEKLS On Jan 2, 2011, at 11:10 AM, Marty wrote: Sorry, I was gone for the week. Thanks Chris, Yes, I have errors in the apache error logs (just didn't think to look there) [Sun Jan 2 11:46:11 2011] memberentry.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/SQLHelper.pm line 336. [Sun Jan 2 11:46:11 2011] memberentry.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /usr/share/koha/lib/C4/SQLHelper.pm line 175. Mysql version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 --- On Mon, 12/27/10, Chris Cormack <chris@bigballofwax.co.nz> wrote: From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Monday, December 27, 2010, 1:39 PM On 28 December 2010 05:29, Marty <ontariowolf64@yahoo.com> wrote:
Sorry, running Koha version: 3.02.00.007 on Debian Lenny
I cannot find any errors in /var/log/koha or /var/log/mysql.err I wish there were, then I had something to work with... But as I said, I can change things without any problems directly in mysql
with UPDATE table, and these changes show up in Koha, so to me it seems more of a communications problem between Koha and mysql than a mysql problem. But I have been wrong before.
Marty
Hi Marty, Sorry I was unclear I meant the apache logs. When you submit does it take you to the details page showing nothing changed? Chris _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Too bad, I upgraded to 3.02.02.000 but it does not make any difference. I can add a new patron, but I cannot edit brand new patrons either. Apache error log: [Mon Jan 3 14:03:41 2011] memberentry.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /usr/share/koha/lib/C4/SQLHelper.pm line 175. [Mon Jan 3 14:04:32 2011] about.pl: Can't exec "httpd": No such file or directory at /usr/share/koha/intranet/cgi-bin/about.pl line 51. [Mon Jan 3 14:04:32 2011] about.pl: Can't exec "httpd2": No such file or directory at /usr/share/koha/intranet/cgi-bin/about.pl line 52. EXPR:at pos 3: non-initialized variable key EXPR:at pos 3: non-initialized variable key EXPR:at pos 3: non-initialized variable key [Mon Jan 3 14:09:14 2011] memberentry.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /usr/share/koha/lib/C4/SQLHelper.pm line 175. --- On Mon, 1/3/11, Marty <ontariowolf64@yahoo.com> wrote: From: Marty <ontariowolf64@yahoo.com> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Liz Rea" <lrea@nekls.org> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Monday, January 3, 2011, 11:15 AM No, I don't have any special characters so i don't think that's the issue. We are in Canada and not in the French part (dommage, non?) so there is no need for special characters anywhere. Also, it seems to give that error for every patron whose information I try to modify. I will upgrade my test box here and see what it does. Marty --- On Mon, 1/3/11, Liz Rea <lrea@nekls.org> wrote: From: Liz Rea <lrea@nekls.org> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Liz Rea" <lrea@nekls.org> Cc: "Marty" <ontariowolf64@yahoo.com>, "koha koha" <koha@lists.katipo.co.nz> Received: Monday, January 3, 2011, 10:39 AM (I should add, I just did a test on the very latest head where I put all of the special characters in every field of a patron record and I was able to save and edit the record fine) LR On Jan 3, 2011, at 9:28 AM, Liz Rea wrote: I wonder what you have in the record you are trying to save: any special characters or characters that might mean something to the script? (/, *, &, etc) If that's true, then you've found a bug I think. Can you send us (sanitized for privacy, of course, but leave the essential format the same of all field entries) an example of the information you are trying to save in the DB? Liz ReaNEKLS On Jan 2, 2011, at 11:10 AM, Marty wrote: Sorry, I was gone for the week. Thanks Chris, Yes, I have errors in the apache error logs (just didn't think to look there) [Sun Jan 2 11:46:11 2011] memberentry.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/SQLHelper.pm line 336. [Sun Jan 2 11:46:11 2011] memberentry.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /usr/share/koha/lib/C4/SQLHelper.pm line 175. Mysql version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 --- On Mon, 12/27/10, Chris Cormack <chris@bigballofwax.co.nz> wrote: From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql) To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Monday, December 27, 2010, 1:39 PM On 28 December 2010 05:29, Marty <ontariowolf64@yahoo.com> wrote:
Sorry, running Koha version: 3.02.00.007 on Debian Lenny
I cannot find any errors in /var/log/koha or /var/log/mysql.err I wish there were, then I had something to work with... But as I said, I can change things without any problems directly in mysql
with UPDATE table, and these changes show up in Koha, so to me it seems more of a communications problem between Koha and mysql than a mysql problem. But I have been wrong before.
Marty
Hi Marty, Sorry I was unclear I meant the apache logs. When you submit does it take you to the details page showing nothing changed? Chris _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -----Inline Attachment Follows----- _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
A funny thing is that the modifications done directly in mysql do show up in the modification log; 2010-12-27 10:57:33 374 MEMBERS MODIFY member 479 UPDATE (executed w/ arg: 479) Don't know if that helps any, but I figured it was worth mentioning Marty
participants (3)
-
Chris Cormack -
Liz Rea -
Marty