Upgrade aimeos from 22.10.9 to 23.10.3

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Post Reply
robert63
Posts: 43
Joined: 03 Nov 2021, 13:38

Upgrade aimeos from 22.10.9 to 23.10.3

Post by robert63 » 08 Oct 2024, 09:55

Upgrading from Typo3 11.5.34 to 12.4.20. Aimeos_dist 22.10.1 to 23.7.1., php is 8.3 on both, Linux is Ubuntu 20.04.6 LTS

When I do the Upgrade wizard on the source system it comes back green and successful but on the new system it comes back with an update failed:

Update failed!
Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php Migrate type columns Add new type columns Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Drop old unique indexes Checking index "unq_msattr_sid_dom_cod_tid": Checking index "unq_msattli_sid_dm_rid_tid_pid": Checking index "unq_msattpr_sid_tid_lid_value": Checking index "unq_mscatli_sid_dm_rid_tid_pid": Checking index "unq_mscusli_sid_dm_rid_tid_pid": Checking index "unq_mcuspr_sid_tid_lid_value": Checking index "unq_msmedli_sid_dm_rid_tid_pid": Checking index "unq_msmedpr_sid_tid_lid_value": Checking index "unq_msplu_sid_tid_prov": Checking index "unq_msprili_sid_dm_rid_tid_pid": Checking index "unq_msproli_sid_dm_rid_tid_pid": Checking index "unq_mspropr_sid_tid_lid_value": Checking index "unq_msserli_sid_dm_rid_tid_pid": Checking index "unq_mssto_sid_pcode_tid": Checking index "unq_mssupli_sid_dm_rid_tid_pid": Checking index "unq_mstag_sid_dom_tid_lid_lab": Checking index "unq_mstexli_sid_dm_rid_tid_pid": Migrate typeid to type Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Drop typeid columns Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php (1172.52ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (21.62ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (21.49ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (25.71ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (22.58ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (21.6ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php Migrate typeid to type for TYPO3 Add new type columns for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Drop old unique indexes for TYPO3 Checking index "unq_t3feuli_sid_dm_rid_tid_pid": Checking index "unq_t3feupr_sid_tid_lid_value": Migrate typeid to type for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Drop typeid columns for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (107.54ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Attribute.php (28.79ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (472.79ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (42.98ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (70.1ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Cache.php Creating cache schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Cache.php (22.52ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Catalog.php (23.66ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (304.74ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (72.93ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (25.3ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (92.08ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Coupon.php (27.42ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (250.76ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php Remove left over TYPO3 fe_users references Remove records from fe_users_address Remove records from fe_users_list Remove records from fe_users_property Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (29.67ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (22.94ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Customer.php Creating customer schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Customer.php (24.02ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Media.php Creating media schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Media.php (24.1ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Price.php Creating price schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Price.php (27.12ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Product.php Creating product schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Product.php (24.19ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (91.01ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (25.5ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Service.php Creating service schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Service.php (22.57ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Supplier.php (23.43ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Text.php Creating text schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Text.php (52.26ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/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: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (604.98ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (79.71ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (77.08ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (607.27ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (487.29ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Log.php Creating log schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Log.php (22.9ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (22.09ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (27.08ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (23.14ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Locale.php Creating locale schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/Locale.php (117.05ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/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: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (46.12ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php Adding data for MShop locale domain Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (29.63ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php Adding currency ID to order base product table An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'baseid' in 'where clause' #0 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/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 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/doctrine/dbal/src/Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/doctrine/dbal/src/Connection.php(1213): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), '\n\t\t\tUPDATE msho...', Array, Array) #3 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Schema/DB.php(267): Doctrine\DBAL\Connection->executeStatement('\n\t\t\tUPDATE msho...', Array, Array) #4 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php(30): Aimeos\Upscheme\Schema\DB->exec('\n\t\t\tUPDATE msho...') #5 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\Upscheme\Task\OrderAddBaseProductCurrencyid->up() #6 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #7 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #8 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #9 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #10 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks(Array, Array) #11 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\Upscheme\Up->runTasks(Array) #12 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\Upscheme\Up->up() #13 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-typo3/Classes/Setup.php(148): Aimeos\Setup->up('default', 'default') #14 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/aimeos/aimeos-typo3/Classes/Setup.php(77): Aimeos\Aimeos\Setup::execute() #15 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-install/Classes/Service/UpgradeWizardsService.php(275): Aimeos\Aimeos\Setup->executeUpdate() #16 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-install/Classes/Controller/UpgradeController.php(1099): TYPO3\CMS\Install\Service\UpgradeWizardsService->executeWizard('aimeos', Array) #17 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-install/Classes/Middleware/Maintenance.php(234): TYPO3\CMS\Install\Controller\UpgradeController->upgradeWizardsExecuteAction(Object(TYPO3\CMS\Core\Http\ServerRequest)) #18 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(111): TYPO3\CMS\Install\Middleware\Maintenance->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #19 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-core/Classes/Middleware/NormalizedParamsAttribute.php(41): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #20 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #21 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(70): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #22 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php(80): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #23 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-install/Classes/Http/Application.php(46): TYPO3\CMS\Core\Http\AbstractApplication->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #24 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php(92): TYPO3\CMS\Install\Http\Application->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #25 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/public/typo3/install.php(19): TYPO3\CMS\Core\Http\AbstractApplication->run() #26 /www/htdocs/w01c5b44/criollo-crzvd.de_v12/public/typo3/install.php(20): {closure}() #27 {main}


How can I solve this?
Top
User avatar
aimeos
Administrator
Posts: 8387
Joined: 01 Jan 1970, 00:00

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by aimeos » 08 Oct 2024, 11:35

Can you please check if these two changes solves the issue?
https://github.com/aimeos/aimeos-core/c ... 4f2a20ef55
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
robert63
Posts: 43
Joined: 03 Nov 2021, 13:38

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by robert63 » 08 Oct 2024, 11:45

No, it is still the same.
Top
User avatar
aimeos
Administrator
Posts: 8387
Joined: 01 Jan 1970, 00:00

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by aimeos » 08 Oct 2024, 12:05

Can you post the create statements of the mshop_order* tables? Use "SHOW CREATE TABLE mshop_order", "SHOW CREATE TABLE mshop_order_base", etc.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
robert63
Posts: 43
Joined: 03 Nov 2021, 13:38

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by robert63 » 08 Oct 2024, 12:21

Here it is:
-- phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Erstellungszeit: 08. Okt 2024 um 14:19
-- Server-Version: 10.5.26-MariaDB-ubu2004-log
-- PHP-Version: 7.4.33-nmm5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Datenbank: `d0419711`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order`
--

CREATE TABLE `mshop_order` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`baseid` bigint(20) NOT NULL,
`relatedid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`channel` varchar(16) NOT NULL DEFAULT '',
`invoiceno` varchar(32) NOT NULL DEFAULT '',
`datepayment` datetime DEFAULT NULL,
`datedelivery` datetime DEFAULT NULL,
`statuspayment` smallint(6) NOT NULL DEFAULT -1,
`statusdelivery` smallint(6) NOT NULL DEFAULT -1,
`cdate` varchar(10) NOT NULL DEFAULT '',
`cmonth` varchar(7) NOT NULL DEFAULT '',
`cweek` varchar(7) NOT NULL DEFAULT '',
`cwday` varchar(1) NOT NULL DEFAULT '',
`chour` varchar(2) NOT NULL DEFAULT '',
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_address`
--

CREATE TABLE `mshop_order_address` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`addrid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`salutation` varchar(8) NOT NULL DEFAULT '',
`company` varchar(100) NOT NULL DEFAULT '',
`vatid` varchar(32) NOT NULL DEFAULT '',
`title` varchar(64) NOT NULL DEFAULT '',
`firstname` varchar(64) NOT NULL DEFAULT '',
`lastname` varchar(64) NOT NULL DEFAULT '',
`address1` varchar(200) NOT NULL DEFAULT '',
`address2` varchar(200) NOT NULL DEFAULT '',
`address3` varchar(200) NOT NULL DEFAULT '',
`postal` varchar(16) NOT NULL DEFAULT '',
`city` varchar(200) NOT NULL DEFAULT '',
`state` varchar(200) NOT NULL DEFAULT '',
`langid` varchar(5) DEFAULT NULL,
`countryid` varchar(2) DEFAULT NULL,
`telephone` varchar(32) NOT NULL DEFAULT '',
`telefax` varchar(32) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`website` varchar(255) NOT NULL DEFAULT '',
`longitude` double DEFAULT 0,
`latitude` double DEFAULT 0,
`birthday` date DEFAULT NULL,
`pos` int(11) NOT NULL DEFAULT 0,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL,
`mobile` varchar(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_base`
--

CREATE TABLE `mshop_order_base` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`customerid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`sitecode` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`langid` varchar(5) NOT NULL,
`currencyid` varchar(3) NOT NULL,
`price` decimal(12,2) NOT NULL DEFAULT 0.00,
`costs` decimal(12,2) NOT NULL DEFAULT 0.00,
`rebate` decimal(12,2) NOT NULL DEFAULT 0.00,
`tax` decimal(14,4) NOT NULL DEFAULT 0.0000,
`taxflag` smallint(6) NOT NULL DEFAULT 1,
`customerref` varchar(255) NOT NULL DEFAULT '',
`comment` text NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_base_address`
--

CREATE TABLE `mshop_order_base_address` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`addrid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`salutation` varchar(8) NOT NULL DEFAULT '',
`company` varchar(100) NOT NULL DEFAULT '',
`vatid` varchar(32) NOT NULL DEFAULT '',
`title` varchar(64) NOT NULL DEFAULT '',
`firstname` varchar(64) NOT NULL DEFAULT '',
`lastname` varchar(64) NOT NULL DEFAULT '',
`address1` varchar(200) NOT NULL DEFAULT '',
`address2` varchar(200) NOT NULL DEFAULT '',
`address3` varchar(200) NOT NULL DEFAULT '',
`postal` varchar(16) NOT NULL DEFAULT '',
`city` varchar(200) NOT NULL DEFAULT '',
`state` varchar(200) NOT NULL DEFAULT '',
`langid` varchar(5) DEFAULT NULL,
`countryid` varchar(2) DEFAULT NULL,
`telephone` varchar(32) NOT NULL DEFAULT '',
`telefax` varchar(32) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`website` varchar(255) NOT NULL DEFAULT '',
`longitude` double DEFAULT 0,
`latitude` double DEFAULT 0,
`birthday` date DEFAULT NULL,
`pos` int(11) NOT NULL DEFAULT 0,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_base_coupon`
--

CREATE TABLE `mshop_order_base_coupon` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`ordprodid` bigint(20) DEFAULT NULL,
`code` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_base_product`
--

CREATE TABLE `mshop_order_base_product` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`ordprodid` bigint(20) DEFAULT NULL,
`ordaddrid` bigint(20) DEFAULT NULL,
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`prodid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`parentprodid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`prodcode` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`stocktype` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'default',
`vendor` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`description` text NOT NULL,
`mediaurl` varchar(255) NOT NULL DEFAULT '',
`target` varchar(255) NOT NULL DEFAULT '',
`timeframe` varchar(16) NOT NULL DEFAULT '',
`quantity` double NOT NULL DEFAULT 1,
`qtyopen` double NOT NULL DEFAULT 0,
`scale` double NOT NULL DEFAULT 1,
`currencyid` varchar(3) NOT NULL,
`price` decimal(12,2) DEFAULT 0.00,
`costs` decimal(12,2) NOT NULL DEFAULT 0.00,
`rebate` decimal(12,2) NOT NULL DEFAULT 0.00,
`tax` decimal(14,4) NOT NULL DEFAULT 0.0000,
`taxrate` varchar(255) NOT NULL DEFAULT '{}',
`taxflag` smallint(6) NOT NULL DEFAULT 1,
`flags` int(11) NOT NULL DEFAULT 0,
`pos` int(11) NOT NULL DEFAULT 0,
`statuspayment` smallint(6) NOT NULL DEFAULT -1,
`statusdelivery` smallint(6) NOT NULL DEFAULT -1,
`notes` text NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_base_product_attr`
--

CREATE TABLE `mshop_order_base_product_attr` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL,
`attrid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`quantity` double NOT NULL DEFAULT 1,
`price` decimal(12,2) DEFAULT 0.00,
`name` varchar(255) NOT NULL DEFAULT '',
`value` text NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_base_service`
--

CREATE TABLE `mshop_order_base_service` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`servid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`code` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`mediaurl` varchar(255) NOT NULL DEFAULT '',
`currencyid` varchar(3) NOT NULL,
`price` decimal(12,2) DEFAULT 0.00,
`costs` decimal(12,2) NOT NULL DEFAULT 0.00,
`rebate` decimal(12,2) NOT NULL DEFAULT 0.00,
`tax` decimal(14,4) NOT NULL DEFAULT 0.0000,
`taxrate` varchar(255) NOT NULL DEFAULT '{}',
`taxflag` smallint(6) NOT NULL DEFAULT 1,
`pos` int(11) NOT NULL DEFAULT 0,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_base_service_attr`
--

CREATE TABLE `mshop_order_base_service_attr` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL,
`attrid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`quantity` double NOT NULL DEFAULT 1,
`price` decimal(12,2) DEFAULT 0.00,
`name` varchar(255) NOT NULL DEFAULT '',
`value` text NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_basket`
--

CREATE TABLE `mshop_order_basket` (
`id` varchar(255) NOT NULL,
`siteid` varchar(255) NOT NULL,
`customerid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`content` mediumtext NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_coupon`
--

CREATE TABLE `mshop_order_coupon` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`ordprodid` bigint(20) DEFAULT NULL,
`code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_product`
--

CREATE TABLE `mshop_order_product` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`ordprodid` bigint(20) DEFAULT NULL,
`ordaddrid` bigint(20) DEFAULT NULL,
`type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`prodid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`parentprodid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`prodcode` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`stocktype` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'default',
`vendor` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`description` text NOT NULL DEFAULT '',
`mediaurl` varchar(255) NOT NULL DEFAULT '',
`target` varchar(255) NOT NULL DEFAULT '',
`timeframe` varchar(16) NOT NULL DEFAULT '',
`quantity` double NOT NULL DEFAULT 1,
`qtyopen` double NOT NULL DEFAULT 0,
`scale` double NOT NULL DEFAULT 1,
`currencyid` varchar(3) NOT NULL,
`price` decimal(12,2) DEFAULT 0.00,
`costs` decimal(12,2) NOT NULL DEFAULT 0.00,
`rebate` decimal(12,2) NOT NULL DEFAULT 0.00,
`tax` decimal(14,4) NOT NULL DEFAULT 0.0000,
`taxrate` varchar(255) NOT NULL DEFAULT '{}',
`taxflag` smallint(6) NOT NULL DEFAULT 1,
`flags` int(11) NOT NULL DEFAULT 0,
`pos` int(11) NOT NULL DEFAULT 0,
`statuspayment` smallint(6) NOT NULL DEFAULT -1,
`statusdelivery` smallint(6) NOT NULL DEFAULT -1,
`notes` text NOT NULL DEFAULT '',
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_product_attr`
--

CREATE TABLE `mshop_order_product_attr` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL,
`attrid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`quantity` double NOT NULL DEFAULT 1,
`price` decimal(12,2) DEFAULT 0.00,
`name` varchar(255) NOT NULL DEFAULT '',
`value` text NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_service`
--

CREATE TABLE `mshop_order_service` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`servid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`mediaurl` varchar(255) NOT NULL DEFAULT '',
`currencyid` varchar(3) NOT NULL,
`price` decimal(12,2) DEFAULT 0.00,
`costs` decimal(12,2) NOT NULL DEFAULT 0.00,
`rebate` decimal(12,2) NOT NULL DEFAULT 0.00,
`tax` decimal(14,4) NOT NULL DEFAULT 0.0000,
`taxrate` varchar(255) NOT NULL DEFAULT '{}',
`taxflag` smallint(6) NOT NULL DEFAULT 1,
`pos` int(11) NOT NULL DEFAULT 0,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_service_attr`
--

CREATE TABLE `mshop_order_service_attr` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL,
`attrid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`quantity` double NOT NULL DEFAULT 1,
`price` decimal(12,2) DEFAULT 0.00,
`name` varchar(255) NOT NULL DEFAULT '',
`value` text NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_service_tx`
--

CREATE TABLE `mshop_order_service_tx` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL,
`type` varchar(16) NOT NULL DEFAULT '',
`currencyid` varchar(3) NOT NULL,
`price` decimal(12,2) NOT NULL DEFAULT 0.00,
`costs` decimal(12,2) NOT NULL DEFAULT 0.00,
`rebate` decimal(12,2) NOT NULL DEFAULT 0.00,
`tax` decimal(14,4) NOT NULL DEFAULT 0.0000,
`taxflag` smallint(6) NOT NULL DEFAULT 1,
`status` smallint(6) NOT NULL DEFAULT -1,
`config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mshop_order_status`
--

CREATE TABLE `mshop_order_status` (
`id` bigint(20) NOT NULL,
`siteid` varchar(255) NOT NULL,
`parentid` bigint(20) NOT NULL,
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`value` varchar(64) NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `mshop_order`
--
ALTER TABLE `mshop_order`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_msord_channel_sid` (`channel`,`siteid`),
ADD KEY `idx_msord_ctime_pstat_sid` (`ctime`,`statuspayment`,`siteid`),
ADD KEY `idx_msord_mtime_pstat_sid` (`mtime`,`statuspayment`,`siteid`),
ADD KEY `idx_msord_mtime_dstat_sid` (`mtime`,`statusdelivery`,`siteid`),
ADD KEY `idx_msord_dstat_sid` (`statusdelivery`,`siteid`),
ADD KEY `idx_msord_ddate_sid` (`datedelivery`,`siteid`),
ADD KEY `idx_msord_pdate_sid` (`datepayment`,`siteid`),
ADD KEY `idx_msord_editor_sid` (`editor`,`siteid`),
ADD KEY `idx_msord_cdate_sid` (`cdate`,`siteid`),
ADD KEY `idx_msord_cmonth_sid` (`cmonth`,`siteid`),
ADD KEY `idx_msord_cweek_sid` (`cweek`,`siteid`),
ADD KEY `idx_msord_cwday_sid` (`cwday`,`siteid`),
ADD KEY `idx_msord_chour_sid` (`chour`,`siteid`),
ADD KEY `fk_msord_baseid` (`baseid`);

--
-- Indizes für die Tabelle `mshop_order_address`
--
ALTER TABLE `mshop_order_address`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unq_msordad_pid_type` (`parentid`,`type`),
ADD KEY `idx_msordad_pid_lname` (`parentid`,`lastname`),
ADD KEY `idx_msordad_pid_addr1` (`parentid`,`address1`),
ADD KEY `idx_msordad_pid_postal` (`parentid`,`postal`),
ADD KEY `idx_msordad_pid_city` (`parentid`,`city`),
ADD KEY `idx_msordad_pid_email` (`parentid`,`email`),
ADD KEY `fk_msordad_parentid` (`parentid`);

--
-- Indizes für die Tabelle `mshop_order_base`
--
ALTER TABLE `mshop_order_base`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_msordba_custid_scode` (`customerid`,`sitecode`),
ADD KEY `idx_msordba_custid_sid` (`customerid`,`siteid`),
ADD KEY `idx_msordba_ctime_sid` (`ctime`,`siteid`);

--
-- Indizes für die Tabelle `mshop_order_base_address`
--
ALTER TABLE `mshop_order_base_address`
ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `mshop_order_base_coupon`
--
ALTER TABLE `mshop_order_base_coupon`
ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `mshop_order_base_product`
--
ALTER TABLE `mshop_order_base_product`
ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `mshop_order_base_product_attr`
--
ALTER TABLE `mshop_order_base_product_attr`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_msordbaprat_parentid` (`parentid`);

--
-- Indizes für die Tabelle `mshop_order_base_service`
--
ALTER TABLE `mshop_order_base_service`
ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `mshop_order_base_service_attr`
--
ALTER TABLE `mshop_order_base_service_attr`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_msordbaseat_parentid` (`parentid`);

--
-- Indizes für die Tabelle `mshop_order_basket`
--
ALTER TABLE `mshop_order_basket`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_msordca_custid` (`customerid`),
ADD KEY `idx_msordca_mtime` (`mtime`);

--
-- Indizes für die Tabelle `mshop_order_coupon`
--
ALTER TABLE `mshop_order_coupon`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_msordco_pid_code` (`parentid`,`code`),
ADD KEY `fk_msordco_parentid` (`parentid`);

--
-- Indizes für die Tabelle `mshop_order_product`
--
ALTER TABLE `mshop_order_product`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unq_msordpr_pid_pos` (`parentid`,`pos`),
ADD KEY `idx_msordpr_pid_prid` (`parentid`,`prodid`),
ADD KEY `idx_msordpr_pid_pcd` (`parentid`,`prodcode`),
ADD KEY `idx_msordpr_pid_qtyo` (`parentid`,`qtyopen`),
ADD KEY `idx_msordpr_ct_prid_pid` (`ctime`,`prodid`,`parentid`),
ADD KEY `fk_msordpr_parentid` (`parentid`);

--
-- Indizes für die Tabelle `mshop_order_product_attr`
--
ALTER TABLE `mshop_order_product_attr`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unq_msordprat_pid_aid_ty_cd` (`parentid`,`attrid`,`type`,`code`),
ADD KEY `fk_msordbaprat_parentid` (`parentid`),
ADD KEY `fk_msordprat_parentid` (`parentid`),
ADD KEY `idx_msordprat_si_cd_va` (`siteid`,`code`,`value`(16));

--
-- Indizes für die Tabelle `mshop_order_service`
--
ALTER TABLE `mshop_order_service`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unq_msordse_pid_cd_typ_sid` (`parentid`,`code`,`type`,`siteid`),
ADD KEY `idx_msordse_code_type_sid` (`code`,`type`,`siteid`),
ADD KEY `fk_msordse_parentid` (`parentid`);

--
-- Indizes für die Tabelle `mshop_order_service_attr`
--
ALTER TABLE `mshop_order_service_attr`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unq_msordseat_pid_aid_ty_cd` (`parentid`,`attrid`,`type`,`code`),
ADD KEY `fk_msordbaseat_parentid` (`parentid`),
ADD KEY `fk_msordseat_parentid` (`parentid`),
ADD KEY `idx_msordseat_si_cd_va` (`siteid`,`code`,`value`(16));

--
-- Indizes für die Tabelle `mshop_order_service_tx`
--
ALTER TABLE `mshop_order_service_tx`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_msordsetx_parentid` (`parentid`);

--
-- Indizes für die Tabelle `mshop_order_status`
--
ALTER TABLE `mshop_order_status`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_msordst_pid_typ_val_sid` (`parentid`,`type`,`value`,`siteid`),
ADD KEY `fk_msordst_pid` (`parentid`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `mshop_order`
--
ALTER TABLE `mshop_order`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_address`
--
ALTER TABLE `mshop_order_address`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_base`
--
ALTER TABLE `mshop_order_base`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_base_address`
--
ALTER TABLE `mshop_order_base_address`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_base_coupon`
--
ALTER TABLE `mshop_order_base_coupon`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_base_product`
--
ALTER TABLE `mshop_order_base_product`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_base_product_attr`
--
ALTER TABLE `mshop_order_base_product_attr`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_base_service`
--
ALTER TABLE `mshop_order_base_service`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_base_service_attr`
--
ALTER TABLE `mshop_order_base_service_attr`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_coupon`
--
ALTER TABLE `mshop_order_coupon`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_product`
--
ALTER TABLE `mshop_order_product`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_product_attr`
--
ALTER TABLE `mshop_order_product_attr`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_service`
--
ALTER TABLE `mshop_order_service`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_service_attr`
--
ALTER TABLE `mshop_order_service_attr`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_service_tx`
--
ALTER TABLE `mshop_order_service_tx`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `mshop_order_status`
--
ALTER TABLE `mshop_order_status`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `mshop_order`
--
ALTER TABLE `mshop_order`
ADD CONSTRAINT `fk_msord_baseid` FOREIGN KEY (`baseid`) REFERENCES `mshop_order_base` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_address`
--
ALTER TABLE `mshop_order_address`
ADD CONSTRAINT `fk_msordad_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_coupon`
--
ALTER TABLE `mshop_order_coupon`
ADD CONSTRAINT `fk_msordco_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_product`
--
ALTER TABLE `mshop_order_product`
ADD CONSTRAINT `fk_msordpr_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_product_attr`
--
ALTER TABLE `mshop_order_product_attr`
ADD CONSTRAINT `fk_msordprat_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_service`
--
ALTER TABLE `mshop_order_service`
ADD CONSTRAINT `fk_msordse_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_service_attr`
--
ALTER TABLE `mshop_order_service_attr`
ADD CONSTRAINT `fk_msordseat_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order_service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_service_tx`
--
ALTER TABLE `mshop_order_service_tx`
ADD CONSTRAINT `fk_msordsetx_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order_service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `mshop_order_status`
--
ALTER TABLE `mshop_order_status`
ADD CONSTRAINT `fk_msordst_pid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;
Top
User avatar
aimeos
Administrator
Posts: 8387
Joined: 01 Jan 1970, 00:00

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by aimeos » 08 Oct 2024, 12:31

It seems like a previous upgrade already failed and this is a subsequent error. Can you restore the original 2022.10 database and run "./vendor/bin/typo3 aimeos:setup" from the command line? If there's any error, please post the output.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
robert63
Posts: 43
Joined: 03 Nov 2021, 13:38

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by robert63 » 08 Oct 2024, 12:38

Sorry, but the previous system is without composer. How shall I run it then?
Top
User avatar
aimeos
Administrator
Posts: 8387
Joined: 01 Jan 1970, 00:00

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by aimeos » 08 Oct 2024, 12:46

OK, then use the upgrade wizard again
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
robert63
Posts: 43
Joined: 03 Nov 2021, 13:38

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by robert63 » 08 Oct 2024, 13:02

The upgrade wizard in the previous system says:
Update successful
Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TypesMigrateColumns.php Migrate type columns Add new type columns Checking table "mshop_attribute": -> ALTER TABLE mshop_attribute CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_attribute_list": -> ALTER TABLE mshop_attribute_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_attribute_property": -> ALTER TABLE mshop_attribute_property CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_catalog_list": -> ALTER TABLE mshop_catalog_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_customer_list": -> ALTER TABLE mshop_customer_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_customer_property": -> ALTER TABLE mshop_customer_property CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_media": -> ALTER TABLE mshop_media CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_media_list": -> ALTER TABLE mshop_media_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_media_property": -> ALTER TABLE mshop_media_property CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_plugin": -> ALTER TABLE mshop_plugin CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_price": -> ALTER TABLE mshop_price CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_price_list": -> ALTER TABLE mshop_price_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_product": -> ALTER TABLE mshop_product CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_product_list": -> ALTER TABLE mshop_product_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_product_property": -> ALTER TABLE mshop_product_property CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_service": -> ALTER TABLE mshop_service CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_service_list": -> ALTER TABLE mshop_service_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_stock": -> ALTER TABLE mshop_stock CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_supplier_list": -> ALTER TABLE mshop_supplier_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_tag": -> ALTER TABLE mshop_tag CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_text": -> ALTER TABLE mshop_text CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_text_list": -> ALTER TABLE mshop_text_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Drop old unique indexes Checking index "unq_msattr_sid_dom_cod_tid": Checking index "unq_msattli_sid_dm_rid_tid_pid": Checking index "unq_msattpr_sid_tid_lid_value": Checking index "unq_mscatli_sid_dm_rid_tid_pid": Checking index "unq_mscusli_sid_dm_rid_tid_pid": Checking index "unq_mcuspr_sid_tid_lid_value": Checking index "unq_msmedli_sid_dm_rid_tid_pid": Checking index "unq_msmedpr_sid_tid_lid_value": Checking index "unq_msplu_sid_tid_prov": Checking index "unq_msprili_sid_dm_rid_tid_pid": Checking index "unq_msproli_sid_dm_rid_tid_pid": Checking index "unq_mspropr_sid_tid_lid_value": Checking index "unq_msserli_sid_dm_rid_tid_pid": Checking index "unq_mssto_sid_pcode_tid": Checking index "unq_mssupli_sid_dm_rid_tid_pid": Checking index "unq_mstag_sid_dom_tid_lid_lab": Checking index "unq_mstexli_sid_dm_rid_tid_pid": Migrate typeid to type Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Drop typeid columns Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TypesMigrateColumns.php (899.19ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php (16.5ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (15.43ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (15.5ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (16.62ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (15.71ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php Migrate typeid to type for TYPO3 Add new type columns for TYPO3 Checking table "fe_users_list": -> ALTER TABLE fe_users_list CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "fe_users_property": -> ALTER TABLE fe_users_property CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Drop old unique indexes for TYPO3 Checking index "unq_t3feuli_sid_dm_rid_tid_pid": Checking index "unq_t3feupr_sid_tid_lid_value": Migrate typeid to type for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Drop typeid columns for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (86.79ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema -> ALTER TABLE mshop_attribute CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_attribute_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_attribute_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_attribute_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_attribute_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php (29.61ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (323.5ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (28.99ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (43.59ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php Creating cache schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php (15.33ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema -> ALTER TABLE mshop_catalog CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_catalog_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_catalog_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php (27.71ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (204.83ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (49.99ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (21.14ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (56.03ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema -> ALTER TABLE mshop_coupon_code CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE ref ref VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php (22.29ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (168.93ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php Remove left over TYPO3 fe_users references Remove records from fe_users_address Remove records from fe_users_list Remove records from fe_users_property Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (23.46ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (21.09ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php Creating customer schema -> ALTER TABLE fe_users_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE fe_users_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE fe_users_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_customer_group CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_customer_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_customer_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_customer_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php (34.11ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php Creating media schema -> ALTER TABLE mshop_media_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_media_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_media_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_media_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php (28.52ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php Creating price schema -> ALTER TABLE mshop_price_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_price_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_price_property CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_price_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_price_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php (29.72ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php Creating product schema -> ALTER TABLE mshop_product CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_product_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_product_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_product_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_product_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php (30.41ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (57.54ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php (22.67ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php Creating service schema -> ALTER TABLE mshop_service CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_service_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_service_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_service_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php (29.91ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema -> ALTER TABLE mshop_supplier CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_supplier_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_supplier_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php (27.7ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php Creating text schema -> ALTER TABLE mshop_text_list CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_text_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_text_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php (41.68ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/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: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (469.66ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (55.25ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (51.27ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (410.65ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (356.84ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php (15.29ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (16.19ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (16.42ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Locale.php Creating locale schema -> ALTER TABLE mshop_locale_site CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Locale.php (99.32ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/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: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (34.07ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php Creating log schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php (29.4ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php Adding data for MShop locale domain Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (21.99ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleData.php Adding locale data if not yet present Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleData.php (29.47ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopSetLocale.php Setting locale to "default" Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopSetLocale.php (18.38ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php Processing catalog demo data Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php (15.21ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCouponData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCouponData.php (17ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Plugin.php Creating plugin schema -> ALTER TABLE mshop_plugin_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Plugin.php (19.12ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Rule.php Creating rule schema -> ALTER TABLE mshop_rule CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_rule_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Rule.php (19.58ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockMigrateProductId.php Migrate product code to product ID in stock table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockMigrateProductId.php (46.26ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Stock.php Creating stock schema -> ALTER TABLE mshop_stock CHANGE prodid prodid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_stock_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Stock.php (19.91ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Tag.php Creating tag schema -> ALTER TABLE mshop_tag_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Tag.php (20.3ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php (15.46ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddTypeDataDefault.php Adding MShop type data for site "default" Checking "attribute/type" type data Checking "attribute/lists/type" type data Checking "catalog/lists/type" type data Checking "customer/lists/type" type data Checking "media/type" type data Checking "media/property/type" type data Checking "plugin/type" type data Checking "price/type" type data Checking "product/type" type data Checking "product/lists/type" type data Checking "product/property/type" type data Checking "rule/type" type data Checking "stock/type" type data Checking "service/type" type data Checking "service/lists/type" type data Checking "supplier/lists/type" type data Checking "tag/type" type data Checking "text/type" type data Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddTypeDataDefault.php (150.37ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddCodeData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddCodeData.php (16.35ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCodeDataDefault.php Adding default code data for site "default" Checking "customer/group" codes Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCodeDataDefault.php (23.69ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCustomerData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCustomerData.php (17.36ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddTypeData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddTypeData.php (14.59ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddSupplierData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddSupplierData.php (14.81ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddProductData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddProductData.php (14.6ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddServiceData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddServiceData.php (14.88ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimplePrice.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimplePrice.php (14.78ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimpleText.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimpleText.php (16.05ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveCtimeEditor.php Remove ctime/editor from index tables Checking table "mshop_index_attribute": Checking table "mshop_index_catalog": Checking table "mshop_index_price": Checking table "mshop_index_supplier": Checking table "mshop_index_text": Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveCtimeEditor.php (169.39ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php Remove old indexes from mshop_index_* tables Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (30.32ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php Creating index schema -> ALTER TABLE mshop_index_attribute CHANGE attrid attrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE listtype listtype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_index_catalog CHANGE catid catid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE listtype listtype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_index_supplier CHANGE supid supid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE listtype listtype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php (41.83ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoRebuildIndex.php Rebuilding index for demo data Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoRebuildIndex.php (15.15ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexCreateSQLSrvFulltext.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexCreateSQLSrvFulltext.php (14.7ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (14.9ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php Creating job schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php (15.52ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobMigratePath.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobMigratePath.php (15.35ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobRemoveIndexes.php Remove job indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobRemoveIndexes.php (51.21ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes.php Remove indexes from mshop_locale Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes.php (113.49ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes2.php Remove locale indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes2.php (73.67ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleUpdateSiteTheme.php Allow NULL for "theme" column in "mshop_locale_site" => UPDATE {"mshop_locale_site"} SET {"theme":null} WHERE {"theme":""} Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleUpdateSiteTheme.php (15.27ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LogRemoveIndexes.php Remove log indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LogRemoveIndexes.php (34.6ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddAttributeData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddAttributeData.php (15.77ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddAttributeDataDefault.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddAttributeDataDefault.php (17ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCatalogDataDefault.php Adding MShop catalog data for site "default" Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCatalogDataDefault.php (24.66ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddDataAbstract.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddDataAbstract.php (14.87ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddPluginData.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddPluginData.php (14.82ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddPluginDataDefault.php Adding default plugin data Adding data for MShop plugins Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddPluginDataDefault.php (22.97ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaAddFsname.php Populating "fsname" column in media table => UPDATE {"mshop_media"} SET {"fsname":"fs-media"} WHERE {"fsname":""} Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaAddFsname.php (17.19ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaMigratePreview.php Migrating preview column in media table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaMigratePreview.php (15.4ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaRemoveIndexes.php Remove media indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaRemoveIndexes.php (309.45ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php Separate product ID and parent ID in order base product table -> ALTER TABLE mshop_order_base_product CHANGE parentprodid parentprodid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php (42.83ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (16.15ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (17.65ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php Rename "suppliername" to "vendor" in "mshop_order_base_product" table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (53.7ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php (14.78ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php Creating order schema -> ALTER TABLE mshop_order CHANGE relatedid relatedid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_base CHANGE customerid customerid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE sitecode sitecode VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_base_address CHANGE addrid addrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_base_coupon CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_base_product CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE prodid prodid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE prodcode prodcode VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE stocktype stocktype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT 'default' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_base_product_attr CHANGE attrid attrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_base_service CHANGE servid servid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_base_service_attr CHANGE attrid attrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_basket CHANGE customerid customerid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_order_status CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php (53.61ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php Adding currency ID to order base product table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php (16.77ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php Adding currency ID to order base service table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php (17.58ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddWeekday.php Populate weekday column in order table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddWeekday.php (17.15ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateStatus.php Migrate order product payment/delivery status => UPDATE {"mshop_order"} SET {"relatedid":""} WHERE {"relatedid":null} => UPDATE {"mshop_order"} SET {"statuspayment":-1} WHERE {"statuspayment":null} => UPDATE {"mshop_order"} SET {"statusdelivery":-1} WHERE {"statusdelivery":null} => UPDATE {"mshop_order_base_product"} SET {"statuspayment":-1} WHERE {"statuspayment":null} => UPDATE {"mshop_order_base_product"} SET {"statusdelivery":-1} WHERE {"statusdelivery":null} Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateStatus.php (16.91ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateTaxrate.php Migrating taxrate columns in order tables Migrating taxrate column in order base product table Migrating taxrate column in order base service table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateTaxrate.php (15.91ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRemoveIndexes.php Remove order indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRemoveIndexes.php (505.33ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PluginRemoveIndexes.php Remove plugin indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PluginRemoveIndexes.php (164.56ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxrate.php Migrating taxrate column in price table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxrate.php (17.34ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxRateName.php Migrating taxrate name in price table Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxRateName.php (17.48ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceRemoveIndexes.php Remove price indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceRemoveIndexes.php (409.27ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateCatalog.php Migrating category references to product domain Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateCatalog.php (20.51ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateSupplier.php Migrating supplier references to product domain Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateSupplier.php (20.33ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductRemoveIndexes.php Remove product indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductRemoveIndexes.php (587.52ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Queue.php Creating queue schema Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Queue.php (21.39ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Review.php Creating review schema -> ALTER TABLE mshop_review CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Review.php (35.46ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ReviewRemoveIndexes.php Remove review indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ReviewRemoveIndexes.php (116.42ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/RuleRemoveIndexes.php Remove rule indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/RuleRemoveIndexes.php (199.15ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceRemoveIndexes.php Remove service indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceRemoveIndexes.php (298.03ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockAddTypeDomainValue.php Add stock type domain values Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockAddTypeDomainValue.php (18.73ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockRemoveIndexes.php Remove stock indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockRemoveIndexes.php (145.25ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Subscription.php Creating subscription schema -> ALTER TABLE mshop_subscription CHANGE productid productid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Subscription.php (20.75ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigratePeriod.php Updating period count in subscriptions Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigratePeriod.php (18.98ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigrateProductId.php Updating product ID in subscriptions Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigrateProductId.php (17.01ms)
Top
robert63
Posts: 43
Joined: 03 Nov 2021, 13:38

Re: Upgrade aimeos from 22.10.9 to 23.10.3

Post by robert63 » 08 Oct 2024, 13:02

Second part because of 60.000 character limit:

Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionRemoveIndexes.php Remove subscription indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionRemoveIndexes.php (82.05ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SupplierRemoveIndexes.php Remove supplier indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SupplierRemoveIndexes.php (250.56ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigratePropertyKey.php Update property "key" columns Checking table mshop_attribute_property Checking table mshop_customer_property Checking table mshop_media_property Checking table mshop_price_property Checking table mshop_product_property Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigratePropertyKey.php (229.36ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TagRemoveIndexes.php Remove tag indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TagRemoveIndexes.php (142.19ms) Migrating: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TextRemoveIndexes.php Remove text indexes with siteid column first Migrated: /www/htdocs/w01c5b44/criollo-crzvd.de_v11_test/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TextRemoveIndexes.php (232.93ms) Setup process lasted 9.451028 sec
Top
Post Reply

Return to “TYPO3 extension”