Revision value is set to array when mapping imported entities [#1951904]

Updated: Comment #7

Problem/Motivation

The revision value of imported entities is set to an array by MigrateDestinationEntityAPI::import(). This causes mapping of created entities to source records to fail with non-MySQL databases. The problem appears to have been caused by someone forgetting to remove the array() function when pasting the code from a previous line.

Proposed resolution

Remove the array() function from the revision value.

Original report by @OriPekelman

Fresh install with SQLite on PHP 5.3.15

On http://localhost/commerce_kickstart-7.x-2.5/#overlay=fr/admin/reports/st... I get two notices:

Notice: Undefined index: name in system_requirements() (line 39 of /Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/modules/system/system.install).
Notice: Undefined index: version in system_requirements() (line 41 of /Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/modules/system/system.install).

In the status report I have:

Install profile (commerce_kickstart-)

The content of
$profile = drupal_get_profile();
is at this point a string and not an array as I believe expected
string(18) "commerce_kickstart"

During the installation process I had a bunch of "out of memory errors". Will repeat installation process with php.ini set to gazillion bytes.

Comment	File	Size	Author
#5	migrate_extras-fix-destid2-array-1951904-4.patch	533 bytes	jsacksick
#4	migrate_extras.info	533 bytes	jsacksick
#1	Screen Shot 2013-03-25 at 10.20.23.png	39.49 KB	OriPekelman
#1	Screen Shot 2013-03-25 at 10.29.44.png	83.11 KB	OriPekelman
	Screen Shot 2013-03-25 at 10.17.19.png	45.55 KB	OriPekelman

Comments

Comment #1

OriPekelman commented 25 March 2013 at 09:34

Status	File	Size
new	Screen Shot 2013-03-25 at 10.29.44.png	83.11 KB
new	Screen Shot 2013-03-25 at 10.20.23.png	39.49 KB

with fresh install and memory limit set to 1gb I get the following error during installation:
"There is already a table named message type"

No other errors during first phase of installation.

Chose "France" Localize, "VAT" "EUR" in the options phase + install Demo. After Demo "import content" phase got :
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://localhost/commerce_kickstart-7.x-2.5/install.php?profile=commerce_kickstart&welcome=done&locale=en&id=3&op=do StatusText: OK ResponseText: Home | LouLouRangeTaChambre @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/system/system.menus.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/system/system.messages.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/system/system.theme.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/system/system.base.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/misc/ui/jquery.ui.core.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/themes/shiny/css/jquery.ui.theme.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/overlay/overlay-parent.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/comment/comment.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/commerce_add_to_cart_confirmation/css/commerce_add_to_cart_confirmation.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/commerce_kickstart/commerce_kickstart_menus/commerce_kickstart_menus.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/date/date_api/date.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/date/date_popup/themes/datepicker.1.7.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/field/theme/field.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/node/node.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/user/user.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/views/css/views.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/system/system.admin.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/modules/system/system.maintenance.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/libraries/chosen/chosen/chosen.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/ctools/css/ctools.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/themes/shiny/css/reset.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/themes/shiny/css/style.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/themes/shiny/css/contrib.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/themes/shiny/css/shiny.css?mk7m5u"); @import url("http://localhost/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/themes/commerce_kickstart_admin/css/commerce_kickstart_admin.css?mk7m5u"); Home Installation tasksWelcome(done)Verify requirements(done)Set up database(done)Install profile(done)Configure site(done)Configure store(done)Install demo store(done)Import content(active)Finished Processed 10 (10 created, 0 updated, 0 failed, 0 ignored) in 16.2 sec (37/min) - done with 'CommerceKickstartPages' Processed 6 (6 created, 0 updated, 6 failed, 0 ignored) in 1.6 sec (225/min) - done with 'CommerceKickstartBagsCases' Processed 4 (4 created, 0 updated, 4 failed, 0 ignored) in 1.5 sec (162/min) - done with 'CommerceKickstartDrinks' Processed 2 (2 created, 0 updated, 2 failed, 0 ignored) in 1.4 sec (86/min) - done with 'CommerceKickstartHats' Processed 54 (54 created, 0 updated, 54 failed, 0 ignored) in 3.8 sec (862/min) - done with 'CommerceKickstartTops' Processed 15 (15 created, 0 updated, 15 failed, 0 ignored) in 2.1 sec (439/min) - done with 'CommerceKickstartShoes' Processed 3 (3 created, 0 updated, 3 failed, 0 ignored) in 1.4 sec (127/min) - done with 'CommerceKickstartStorage' Processed 4 (4 created, 0 updated, 0 failed, 0 ignored) in 1.5 sec (156/min) - done with 'CommerceKickstartCollection' Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 1.5 sec (81/min) - done with 'CommerceKickstartBlogPost' Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 1.4 sec (84/min) - done with 'CommerceKickstartAdPush' Processed 3 (3 created, 0 updated, 0 failed, 0 ignored) in 1.4 sec (125/min) - done with 'CommerceKickstartSlideshow' Processed 4 (4 created, 0 updated, 0 failed, 0 ignored) in 14 sec (17/min) - done with 'commercekickstartnodebags_cases' Processed 3 (3 created, 0 updated, 0 failed, 0 ignored) in 7.1 sec (25/min) - done with 'commercekickstartnodedrinks' Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 5.6 sec (21/min) - done with 'commercekickstartnodehats' Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 5.7 sec (21/min) - done with 'commercekickstartnodeshoes' Processed 1 (1 created, 0 updated, 0 failed, 0 ignored) in 2.9 sec (21/min) - done with 'commercekickstartnodestorage_devices' Processed 8 (8 created, 0 updated, 0 failed, 0 ignored) in 17.2 sec (28/min) - done with 'commercekickstartnodetops' Error message SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartbagscases} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TOT1-GRN-OS [1] => 0 [2] => 0 [3] => 1 [4_0] => 1 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartbagscases} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => MES1-BLU-OS [1] => 0 [2] => 0 [3] => 2 [4_0] => 2 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartbagscases} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => LAP1-BLK-13 [1] => 0 [2] => 0 [3] => 3 [4_0] => 3 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartbagscases} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => LAP1-BLK-15 [1] => 0 [2] => 0 [3] => 4 [4_0] => 4 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartbagscases} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => LAP1-BLK-17 [1] => 0 [2] => 0 [3] => 5 [4_0] => 5 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartbagscases} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => IPH1-BLK-OS [1] => 0 [2] => 0 [3] => 6 [4_0] => 6 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartdrinks} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => MG1-BLU-OS [1] => 0 [2] => 0 [3] => 7 [4_0] => 7 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartdrinks} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => MG2-YLW-OS [1] => 0 [2] => 0 [3] => 8 [4_0] => 8 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartdrinks} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TMG-SIL-OS [1] => 0 [2] => 0 [3] => 9 [4_0] => 9 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartdrinks} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => WTR-BLU-OS [1] => 0 [2] => 0 [3] => 10 [4_0] => 10 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarthats} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => HAT1-GRY-OS [1] => 0 [2] => 0 [3] => 11 [4_0] => 11 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarthats} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => HAT2-BLK-OS [1] => 0 [2] => 0 [3] => 12 [4_0] => 12 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH1-BLK-SM [1] => 0 [2] => 0 [3] => 13 [4_0] => 13 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH1-BLK-MD [1] => 0 [2] => 0 [3] => 14 [4_0] => 14 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH1-BLK-LG [1] => 0 [2] => 0 [3] => 15 [4_0] => 15 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-BLU-SM [1] => 0 [2] => 0 [3] => 16 [4_0] => 16 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-BLU-MD [1] => 0 [2] => 0 [3] => 17 [4_0] => 17 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-BLU-LG [1] => 0 [2] => 0 [3] => 18 [4_0] => 18 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-GRN-SM [1] => 0 [2] => 0 [3] => 19 [4_0] => 19 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-GRN-MD [1] => 0 [2] => 0 [3] => 20 [4_0] => 20 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-GRN-LG [1] => 0 [2] => 0 [3] => 21 [4_0] => 21 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-PRL-SM [1] => 0 [2] => 0 [3] => 22 [4_0] => 22 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-PRL-MD [1] => 0 [2] => 0 [3] => 23 [4_0] => 23 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH2-PRL-LG [1] => 0 [2] => 0 [3] => 24 [4_0] => 24 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-CRM-SM [1] => 0 [2] => 0 [3] => 25 [4_0] => 25 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-CRM-MD [1] => 0 [2] => 0 [3] => 26 [4_0] => 26 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-CRM-LG [1] => 0 [2] => 0 [3] => 27 [4_0] => 27 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-HGY-SM [1] => 0 [2] => 0 [3] => 28 [4_0] => 28 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-HGY-MD [1] => 0 [2] => 0 [3] => 29 [4_0] => 29 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-HGY-LG [1] => 0 [2] => 0 [3] => 30 [4_0] => 30 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-LTB-SM [1] => 0 [2] => 0 [3] => 31 [4_0] => 31 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-LTB-MD [1] => 0 [2] => 0 [3] => 32 [4_0] => 32 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH3-LTB-LG [1] => 0 [2] => 0 [3] => 33 [4_0] => 33 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH4-BLK-SM [1] => 0 [2] => 0 [3] => 34 [4_0] => 34 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH4-BLK-MD [1] => 0 [2] => 0 [3] => 35 [4_0] => 35 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH4-BLK-LG [1] => 0 [2] => 0 [3] => 36 [4_0] => 36 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-GRY-SM [1] => 0 [2] => 0 [3] => 37 [4_0] => 37 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-GRY-MD [1] => 0 [2] => 0 [3] => 38 [4_0] => 38 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-GRY-LG [1] => 0 [2] => 0 [3] => 39 [4_0] => 39 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-ORG-SM [1] => 0 [2] => 0 [3] => 40 [4_0] => 40 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-ORG-MD [1] => 0 [2] => 0 [3] => 41 [4_0] => 41 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-ORG-LG [1] => 0 [2] => 0 [3] => 42 [4_0] => 42 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-YLW-SM [1] => 0 [2] => 0 [3] => 43 [4_0] => 43 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-YLW-MD [1] => 0 [2] => 0 [3] => 44 [4_0] => 44 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH5-YLW-LG [1] => 0 [2] => 0 [3] => 45 [4_0] => 45 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-BLU-SM [1] => 0 [2] => 0 [3] => 46 [4_0] => 46 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-BLU-MD [1] => 0 [2] => 0 [3] => 47 [4_0] => 47 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-BLU-LG [1] => 0 [2] => 0 [3] => 48 [4_0] => 48 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-GRN-SM [1] => 0 [2] => 0 [3] => 49 [4_0] => 49 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-GRN-MD [1] => 0 [2] => 0 [3] => 50 [4_0] => 50 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-GRN-LG [1] => 0 [2] => 0 [3] => 51 [4_0] => 51 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-DPK-SM [1] => 0 [2] => 0 [3] => 52 [4_0] => 52 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-DPK-MD [1] => 0 [2] => 0 [3] => 53 [4_0] => 53 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => TSH6-DPK-LG [1] => 0 [2] => 0 [3] => 54 [4_0] => 54 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT1-PNK-SM [1] => 0 [2] => 0 [3] => 55 [4_0] => 55 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT1-PNK-MD [1] => 0 [2] => 0 [3] => 56 [4_0] => 56 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT1-PNK-LG [1] => 0 [2] => 0 [3] => 57 [4_0] => 57 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT1-GRY-SM [1] => 0 [2] => 0 [3] => 58 [4_0] => 58 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT1-GRY-MD [1] => 0 [2] => 0 [3] => 59 [4_0] => 59 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT1-GRY-LG [1] => 0 [2] => 0 [3] => 60 [4_0] => 60 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT2-BLU-SM [1] => 0 [2] => 0 [3] => 61 [4_0] => 61 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT2-BLU-MD [1] => 0 [2] => 0 [3] => 62 [4_0] => 62 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT2-BLU-LG [1] => 0 [2] => 0 [3] => 63 [4_0] => 63 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT2-GRN-SM [1] => 0 [2] => 0 [3] => 64 [4_0] => 64 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT2-GRN-MD [1] => 0 [2] => 0 [3] => 65 [4_0] => 65 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstarttops} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SWT2-GRN-LG [1] => 0 [2] => 0 [3] => 66 [4_0] => 66 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO1-RED-05 [1] => 0 [2] => 0 [3] => 67 [4_0] => 67 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO1-RED-06 [1] => 0 [2] => 0 [3] => 68 [4_0] => 68 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO1-RED-08 [1] => 0 [2] => 0 [3] => 69 [4_0] => 69 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO1-RED-09 [1] => 0 [2] => 0 [3] => 70 [4_0] => 70 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO1-RED-11 [1] => 0 [2] => 0 [3] => 71 [4_0] => 71 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO1-RED-12 [1] => 0 [2] => 0 [3] => 72 [4_0] => 72 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-04 [1] => 0 [2] => 0 [3] => 73 [4_0] => 73 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-05 [1] => 0 [2] => 0 [3] => 74 [4_0] => 74 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-06 [1] => 0 [2] => 0 [3] => 75 [4_0] => 75 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-07 [1] => 0 [2] => 0 [3] => 76 [4_0] => 76 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-08 [1] => 0 [2] => 0 [3] => 77 [4_0] => 77 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-09 [1] => 0 [2] => 0 [3] => 78 [4_0] => 78 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-10 [1] => 0 [2] => 0 [3] => 79 [4_0] => 79 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-11 [1] => 0 [2] => 0 [3] => 80 [4_0] => 80 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartshoes} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => SHO2-PRL-12 [1] => 0 [2] => 0 [3] => 81 [4_0] => 81 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartstorage} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => USB-BLU-08 [1] => 0 [2] => 0 [3] => 82 [4_0] => 82 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartstorage} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => USB-BLU-16 [1] => 0 [2] => 0 [3] => 83 [4_0] => 83 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) SQLSTATE[HY000]: General error: 25 bind or column index out of range: INSERT INTO {migrate_map_commercekickstartstorage} (sourceid1, needs_update, rollback_action, destid1, destid2) VALUES (?, ?, ?, ?, ?); Array ( [0] => USB-BLU-32 [1] => 0 [2] => 0 [3] => 84 [4_0] => 84 ) (/Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/profiles/commerce_kickstart/modules/contrib/migrate/plugins/sources/sqlmap.inc:337) Unknown data property message_commerce_order. Proudly built byCommerce Guys

After clicking on "go to error page" I get a flash of somewhat unstyled content which disappears (see screen shot) after a couple of seconds.

Now visiting http://localhost/commerce_kickstart-7.x-2.5/admin/reports/status gives the same error

Notice: Undefined index: name in system_requirements() (line 39 of /Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/modules/system/system.install).
Notice: Undefined index: version in system_requirements() (line 41 of /Users/oripekelman/Sites/commerce_kickstart-7.x-2.5/modules/system/system.install).

Yup I know Sqlite?!

Comment #2

damien tournoud commented 15 April 2013 at 22:57

Title:

On Fresh install with SQLite Undefined index: name in system_requirements

» Investigate why we are passing an array to destid2 in the term migrations

This is one of those things that really should not work, but because of a weird combination of issues actually does.

We are likely passing an array to destid2 (somewhere in our migration script, or it is actually a Migrate bug);
This array is expanded to a single value by ->expandArguments during the query preparation, during this process we suffix the name of the argument with the index of the array, that's how we end up with 4_0;
This expansion doesn't actually work for unnamed placeholders, but it doesn't matter because the MySQL implementation of InsertQuery actually renames the arguments to named placeholders

In a nutshell, it seems like it's not SQLite fault at all.

Comment #3

jsacksick commented 17 May 2013 at 15:07

Priority:

Minor

» Normal

For the bug described in #1

There is already a table named message type

there's already an open issue on the message module issue queue with the patch #1941448: Message module fails to install with SQLite (TABLE and INDEX both named "message_type").
Concerning the migrations, some of them worked some none, here's the summary :

    Processed 10 (10 created, 0 updated, 0 failed, 0 ignored) in 27.9 sec (22/min) - done with 'CommerceKickstartPages'
    Processed 6 (6 created, 0 updated, 6 failed, 0 ignored) in 4.6 sec (79/min) - done with 'CommerceKickstartBagsCases'
    Processed 4 (4 created, 0 updated, 4 failed, 0 ignored) in 3.1 sec (77/min) - done with 'CommerceKickstartDrinks'
    Processed 2 (2 created, 0 updated, 2 failed, 0 ignored) in 2.8 sec (43/min) - done with 'CommerceKickstartHats'
    Processed 54 (54 created, 0 updated, 54 failed, 0 ignored) in 12.3 sec (263/min) - done with 'CommerceKickstartTops'
    Processed 15 (15 created, 0 updated, 15 failed, 0 ignored) in 5.6 sec (160/min) - done with 'CommerceKickstartShoes'
    Processed 3 (3 created, 0 updated, 3 failed, 0 ignored) in 2.7 sec (66/min) - done with 'CommerceKickstartStorage'
    Processed 4 (4 created, 0 updated, 0 failed, 0 ignored) in 3.2 sec (76/min) - done with 'CommerceKickstartCollection'
    Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 3.1 sec (39/min) - done with 'CommerceKickstartBlogPost'
    Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 2.8 sec (43/min) - done with 'CommerceKickstartAdPush'
    Processed 3 (3 created, 0 updated, 0 failed, 0 ignored) in 2.7 sec (66/min) - done with 'CommerceKickstartSlideshow'
    Processed 4 (4 created, 0 updated, 0 failed, 0 ignored) in 25.3 sec (9/min) - done with 'commercekickstartnodebags_cases'
    Processed 3 (3 created, 0 updated, 0 failed, 0 ignored) in 12.6 sec (14/min) - done with 'commercekickstartnodedrinks'
    Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 10.4 sec (12/min) - done with 'commercekickstartnodehats'
    Processed 2 (2 created, 0 updated, 0 failed, 0 ignored) in 11.7 sec (10/min) - done with 'commercekickstartnodeshoes'
    Processed 1 (1 created, 0 updated, 0 failed, 0 ignored) in 5.2 sec (11/min) - done with 'commercekickstartnodestorage_devices'
    Processed 8 (8 created, 0 updated, 0 failed, 0 ignored) in 29.7 sec (16/min) - done with 'commercekickstartnodetops'

Comment #4

jsacksick commented 20 May 2013 at 12:21

Project:	Commerce Kickstart	» Migrate Extras
Version:	7.x-2.1	» 7.x-2.x-dev
Component:	Code	» Entity API
Status:	Active	» Needs review

Status	File	Size
new	migrate_extras.info	533 bytes

It seems to be a Migrate Extras bug, it works fine with the attached patch.

Comment #5

jsacksick commented 20 May 2013 at 12:21

Status	File	Size
new	migrate_extras-fix-destid2-array-1951904-4.patch	533 bytes

With the patch this time :)

