6.20 to 7.0 upgrade error: Table block_node_type doesn't exist

Dear fellow Drupal enthusiasts,

this issue is now lasting for a very long time in the issue queue and was unfortunately never solved. As Drupal is a open source project everyone is helping on voluntary basis. So that this is was not solved is nothing personal and means no harm. But perhaps no one had time to deal with this issue, maybe it is too complex or did not pose the problem comprehensible.

But this issue is not the only one. There are thousands of issues on Drupal.org that have never been worked on or could not be processed. This means that we are building a wave that is unmanageable and just a problem for the Drupal project as a whole. Please help us keep the issue queue smaller and more manageable.

Please read again, "Making an issue report" and see if you can improve the issue. Test the problem with the current Core and modules. Maybe the problem doesn't exist anymore, is a duplicate or has even been solved within this issue but never closed.

Help can also be found for it on IRC and in the user groups.

In order this issue no longer remains, I put this issue to "fixed".

If there is new information, please re-open the issue.

I have the same issues, but more. No fix?

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxxxxl.block_node_type' doesn't exist: SELECT module, delta, type FROM {block_node_type}; Array ( ) in node_block_list_alter() (line 2521 of /home/xxx/public_html/modules/node/node.module).
The following updates returned messages

node module

Update #7006
Failed: DatabaseSchemaObjectExistsException: Table <em class="placeholder">field_data_body</em> already exists. in DatabaseSchema->createTable() (line 657 of /home/xxx/public_html/includes/database/schema.inc).
taxonomy module

Update #7005
Failed: DatabaseSchemaObjectExistsException: Table <em class="placeholder">taxonomy_update_7005</em> already exists. in DatabaseSchema->createTable() (line 657 of /home/xxx/public_html/includes/database/schema.inc).
domain_source module

Update #7300
Failed: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'domain_id' at row 2: UPDATE {domain_source} SET domain_id=:db_update_placeholder_0 WHERE (domain_id = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => [:db_condition_placeholder_0] => 0 ) in domain_source_update_7300() (line 44 of /home/xxx/public_html/sites/all/modules/domain/domain_source/domain_source.install).

Did you try just creating the table:

CREATE TABLE `block_node_type` (
`module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from block.module.',
`delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from block.delta.',
`type` varchar(32) NOT NULL COMMENT 'The machine-readable name of this type from node_type.type.',
PRIMARY KEY (`module`,`delta`,`type`),
KEY `type` (`type`)
)

I had this issue while upgrading from Drupal 6.38. The issue was one of data corruption. My data has come from Drupal 5 through Drupal 6, and so some of the data has become corrupt.

In my case, the problem was in the users table and the blocks table (in D6). I had users with NULL passwords, and blocks with NULL titles. I removed the users with NULL passwords and turned the block titles from NULL to the empty string, and that worked.

I found the affected rows in the error messages produced by update.php (in my case, invoked through drush), examined the data which generated the errors, and that helped me isolate what the problem is. I can't say for sure that this is your problem, but it was what was blocking me from making the updates. When the NULL values were removed, the update proceeded normally, and all of the tables were created.

What appears to happen is that the update process comes across an error, and then only partially completes. This is not apparent from the report at the end of the update process.

If you have users with NULL passwords, you can select them with:

Select * from users where pass is NULL;

Then take those uids and insert them into the user delete URL to delete the user.

As for the blocks table, I issued the following SQL statement:

update blocks set title = '' where title is null;

in MySQL.