Friday, 9 May 2014

Drupal Migrate Module error on activating Migrate UI

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '*.migrate_group' doesn't exist: SELECT AS name, mg.title AS title, mg.arguments AS arguments FROM {migrate_group} mg; Array ( ) in migrate_ui_migrate_dashboard() (line 29of *sites/all/modules/contrib/migrate/migrate_ui/

the fix here was to add the following table to mysql 

CREATE TABLE IF NOT EXISTS `migrate_group` (
  `name` varchar(255) NOT NULL COMMENT 'Unique machine name for a migration group',
  `title` varchar(255) NOT NULL COMMENT 'Display name for a migration group',
  `arguments` blob NOT NULL COMMENT 'A serialized array of arguments to the migration group',
  PRIMARY KEY (`name`)

No comments: