D7 Migration failing on d6_filter_format

Created on 11 April 2017, over 7 years ago
Updated 8 February 2024, 11 months ago

Hi, I'm trying to run a D7 to D8 migration following the instructions here to create a custom module (using Drupal 8.3.0 core): http://cgit.drupalcode.org/migrate_upgrade/tree/README.txt

I have not altered any migrations yet. When I run the migrations it files on d6_filter_format, and I seem to have other tables missing, for example imagecache, which I had not installed in D7.

Here is the output of drush migrate-status:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.imagecache_preset' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{imagecache_preset} icp) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.filter_formats' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{filter_formats} f) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.boxes' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{boxes} b) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.files' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{files} f) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.comments' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{comments} c
INNER JOIN {node} n ON c.nid = n.nid) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.content_node_field' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT DISTINCT cnf.field_name AS field_name, cnf.type AS type, cnf.global_settings AS global_settings, cnf.required AS required, cnf.multiple AS multiple, cnf.db_storage AS db_storage, cnf.module AS module, cnf.db_columns AS db_columns, cnf.active AS active, cnf.locked AS locked, 1 AS expression
FROM 
{content_node_field} cnf
INNER JOIN {content_node_field_instance} cnfi ON cnfi.field_name = cnf.field_name) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.content_node_field_instance' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{content_node_field_instance} cnfi
INNER JOIN {content_node_field} cnf ON cnf.field_name = cnfi.field_name) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.content_node_field_instance' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{content_node_field_instance} cnfi
INNER JOIN {content_node_field} cnf ON cnfi.field_name = cnf.field_name) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.content_node_field_instance' doesn't exist: SELECT cnfi.display_settings AS display_settings
FROM 
{content_node_field_instance} cnfi; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.content_node_field_instance' doesn't exist: SELECT cnfi.field_name AS field_name, cnfi.type_name AS type_name, cnfi.weight AS weight, cnfi.label AS label, cnfi.display_settings AS display_settings, cnfi.widget_settings AS widget_settings, cnf.type AS type, cnf.module AS module
FROM 
{content_node_field_instance} cnfi
INNER JOIN {content_node_field} cnf ON cnfi.field_name = cnf.field_name
ORDER BY cnfi.weight ASC; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.upload' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT DISTINCT u.nid AS nid, u.vid AS vid, n.type AS type, 1 AS expression
FROM 
{upload} u
INNER JOIN {node} n ON n.nid = u.nid AND n.vid = u.vid) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.vocabulary' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{vocabulary} v) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.vocabulary' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{vocabulary} v) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.vocabulary' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{vocabulary} v
INNER JOIN {vocabulary_node_types} nt ON v.vid = nt.vid) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.vocabulary' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{vocabulary} v
INNER JOIN {vocabulary_node_types} nt ON v.vid = nt.vid) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.vocabulary' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{vocabulary} v
INNER JOIN {vocabulary_node_types} nt ON v.vid = nt.vid) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.term_data' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT DISTINCT td.*, 1 AS expression
FROM 
{term_data} td) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.profile_field' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{profile_field} pf) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.profile_field' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{profile_field} pf) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.profile_field' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{profile_field} pf) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.profile_field' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT 1 AS expression
FROM 
{profile_field} pf) subquery; Array
(
)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cherished.profile_values' doesn't exist: SELECT COUNT(*) AS expression
FROM 
(SELECT DISTINCT pv.uid AS uid, 1 AS expression
FROM 
{profile_values} pv) subquery; Array
(
)

 Group: default                          Status  Total  Imported  Unprocessed  Last imported       
 contact_category                        Idle    2      2         0            2017-04-11 19:02:17 
 d6_date_formats                         Idle    3      3         0            2017-04-11 19:02:17 
 d6_dblog_settings                       Idle    0      1         -1           2017-04-11 19:02:17 
 d6_imagecache_presets                   Idle    N/A    0         N/A                              
 d6_menu                                 Idle    4      4         0            2017-04-11 19:02:17 
 d6_node_settings                        Idle    1      1         0            2017-04-11 19:02:17 
 d6_search_settings                      Idle    0      1         -1           2017-04-11 19:02:17 
 d6_system_cron                          Idle    1      1         0            2017-04-11 19:02:17 
 d6_system_date                          Idle    1      1         0            2017-04-11 19:02:17 
 d6_system_file                          Idle    0      0         -1           2017-04-11 19:02:17 
 d6_system_performance                   Idle    1      1         0            2017-04-11 19:02:17 
 d6_url_alias                            Idle    105    0         0            2017-04-11 19:02:17 
 d6_user_mail                            Idle    1      1         0            2017-04-11 19:02:17 
 d6_user_settings                        Idle    1      1         0            2017-04-11 19:02:17 
 d7_dblog_settings                       Idle    0      1         -1           2017-04-11 19:02:17 
 d7_filter_format                        Idle    4      4         0            2017-04-11 19:02:17 
 d7_filter_settings                      Idle    1      1         0            2017-04-11 19:02:17 
 d7_global_theme_settings                Idle    1      1         0            2017-04-11 19:02:17 
 d7_image_settings                       Idle    0      1         -1           2017-04-11 19:02:17 
 d7_image_styles                         Idle    0      0         0            2017-04-11 19:02:17 
 d7_node_settings                        Idle    1      1         0            2017-04-11 19:02:17 
 d7_search_settings                      Idle    0      0         -1           2017-04-11 19:02:17 
 d7_system_authorize                     Idle    0      1         -1           2017-04-11 19:02:17 
 d7_system_cron                          Idle    0      1         -1           2017-04-11 19:02:17 
 d7_system_date                          Idle    1      1         0            2017-04-11 19:02:17 
 d7_system_file                          Idle    1      0         0            2017-04-11 19:02:17 
 d7_system_mail                          Idle    0      0         -1           2017-04-11 19:02:17 
 d7_system_performance                   Idle    1      1         0            2017-04-11 19:02:17 
 d7_url_alias                            Idle    105    105       0            2017-04-11 19:02:17 
 d7_user_flood                           Idle    0      1         -1           2017-04-11 19:02:17 
 d7_user_mail                            Idle    1      1         0            2017-04-11 19:02:17 
 file_settings                           Idle    0      1         -1           2017-04-11 19:02:17 
 menu_settings                           Idle    0      1         -1           2017-04-11 19:02:18 
 search_page                             Idle    0      1         -1           2017-04-11 19:02:18 
 system_image                            Idle    0      1         -1           2017-04-11 19:02:18 
 system_image_gd                         Idle    0      1         -1           2017-04-11 19:02:18 
 system_logging                          Idle    1      1         0            2017-04-11 19:02:18 
 system_maintenance                      Idle    0      1         -1           2017-04-11 19:02:18 
 system_rss                              Idle    0      1         -1           2017-04-11 19:02:18 
 system_site                             Idle    1      1         0            2017-04-11 19:02:18 
 taxonomy_settings                       Idle    0      1         -1           2017-04-11 19:02:18 
 text_settings                           Idle    0      1         -1           2017-04-11 19:02:18 
 update_settings                         Idle    0      1         -1           2017-04-11 19:02:18 
 block_content_type                      Idle    1      1         0            2017-04-11 19:02:18 
 d6_menu_links                           Idle    34     30        0            2017-04-11 19:02:18 
 d7_contact_settings                     Idle    1      1         0            2017-04-11 19:02:18 
 block_content_body_field                Idle    1      1         0            2017-04-11 19:02:18 
 d6_contact_settings                     Idle    1      1         0            2017-04-11 19:02:18 
 d7_custom_block                         Idle    5      5         0            2017-04-11 19:02:18 
 d7_user_role                            Idle    4      4         0            2017-04-11 19:02:18 
 d7_block                                Idle    449    103       0            2017-04-11 19:02:18 
 d6_filter_format                        Idle    N/A    0         N/A                              
 d6_custom_block                         Idle    N/A    0         N/A                              
 d6_user_role                            Idle    4      0         4                                
 d6_block                                Idle    449    0         449                              
 d7_node_type                            Idle    4      4         0                                
 d7_comment_type                         Idle    4      0         4                                
 d7_comment_field                        Idle    4      0         4                                
 d6_comment_type                         Idle    1      0         1                                
 d6_comment_field                        Idle    1      0         1                                
 d6_node_type                            Idle    4      0         4                                
 d6_comment_field_instance               Idle    3      0         3                                
 d6_comment_entity_display               Idle    3      0         3                                
 d7_comment_field_instance               Idle    4      0         4                                
 d6_comment_entity_form_display_subject  Idle    1      0         1                                
 d7_comment_entity_display               Idle    4      0         4                                
 d7_field                                Idle    23     19        0                                
 d7_taxonomy_vocabulary                  Idle    2      2         0                                
 d7_field_instance                       Idle    37     33        0                                
 d7_file                                 Idle    515    0         0                                
 user_picture_field                      Idle    1      1         0                                
 user_picture_field_instance             Idle    1      1         0                                
 user_picture_entity_display             Idle    1      1         0                                
 user_picture_entity_form_display        Idle    1      1         0                                
 d7_user                                 Idle    3      3         0                                
 d7_node:article                         Idle    1      1         0                                
 d7_node:media_gallery                   Idle    1      1         0                                
 d7_node:page                            Idle    43     43        0                                
 d7_node:poll                            Idle    0      0         0                                
 d7_comment                              Idle    0      0         0                                
 d7_comment_entity_form_display_subject  Idle    4      0         4                                
 d6_comment_entity_form_display          Idle    3      0         3                                
 d6_file                                 Idle    N/A    0         N/A                              
 d6_user_picture_file                    Idle    0      0         0                                
 d6_user                                 Idle    3      0         3                                
 d6_comment                              Idle    N/A    0         N/A                              
 d7_comment_entity_form_display          Idle    4      0         4                                
 d6_field                                Idle    N/A    0         N/A                              
 d6_field_instance                       Idle    N/A    0         N/A                              
 d6_field_instance_widget_settings       Idle    N/A    0         N/A                              
 d7_field_instance_widget_settings       Idle    37     33        0                                
 d7_view_modes                           Idle    11     11        0                                
 d6_view_modes                           Idle    N/A    0         N/A                              
 d6_field_formatter_settings             Idle    N/A    0         N/A                              
 d7_field_formatter_settings             Idle    115    51        0                                
 d6_upload_field                         Idle    1      1         0                                
 d6_upload_field_instance                Idle    4      0         4                                
 d6_upload_entity_form_display           Idle    4      0         4                                
 d6_upload                               Idle    N/A    0         N/A                              
 d6_upload_entity_display                Idle    4      0         4                                
 d6_node_setting_status                  Idle    4      0         4                                
 d6_node_setting_sticky                  Idle    4      0         4                                
 d7_node_title_label                     Idle    4      4         0                                
 d7_node_revision:article                Idle    0      0         0                                
 d7_node_revision:media_gallery          Idle    0      0         0                                
 d7_node_revision:page                   Idle    0      0         0                                
 d7_node_revision:poll                   Idle    0      0         0                                
 d6_node_setting_promote                 Idle    4      0         4                                
 d7_shortcut_set                         Idle    1      1         0                                
 d7_shortcut_set_users                   Idle    0      0         0                                
 d7_menu                                 Idle    4      4         0                                
 d7_menu_links                           Idle    34     30        0                                
 d7_shortcut                             Idle    4      4         0                                
 d6_taxonomy_vocabulary                  Idle    N/A    0         N/A                              
 d6_vocabulary_field                     Idle    N/A    0         N/A                              
 d6_vocabulary_field_instance            Idle    N/A    0         N/A                              
 d6_vocabulary_entity_form_display       Idle    N/A    0         N/A                              
 d7_taxonomy_term:gallery_collections    Idle    1      1         0                                
 d7_taxonomy_term:tags                   Idle    54     54        0                                
 d6_vocabulary_entity_display            Idle    N/A    0         N/A                              
 d6_taxonomy_term                        Idle    N/A    0         N/A                              
 user_profile_field                      Idle    N/A    0         N/A                              
 user_profile_field_instance             Idle    N/A    0         N/A                              
 user_profile_entity_display             Idle    N/A    0         N/A                              
 user_profile_entity_form_display        Idle    N/A    0         N/A                              
 d6_profile_values                       Idle    N/A    0         N/A                              
 d6_user_contact_settings                Idle    3      0         3

