Community

[SOLVED] Problem upgrading from D6 to D7 with url_alias table columns.

Hello all, I'm trying to upgrade a site from D6 (6.27) to D7 using drush site-upgrade. It all goes fine until step 13 where update.php is run on the new D7 database. I get the following error ...

13. Run update.php by visiting http://www.example.com/update.php (replace www.example.com with your domain
    name). This will update the core database tables.
   
    If you are unable to access update.php do the following:
   
    - Open settings.php with a text editor.
   
    - Find the line that says: $update_free_access = FALSE;
   
    - Change it into: $update_free_access = TRUE;
   
    - Once the upgrade is done, $update_free_access must be reverted to FALSE.

Note that Drush will copy your database and run updatedb on the copy. The source database remains
unchanged.

Drush will automatically do this step now.
WD php: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'source' in 'field      [error]
list': SELECT source FROM {url_alias} WHERE alias = :alias AND language IN (:language,
:language_none) ORDER BY language ASC, pid DESC; Array
(
    [:alias] => node
    [:language] => en
    [:language_none] => und
)
in drupal_lookup_path() (line 176 of /var/www/drupal7/includes/path.inc).
Drush command terminated abnormally due to an unrecoverable error.                                   [error]
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'source' in 'field list': SELECT source FROM {url_alias} WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC; Array
(
    [:alias] => node
    [:language] => en
    [:language_none] => und
)
in drupal_lookup_path() (line 176 of /var/www/drupal7/includes/path.inc).
updatedb failed for core

I've tried uninstalling, and removing all contrib modules, but the error persists.

Any pointers in the right direction here would be appreciated.

Thanks.

Comments

Turns out that using the

Turns out that using the "Schema" module, and removing all the tables marked as extra solved the problem.

nobody click here