By Covercrosser on

I decided to jump from Dru 6 to Dru 7
And Update.php now have some problem with Block module:

The following updates returned messages
block module
Update #7002
 
    Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mysql.blocks' doesn't exist: SHOW INDEX FROM {blocks} 
WHERE key_name = 'list'; Array ( ) in db_drop_index() (line 2924 of /home/account/domains/mysite.org/includes/database/database.inc).

(sitename, bd etc renamed)

I decided to try some other table for blocks and get new problem:

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); Array ( [:db_insert_placeholder_0] => block [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => kanji [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => -1 [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => -1 ) in drupal_write_record() (line 7106 of /includes/common.inc).

In fact, I still have 36 updates at update php, but they crashed because of blocks.
What 2 do?

⋅ Categories: Drupal 7.x