Hi All,

I'm having an issue migrating Multiselect content from D6 to D7. Using the D7 CCK Migrate Fields module, I've managed to move some fields, but none of 4 that use the 'multiselect_select' widget.

CCK Migrate Fields reports: Missing widget: The 'multiselect_select' widget is not available for the field_services_provided field, it will be set to the default widget.

After trying to migrate in spite of this message returns the following (x4):

Error creating field field_services_provided
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL DEFAULT NULL, `field_services_provided_format` VARCHAR(255) NULL DEFAULT' at line 9' in /home/cowtown/subdomains/mxc/includes/database/database.inc:2168 Stack trace: #0 /home/cowtown/subdomains/mxc/includes/database/database.inc(2168): PDOStatement->execute(Array) #1 /home/cowtown/subdomains/mxc/includes/database/database.inc(680): DatabaseStatementBase->execute(Array, Array) #2 /home/cowtown/subdomains/mxc/includes/database/schema.inc(661): DatabaseConnection->query('CREATE TABLE {f...') #3 /home/cowtown/subdomains/mxc/includes/database/database.inc(2717): DatabaseSchema->createTable('field_data_fiel...', Array) #4 /home/cowtown/subdomains/mxc/modules/field/modules/field_sql_storage/field_sql_storage.module(216): db_create_table('field_data_fiel...', Array) #5 [internal function]: field_sql_storage_field_storage_create_field(Array) #6 /home/cowtown/subdomains/mxc/includes/module.inc(866): call_user_func_array('field_sql_stora...', Array) #7 /home/cowtown/subdomains/mxc/modules/field/field.crud.inc(180): module_invoke('field_sql_stora...', 'field_storage_c...', Array) #8 /home/cowtown/subdomains/mxc/sites/all/modules/cck/modules/content_migrate/includes/content_migrate.admin.inc(246): field_create_field(Array) #9 [internal function]: _content_migrate_batch_process_create_fields('field_services_...', Array) #10 /home/cowtown/subdomains/mxc/includes/batch.inc(284): call_user_func_array('_content_migrat...', Array) #11 /home/cowtown/subdomains/mxc/includes/batch.inc(161): _batch_process() #12 /home/cowtown/subdomains/mxc/includes/batch.inc(80): _batch_do() #13 /home/cowtown/subdomains/mxc/modules/system/system.admin.inc(2365): _batch_page() #14 [internal function]: system_batch_page() #15 /home/cowtown/subdomains/mxc/includes/menu.inc(517): call_user_func_array('system_batch_pa...', Array) #16 /home/cowtown/subdomains/mxc/index.php(21): menu_execute_active_handler() #17 {main}

I've walked through the CCK migration guide, which references an PDOException errors, but only in reference to 'autocomplete_widget' widgets.

Any thoughts on this? Any help would be appreciated.

- Todd

Comments

usefu’s picture

Issue summary: View changes