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?
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.
You're right. It is not. Hmmm, is there a known issue of the conversion of isam->innodb losing autonum?
On Tue, Oct 23, 2012 at 8:33 AM, Richard Damon Richard@damon-family.orgwrote:
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
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Jeff Greenberg -
Richard Damon