And the output of drush migrate-import --all

Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'contact_category'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_date_formats'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_dblog_settings'
Migration d6_imagecache_presets did not meet the requirements. The module imagecache is  [error]
not enabled in the source site. source_provider: imagecache.
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_imagecache_presets'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd6_menu'      [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_node_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_search_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_system_cron'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_system_date'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_system_file'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_system_performance'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd6_url_alias' [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd6_user_mail' [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_user_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_dblog_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_filter_format'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_filter_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_global_theme_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_image_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_image_styles'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_node_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_search_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_system_authorize'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_system_cron'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_system_date'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_system_file'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_system_mail'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_system_performance'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd7_url_alias' [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd7_user_flood'[status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd7_user_mail' [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'file_settings'[status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'menu_settings'[status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'search_page'  [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'system_image' [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'system_image_gd'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'system_logging'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'system_maintenance'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'system_rss'   [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'system_site'  [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'taxonomy_settings'

Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'text_settings'[status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'update_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'block_content_type'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd6_menu_links'[status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_contact_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'block_content_body_field'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd6_contact_settings'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with                [status]
'd7_custom_block'
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd7_user_role' [status]
Processed 0 items (0 created, 0 updated, 0 failed, 0 ignored) - done with 'd7_block'     [status]
Migration failed with source plugin exception: SQLSTATE[42S02]: Base table or view not   [error]
found: 1146 Table 'cherished.filter_formats' doesn't exist: SELECT f.*,
map.sourceid1 AS migrate_map_sourceid1, map.source_row_status AS
migrate_map_source_row_status
FROM 
{filter_formats} f
LEFT OUTER JOIN drupal.cherished_migrate_map_d6_filter_format map ON format =
map.sourceid1
WHERE (map.sourceid1 IS NULL) OR (map.source_row_status = :db_condition_placeholder_0);
Array
(
    [:db_condition_placeholder_0] => 1
)

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table                  [error]
'cherished.filter_formats' doesn't exist in
/html/core/lib/Drupal/Core/Database/Statement.php:59
Stack trace:
#0 /html/core/lib/Drupal/Core/Database/Statement.php(59):
PDOStatement->execute(Array)
#1 /html/core/lib/Drupal/Core/Database/Connection.php(624):
Drupal\Core\Database\Statement->execute(Array, Array)
#2 /html/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87):
Drupal\Core\Database\Connection->query('SELECT COUNT(*)...', Array, Array)
#3 /html/core/lib/Drupal/Core/Database/Query/Select.php(508):
Drupal\Core\Database\Driver\mysql\Connection->query('SELECT COUNT(*)...', Array, Array)
#4 /html/core/modules/migrate/src/Plugin/migrate/source/SqlBase.php(321):
Drupal\Core\Database\Query\Select->execute()
#5 /html/core/modules/migrate/src/Plugin/Migration.php(515):
Drupal\migrate\Plugin\migrate\source\SqlBase->count()
#6 /html/core/modules/migrate/src/Plugin/Migration.php(443):
Drupal\migrate\Plugin\Migration->allRowsProcessed()
#7 /html/core/modules/migrate/src/MigrateExecutable.php(164):
Drupal\migrate\Plugin\Migration->checkRequirements()
#8 /vendor/drush/drush/includes/drush.inc(720):
Drupal\migrate\MigrateExecutable->import()
#9 /vendor/drush/drush/includes/drush.inc(711):
drush_call_user_func_array(Array, Array)
#10 /html/modules/migrate_tools/migrate_tools.drush.inc(280):
drush_op(Array)
#11 [internal function]:
_drush_migrate_tools_execute_migration(Object(Drupal\migrate\Plugin\Migration),
'd6_custom_block', Array)
#12 /html/modules/migrate_tools/migrate_tools.drush.inc(246):
array_walk(Array, '_drush_migrate_...', Array)
#13 /vendor/drush/drush/includes/command.inc(422):
drush_migrate_tools_migrate_import()
#14 /vendor/drush/drush/includes/command.inc(231):
_drush_invoke_hooks(Array, Array)
#15 /vendor/drush/drush/includes/command.inc(199): drush_command()
#16 /vendor/drush/drush/lib/Drush/Boot/BaseBoot.php(67):
drush_dispatch(Array)
#17 /vendor/drush/drush/includes/preflight.inc(66):
Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#18 /vendor/drush/drush/drush.php(12): drush_main()
#19 {main}

Next Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view
not found: 1146 Table 'cherished.filter_formats' doesn't exist: SELECT COUNT(*) AS
expression
FROM 
(SELECT 1 AS expression
FROM 
{filter_formats} f) subquery; Array
(
)
 in /html/core/lib/Drupal/Core/Database/Connection.php:685
Stack trace:
#0 /html/core/lib/Drupal/Core/Database/Connection.php(649):
Drupal\Core\Database\Connection->handleQueryException(Object(PDOException), 'SELECT
COUNT(*)...', Array, Array)
#1 /html/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87):
Drupal\Core\Database\Connection->query('SELECT COUNT(*)...', Array, Array)
#2 /html/core/lib/Drupal/Core/Database/Query/Select.php(508):
Drupal\Core\Database\Driver\mysql\Connection->query('SELECT COUNT(*)...', Array, Array)
#3 /html/core/modules/migrate/src/Plugin/migrate/source/SqlBase.php(321):
Drupal\Core\Database\Query\Select->execute()
#4 /html/core/modules/migrate/src/Plugin/Migration.php(515):
Drupal\migrate\Plugin\migrate\source\SqlBase->count()
#5 /html/core/modules/migrate/src/Plugin/Migration.php(443):
Drupal\migrate\Plugin\Migration->allRowsProcessed()
#6 /html/core/modules/migrate/src/MigrateExecutable.php(164):
Drupal\migrate\Plugin\Migration->checkRequirements()
#7 /vendor/drush/drush/includes/drush.inc(720):
Drupal\migrate\MigrateExecutable->import()
#8 /vendor/drush/drush/includes/drush.inc(711):
drush_call_user_func_array(Array, Array)
#9 /html/modules/migrate_tools/migrate_tools.drush.inc(280):
drush_op(Array)
#10 [internal function]:
_drush_migrate_tools_execute_migration(Object(Drupal\migrate\Plugin\Migration),
'd6_custom_block', Array)
#11 /html/modules/migrate_tools/migrate_tools.drush.inc(246):
array_walk(Array, '_drush_migrate_...', Array)
#12 /vendor/drush/drush/includes/command.inc(422):
drush_migrate_tools_migrate_import()
#13 /vendor/drush/drush/includes/command.inc(231):
_drush_invoke_hooks(Array, Array)
#14 /vendor/drush/drush/includes/command.inc(199): drush_command()
#15 /vendor/drush/drush/lib/Drush/Boot/BaseBoot.php(67):
drush_dispatch(Array)
#16 /vendor/drush/drush/includes/preflight.inc(66):
Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#17 /vendor/drush/drush/drush.php(12): drush_main()
#18 {main}

I couldn't find a previous issue on this - hopeully this is not a duplicate. Do I need to install additional modules in D7?

πŸ› Bug report
Status

Needs review

Version

6.0

Component

Code

Created by

πŸ‡¬πŸ‡§United Kingdom matt b

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024