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