[Koha] Still cannot save edited patron info - Solved

[Marty]

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 at bywatersolutions.com> wrote:

From: Ian Walls <ian.walls at bywatersolutions.com>
Subject: Re: [Koha] Still cannot save edited patron info
To: "Marty" <ontariowolf64 at yahoo.com>
Cc: "Chris Nighswonger" <cnighswonger at foundations.edu>, "koha koha" <koha at 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 at 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 at yahoo.com> wrote:


From: Marty <ontariowolf64 at yahoo.com>

Subject: Re: [Koha] Still cannot save edited patron info
To: "Chris Nighswonger" <cnighswonger at foundations.edu>

Cc: "koha koha" <koha at 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 at foundations.edu> wrote:


From: Chris Nighswonger <cnighswonger at foundations.edu>

Subject: Re: [Koha] Still cannot save edited patron info
To: "Marty" <ontariowolf64 at yahoo.com>
Cc: "koha koha" <koha at lists.katipo.co.nz>

Received: Wednesday, January 12, 2011, 5:35 PM

2011/1/12 Marty <ontariowolf64 at 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 at lists.katipo.co.nz

http://lists.katipo.co.nz/mailman/listinfo/koha


_______________________________________________


Koha mailing list  http://koha-community.org

Koha at 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 at bywatersolutions.com

Twitter: @sekjal



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110113/75fd8814/attachment.htm