Still cannot save edited patron info
Oy vey, I hate it when I seem to have a unique problem... I have been trying everything I could think of to be able to change my patron info in Koha.I can enter new patrons without problems. However, I cannot save changed in Koha.I can go into a patron's account and change anything I want, but when I save all info is left unchanged. I can go into the database and use the UPDATE table SET etc. command, and that works.Obviously that is only a temporary solution. I tried upgrading (now on 3.02.02.000), deleting the database and recreating it and reentering the data in mysql, and some other things I cannot remember anymore. The only thing I can think of is that maybe I am missing info in some table or another as I've had problems upgrading from an earlier version and the cataloguing page disappeared which I solved by doing a selective backup and restore, and I might have lost some vital information there maybe. But I haven't the foggiest which table that could be and if that is the actual problem. Also, the checkout history always returns 'title' has never been checked out and the reading record is always empty, not sure whether that might be related somehow. Below is part of the apache error log; with the errors it throws when I want to save changes to a patron. [Wed Jan 12 10:04: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. I hope somebody will have some bright idea, because I'm out of ideas. Thanks, Marty
2011/1/12 Marty <ontariowolf64@yahoo.com> <snip>
I tried upgrading (now on 3.02.02.000), deleting the database and recreating it and reentering the data in mysql, and some other things I cannot remember anymore.
Have you tried creating an empty database, installing some of the sample data, and trying to add/edit a patron? Kind Regards, Chris
Thanks Chris, that was a good idea. When I start with an empty database and add the sample patrons and some other sample data I can edit AND save the patron data. So I guess it's something in my database, now I have to figure out what... Marty --- On Wed, 1/12/11, Chris Nighswonger <cnighswonger@foundations.edu> wrote: From: Chris Nighswonger <cnighswonger@foundations.edu> Subject: Re: [Koha] Still cannot save edited patron info To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, January 12, 2011, 5:35 PM 2011/1/12 Marty <ontariowolf64@yahoo.com> <snip>
I tried upgrading (now on 3.02.02.000), deleting the database and recreating it and reentering the data in mysql, and some other things I cannot remember anymore.
Have you tried creating an empty database, installing some of the sample data, and trying to add/edit a patron? Kind Regards, Chris
Can anybody tell me which tables koha uses when editing patron info? Only borrowers or are other tables involved? Thanks, Marty --- On Wed, 1/12/11, Marty <ontariowolf64@yahoo.com> wrote: From: Marty <ontariowolf64@yahoo.com> Subject: Re: [Koha] Still cannot save edited patron info To: "Chris Nighswonger" <cnighswonger@foundations.edu> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, January 12, 2011, 10:31 PM Thanks Chris, that was a good idea. When I start with an empty database and add the sample patrons and some other sample data I can edit AND save the patron data. So I guess it's something in my database, now I have to figure out what... Marty --- On Wed, 1/12/11, Chris Nighswonger <cnighswonger@foundations.edu> wrote: From: Chris Nighswonger <cnighswonger@foundations.edu> Subject: Re: [Koha] Still cannot save edited patron info To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, January 12, 2011, 5:35 PM 2011/1/12 Marty <ontariowolf64@yahoo.com> <snip>
I tried upgrading (now on 3.02.02.000), deleting the database and recreating it and reentering the data in mysql, and some other things I cannot remember anymore.
Have you tried creating an empty database, installing some of the sample data, and trying to add/edit a patron? Kind Regards, Chris -----Inline Attachment Follows----- _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Marty, borrowers is pretty much it, unless you use Extended Patron Attributes, then borrower_attributes and borrower_attribute_types are also factored in. -Ian 2011/1/13 Marty <ontariowolf64@yahoo.com>
Can anybody tell me which tables koha uses when editing patron info? Only borrowers or are other tables involved? Thanks, Marty
--- On *Wed, 1/12/11, Marty <ontariowolf64@yahoo.com>* wrote:
From: Marty <ontariowolf64@yahoo.com>
Subject: Re: [Koha] Still cannot save edited patron info To: "Chris Nighswonger" <cnighswonger@foundations.edu>
Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, January 12, 2011, 10:31 PM
Thanks Chris, that was a good idea. When I start with an empty database and add the sample patrons and some other sample data I can edit AND save the patron data. So I guess it's something in my database, now I have to figure out what...
Marty
--- On *Wed, 1/12/11, Chris Nighswonger <cnighswonger@foundations.edu>*wrote:
From: Chris Nighswonger <cnighswonger@foundations.edu> Subject: Re: [Koha] Still cannot save edited patron info To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, January 12, 2011, 5:35 PM
2011/1/12 Marty <ontariowolf64@yahoo.com>
<snip>
I tried upgrading (now on 3.02.02.000), deleting the database and recreating it and reentering the data in mysql, and some other things I cannot remember anymore.
Have you tried creating an empty database, installing some of the sample data, and trying to add/edit a patron?
Kind Regards, Chris
-----Inline Attachment Follows-----
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <http://mc/compose?to=Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
Thanks all, it turned out there was no primary key in koha.borrowers, probably because there was a duplicate entry left over from long ago. After deleting the duplicate entry and adding the primary key I can edit and save patron info again. Thanks for all your help. Marty --- On Thu, 1/13/11, Ian Walls <ian.walls@bywatersolutions.com> wrote: From: Ian Walls <ian.walls@bywatersolutions.com> Subject: Re: [Koha] Still cannot save edited patron info To: "Marty" <ontariowolf64@yahoo.com> Cc: "Chris Nighswonger" <cnighswonger@foundations.edu>, "koha koha" <koha@lists.katipo.co.nz> Received: Thursday, January 13, 2011, 2:35 PM Marty, borrowers is pretty much it, unless you use Extended Patron Attributes, then borrower_attributes and borrower_attribute_types are also factored in. -Ian 2011/1/13 Marty <ontariowolf64@yahoo.com> Can anybody tell me which tables koha uses when editing patron info? Only borrowers or are other tables involved? Thanks, Marty --- On Wed, 1/12/11, Marty <ontariowolf64@yahoo.com> wrote: From: Marty <ontariowolf64@yahoo.com> Subject: Re: [Koha] Still cannot save edited patron info To: "Chris Nighswonger" <cnighswonger@foundations.edu> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, January 12, 2011, 10:31 PM Thanks Chris, that was a good idea. When I start with an empty database and add the sample patrons and some other sample data I can edit AND save the patron data. So I guess it's something in my database, now I have to figure out what... Marty --- On Wed, 1/12/11, Chris Nighswonger <cnighswonger@foundations.edu> wrote: From: Chris Nighswonger <cnighswonger@foundations.edu> Subject: Re: [Koha] Still cannot save edited patron info To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, January 12, 2011, 5:35 PM 2011/1/12 Marty <ontariowolf64@yahoo.com> <snip>
I tried upgrading (now on 3.02.02.000), deleting the database and recreating it and reentering the data in mysql, and some other things I cannot remember anymore.
Have you tried creating an empty database, installing some of the sample data, and trying to add/edit a patron? Kind Regards, Chris -----Inline Attachment Follows----- _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
participants (3)
-
Chris Nighswonger -
Ian Walls -
Marty