Attempting upgrade from D6.20 to D7-rc4. My update.php process failed, and for an error I got:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydb.d7_block_custom' doesn't exist: SELECT bid, info FROM {block_custom} ORDER BY info; Array ( ) in block_block_info() (line 209 of /modules/block/block.module).

There were a bunch of "Notice: Undefined property: stdClass::$disabled in _node_types_build()" messages in there too, but I assume being notices I can ignore them.

I have a clean (non-upgrade) RC4 installation, so I copied the blocks_custom table from that install into the db I'm trying to upgrade. The table is empty so I hoped that the structure would be correct.

Copying that table seems to have gotten me past that error. The next was the same error but with table 'block'. Comparing a D6 db to a D7 db it looks like those are the same table. So I manually renamed by 'blocks' table to 'block' along with 'blocks_roles' to 'block_role.'

Sadly, next I got "The update process was aborted prematurely while running update #7000 in user.module. All errors have been logged. You may need to check the watchdog database table manually." That I had to look in the watchdog table for, and it appears to be the 'disabled' column in the node_type table, present in d7 and missing from d6. I would have thought that the installer would have modified that for me.

Next is "menu_router.include_file". I fully expect from this that every database schema change I make I will have to make manually. I presume that this is an atypical experience but I figure someone should be aware of it. Hence my post here.


mikolaskova’s picture

I have the same problem as you describe. Did you find a good solution?
It would be very helpful to get some help. I tried many different things and still, there is this AJAX Error and the 'missing table' as you describe in the drupal error list.

Thanks and regards