search

aimeos / aimeos-typo3

TYPO3 e-commerce extension for ultra fast online shops, scalable marketplaces, complex B2B applications and #gigacommerce
https://aimeos.org/TYPO3
GNU General Public License v3.0
356 stars 743 forks source link

Upgrade from v22.10.9 to v24.10.1 #223

Closed nollm closed 1 day ago

nollm commented 5 days ago

I want to upgrade the shop from v22.10.9 to v24.10.1. When I run the task in the upgrade wizard I get the following error,

Update failed! Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php (517.2ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (92.02ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (91.35ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (94.62ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (82.19ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php (96.76ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (1905.96ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (173.8ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (263.35ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php Creating cache schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php (89.06ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php (87.86ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (1143.56ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (264.02ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (87.65ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (268.75ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php (88.22ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (936.01ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php Rename mshop_customer_group to mshop_group Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php (88.92ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php Migrate TYPO3 "customer/group" domain to "group" Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php (86.23ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (106.51ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php Creating customer schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php (90.28ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php Creating media schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php (88.77ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php Creating price schema -> ALTER TABLE mshop_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php (105.6ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php Creating product schema -> ALTER TABLE mshop_product CHANGE rating rating NUMERIC(4, 2) DEFAULT '0' NOT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php (106.79ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (298.98ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php (88.52ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php Creating service schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php (91ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php (88.55ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php Creating text schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php (178.85ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php Update lists "key" columns Checking table mshop_attribute_list Checking table mshop_catalog_list Checking table mshop_customer_list Checking table mshop_media_list Checking table mshop_price_list Checking table mshop_product_list Checking table mshop_service_list Checking table mshop_supplier_list Checking table mshop_text_list Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (1801.52ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (277.38ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (276.09ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (2150.16ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (1713.66ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php Creating log schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php (92.56ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php Creating group schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php (89.46ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (87.92ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php Remove old indexes from mshopindex* tables Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (179.37ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php Creating index schema -> ALTER TABLE mshop_index_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php (189.68ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php Creating job schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php (87.23ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php (92.48ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (91.81ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (97.12ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php Separate product ID and parent ID in order base product table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php (262.43ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php -> ALTER TABLE mshop_order_base_service DROP baseid An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'baseid' doesn't exist in table #0 /var/www/html/typo3_src-12.4.20/vendor/doctrine/dbal/src/Connection.php(1939): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #1 /var/www/html/typo3_src-12.4.20/vendor/doctrine/dbal/src/Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 /var/www/html/typo3_src-12.4.20/vendor/doctrine/dbal/src/Connection.php(1213): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'ALTER TABLE msh...', Array, Array) #3 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Schema/DB.php(763): Doctrine\DBAL\Connection->executeStatement('ALTER TABLE msh...') #4 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Schema/DB.php(137): Aimeos\Upscheme\Schema\DB->up() #5 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php(131): Aimeos\Upscheme\Schema\DB->dropColumn('mshop_order_bas...', 'baseid') #6 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\Upscheme\Task\OrderConnectTables->service() #7 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(341): Aimeos\Upscheme\Task\OrderConnectTables->up() #8 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #9 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #10 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #11 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #12 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #13 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #14 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #15 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #16 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(172): Aimeos\Upscheme\Up->runTasks(Array) #17 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/Setup.php(84): Aimeos\Upscheme\Up->up() #18 /var/www/html/typo3/typo3conf/ext/aimeos/Classes/Setup.php(148): Aimeos\Setup->up('default', 'default') #19 /var/www/html/typo3/typo3conf/ext/aimeos/Classes/Setup.php(77): Aimeos\Aimeos\Setup::execute() #20 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Service/UpgradeWizardsService.php(275): Aimeos\Aimeos\Setup->executeUpdate() #21 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Controller/UpgradeController.php(1099): TYPO3\CMS\Install\Service\UpgradeWizardsService->executeWizard('aimeos', Array) #22 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Middleware/Maintenance.php(234): TYPO3\CMS\Install\Controller\UpgradeController->upgradeWizardsExecuteAction(Object(TYPO3\CMS\Core\Http\ServerRequest)) #23 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(111): TYPO3\CMS\Install\Middleware\Maintenance->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #24 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Middleware/NormalizedParamsAttribute.php(41): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #25 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #26 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(70): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #27 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/AbstractApplication.php(80): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #28 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Http/Application.php(46): TYPO3\CMS\Core\Http\AbstractApplication->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #29 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/AbstractApplication.php(92): TYPO3\CMS\Install\Http\Application->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #30 /var/www/html/typo3_src-12.4.20/typo3/install.php(19): TYPO3\CMS\Core\Http\AbstractApplication->run() #31 /var/www/html/typo3_src-12.4.20/typo3/install.php(20): {closure}() #32 {main}

aimeos commented 5 days ago

Did the migration fail already before? It seems that this is a subsequent error. Can you do the migration of the Aimeos tables from the 22.10 database from scratch again and post the output?

nollm commented 5 days ago

I restored my database to the state before I installed the new version. But the upgrade wizard will not work.

Update failed! Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php (417.66ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (79.32ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (84.29ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (79.48ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (86.12ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema -> ALTER TABLE mshop_attribute_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_attribute_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_attribute_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_attribute_list CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php (308.55ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (1812.08ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (206.47ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (257.21ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php Creating cache schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php (85.15ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema -> ALTER TABLE mshop_catalog_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_catalog_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_catalog CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php (326.98ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (1152.23ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (279.32ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (90.02ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (286.45ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema -> ALTER TABLE mshop_coupon CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php (178.39ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (889.07ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php Rename mshop_customer_group to mshop_group -> DROP INDEX unq_mscusgr_code_sid ON mshop_customer_group -> DROP INDEX idx_mscusgr_label_sid ON mshop_customer_group Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php (856.58ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php Migrate TYPO3 "customer/group" domain to "group" Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php (90.47ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (119.9ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php Creating customer schema -> ALTER TABLE fe_users_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE fe_users_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE fe_users_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_customer_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_customer_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_customer_address ADD type VARCHAR(64) DEFAULT 'delivery' NOT NULL, ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> CREATE INDEX idx_mscusad_pid_type ON mshop_customer_address (parentid, type) -> ALTER TABLE mshop_customer ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> ALTER TABLE fe_users_address ADD type VARCHAR(64) DEFAULT 'delivery' NOT NULL, ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> ALTER TABLE mshop_customer_list_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php (701.94ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php Creating media schema -> ALTER TABLE mshop_media_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_media_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_media_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_media_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_media CHANGE preview preview TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php (530.75ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php Creating price schema -> ALTER TABLE mshop_price_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_price_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_price_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_price_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php (289.06ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php Creating product schema -> ALTER TABLE mshop_product_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_product_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_product ADD boost DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE config config TEXT DEFAULT NULL, CHANGE rating rating NUMERIC(4, 2) DEFAULT '0' NOT NULL -> CREATE UNIQUE INDEX unq_mspro_code_sid ON mshop_product (code, siteid) -> ALTER TABLE mshop_product_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_product_list CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php (1042.58ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (262.19ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php (90.38ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php Creating service schema -> ALTER TABLE mshop_service CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_service_list CHANGE config config TEXT DEFAULT '{}' -> ALTER TABLE mshop_service_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_service_list_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php (218.64ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema -> ALTER TABLE mshop_supplier_address ADD type VARCHAR(64) DEFAULT '' NOT NULL, ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> ALTER TABLE mshop_supplier_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_supplier_list_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php (162.43ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php Creating text schema -> ALTER TABLE mshop_text_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_text_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_text_list CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php (245.53ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php Update lists "key" columns Checking table mshop_attribute_list Checking table mshop_catalog_list Checking table mshop_customer_list Checking table mshop_media_list Checking table mshop_price_list Checking table mshop_product_list Checking table mshop_service_list Checking table mshop_supplier_list Checking table mshop_text_list Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (1763.64ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (277.42ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (275.48ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (2150.45ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (1692.66ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php Creating log schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php (94.49ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php Creating group schema -> CREATE UNIQUE INDEX unq_msgro_code_sid ON mshop_group (code, siteid) -> CREATE INDEX idx_msgro_label_sid ON mshop_group (label, siteid) Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php (123.17ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (85.92ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php Remove old indexes from mshopindex* tables Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (179.97ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php Creating index schema -> ALTER TABLE mshop_index_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php (196.56ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php Creating job schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php (89.38ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php (87.64ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (92.81ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (88.86ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php Separate product ID and parent ID in order base product table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php (1049.59ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php -> ALTER TABLE mshop_order_base_address DROP FOREIGN KEY fk_msordbaad_baseid -> DROP INDEX unq_msordbaad_bid_type ON mshop_order_base_address -> ALTER TABLE mshop_order_base_address ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_address DROP baseid -> ALTER TABLE mshop_order_base_coupon DROP FOREIGN KEY fk_msordbaco_baseid -> ALTER TABLE mshop_order_base_coupon ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_coupon DROP baseid -> ALTER TABLE mshop_order_base_product DROP FOREIGN KEY fk_msordbapr_baseid -> DROP INDEX unq_msordbapr_bid_pos ON mshop_order_base_product -> ALTER TABLE mshop_order_base_product ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_product DROP baseid -> ALTER TABLE mshop_order_base_service DROP FOREIGN KEY fk_msordbase_baseid -> DROP INDEX unq_msordbase_bid_cd_typ_sid ON mshop_order_base_service -> ALTER TABLE mshop_order_base_service ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_service DROP baseid An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'baseid' doesn't exist in table #0 /var/www/html/typo3_src-12.4.20/vendor/doctrine/dbal/src/Connection.php(1939): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #1 /var/www/html/typo3_src-12.4.20/vendor/doctrine/dbal/src/Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 /var/www/html/typo3_src-12.4.20/vendor/doctrine/dbal/src/Connection.php(1213): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'ALTER TABLE msh...', Array, Array) #3 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Schema/DB.php(763): Doctrine\DBAL\Connection->executeStatement('ALTER TABLE msh...') #4 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Schema/DB.php(137): Aimeos\Upscheme\Schema\DB->up() #5 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php(131): Aimeos\Upscheme\Schema\DB->dropColumn('mshop_order_bas...', 'baseid') #6 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php(22): Aimeos\Upscheme\Task\OrderConnectTables->service() #7 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(341): Aimeos\Upscheme\Task\OrderConnectTables->up() #8 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #9 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #10 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #11 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #12 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #13 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #14 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #15 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #16 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(172): Aimeos\Upscheme\Up->runTasks(Array) #17 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/Setup.php(84): Aimeos\Upscheme\Up->up() #18 /var/www/html/typo3/typo3conf/ext/aimeos/Classes/Setup.php(148): Aimeos\Setup->up('default', 'default') #19 /var/www/html/typo3/typo3conf/ext/aimeos/Classes/Setup.php(77): Aimeos\Aimeos\Setup::execute() #20 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Service/UpgradeWizardsService.php(275): Aimeos\Aimeos\Setup->executeUpdate() #21 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Controller/UpgradeController.php(1099): TYPO3\CMS\Install\Service\UpgradeWizardsService->executeWizard('aimeos', Array) #22 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Middleware/Maintenance.php(234): TYPO3\CMS\Install\Controller\UpgradeController->upgradeWizardsExecuteAction(Object(TYPO3\CMS\Core\Http\ServerRequest)) #23 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(111): TYPO3\CMS\Install\Middleware\Maintenance->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #24 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Middleware/NormalizedParamsAttribute.php(41): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #25 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #26 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(70): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #27 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/AbstractApplication.php(80): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #28 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Http/Application.php(46): TYPO3\CMS\Core\Http\AbstractApplication->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #29 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/AbstractApplication.php(92): TYPO3\CMS\Install\Http\Application->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #30 /var/www/html/typo3_src-12.4.20/typo3/install.php(19): TYPO3\CMS\Core\Http\AbstractApplication->run() #31 /var/www/html/typo3_src-12.4.20/typo3/install.php(20): {closure}() #32 {main}

aimeos commented 5 days ago

But the mshop_order_base_service.baseid column is available in you 2022.10 tables?

nollm commented 5 days ago

Yes it is.

baseid

aimeos commented 5 days ago

Very strange! The baseid column is dropped after the error occurred? Can you check by adding a few debug statements when the mshop_order_base_service.baseid column is dropped?

nollm commented 5 days ago

No the column is still there after the error occured. In line 131 the exception occurs. Or what debug information do you need? When I execute the SQL manually the same error occurs in phpmyadmin.

function

nollm commented 5 days ago

I think I got the solution. In my database an index "unq_msordbase_sid_bid_cd_typ" exists. When I remove this index I can also remove the "baseid". The index name is wrong or missing in line 118.

nollm commented 5 days ago

The next error that occurs in the upgrade wizard....

Update failed! Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php (423.12ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (81.97ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (81.24ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (74.77ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (85.5ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema -> ALTER TABLE mshop_attribute_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_attribute_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_attribute_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_attribute_list CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php (195.68ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (1716.75ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (166.38ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (247.36ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php Creating cache schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php (84.7ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema -> ALTER TABLE mshop_catalog_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_catalog_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_catalog CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php (177.27ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (1067.45ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (248.29ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (82.61ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (252.21ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema -> ALTER TABLE mshop_coupon CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php (124.1ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (815.63ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php Rename mshop_customer_group to mshop_group -> DROP INDEX unq_mscusgr_code_sid ON mshop_customer_group -> DROP INDEX idx_mscusgr_label_sid ON mshop_customer_group Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php (780.66ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php Migrate TYPO3 "customer/group" domain to "group" Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php (83.66ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (119.01ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php Creating customer schema -> ALTER TABLE fe_users_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE fe_users_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE fe_users_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_customer_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_customer_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_customer_address ADD type VARCHAR(64) DEFAULT 'delivery' NOT NULL, ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> CREATE INDEX idx_mscusad_pid_type ON mshop_customer_address (parentid, type) -> ALTER TABLE mshop_customer ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> ALTER TABLE fe_users_address ADD type VARCHAR(64) DEFAULT 'delivery' NOT NULL, ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> ALTER TABLE mshop_customer_list_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php (391.77ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php Creating media schema -> ALTER TABLE mshop_media_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_media_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_media_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_media_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_media CHANGE preview preview TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php (341.15ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php Creating price schema -> ALTER TABLE mshop_price_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_price_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_price_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_price_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php (190.26ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php Creating product schema -> ALTER TABLE mshop_product_property_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_product_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_product ADD boost DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE config config TEXT DEFAULT NULL, CHANGE rating rating NUMERIC(4, 2) DEFAULT '0' NOT NULL -> CREATE UNIQUE INDEX unq_mspro_code_sid ON mshop_product (code, siteid) -> ALTER TABLE mshop_product_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_product_list CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php (827.56ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (251.24ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php (86.94ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php Creating service schema -> ALTER TABLE mshop_service CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_service_list CHANGE config config TEXT DEFAULT '{}' -> ALTER TABLE mshop_service_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_service_list_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php (211.84ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema -> ALTER TABLE mshop_supplier_address ADD type VARCHAR(64) DEFAULT '' NOT NULL, ADD mobile VARCHAR(32) DEFAULT '' NOT NULL -> ALTER TABLE mshop_supplier_list CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_supplier_list_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php (160.69ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php Creating text schema -> ALTER TABLE mshop_text_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_text_list_type ADD i18n TEXT DEFAULT NULL -> ALTER TABLE mshop_text_list CHANGE config config TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php (238.96ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php Update lists "key" columns Checking table mshop_attribute_list Checking table mshop_catalog_list Checking table mshop_customer_list Checking table mshop_media_list Checking table mshop_price_list Checking table mshop_product_list Checking table mshop_service_list Checking table mshop_supplier_list Checking table mshop_text_list Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (1627.33ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (249.33ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (251.81ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (1974.43ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (1531.3ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php Creating log schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php (92.13ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php Creating group schema -> CREATE UNIQUE INDEX unq_msgro_code_sid ON mshop_group (code, siteid) -> CREATE INDEX idx_msgro_label_sid ON mshop_group (label, siteid) Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php (112.2ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (85.15ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php Remove old indexes from mshopindex* tables Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (167.43ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php Creating index schema -> ALTER TABLE mshop_index_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php (179.53ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php Creating job schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php (81.46ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php (79.86ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (81.61ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (79.94ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php Separate product ID and parent ID in order base product table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php (1061.27ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php -> ALTER TABLE mshop_order_base_address DROP FOREIGN KEY fk_msordbaad_baseid -> DROP INDEX unq_msordbaad_bid_type ON mshop_order_base_address -> ALTER TABLE mshop_order_base_address ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_address DROP baseid -> ALTER TABLE mshop_order_base_coupon DROP FOREIGN KEY fk_msordbaco_baseid -> ALTER TABLE mshop_order_base_coupon ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_coupon DROP baseid -> ALTER TABLE mshop_order_base_product DROP FOREIGN KEY fk_msordbapr_baseid -> DROP INDEX unq_msordbapr_bid_pos ON mshop_order_base_product -> ALTER TABLE mshop_order_base_product ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_product DROP baseid -> ALTER TABLE mshop_order_base_service DROP FOREIGN KEY fk_msordbase_baseid -> DROP INDEX unq_msordbase_sid_bid_cd_typ ON mshop_order_base_service -> DROP INDEX unq_msordbase_bid_cd_typ_sid ON mshop_order_base_service -> ALTER TABLE mshop_order_base_service ADD parentid BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_service DROP baseid -> DROP INDEX idx_mssub_baseid ON mshop_subscription -> ALTER TABLE mshop_subscription ADD orderid BIGINT DEFAULT NULL -> ALTER TABLE mshop_subscription DROP baseid Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php (2481.13ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (82.37ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (84.05ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php Rename "suppliername" to "vendor" in "mshop_order_base_product" table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (256.6ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameTables.php -> ALTER TABLE mshop_order_base_product_attr DROP FOREIGN KEY fk_msordbaprat_parentid -> ALTER TABLE mshop_order_base_service_attr DROP FOREIGN KEY fk_msordbaseat_parentid -> DROP INDEX idx_msordbaco_bid_code ON mshop_order_base_coupon -> DROP INDEX idx_msordbaad_bid_addr1 ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_city ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_lname ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_postal ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_email ON mshop_order_base_address -> DROP INDEX idx_msordbapr_ct_pid_bid ON mshop_order_base_product -> DROP INDEX idx_msordbapr_bid_pid ON mshop_order_base_product -> DROP INDEX idx_msordbapr_bid_qtyo ON mshop_order_base_product -> DROP INDEX idx_msordbapr_bid_pcd ON mshop_order_base_product -> DROP INDEX idx_msordbase_code_type_sid ON mshop_order_base_service -> DROP INDEX unq_msordbaprat_oid_aid_ty_cd ON mshop_order_base_product_attr -> DROP INDEX idx_msordbaprat_si_cd_va ON mshop_order_base_product_attr -> DROP INDEX unq_msordbaseat_oid_aid_ty_cd ON mshop_order_base_service_attr -> DROP INDEX idx_msordbaseat_si_cd_va ON mshop_order_base_service_attr Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameTables.php (1561.43ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php (81.81ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php Creating order schema -> CREATE TABLE mshop_order_service_tx (id BIGINT AUTO_INCREMENT NOT NULL, siteid VARCHAR(255) NOT NULL, parentid BIGINT NOT NULL, type VARCHAR(16) DEFAULT '' NOT NULL, currencyid VARCHAR(3) NOT NULL, price NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, costs NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, rebate NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, tax NUMERIC(14, 4) DEFAULT '0.0000' NOT NULL, taxflag SMALLINT DEFAULT 1 NOT NULL, status SMALLINT DEFAULT -1 NOT NULL, config TEXT DEFAULT NULL, mtime DATETIME NOT NULL, ctime DATETIME NOT NULL, editor VARCHAR(255) NOT NULL, INDEX fk_msordsetx_parentid (parentid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB -> ALTER TABLE mshop_order_service_tx ADD CONSTRAINT fk_msordsetx_parentid FOREIGN KEY (parentid) REFERENCES mshop_order_service (id) ON UPDATE CASCADE ON DELETE CASCADE -> ALTER TABLE mshop_order_service_attr CHANGE price price NUMERIC(12, 2) DEFAULT '0' -> ALTER TABLE mshop_order_service_attr ADD CONSTRAINT fk_msordseat_parentid FOREIGN KEY (parentid) REFERENCES mshop_order_service (id) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX unq_msordseat_pid_aid_ty_cd ON mshop_order_service_attr (parentid, attrid, type, code) -> CREATE INDEX fk_msordseat_parentid ON mshop_order_service_attr (parentid) -> ALTER TABLE mshop_order_product_attr CHANGE price price NUMERIC(12, 2) DEFAULT '0' -> ALTER TABLE mshop_order_product_attr ADD CONSTRAINT fk_msordprat_parentid FOREIGN KEY (parentid) REFERENCES mshop_order_product (id) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX unq_msordprat_pid_aid_ty_cd ON mshop_order_product_attr (parentid, attrid, type, code) -> CREATE INDEX fk_msordprat_parentid ON mshop_order_product_attr (parentid) -> ALTER TABLE mshop_order ADD sitecode VARCHAR(255) DEFAULT '' NOT NULL, ADD customerid VARCHAR(36) DEFAULT '' NOT NULL, ADD langid VARCHAR(5) DEFAULT '' NOT NULL, ADD currencyid VARCHAR(3) DEFAULT '' NOT NULL, ADD price NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, ADD costs NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, ADD rebate NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, ADD tax NUMERIC(14, 4) DEFAULT '0.0000' NOT NULL, ADD taxflag SMALLINT DEFAULT 1 NOT NULL, ADD customerref VARCHAR(255) DEFAULT NULL, ADD comment TEXT DEFAULT '' NOT NULL -> CREATE INDEX idx_msord_custid_sid ON mshop_order (customerid, siteid) -> CREATE INDEX idx_msord_custid_scode ON mshop_order (customerid, sitecode) -> ALTER TABLE mshop_order_basket CHANGE content content MEDIUMTEXT DEFAULT '' NOT NULL -> ALTER TABLE mshop_order_address ADD mobile VARCHAR(32) DEFAULT '' NOT NULL, CHANGE parentid parentid BIGINT NOT NULL -> ALTER TABLE mshop_order_address ADD CONSTRAINT fk_msordad_parentid FOREIGN KEY (parentid) REFERENCES mshop_order (id) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX unq_msordad_pid_type_pos ON mshop_order_address (parentid, type, pos) -> CREATE INDEX idx_msordad_pid_lname ON mshop_order_address (parentid, lastname) -> CREATE INDEX idx_msordad_pid_addr1 ON mshop_order_address (parentid, address1) -> CREATE INDEX idx_msordad_pid_postal ON mshop_order_address (parentid, postal) -> CREATE INDEX idx_msordad_pid_city ON mshop_order_address (parentid, city) -> CREATE INDEX idx_msordad_pid_email ON mshop_order_address (parentid, email) -> CREATE INDEX fk_msordad_parentid ON mshop_order_address (parentid) -> ALTER TABLE mshop_order_product CHANGE price price NUMERIC(12, 2) DEFAULT '0', CHANGE description description TEXT DEFAULT '' NOT NULL, CHANGE notes notes TEXT DEFAULT '' NOT NULL, CHANGE parentid parentid BIGINT NOT NULL -> ALTER TABLE mshop_order_product ADD CONSTRAINT fk_msordpr_parentid FOREIGN KEY (parentid) REFERENCES mshop_order (id) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX unq_msordpr_pid_pos ON mshop_order_product (parentid, pos) -> CREATE INDEX idx_msordpr_pid_prid ON mshop_order_product (parentid, prodid) -> CREATE INDEX idx_msordpr_pid_pcd ON mshop_order_product (parentid, prodcode) -> CREATE INDEX idx_msordpr_pid_qtyo ON mshop_order_product (parentid, qtyopen) -> CREATE INDEX idx_msordpr_ct_prid_pid ON mshop_order_product (ctime, prodid, parentid) -> CREATE INDEX fk_msordpr_parentid ON mshop_order_product (parentid) -> ALTER TABLE mshop_order_service CHANGE price price NUMERIC(12, 2) DEFAULT '0', CHANGE parentid parentid BIGINT NOT NULL -> ALTER TABLE mshop_order_service ADD CONSTRAINT fk_msordse_parentid FOREIGN KEY (parentid) REFERENCES mshop_order (id) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX unq_msordse_pid_type_pos ON mshop_order_service (parentid, type, pos) -> CREATE INDEX idx_msordse_code_type_sid ON mshop_order_service (code, type, siteid) -> CREATE INDEX fk_msordse_parentid ON mshop_order_service (parentid) -> ALTER TABLE mshop_order_coupon CHANGE parentid parentid BIGINT NOT NULL -> ALTER TABLE mshop_order_coupon ADD CONSTRAINT fk_msordco_parentid FOREIGN KEY (parentid) REFERENCES mshop_order (id) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE INDEX idx_msordco_pid_code ON mshop_order_coupon (parentid, code) -> CREATE INDEX fk_msordco_parentid ON mshop_order_coupon (parentid) Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php (1936.44ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Plugin.php Creating plugin schema -> ALTER TABLE mshop_plugin CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_plugin_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Plugin.php (139.57ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Queue.php Creating queue schema Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Queue.php (88.76ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Review.php Creating review schema -> ALTER TABLE mshop_review CHANGE comment comment TEXT DEFAULT '' NOT NULL, CHANGE response response TEXT DEFAULT '' NOT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Review.php (98.45ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Rule.php Creating rule schema -> ALTER TABLE mshop_rule CHANGE config config TEXT DEFAULT NULL -> ALTER TABLE mshop_rule_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Rule.php (141.99ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockMigrateProductId.php Migrate product code to product ID in stock table Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockMigrateProductId.php (258.51ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Stock.php Creating stock schema -> ALTER TABLE mshop_stock CHANGE stocklevel stocklevel DOUBLE PRECISION DEFAULT '0' -> ALTER TABLE mshop_stock_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Stock.php (208.22ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Subscription.php Creating subscription schema -> ALTER TABLE mshop_subscription CHANGE next next DATETIME DEFAULT NULL, CHANGE end end DATETIME DEFAULT NULL -> CREATE INDEX idx_mssub_oid ON mshop_subscription (orderid) Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Subscription.php (141.57ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Tag.php Creating tag schema -> ALTER TABLE mshop_tag_type ADD i18n TEXT DEFAULT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Tag.php (100.51ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Locale.php Creating locale schema -> ALTER TABLE mshop_locale_site CHANGE config config TEXT DEFAULT NULL, CHANGE rating rating NUMERIC(4, 2) DEFAULT '0' NOT NULL Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Locale.php (467.13ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php Add locale data for languages and currencies Adding data for MShop locale languages Adding data for MShop locale currencies Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (98.41ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/LocaleCreateSite.php Create site and locale Adding data for MShop locale sites Adding data for MShop locales Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/LocaleCreateSite.php (89.5ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php Adding data for MShop locale domain Adding data for MShop locale sites Adding data for MShop locales Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (95.17ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMergeBaseTable.php -> ALTER TABLE mshop_order DROP FOREIGN KEY fk_msord_baseid -> ALTER TABLE mshop_order DROP baseid Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMergeBaseTable.php (843.48ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleData.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleData.php (83.7ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopSetLocale.php Setting locale to "default" Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopSetLocale.php (90.11ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php Processing catalog demo data Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php (199.05ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCouponData.php Processing coupon demo data Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCouponData.php (100.01ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php Migrated: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php (82.91ms) Migrating: /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddTypeDataDefault.php Adding MShop type data for site "default" Checking "attribute/type" type data PHP Runtime Deprecation Notice: json_decode(): Passing null to parameter #1 ($json) of type string is deprecated in /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Base.php line 382 #0 [internal function]: TYPO3\CMS\Core\Error\ErrorHandler->handleError(8192, 'json_decode(): ...', '/var/www/html/t...', 382) #1 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Base.php(382): json_decode(NULL, true) #2 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Depth.php(58): Aimeos\MShop\Common\Manager\Base->search(Object(Aimeos\Base\Criteria\SQL), Array, NULL) #3 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Lazy.php(38): Aimeos\MShop\Common\Manager\Decorator\Depth->search(Object(Aimeos\Base\Criteria\SQL), Array, NULL) #4 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/map/src/Map.php(5533): Aimeos\MShop\Common\Manager\Decorator\Lazy->Aimeos\MShop\Common\Manager\Decorator{closure}() #5 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/map/src/Map.php(1695): Aimeos\Map->array(Object(Closure)) #6 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php(74): Aimeos\Map->getIterator() #7 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php(95): Aimeos\Upscheme\Task\MShopAddTypeData->existing('attribute/type', Array) #8 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php(53): Aimeos\Upscheme\Task\MShopAddTypeData->update(Array) #9 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddTypeDataDefault.php(30): Aimeos\Upscheme\Task\MShopAddTypeData->add() #10 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(341): Aimeos\Upscheme\Task\MShopAddTypeDataDefault->up() #11 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #12 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(172): Aimeos\Upscheme\Up->runTasks(Array) #13 /var/www/html/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/Setup.php(84): Aimeos\Upscheme\Up->up() #14 /var/www/html/typo3/typo3conf/ext/aimeos/Classes/Setup.php(148): Aimeos\Setup->up('default', 'default') #15 /var/www/html/typo3/typo3conf/ext/aimeos/Classes/Setup.php(77): Aimeos\Aimeos\Setup::execute() #16 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Service/UpgradeWizardsService.php(275): Aimeos\Aimeos\Setup->executeUpdate() #17 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Controller/UpgradeController.php(1099): TYPO3\CMS\Install\Service\UpgradeWizardsService->executeWizard('aimeos', Array) #18 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Middleware/Maintenance.php(234): TYPO3\CMS\Install\Controller\UpgradeController->upgradeWizardsExecuteAction(Object(TYPO3\CMS\Core\Http\ServerRequest)) #19 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(111): TYPO3\CMS\Install\Middleware\Maintenance->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #20 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Middleware/NormalizedParamsAttribute.php(41): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #21 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #22 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(70): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #23 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/AbstractApplication.php(80): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #24 /var/www/html/typo3_src-12.4.20/typo3/sysext/install/Classes/Http/Application.php(46): TYPO3\CMS\Core\Http\AbstractApplication->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #25 /var/www/html/typo3_src-12.4.20/typo3/sysext/core/Classes/Http/AbstractApplication.php(92): TYPO3\CMS\Install\Http\Application->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #26 /var/www/html/typo3_src-12.4.20/typo3/install.php(19): TYPO3\CMS\Core\Http\AbstractApplication->run() #27 /var/www/html/typo3_src-12.4.20/typo3/install.php(20): {closure}() #28 {main}

aimeos commented 4 days ago

Thanks for the info! Both problems has been fixed in aimeos/aimeos-core 2024.10.x-dev and will be part of the next release. You can test the changes yourself after executing composer req aimeos/aimeos-core:2024.10.x-dev in the meantime.

nollm commented 4 days ago

I use a legacy Typo3 installation. How can I create the extension by myself?

aimeos commented 4 days ago

Checkout the aimeos/aimeos-typo3 repo, switch branch using git checkout 2024.10, install phing (https://www.phing.info/) and run phing deploy

nollm commented 4 days ago

Thank you for the explanation. I was able to create a version by myself. But it seems that the fixes in aimeos-core won't be there. For example this line is missing https://github.com/aimeos/aimeos-core/commit/3eea7b39f2409cce10eb3805af46f6b06c86e16e Do I forgot something?

aimeos commented 4 days ago

Don't forget to execute composer req aimeos/aimeos-core:2024.10.x-dev

nollm commented 1 day ago

Ok, I got the upgrade wizard working.

But only if I use the official 24.10.1 and change this line https://github.com/aimeos/aimeos-core/commit/4b308e9031cfd02ce66cd783d409a67e2cfaa9a8 and remove the index unq_msordbase_sid_bid_cd_typ in this line https://github.com/aimeos/aimeos-core/blob/2024.10/setup/OrderConnectTables.php#L118 With the current 2024.10.x-dev branch I got the exception from the beginning that baseid cannot be removed.

aimeos commented 1 day ago

OK, will be both part of the next release