<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">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.<div><br></div><div>Thanks for all your help.</div><div><br></div><div>Marty<br><br>--- On <b>Thu, 1/13/11, Ian Walls <i><ian.walls@bywatersolutions.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Ian Walls <ian.walls@bywatersolutions.com><br>Subject: Re: [Koha] Still cannot save edited patron info<br>To: "Marty" <ontariowolf64@yahoo.com><br>Cc: "Chris Nighswonger" <cnighswonger@foundations.edu>, "koha koha" <koha@lists.katipo.co.nz><br>Received: Thursday, January 13, 2011, 2:35 PM<br><br><div
id="yiv1246447702">Marty,<br><br><br>borrowers is pretty much it, unless you use Extended Patron Attributes, then borrower_attributes and borrower_attribute_types are also factored in.<br><br><br>-Ian<br><br><div class="yiv1246447702gmail_quote">2011/1/13 Marty <span dir="ltr"><<a rel="nofollow" ymailto="mailto:ontariowolf64@yahoo.com" target="_blank" href="/mc/compose?to=ontariowolf64@yahoo.com">ontariowolf64@yahoo.com</a>></span><br>
<blockquote class="yiv1246447702gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex;"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit;" valign="top">
Can anybody tell me which tables koha uses when editing patron info? Only borrowers or are other tables involved? Thanks, Marty<div><br><br>--- On <b>Wed, 1/12/11, Marty <i><<a rel="nofollow" ymailto="mailto:ontariowolf64@yahoo.com" target="_blank" href="/mc/compose?to=ontariowolf64@yahoo.com">ontariowolf64@yahoo.com</a>></i></b> wrote:<br>
<blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;"><br>From: Marty <<a rel="nofollow" ymailto="mailto:ontariowolf64@yahoo.com" target="_blank" href="/mc/compose?to=ontariowolf64@yahoo.com">ontariowolf64@yahoo.com</a>><div class="yiv1246447702im">
<br>Subject: Re: [Koha] Still cannot save edited patron info<br></div>To: "Chris Nighswonger" <<a rel="nofollow" ymailto="mailto:cnighswonger@foundations.edu" target="_blank" href="/mc/compose?to=cnighswonger@foundations.edu">cnighswonger@foundations.edu</a>><div class="yiv1246447702im">
<br>Cc: "koha koha" <<a rel="nofollow" ymailto="mailto:koha@lists.katipo.co.nz" target="_blank" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>><br></div>Received: Wednesday, January 12, 2011, 10:31 PM<div><div></div><div class="yiv1246447702h5"><br><br><div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit;" valign="top">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...<div><br></div><div>Marty<br><br>--- On <b>Wed, 1/12/11, Chris Nighswonger <i><<a rel="nofollow" ymailto="mailto:cnighswonger@foundations.edu" target="_blank" href="/mc/compose?to=cnighswonger@foundations.edu">cnighswonger@foundations.edu</a>></i></b> wrote:<br>
<blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;"><br>From: Chris Nighswonger <<a rel="nofollow" ymailto="mailto:cnighswonger@foundations.edu" target="_blank" href="/mc/compose?to=cnighswonger@foundations.edu">cnighswonger@foundations.edu</a>><br>
Subject: Re: [Koha] Still cannot save edited patron info<br>To: "Marty" <<a rel="nofollow" ymailto="mailto:ontariowolf64@yahoo.com" target="_blank" href="/mc/compose?to=ontariowolf64@yahoo.com">ontariowolf64@yahoo.com</a>><br>Cc: "koha koha" <<a rel="nofollow" ymailto="mailto:koha@lists.katipo.co.nz" target="_blank" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>><br>
Received: Wednesday, January 12, 2011, 5:35 PM<br><br><div>2011/1/12 Marty <<a rel="nofollow">ontariowolf64@yahoo.com</a>><br><br><snip><br><br>> 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.<br>
<br>Have you tried creating an empty database, installing some
of the<br>sample data, and trying to add/edit a patron?<br><br>Kind Regards,<br>Chris<br></div></blockquote></div></td></tr></tbody></table><br></div><br></div></div>-----Inline Attachment Follows-----<div class="yiv1246447702im"><br>
<br><div>_______________________________________________<br>Koha mailing list <a rel="nofollow" target="_blank" href="http://koha-community.org">http://koha-community.org</a><br><a rel="nofollow" target="_blank" href="http://mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a rel="nofollow" target="_blank" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br></div></div></blockquote></div></td></tr></tbody></table><br><br>_______________________________________________<br>
Koha mailing list <a rel="nofollow" target="_blank" href="http://koha-community.org">http://koha-community.org</a><br>
<a rel="nofollow" ymailto="mailto:Koha@lists.katipo.co.nz" target="_blank" href="/mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a rel="nofollow" target="_blank" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Ian Walls<br>Lead Development Specialist<br>ByWater Solutions<br>Phone # (888) 900-8944<br><a rel="nofollow" target="_blank" href="http://bywatersolutions.com">http://bywatersolutions.com</a><br><a rel="nofollow" ymailto="mailto:ian.walls@bywatersolutions.com" target="_blank" href="/mc/compose?to=ian.walls@bywatersolutions.com">ian.walls@bywatersolutions.com</a><br>
Twitter: @sekjal<br>
</div></blockquote></div></td></tr></table><br>