Comment #6

darren oh

English

Lakeland, Florida

commented 7 January 2014 at 21:45

Issue summary:	View changes
Status:	Needs review	» Reviewed & tested by the community

The patch works. This appears to have been a simple copy/paste error in the original code.

Comment #7

darren oh

English

Lakeland, Florida

commented 6 March 2014 at 14:52

Title:	Investigate why we are passing an array to destid2 in the term migrations	» Revision value is set to array when mapping imported entities
Issue summary:	View changes

4 files were hidden/shown/deleted

Status	File	Size
hidden	Screen Shot 2013-03-25 at 10.17.19.png	45.55 KB
hidden	Screen Shot 2013-03-25 at 10.29.44.png	83.11 KB
hidden	Screen Shot 2013-03-25 at 10.20.23.png	39.49 KB
hidden	migrate_extras.info	533 bytes

Added standard issue summary.

Comment #8

claudiu.cristea

Romanian

Arad 🇷🇴

commented 13 November 2014 at 09:04

#5 is doing the job. Can you push this in? It's trivial.

Comment #9

claudiu.cristea

Romanian

Arad 🇷🇴

commented 13 November 2014 at 09:09

Priority:

Normal

» Critical

Without this destinations with revision ID will allways fail.

Comment #10

alex.bukach commented 17 November 2020 at 09:27

Status:

Reviewed & tested by the community

» Fixed

The fix is in 7.x-2.5.

Comment #11

alex.bukach commented 17 November 2020 at 09:43

Status:

Fixed

» Reviewed & tested by the community

No, my bad :(

Revision value is set to array when mapping imported entities