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 mg.name 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/migrate_ui.pages.inc).



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`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



No comments: