Undefined array key "code"

[sergey030]

"laravel/framework": "^9.0"
"aimeos/aimeos-core": "2023.10"

php artisan aimeos:setup
Initializing or updating the Aimeos database tables for site "default"
Migrating: vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php
Migrated: vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php (3053.61ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (10.34ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (9.87ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (9.88ms)
Migrating: vendor/aimeos/ai-laravel/setup/TablesMigrateSiteidLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/TablesMigrateSiteidLaravel.php (10.36ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (10.45ms)
Migrating: vendor/aimeos/ai-laravel/setup/TypesMigrateColumnsLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/TypesMigrateColumnsLaravel.php (147.38ms)
Migrating: vendor/aimeos/aimeos-core/setup/Attribute.php
Migrated: vendor/aimeos/aimeos-core/setup/Attribute.php (558.82ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (242.22ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (19.8ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (32.47ms)
Migrating: vendor/aimeos/aimeos-core/setup/Cache.php
Migrated: vendor/aimeos/aimeos-core/setup/Cache.php (11.52ms)
Migrating: vendor/aimeos/aimeos-core/setup/Catalog.php
Migrated: vendor/aimeos/aimeos-core/setup/Catalog.php (146.64ms)
Migrating: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (140.94ms)
Migrating: vendor/aimeos/ai-cms-grapesjs/setup/Cms.php
Migrated: vendor/aimeos/ai-cms-grapesjs/setup/Cms.php (40.5ms)
Migrating: vendor/aimeos/ai-cms-grapesjs/setup/CmsRemoveIndexes.php
Migrated: vendor/aimeos/ai-cms-grapesjs/setup/CmsRemoveIndexes.php (89.05ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (29.81ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (13.43ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php
Migrated: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (32.55ms)
Migrating: vendor/aimeos/aimeos-core/setup/Coupon.php
Migrated: vendor/aimeos/aimeos-core/setup/Coupon.php (71.68ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (111.49ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigrateTableInnoDB.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigrateTableInnoDB.php (108.63ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveConstraints.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveConstraints.php (12.1ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveLostUserDataLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveLostUserDataLaravel.php (11.61ms)
Migrating: vendor/aimeos/aimeos-core/setup/Customer.php
Migrated: vendor/aimeos/aimeos-core/setup/Customer.php (231.49ms)
Migrating: vendor/aimeos/aimeos-core/setup/Media.php
Migrated: vendor/aimeos/aimeos-core/setup/Media.php (195.85ms)
Migrating: vendor/aimeos/aimeos-core/setup/Price.php
Migrated: vendor/aimeos/aimeos-core/setup/Price.php (102.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/Product.php
Migrated: vendor/aimeos/aimeos-core/setup/Product.php (358.49ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerClearPropertyKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerClearPropertyKeyLaravel.php (60.63ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php
Migrated: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (38.58ms)
Migrating: vendor/aimeos/aimeos-core/setup/Service.php
Migrated: vendor/aimeos/aimeos-core/setup/Service.php (165.54ms)
Migrating: vendor/aimeos/aimeos-core/setup/Supplier.php
Migrated: vendor/aimeos/aimeos-core/setup/Supplier.php (149.26ms)
Migrating: vendor/aimeos/aimeos-core/setup/Text.php
Migrated: vendor/aimeos/aimeos-core/setup/Text.php (317.11ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (352.72ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigrateListsKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigrateListsKeyLaravel.php (47.47ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigratePropertyKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigratePropertyKeyLaravel.php (64.79ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (299.18ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveIndexesLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveIndexesLaravel.php (193.45ms)
Migrating: vendor/aimeos/aimeos-core/setup/Log.php
Migrated: vendor/aimeos/aimeos-core/setup/Log.php (11.3ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (11.73ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (12.27ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (11.74ms)
Migrating: vendor/aimeos/aimeos-core/setup/Locale.php
Migrated: vendor/aimeos/aimeos-core/setup/Locale.php (150.2ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (71.96ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (17.18ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php (776.39ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php (15.76ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php (10.98ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php
[2025-02-20 19:21:37] local.ERROR: Undefined array key "code" {"exception":"[object] (ErrorException(code: 0): Undefined array key \"code\" at /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php:55)
[stacktrace]
#0 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(266): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(2, 'Undefined array...', '/Users/sergey/P...', 55)
#1 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php(55): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}(2, 'Undefined array...', '/Users/sergey/P...', 55)
#2 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\\Upscheme\\Task\\OrderAddProductParentid->up()
#3 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#4 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#5 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#6 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#7 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#8 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\\Upscheme\\Up->runTasks(Array)
#9 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#10 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up('default', 'default')
#11 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#12 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#13 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#14 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#15 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#16 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#17 /Users/sergey/Projects/dezigned/backend/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#18 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(152): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#19 /Users/sergey/Projects/dezigned/backend/vendor/symfony/console/Application.php(1022): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#20 /Users/sergey/Projects/dezigned/backend/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand(Object(Aimeos\\Shop\\Command\\SetupCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#21 /Users/sergey/Projects/dezigned/backend/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#22 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#23 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#24 /Users/sergey/Projects/dezigned/backend/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#25 {main}
"}

ErrorException

Undefined array key "code"

at vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php:55
51▕ $proddb = $this->db( 'db-product' );
52▕
53▕ while( $row = $result->fetchAssociative() )
54▕ {
➜ 55▕ if( isset( $used[$row['siteid']][$row['code']] ) ) {
56▕ continue;
57▕ }
58▕
59▕ $rows = $proddb->select( 'mshop_product', ['siteid' => $row['siteid'], 'code' => $row['prodcode']] );

+23 vendor frames
24 artisan:35
Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

Hi, when I run migrations I get an error because $row contains 'prodcode' instead of 'code'. Can you fix it please ?

[aimeos]

The fix has been backported to 2023.10 and a new version has been tagged. Please run "composer up" to get the latest version.