Upgrading from Drupal 6.24 to 7.12

Update #7004
Failed: PDOException: SQLSTATE[HY000]: General error: 1364 Field 'title' doesn't have a default value: INSERT INTO {block} (module, delta, theme, status, weight, region, pages, cache) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15); Array ( [:db_insert_placeholder_0] => system [:db_insert_placeholder_1] => help [:db_insert_placeholder_2] => garland [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => help [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => 1 [:db_insert_placeholder_8] => system [:db_insert_placeholder_9] => main [:db_insert_placeholder_10] => garland [:db_insert_placeholder_11] => 1 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => content [:db_insert_placeholder_14] => [:db_insert_placeholder_15] => -1 ) in block_update_7004() (line 283 of /home2/formykid/drupal/7/drupal-7.12/modules/block/block.install).

I modified the DB block table 'title' field to add a default of '' and re-executed update.php.

Comments

neRok’s picture

Category: bug » support
Status: Active » Closed (fixed)
Anonymous’s picture

Category: support » bug
Status: Closed (fixed) » Active

The page provides a workaround to the issue. It does not provide a fix to the issue.

neRok’s picture

Im not too familiar with the upgrade path, nor can I test the problem.

I am wondering though, do you still have the problem db? If so, can you open it in phpmyadmin or something, and manually add a row to the block table, without a title?

Version: 7.12 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.