[support] Trouble with block boxes

[Richard Damon]

On 10/23/12 8:14 AM, Jeff Greenberg wrote:
> 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.
>
> 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.
>
> Any thoughts on why I'm ending up with the 0 value?
>
> -- 
> ---
> drupal.org/user/367108 <http://drupal.org/user/367108>
> linkedin.com/in/jeffrgreenberg <http://linkedin.com/in/jeffrgreenberg>
> accidentalcoder.com <http://accidentalcoder.com> / ayendesigns.com
> <http://ayendesigns.com>
> @accidentalcoder
>
>
>
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.

-- 
Richard Damon

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20121023/44505727/attachment.html