<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><meta http-equiv="content-type" content="text/html; charset=utf-8"><span class="Apple-style-span" style="border-collapse: collapse; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><font class="yiv478251517Apple-style-span" face="arial" size="2" style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial, helvetica, clean, sans-serif; font-size: 10pt; ">Oy vey, I hate it when I seem to have a unique problem...</font><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; "><br style="line-height: 1.2em; outline-style: none; outline-width: initial;
outline-color: initial; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">I have been trying everything I could think of to be able to change my patron info in Koha.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">I can enter new patrons without problems. However, I cannot save changed in Koha.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color:
initial; ">I can go into a patron's account and change anything I want, but when I save all info is left unchanged.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "><br style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">I can go into the database and use the UPDATE table SET etc. command, and that works.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px;
padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">Obviously that is only a temporary solution.</div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; "><br style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; ">I tried upgrading (now on <span class="yiv478251517Apple-style-span"
style="line-height: 15px; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial, verdana, helvetica, sans-serif; border-collapse: collapse; color: rgb(73, 73, 73); ">3.02.02.000</span>), deleting the database and recreating it and reentering the data in mysql, and some other things I cannot remember anymore.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; "><br style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none;
outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; ">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. </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; "><br style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;
padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; ">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.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; "><br style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em;
outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; ">Below is part of the apache error log; with the errors it throws when I want to save changes to a patron.</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial; font-size: 10pt; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; outline-style: none; outline-width: initial; outline-color: initial; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none;
outline-width: initial; outline-color: initial; font-family: arial, helvetica, clean, sans-serif; font-size: 10pt; "><font class="yiv478251517Apple-style-span" face="arial" size="2" style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">[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.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial, helvetica, clean, sans-serif; font-size: 10pt; "><font class="yiv478251517Apple-style-span" face="arial" size="2"
style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial, helvetica, clean, sans-serif; font-size: 10pt; "><font class="yiv478251517Apple-style-span" face="arial" size="2" style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">I hope somebody will have some bright idea, because I'm out of ideas.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial, helvetica,
clean, sans-serif; font-size: 10pt; "><font class="yiv478251517Apple-style-span" face="arial" size="2" style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial, helvetica, clean, sans-serif; font-size: 10pt; "><font class="yiv478251517Apple-style-span" face="arial" size="2" style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">Thanks,</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color:
initial; font-family: arial, helvetica, clean, sans-serif; font-size: 10pt; "><font class="yiv478251517Apple-style-span" face="arial" size="2" style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; "><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; font-family: arial, helvetica, clean, sans-serif; font-size: 10pt; "><font class="yiv478251517Apple-style-span" face="arial" size="2" style="line-height: 1.2em; outline-style: none; outline-width: initial; outline-color: initial; ">Marty</font></div></div></span></td></tr></table><br>