Subquery returns more than 1 row
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Subquery returns more than 1 row
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 (3570.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (9.21ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (9.51ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (8.68ms)
Migrating: vendor/aimeos/ai-laravel/setup/TablesMigrateSiteidLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/TablesMigrateSiteidLaravel.php (9.35ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (8.86ms)
Migrating: vendor/aimeos/ai-laravel/setup/TypesMigrateColumnsLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/TypesMigrateColumnsLaravel.php (91.96ms)
Migrating: vendor/aimeos/aimeos-core/setup/Attribute.php
Migrated: vendor/aimeos/aimeos-core/setup/Attribute.php (245.65ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (203.22ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (16.03ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (26.89ms)
Migrating: vendor/aimeos/aimeos-core/setup/Cache.php
Migrated: vendor/aimeos/aimeos-core/setup/Cache.php (8.52ms)
Migrating: vendor/aimeos/aimeos-core/setup/Catalog.php
Migrated: vendor/aimeos/aimeos-core/setup/Catalog.php (82.7ms)
Migrating: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (116.67ms)
Migrating: vendor/aimeos/ai-cms-grapesjs/setup/Cms.php
Migrated: vendor/aimeos/ai-cms-grapesjs/setup/Cms.php (44.97ms)
Migrating: vendor/aimeos/ai-cms-grapesjs/setup/CmsRemoveIndexes.php
Migrated: vendor/aimeos/ai-cms-grapesjs/setup/CmsRemoveIndexes.php (78.79ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (37.78ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (17.24ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php
Migrated: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (37.02ms)
Migrating: vendor/aimeos/aimeos-core/setup/Coupon.php
Migrated: vendor/aimeos/aimeos-core/setup/Coupon.php (95.11ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (129.87ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigrateTableInnoDB.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigrateTableInnoDB.php (343.38ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveConstraints.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveConstraints.php (14.97ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveLostUserDataLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveLostUserDataLaravel.php (10.98ms)
Migrating: vendor/aimeos/aimeos-core/setup/Customer.php
Migrated: vendor/aimeos/aimeos-core/setup/Customer.php (691.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/Media.php
Migrated: vendor/aimeos/aimeos-core/setup/Media.php (221.34ms)
Migrating: vendor/aimeos/aimeos-core/setup/Price.php
Migrated: vendor/aimeos/aimeos-core/setup/Price.php (135.15ms)
Migrating: vendor/aimeos/aimeos-core/setup/Product.php
Migrated: vendor/aimeos/aimeos-core/setup/Product.php (456.65ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerClearPropertyKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerClearPropertyKeyLaravel.php (39.61ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php
Migrated: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (26.93ms)
Migrating: vendor/aimeos/aimeos-core/setup/Service.php
Migrated: vendor/aimeos/aimeos-core/setup/Service.php (86.71ms)
Migrating: vendor/aimeos/aimeos-core/setup/Supplier.php
Migrated: vendor/aimeos/aimeos-core/setup/Supplier.php (106.36ms)
Migrating: vendor/aimeos/aimeos-core/setup/Text.php
Migrated: vendor/aimeos/aimeos-core/setup/Text.php (103.45ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (210.87ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigrateListsKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigrateListsKeyLaravel.php (28.3ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigratePropertyKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigratePropertyKeyLaravel.php (36.19ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (237.19ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveIndexesLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveIndexesLaravel.php (235.66ms)
Migrating: vendor/aimeos/aimeos-core/setup/Log.php
Migrated: vendor/aimeos/aimeos-core/setup/Log.php (13.67ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (10.44ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (9.88ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (11.48ms)
Migrating: vendor/aimeos/aimeos-core/setup/Locale.php
Migrated: vendor/aimeos/aimeos-core/setup/Locale.php (123.42ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (42.8ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (20.77ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php
[2025-01-16 13:27:59] local.ERROR: An exception occurred while executing '
UPDATE `mshop_order_base_address` AS dest
SET `parentid` = (
SELECT `id`
FROM `mshop_order` AS src
WHERE dest.`baseid` = src.`baseid`
)
':
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing '
\t\t\tUPDATE `mshop_order_base_address` AS dest
\t\t\tSET `parentid` = (
\t\t\t\tSELECT `id`
\t\t\t\tFROM `mshop_order` AS src
\t\t\t\tWHERE dest.`baseid` = src.`baseid`
\t\t\t)
\t\t':
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128)
[stacktrace]
#0 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))
#1 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), 'An exception oc...')
#2 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2222): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), '\\n\\t\\t\\tUPDATE `msh...', Array)
#3 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1537): Doctrine\\DBAL\\Connection->handleExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), '\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#4 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Schema/DB.php(267): Doctrine\\DBAL\\Connection->executeStatement('\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#5 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(39): Aimeos\\Upscheme\\Schema\\DB->exec('\\n\\t\\t\\tUPDATE `msh...')
#6 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\\Upscheme\\Task\\OrderConnectTables->address()
#7 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\\Upscheme\\Task\\OrderConnectTables->up()
#8 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#9 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#10 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#11 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#12 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#13 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#14 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\\Upscheme\\Up->runTasks(Array)
#15 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#16 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up('default', 'default')
#17 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#18 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#20 /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))
#21 /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)
#22 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#23 /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))
#24 /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))
#25 /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))
#26 /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))
#27 /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))
#28 /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))
#29 /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))
#30 /Users/sergey/Projects/dezigned/backend/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#31 {main}
[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 21000): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
[stacktrace]
#0 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(60): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException))
#1 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1534): Doctrine\\DBAL\\Driver\\PDOConnection->exec('\\n\\t\\t\\tUPDATE `msh...')
#2 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Schema/DB.php(267): Doctrine\\DBAL\\Connection->executeStatement('\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#3 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(39): Aimeos\\Upscheme\\Schema\\DB->exec('\\n\\t\\t\\tUPDATE `msh...')
#4 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\\Upscheme\\Task\\OrderConnectTables->address()
#5 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\\Upscheme\\Task\\OrderConnectTables->up()
#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(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#9 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#10 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#11 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#12 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\\Upscheme\\Up->runTasks(Array)
#13 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#14 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up('default', 'default')
#15 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#16 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#17 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#18 /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))
#19 /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)
#20 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#21 /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))
#22 /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))
#23 /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))
#24 /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))
#25 /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))
#26 /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))
#27 /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))
#28 /Users/sergey/Projects/dezigned/backend/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 {main}
[previous exception] [object] (PDOException(code: 21000): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:55)
[stacktrace]
#0 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(55): PDO->exec('\\n\\t\\t\\tUPDATE `msh...')
#1 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1534): Doctrine\\DBAL\\Driver\\PDOConnection->exec('\\n\\t\\t\\tUPDATE `msh...')
#2 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Schema/DB.php(267): Doctrine\\DBAL\\Connection->executeStatement('\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#3 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(39): Aimeos\\Upscheme\\Schema\\DB->exec('\\n\\t\\t\\tUPDATE `msh...')
#4 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\\Upscheme\\Task\\OrderConnectTables->address()
#5 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\\Upscheme\\Task\\OrderConnectTables->up()
#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(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#9 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#10 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#11 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#12 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\\Upscheme\\Up->runTasks(Array)
#13 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#14 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up('default', 'default')
#15 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#16 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#17 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#18 /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))
#19 /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)
#20 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#21 /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))
#22 /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))
#23 /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))
#24 /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))
#25 /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))
#26 /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))
#27 /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))
#28 /Users/sergey/Projects/dezigned/backend/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 {main}
"}
Doctrine\DBAL\Exception\DriverException
An exception occurred while executing '
UPDATE `mshop_order_base_address` AS dest
SET `parentid` = (
SELECT `id`
FROM `mshop_order` AS src
WHERE dest.`baseid` = src.`baseid`
)
':
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128
124▕ case '1566':
125▕ return new NotNullConstraintViolationException($message, $exception);
126▕ }
127▕
➜ 128▕ return new DriverException($message, $exception);
129▕ }
130▕
131▕ /**
132▕ * {@inheritdoc}
+35 vendor frames
36 artisan:35
Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
Laravel: v9.52.5
Aimeos: 2023.10
What could be the problem when upgrading aimeos 2022 database to aimeos 2023.10 ?
It's just that here it's as if it's not quite the right query when updating tables. Or am I doing something wrong ?
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 (3570.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (9.21ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (9.51ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (8.68ms)
Migrating: vendor/aimeos/ai-laravel/setup/TablesMigrateSiteidLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/TablesMigrateSiteidLaravel.php (9.35ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (8.86ms)
Migrating: vendor/aimeos/ai-laravel/setup/TypesMigrateColumnsLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/TypesMigrateColumnsLaravel.php (91.96ms)
Migrating: vendor/aimeos/aimeos-core/setup/Attribute.php
Migrated: vendor/aimeos/aimeos-core/setup/Attribute.php (245.65ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (203.22ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (16.03ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (26.89ms)
Migrating: vendor/aimeos/aimeos-core/setup/Cache.php
Migrated: vendor/aimeos/aimeos-core/setup/Cache.php (8.52ms)
Migrating: vendor/aimeos/aimeos-core/setup/Catalog.php
Migrated: vendor/aimeos/aimeos-core/setup/Catalog.php (82.7ms)
Migrating: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (116.67ms)
Migrating: vendor/aimeos/ai-cms-grapesjs/setup/Cms.php
Migrated: vendor/aimeos/ai-cms-grapesjs/setup/Cms.php (44.97ms)
Migrating: vendor/aimeos/ai-cms-grapesjs/setup/CmsRemoveIndexes.php
Migrated: vendor/aimeos/ai-cms-grapesjs/setup/CmsRemoveIndexes.php (78.79ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (37.78ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (17.24ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php
Migrated: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (37.02ms)
Migrating: vendor/aimeos/aimeos-core/setup/Coupon.php
Migrated: vendor/aimeos/aimeos-core/setup/Coupon.php (95.11ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (129.87ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigrateTableInnoDB.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigrateTableInnoDB.php (343.38ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveConstraints.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveConstraints.php (14.97ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveLostUserDataLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveLostUserDataLaravel.php (10.98ms)
Migrating: vendor/aimeos/aimeos-core/setup/Customer.php
Migrated: vendor/aimeos/aimeos-core/setup/Customer.php (691.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/Media.php
Migrated: vendor/aimeos/aimeos-core/setup/Media.php (221.34ms)
Migrating: vendor/aimeos/aimeos-core/setup/Price.php
Migrated: vendor/aimeos/aimeos-core/setup/Price.php (135.15ms)
Migrating: vendor/aimeos/aimeos-core/setup/Product.php
Migrated: vendor/aimeos/aimeos-core/setup/Product.php (456.65ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerClearPropertyKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerClearPropertyKeyLaravel.php (39.61ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php
Migrated: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (26.93ms)
Migrating: vendor/aimeos/aimeos-core/setup/Service.php
Migrated: vendor/aimeos/aimeos-core/setup/Service.php (86.71ms)
Migrating: vendor/aimeos/aimeos-core/setup/Supplier.php
Migrated: vendor/aimeos/aimeos-core/setup/Supplier.php (106.36ms)
Migrating: vendor/aimeos/aimeos-core/setup/Text.php
Migrated: vendor/aimeos/aimeos-core/setup/Text.php (103.45ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (210.87ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigrateListsKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigrateListsKeyLaravel.php (28.3ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerMigratePropertyKeyLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerMigratePropertyKeyLaravel.php (36.19ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php
Migrated: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (237.19ms)
Migrating: vendor/aimeos/ai-laravel/setup/CustomerRemoveIndexesLaravel.php
Migrated: vendor/aimeos/ai-laravel/setup/CustomerRemoveIndexesLaravel.php (235.66ms)
Migrating: vendor/aimeos/aimeos-core/setup/Log.php
Migrated: vendor/aimeos/aimeos-core/setup/Log.php (13.67ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (10.44ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (9.88ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (11.48ms)
Migrating: vendor/aimeos/aimeos-core/setup/Locale.php
Migrated: vendor/aimeos/aimeos-core/setup/Locale.php (123.42ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (42.8ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (20.77ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php
[2025-01-16 13:27:59] local.ERROR: An exception occurred while executing '
UPDATE `mshop_order_base_address` AS dest
SET `parentid` = (
SELECT `id`
FROM `mshop_order` AS src
WHERE dest.`baseid` = src.`baseid`
)
':
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing '
\t\t\tUPDATE `mshop_order_base_address` AS dest
\t\t\tSET `parentid` = (
\t\t\t\tSELECT `id`
\t\t\t\tFROM `mshop_order` AS src
\t\t\t\tWHERE dest.`baseid` = src.`baseid`
\t\t\t)
\t\t':
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128)
[stacktrace]
#0 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))
#1 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), 'An exception oc...')
#2 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2222): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), '\\n\\t\\t\\tUPDATE `msh...', Array)
#3 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1537): Doctrine\\DBAL\\Connection->handleExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), '\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#4 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Schema/DB.php(267): Doctrine\\DBAL\\Connection->executeStatement('\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#5 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(39): Aimeos\\Upscheme\\Schema\\DB->exec('\\n\\t\\t\\tUPDATE `msh...')
#6 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\\Upscheme\\Task\\OrderConnectTables->address()
#7 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\\Upscheme\\Task\\OrderConnectTables->up()
#8 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#9 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#10 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#11 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#12 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#13 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#14 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\\Upscheme\\Up->runTasks(Array)
#15 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#16 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up('default', 'default')
#17 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#18 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#20 /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))
#21 /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)
#22 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#23 /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))
#24 /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))
#25 /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))
#26 /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))
#27 /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))
#28 /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))
#29 /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))
#30 /Users/sergey/Projects/dezigned/backend/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#31 {main}
[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 21000): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
[stacktrace]
#0 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(60): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException))
#1 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1534): Doctrine\\DBAL\\Driver\\PDOConnection->exec('\\n\\t\\t\\tUPDATE `msh...')
#2 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Schema/DB.php(267): Doctrine\\DBAL\\Connection->executeStatement('\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#3 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(39): Aimeos\\Upscheme\\Schema\\DB->exec('\\n\\t\\t\\tUPDATE `msh...')
#4 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\\Upscheme\\Task\\OrderConnectTables->address()
#5 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\\Upscheme\\Task\\OrderConnectTables->up()
#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(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#9 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#10 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#11 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#12 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\\Upscheme\\Up->runTasks(Array)
#13 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#14 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up('default', 'default')
#15 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#16 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#17 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#18 /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))
#19 /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)
#20 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#21 /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))
#22 /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))
#23 /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))
#24 /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))
#25 /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))
#26 /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))
#27 /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))
#28 /Users/sergey/Projects/dezigned/backend/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 {main}
[previous exception] [object] (PDOException(code: 21000): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row at /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:55)
[stacktrace]
#0 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(55): PDO->exec('\\n\\t\\t\\tUPDATE `msh...')
#1 /Users/sergey/Projects/dezigned/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1534): Doctrine\\DBAL\\Driver\\PDOConnection->exec('\\n\\t\\t\\tUPDATE `msh...')
#2 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Schema/DB.php(267): Doctrine\\DBAL\\Connection->executeStatement('\\n\\t\\t\\tUPDATE `msh...', Array, Array)
#3 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(39): Aimeos\\Upscheme\\Schema\\DB->exec('\\n\\t\\t\\tUPDATE `msh...')
#4 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\\Upscheme\\Task\\OrderConnectTables->address()
#5 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\\Upscheme\\Task\\OrderConnectTables->up()
#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(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#9 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#10 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#11 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\\Upscheme\\Up->runTasks(Array, Array)
#12 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\\Upscheme\\Up->runTasks(Array)
#13 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#14 /Users/sergey/Projects/dezigned/backend/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up('default', 'default')
#15 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#16 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#17 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#18 /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))
#19 /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)
#20 /Users/sergey/Projects/dezigned/backend/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#21 /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))
#22 /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))
#23 /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))
#24 /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))
#25 /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))
#26 /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))
#27 /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))
#28 /Users/sergey/Projects/dezigned/backend/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 {main}
"}
Doctrine\DBAL\Exception\DriverException
An exception occurred while executing '
UPDATE `mshop_order_base_address` AS dest
SET `parentid` = (
SELECT `id`
FROM `mshop_order` AS src
WHERE dest.`baseid` = src.`baseid`
)
':
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128
124▕ case '1566':
125▕ return new NotNullConstraintViolationException($message, $exception);
126▕ }
127▕
➜ 128▕ return new DriverException($message, $exception);
129▕ }
130▕
131▕ /**
132▕ * {@inheritdoc}
+35 vendor frames
36 artisan:35
Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
Laravel: v9.52.5
Aimeos: 2023.10
What could be the problem when upgrading aimeos 2022 database to aimeos 2023.10 ?
It's just that here it's as if it's not quite the right query when updating tables. Or am I doing something wrong ?
Re: Subquery returns more than 1 row
There seems to be more than one record in mshop_order for the same mshop_order_base record. Can you confirm that?
To circumvent the problem, we've added a "LIMIT 1" in the query and it's available for dev-master, 2024.10.x-dev and 2023.10.x-dev. Can you please update to one of that versions and try again?
To circumvent the problem, we've added a "LIMIT 1" in the query and it's available for dev-master, 2024.10.x-dev and 2023.10.x-dev. Can you please update to one of that versions and try again?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
