<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Any ideas on this?<br>
<br>
On 9/3/10 1:03 PM, Chris Hobbs wrote:
<blockquote cite="mid:4C815482.50204@nhusd.k12.ca.us" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Hi All,<br>
<br>
We're running into a problem on 3.00.05 with the case of our
branchcodes. We have configured our branches with codes like 'LO'
or 'ES'. We imported all of our items against those codes, and
everything looked good. School just stated, and we just began
circulating, and have discovered that when items are checked in,
items.holdingbranch is being populated with lowercase variants of
those branchcodes ('lo' or 'es'). This causes the interface in
many places to claim there's no current branch, even preventing
check-out of that item.<br>
<br>
The obvious fix would be to simply set branchcode to
LOWER(branchcode) in the back end, but the foreign key constraint
prevents me from doing so through mysql. <br>
<br>
I'm fixing this temporarily by running UPDATEs against items
setting holdingbranch=UPPER(holdingbranch), but this is a kludge.
<br>
<br>
Any suggestions?<br>
<br>
<div class="moz-signature">-- <br>
<font color="blue">Chris Hobbs</font><br>
Director, Technology<br>
New Haven Unified School District</div>
--
This message has been checked by ESVA and is believed to be clean.
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Koha mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<font color="blue">Chris Hobbs</font><br>
Director, Technology<br>
New Haven Unified School District</div>
--
This message has been checked by ESVA and is believed to be clean.
</body>
</html>