<!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">
On 9/15/10 9:01 AM, Galen Charlton wrote:
<blockquote
cite="mid:1993A2CD-DAB0-4462-95CD-4CDEBAF24324@esilibrary.com"
type="cite">
<pre wrap="">Hi,
On Sep 3, 2010, at 4:03 PM, Chris Hobbs wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap="">
A longer-term fix would be to figure out why it's not setting the branchcode correctly, but as far as cascading the update of branchcode is concerned, you could either alter the constraints to cascade updates or take advantage of MySQL's ability to disable foreign key checks temporarily:
SET FOREIGN_KEY_CHECKS = 0;</pre>
</blockquote>
Galen's direction on removing the foreign key checks temporarily got
me the ability to update branchcodes across all of my db tables, but
I seem to have a problem with my zebra indexes - most of my items
(those that have not been circulated since the conversion) do not
have branch information visible information - here's a screen shot:
<a class="moz-txt-link-freetext" href="http://www.nhusd.k12.ca.us/it/files/images/Screen%20shot%202010-09-23%20at%204.14.03%20PM.png">http://www.nhusd.k12.ca.us/it/files/images/Screen%20shot%202010-09-23%20at%204.14.03%20PM.png</a><br>
<br>
I have tried re-indexing in the hopes that it would work itself out
(rebuild_zebra.pl -b -a -r) but no luck. Any idea how to get the
correct (lowercase) branch info into the zebra indexes?<br>
<br>
Thanks,<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.
</body>
</html>