Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
neRok CreditAttribution: neRok commentedThe following page seems to have the answer
User warning: Field doesn't have a default value (PDOException: SQLSTATE[HY000]: General error: 1364)
Comment #2
Anonymous (not verified) CreditAttribution: Anonymous commentedThe page provides a workaround to the issue. It does not provide a fix to the issue.
Comment #3
neRok CreditAttribution: neRok commentedIm 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?