[Koha] Cannot save edited patron info in koha (but I can in mysql)

Marty ontariowolf64 at yahoo.com
Tue Jan 4 05:15:10 NZDT 2011

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.


--- On Mon, 1/3/11, Liz Rea <lrea at nekls.org> wrote:

From: Liz Rea <lrea at nekls.org>
Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql)
To: "Liz Rea" <lrea at nekls.org>
Cc: "Marty" <ontariowolf64 at yahoo.com>, "koha koha" <koha at 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)
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?
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 at bigballofwax.co.nz> wrote:

From: Chris Cormack <chris at bigballofwax.co.nz>
Subject: Re: [Koha] Cannot save edited patron info in koha (but I can in mysql)
To: "Marty" <ontariowolf64 at yahoo.com>
Cc: "koha koha" <koha at lists.katipo.co.nz>
Received: Monday, December 27, 2010, 1:39 PM

On 28 December 2010 05:29, Marty <ontariowolf64 at yahoo.com> wrote:
> Sorry, running Koha version: 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?


Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110103/8fde6d70/attachment.htm 

More information about the Koha mailing list