<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 10/23/12 8:14 AM, Jeff Greenberg
wrote:<br>
</div>
<blockquote
cite="mid:CAPpCgRb0wDwn7Uf51JWqUefgwjqHuo9rVCnZHD4Jpk=irXZ-QQ@mail.gmail.com"
type="cite">Recently converted the d6 db to innodb tables on
local, dev and qa platforms. My local box seems to have an issue
that the other two do not, though it may have existed prior to the
conversion. I hadn't manually created blocks before then, though
the site does contain blocks that predate my involvement.
<div>
<br>
</div>
<div>When I add a block, the delta in the blocks table is 0, and
the boxes bid is 0. This results in, I believe, the boxes entry
not being found when I edit the block, as the title, body and
settings are not present. Deleting the block works correctly,
and if I manually change the delta to the highest delta for
'block' + 1, and set the bid in boxes to be the same, the issue
is gone.</div>
<div><br>
</div>
<div>Any thoughts on why I'm ending up with the 0 value?</div>
<div>
<div><br>
</div>
-- <br>
---
<div><a moz-do-not-send="true"
href="http://drupal.org/user/367108" target="_blank">drupal.org/user/367108</a></div>
<div><a moz-do-not-send="true"
href="http://linkedin.com/in/jeffrgreenberg" target="_blank">linkedin.com/in/jeffrgreenberg</a></div>
<div><a moz-do-not-send="true" href="http://accidentalcoder.com"
target="_blank">accidentalcoder.com</a> / <a
moz-do-not-send="true" href="http://ayendesigns.com"
target="_blank">ayendesigns.com</a></div>
<div>@accidentalcoder</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
The fields probably aren't defined as being an "auto-increment"
field in the actual database schema. Auto-increment fields
automatically assign 0 values to the next number in sequence.<br>
<br>
<pre class="moz-signature" cols="72">--
Richard Damon</pre>
</body>
</html>