Hi,

I get this message for all tables about content types when I run drush ms command:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'proXX_XXDrupal6.node_revision' doesn't exist: SELECT COUNT(*) AS expression
FROM
(SELECT 1 AS expression
FROM
{node_revision} nr
INNER JOIN {node} n ON n.nid = nr.nid AND n.vid <> nr.vid
WHERE ((n.tnid = 0 OR n.tnid = n.nid)) AND (n.type = :db_condition_placeholder_0)) subquery; Array
(
    [:db_condition_placeholder_0] => page
)

In my db, I have a node_revisions table but not node_revision,
does it be a problem when performing migrations ?
could it be related with my link generator issue ?
how can I fix this issue ?

thanks

Comments

aiphes created an issue. See original summary.

quietone’s picture

quietone commented
Status: Active » Postponed (maintainer needs more info)

First some clarification, the node_revision table is in Drupal 7 and node_revisions is Drupal 6. When the `drush ms` command is run it tries to get a count of rows for all migrations discovered, and when migrate_drupal is enabled it will do that for Drupal 6 and Drupal 7 migrations. The result is errors for the migrations that are from the other Drupal version, the one that is not your database source.

Judging by the error and the prefix being used, "proXX_XXDrupal6", your source database if a Drupal 6 database. In that case, these errors are annoying but expected.

To answer your questions; They are not a problem when performing migrations. They are not related to the link generator issue. And to fix them you can use the tag option, `--tag=Drupal 6` and/or, if you are using migrate_plus the group option, `--group="some group name`.

Does that answer your questions?

aiphes’s picture

aiphes
Primary language French
commented

great explantation. I understand better the migrate process. Thanks

quietone’s picture

quietone commented
Status: Postponed (maintainer needs more info) » Fixed

@aiphes, Your welcome.

Seems that the questions have been answered satisfactorily, so closing this.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.