I am trying to import a webform content type.
When I enable the option "Create a new revision of the existing node" I am unable to import my webform node due to duplicate error. However when I set it to "Create a new node" it works fine but I have to do a lot of customizations in my templates due to my setup.

I export like this: drush ne-export 123 --file=myfile.export
I am using node_export-7.x-3.1 as well as node_export_webforms-7.x-1.0-rc4

The error I get:

WD node: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1261' for key 'PRIMARY': INSERT INTO {webform} (nid, next_serial,       [error]
confirmation, confirmation_format, redirect_url, status, block, allow_draft, auto_save, submit_notice, submit_text, submit_limit, submit_interval, total_submit_limit,
total_submit_interval, progressbar_bar, progressbar_page_number, progressbar_percent, progressbar_pagebreak_labels, progressbar_include_confirmation,
progressbar_label_first, progressbar_label_confirmation, preview, preview_next_button_label, preview_prev_button_label, preview_title, preview_message,
preview_message_format, preview_excluded_components) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3,
:db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9,
:db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15,
:db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21,
:db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27,
:db_insert_placeholder_28); Array
(
    [:db_insert_placeholder_0] => 1261
    [:db_insert_placeholder_1] => 1
    [:db_insert_placeholder_2] =>
    [:db_insert_placeholder_3] =>
    [:db_insert_placeholder_4] =>
    [:db_insert_placeholder_5] => 1
    [:db_insert_placeholder_6] => 0
    [:db_insert_placeholder_7] => 0
    [:db_insert_placeholder_8] => 0
    [:db_insert_placeholder_9] => 1
    [:db_insert_placeholder_10] =>
    [:db_insert_placeholder_11] => -1
    [:db_insert_placeholder_12] => -1
    [:db_insert_placeholder_13] => -1
    [:db_insert_placeholder_14] => -1
    [:db_insert_placeholder_15] => 1
    [:db_insert_placeholder_16] => 0
    [:db_insert_placeholder_17] => 0
    [:db_insert_placeholder_18] => 1
    [:db_insert_placeholder_19] => 1
    [:db_insert_placeholder_20] => Start
    [:db_insert_placeholder_21] => Complete
    [:db_insert_placeholder_22] => 0
    [:db_insert_placeholder_23] =>
    [:db_insert_placeholder_24] =>
    [:db_insert_placeholder_25] =>
    [:db_insert_placeholder_26] =>
    [:db_insert_placeholder_27] =>
    [:db_insert_placeholder_28] =>
)
 in drupal_write_record() (line 7202 of /var/www/html/otn_support/includes/common.inc).
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1261' for key 'PRIMARY'' in                             [error]
/var/www/html/otn_support/includes/database/database.inc:2171
Stack trace:
#0 /var/www/html/otn_support/includes/database/database.inc(2171): PDOStatement->execute(Array)
#1 /var/www/html/otn_support/includes/database/database.inc(683): DatabaseStatementBase->execute(Array, Array)
#2 /var/www/html/otn_support/includes/database/mysql/query.inc(36): DatabaseConnection->query('INSERT INTO {we...', Array, Array)
#3 /var/www/html/otn_support/includes/common.inc(7202): InsertQuery_mysql->execute()
#4 /var/www/html/otn_support/sites/all/modules/webform/webform.module(1345): drupal_write_record('webform', Array)
#5 /var/www/html/otn_support/sites/all/modules/webform/webform.module(1398): webform_node_insert(Object(stdClass))
#6 [internal function]: webform_node_update(Object(stdClass))
#7 /var/www/html/otn_support/includes/module.inc(895): call_user_func_array('webform_node_up...', Array)
#8 /var/www/html/otn_support/sites/all/modules/node_export/node_export.module(748): module_invoke_all('node_update', Object(stdClass))
#9 /var/www/html/otn_support/sites/all/modules/node_export/node_export.module(599): node_export_save(Object(stdClass))
#10 /var/www/html/otn_support/sites/all/modules/node_export/node_export.drush.inc(286): node_export_import('[{"vid":"1137",...', 'dt')
#11 [internal function]: drush_node_export_callback_import()
#12 phar:///usr/local/bin/drush/includes/command.inc(366): call_user_func_array('drush_node_expo...', Array)
#13 phar:///usr/local/bin/drush/includes/command.inc(217): _drush_invoke_hooks(Array, Array)
#14 [internal function]: drush_command()
#15 phar:///usr/local/bin/drush/includes/command.inc(185): call_user_func_array('drush_command', Array)
#16 phar:///usr/local/bin/drush/lib/Drush/Boot/BaseBoot.php(67): drush_dispatch(Array)
#17 phar:///usr/local/bin/drush/includes/preflight.inc(66): Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#18 phar:///usr/local/bin/drush/includes/startup.inc(321): drush_main()
#19 phar:///usr/local/bin/drush/drush(114): drush_startup(Array)
#20 /usr/local/bin/drush(10): require('phar:///usr/loc...')
#21 {main}

Comments

dtolj created an issue. See original summary.

dtolj’s picture

Title: Unable to create new revision » Unable to import webform as new revision
Issue summary: View changes
Issue tags: +webform
inversed’s picture

Confirmed that I'm seeing the same error. Importing to a new webform node has no problems.

danielb’s picture

Funny I created this module specifically for webforms because they're annoying to set up. Unfortunately it seems in Drupal 7 their architecture is very different and no longer compatible.

DamienMcKenna’s picture

Status: Active » Postponed (maintainer needs more info)

Please test with Webform 4, it stores data in a different structure that might work better.