Upgrade aimeos from 22.10.9 to 23.10.3

[aimeos]

And the problem occurs if you run the update wizard again?

[robert63]

I am not quite sure what you mean:

On the source system I can run the Upgrade wizard with success. So I believe all the data is fine.
Then I use this database with the new system Typo3 V12 and the aimeos versions I already mentioned. Then I run the Upgrade wizard, but I get the Error. Actually the Shop seems to work in the frontend, but in the backend I cannot see the orders.

[aimeos]

You must use the Aimeos 22.10 database and import it into the TYPO3 12 setup with Aimeos 23.10. Then, run "./vendor/bin/typo3 aimeos:setup" in your composer based TYPO3 12 setup and post the output if this step fails.

[robert63]

Yes this is exactly what I do. The output is:

./vendor/bin/typo3 aimeos:setup
Initializing or updating the Aimeos database tables for site default

In ExceptionConverter.php line 67:

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'baseid' in 'where clause'


In Exception.php line 28:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'baseid' in 'where clause'


In Connection.php line 33:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'baseid' in 'where clause'


aimeos:setup [--option OPTION] [--v [V]] [--q] [--] [<site> [<tplsite>]]

Migrating: 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: vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php (3497.79ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (20.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php
Clear property "key" columns
Migrated: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (20.01ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (20.76ms)
Migrating: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php
Migrated: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (20.51ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (20.64ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (282.69ms)
Migrating: vendor/aimeos/aimeos-core/setup/Attribute.php
Creating attribute schema
Migrated: vendor/aimeos/aimeos-core/setup/Attribute.php (444.94ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php
Remove attribute indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (484.71ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php
Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag"
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (52.93ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php
Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (68.06ms)
Migrating: vendor/aimeos/aimeos-core/setup/Cache.php
Creating cache schema
Migrated: vendor/aimeos/aimeos-core/setup/Cache.php (24.18ms)
Migrating: vendor/aimeos/aimeos-core/setup/Catalog.php
Creating catalog schema
Migrated: vendor/aimeos/aimeos-core/setup/Catalog.php (254.67ms)
Migrating: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php
Remove catalog indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (306.25ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php
Drop "fk_mscouco_parentid" in coupon code table
Migrated: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (70.35ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php
Migrating basketvalues configuration in coupon table
Migrated: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (25.8ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php
Drop "fk_mscusad_parentid" in customer address table
Migrated: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (63.05ms)
Migrating: vendor/aimeos/aimeos-core/setup/Coupon.php
Creating coupon schema
Migrated: vendor/aimeos/aimeos-core/setup/Coupon.php (189.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php
Remove coupon indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (228.73ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (24.09ms)
Migrating: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php
Migrating "static_info_country" column in "fe_users" table
Migrated: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (33.22ms)
Migrating: vendor/aimeos/aimeos-core/setup/Customer.php
Creating customer schema
Migrated: vendor/aimeos/aimeos-core/setup/Customer.php (614.12ms)
Migrating: vendor/aimeos/aimeos-core/setup/Media.php
Creating media schema
Migrated: vendor/aimeos/aimeos-core/setup/Media.php (514.51ms)
Migrating: vendor/aimeos/aimeos-core/setup/Price.php
Creating price schema
Migrated: vendor/aimeos/aimeos-core/setup/Price.php (343.12ms)
Migrating: vendor/aimeos/aimeos-core/setup/Product.php
Creating product schema
Migrated: vendor/aimeos/aimeos-core/setup/Product.php (626.1ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (75.44ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php
Ensure unique codes in mshop_service
Migrated: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (23.38ms)
Migrating: vendor/aimeos/aimeos-core/setup/Service.php
Creating service schema
Migrated: vendor/aimeos/aimeos-core/setup/Service.php (398ms)
Migrating: vendor/aimeos/aimeos-core/setup/Supplier.php
Creating supplier schema
Migrated: vendor/aimeos/aimeos-core/setup/Supplier.php (240.1ms)
Migrating: vendor/aimeos/aimeos-core/setup/Text.php
Creating text schema
Migrated: vendor/aimeos/aimeos-core/setup/Text.php (283.2ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (563.24ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php
Update TYPO3 lists "key" columns
Checking table fe_users_list
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (73.26ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (72.33ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (643.02ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (455.3ms)
Migrating: vendor/aimeos/aimeos-core/setup/Log.php
Creating log schema
Migrated: vendor/aimeos/aimeos-core/setup/Log.php (21.63ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (29.45ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php
Remove mshop_locale char constraints
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (23.18ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (21.72ms)
Migrating: vendor/aimeos/aimeos-core/setup/Locale.php
Creating locale schema
Migrated: vendor/aimeos/aimeos-core/setup/Locale.php (290.68ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (33.16ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php
Adding data for MShop locale domain
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (22.57ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php (1112.55ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php
Adding currency ID to order base product table

[aimeos]

These changes should fix the problem:
https://github.com/aimeos/aimeos-core/c ... 702ede400f

[robert63]

Unfortunately not:
./vendor/bin/typo3 aimeos:setup
Initializing or updating the Aimeos database tables for site default

In ExceptionConverter.php line 45:

An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mshop_order_addres
s' already exists


In Exception.php line 28:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mshop_order_address' already exists


In Connection.php line 33:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mshop_order_address' already exists


aimeos:setup [--option OPTION] [--v [V]] [--q] [--] [<site> [<tplsite>]]

Migrating: 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: vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php (1755.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (25.01ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php
Clear property "key" columns
Migrated: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (23.81ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (20.82ms)
Migrating: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php
Migrated: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (20.38ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (20.71ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (150.02ms)
Migrating: vendor/aimeos/aimeos-core/setup/Attribute.php
Creating attribute schema
Migrated: vendor/aimeos/aimeos-core/setup/Attribute.php (108.7ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php
Remove attribute indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (529.23ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php
Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag"
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (45.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php
Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (62.01ms)
Migrating: vendor/aimeos/aimeos-core/setup/Cache.php
Creating cache schema
Migrated: vendor/aimeos/aimeos-core/setup/Cache.php (22.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/Catalog.php
Creating catalog schema
Migrated: vendor/aimeos/aimeos-core/setup/Catalog.php (71.28ms)
Migrating: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php
Remove catalog indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (288.05ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php
Drop "fk_mscouco_parentid" in coupon code table
Migrated: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (65.63ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php
Migrating basketvalues configuration in coupon table
Migrated: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (24.96ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php
Drop "fk_mscusad_parentid" in customer address table
Migrated: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (61.05ms)
Migrating: vendor/aimeos/aimeos-core/setup/Coupon.php
Creating coupon schema
Migrated: vendor/aimeos/aimeos-core/setup/Coupon.php (67.26ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php
Remove coupon indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (222.83ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (30.22ms)
Migrating: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php
Migrating "static_info_country" column in "fe_users" table
Migrated: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (22.46ms)
Migrating: vendor/aimeos/aimeos-core/setup/Customer.php
Creating customer schema
Migrated: vendor/aimeos/aimeos-core/setup/Customer.php (151.2ms)
Migrating: vendor/aimeos/aimeos-core/setup/Media.php
Creating media schema
Migrated: vendor/aimeos/aimeos-core/setup/Media.php (102.5ms)
Migrating: vendor/aimeos/aimeos-core/setup/Price.php
Creating price schema
Migrated: vendor/aimeos/aimeos-core/setup/Price.php (100.54ms)
Migrating: vendor/aimeos/aimeos-core/setup/Product.php
Creating product schema
Migrated: vendor/aimeos/aimeos-core/setup/Product.php (161.74ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (87.27ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php
Ensure unique codes in mshop_service
Migrated: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (35.25ms)
Migrating: vendor/aimeos/aimeos-core/setup/Service.php
Creating service schema
Migrated: vendor/aimeos/aimeos-core/setup/Service.php (93.88ms)
Migrating: vendor/aimeos/aimeos-core/setup/Supplier.php
Creating supplier schema
Migrated: vendor/aimeos/aimeos-core/setup/Supplier.php (93.47ms)
Migrating: vendor/aimeos/aimeos-core/setup/Text.php
Creating text schema
Migrated: vendor/aimeos/aimeos-core/setup/Text.php (104.87ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (589.9ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php
Update TYPO3 lists "key" columns
Checking table fe_users_list
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (72.42ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (88.49ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (595.15ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (433.28ms)
Migrating: vendor/aimeos/aimeos-core/setup/Log.php
Creating log schema
Migrated: vendor/aimeos/aimeos-core/setup/Log.php (21.53ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (25.9ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php
Remove mshop_locale char constraints
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (22.37ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (20.12ms)
Migrating: vendor/aimeos/aimeos-core/setup/Locale.php
Creating locale schema
Migrated: vendor/aimeos/aimeos-core/setup/Locale.php (144.24ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (39.37ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php
Adding data for MShop locale domain
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (21.76ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php
Adding currency ID to order base product table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php (24.08ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php
Adding currency ID to order base service table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php (23.45ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php
Separate product ID and parent ID in order base product table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php (53.66ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php (567.12ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (27.62ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (23.65ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php
Rename "suppliername" to "vendor" in "mshop_order_base_product" table
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (82.18ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameTables.php

[aimeos]

After a failed migration, you must import the old Aimeos database again

[robert63]

I did this. But it persists:

./vendor/bin/typo3 aimeos:setup
Initializing or updating the Aimeos database tables for site default

In ExceptionConverter.php line 45:

An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mshop_order_addres
s' already exists


In Exception.php line 28:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mshop_order_address' already exists


In Connection.php line 33:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mshop_order_address' already exists


aimeos:setup [--option OPTION] [--v [V]] [--q] [--] [<site> [<tplsite>]]

Migrating: 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: vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php (1755.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (25.01ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php
Clear property "key" columns
Migrated: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (23.81ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (20.82ms)
Migrating: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php
Migrated: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (20.38ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (20.71ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (150.02ms)
Migrating: vendor/aimeos/aimeos-core/setup/Attribute.php
Creating attribute schema
Migrated: vendor/aimeos/aimeos-core/setup/Attribute.php (108.7ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php
Remove attribute indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (529.23ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php
Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag"
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (45.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php
Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (62.01ms)
Migrating: vendor/aimeos/aimeos-core/setup/Cache.php
Creating cache schema
Migrated: vendor/aimeos/aimeos-core/setup/Cache.php (22.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/Catalog.php
Creating catalog schema
Migrated: vendor/aimeos/aimeos-core/setup/Catalog.php (71.28ms)
Migrating: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php
Remove catalog indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (288.05ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php
Drop "fk_mscouco_parentid" in coupon code table
Migrated: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (65.63ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php
Migrating basketvalues configuration in coupon table
Migrated: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (24.96ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php
Drop "fk_mscusad_parentid" in customer address table
Migrated: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (61.05ms)
Migrating: vendor/aimeos/aimeos-core/setup/Coupon.php
Creating coupon schema
Migrated: vendor/aimeos/aimeos-core/setup/Coupon.php (67.26ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php
Remove coupon indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (222.83ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (30.22ms)
Migrating: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php
Migrating "static_info_country" column in "fe_users" table
Migrated: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (22.46ms)
Migrating: vendor/aimeos/aimeos-core/setup/Customer.php
Creating customer schema
Migrated: vendor/aimeos/aimeos-core/setup/Customer.php (151.2ms)
Migrating: vendor/aimeos/aimeos-core/setup/Media.php
Creating media schema
Migrated: vendor/aimeos/aimeos-core/setup/Media.php (102.5ms)
Migrating: vendor/aimeos/aimeos-core/setup/Price.php
Creating price schema
Migrated: vendor/aimeos/aimeos-core/setup/Price.php (100.54ms)
Migrating: vendor/aimeos/aimeos-core/setup/Product.php
Creating product schema
Migrated: vendor/aimeos/aimeos-core/setup/Product.php (161.74ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (87.27ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php
Ensure unique codes in mshop_service
Migrated: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (35.25ms)
Migrating: vendor/aimeos/aimeos-core/setup/Service.php
Creating service schema
Migrated: vendor/aimeos/aimeos-core/setup/Service.php (93.88ms)
Migrating: vendor/aimeos/aimeos-core/setup/Supplier.php
Creating supplier schema
Migrated: vendor/aimeos/aimeos-core/setup/Supplier.php (93.47ms)
Migrating: vendor/aimeos/aimeos-core/setup/Text.php
Creating text schema
Migrated: vendor/aimeos/aimeos-core/setup/Text.php (104.87ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (589.9ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php
Update TYPO3 lists "key" columns
Checking table fe_users_list
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (72.42ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (88.49ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (595.15ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (433.28ms)
Migrating: vendor/aimeos/aimeos-core/setup/Log.php
Creating log schema
Migrated: vendor/aimeos/aimeos-core/setup/Log.php (21.53ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (25.9ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php
Remove mshop_locale char constraints
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (22.37ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (20.12ms)
Migrating: vendor/aimeos/aimeos-core/setup/Locale.php
Creating locale schema
Migrated: vendor/aimeos/aimeos-core/setup/Locale.php (144.24ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (39.37ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php
Adding data for MShop locale domain
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (21.76ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php
Adding currency ID to order base product table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php (24.08ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php
Adding currency ID to order base service table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php (23.45ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php
Separate product ID and parent ID in order base product table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php (53.66ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php (567.12ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (27.62ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (23.65ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php
Rename "suppliername" to "vendor" in "mshop_order_base_product" table
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (82.18ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameTables.php
ssh-w01c5b44@dd17838:/www/htdocs/w01c5b44/criollo-crzvd.de_v12$ ./vendor/bin/typo3 aimeos:setup
Initializing or updating the Aimeos database tables for site default
Migrating: 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: vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php (1719.17ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php
Migrated: vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (16.71ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php
Clear property "key" columns
Migrated: vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (16.41ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (16.68ms)
Migrating: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php
Migrated: vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (16.42ms)
Migrating: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php
Migrated: vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (16.13ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (117.51ms)
Migrating: vendor/aimeos/aimeos-core/setup/Attribute.php
Creating attribute schema
Migrated: vendor/aimeos/aimeos-core/setup/Attribute.php (93.75ms)
Migrating: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php
Remove attribute indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (480.36ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php
Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag"
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (34.66ms)
Migrating: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php
Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes
Migrated: vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (53.14ms)
Migrating: vendor/aimeos/aimeos-core/setup/Cache.php
Creating cache schema
Migrated: vendor/aimeos/aimeos-core/setup/Cache.php (17.93ms)
Migrating: vendor/aimeos/aimeos-core/setup/Catalog.php
Creating catalog schema
Migrated: vendor/aimeos/aimeos-core/setup/Catalog.php (83.89ms)
Migrating: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php
Remove catalog indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (270.48ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php
Drop "fk_mscouco_parentid" in coupon code table
Migrated: vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (61.43ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php
Migrating basketvalues configuration in coupon table
Migrated: vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (21.79ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php
Drop "fk_mscusad_parentid" in customer address table
Migrated: vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (61.58ms)
Migrating: vendor/aimeos/aimeos-core/setup/Coupon.php
Creating coupon schema
Migrated: vendor/aimeos/aimeos-core/setup/Coupon.php (58.61ms)
Migrating: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php
Remove coupon indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (192.59ms)
Migrating: 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: vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (23.74ms)
Migrating: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php
Migrating "static_info_country" column in "fe_users" table
Migrated: vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (23.75ms)
Migrating: vendor/aimeos/aimeos-core/setup/Customer.php
Creating customer schema
Migrated: vendor/aimeos/aimeos-core/setup/Customer.php (127.23ms)
Migrating: vendor/aimeos/aimeos-core/setup/Media.php
Creating media schema
Migrated: vendor/aimeos/aimeos-core/setup/Media.php (112.07ms)
Migrating: vendor/aimeos/aimeos-core/setup/Price.php
Creating price schema
Migrated: vendor/aimeos/aimeos-core/setup/Price.php (117.4ms)
Migrating: vendor/aimeos/aimeos-core/setup/Product.php
Creating product schema
Migrated: vendor/aimeos/aimeos-core/setup/Product.php (148.55ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (81.46ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php
Ensure unique codes in mshop_service
Migrated: vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (29.82ms)
Migrating: vendor/aimeos/aimeos-core/setup/Service.php
Creating service schema
Migrated: vendor/aimeos/aimeos-core/setup/Service.php (105.78ms)
Migrating: vendor/aimeos/aimeos-core/setup/Supplier.php
Creating supplier schema
Migrated: vendor/aimeos/aimeos-core/setup/Supplier.php (70.08ms)
Migrating: vendor/aimeos/aimeos-core/setup/Text.php
Creating text schema
Migrated: vendor/aimeos/aimeos-core/setup/Text.php (101.3ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (476.5ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php
Update TYPO3 lists "key" columns
Checking table fe_users_list
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (61.47ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php
Update property "key" columns
Checking table fe_users_property
Migrated: vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (58.75ms)
Migrating: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (457.29ms)
Migrating: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php
Remove customer indexes with siteid column first
Migrated: vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (358.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/Log.php
Creating log schema
Migrated: vendor/aimeos/aimeos-core/setup/Log.php (24.8ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (19.41ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php
Remove mshop_locale char constraints
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (20.73ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (17.43ms)
Migrating: vendor/aimeos/aimeos-core/setup/Locale.php
Creating locale schema
Migrated: vendor/aimeos/aimeos-core/setup/Locale.php (111.07ms)
Migrating: 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: vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (26.1ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php
Adding data for MShop locale domain
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (19.11ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php
Adding currency ID to order base product table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php (19.39ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php
Adding currency ID to order base service table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php (19.67ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php
Separate product ID and parent ID in order base product table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php (57.55ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderConnectTables.php (499ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (19.19ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (17.4ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php
Rename "suppliername" to "vendor" in "mshop_order_base_product" table
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (59.43ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameTables.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameTables.php (483.4ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRenameType.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderRenameType.php (20.64ms)
Migrating: vendor/aimeos/aimeos-core/setup/Order.php
Creating order schema
Migrated: vendor/aimeos/aimeos-core/setup/Order.php (367.6ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderMergeBaseTable.php
Migrated: vendor/aimeos/aimeos-core/setup/OrderMergeBaseTable.php (298.72ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddLocaleData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddLocaleData.php (17.65ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopSetLocale.php
Setting locale to "default"
Migrated: vendor/aimeos/aimeos-core/setup/MShopSetLocale.php (29ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php
Processing catalog demo data
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php (19.3ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoAddCouponData.php
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoAddCouponData.php (18.14ms)
Migrating: vendor/aimeos/aimeos-core/setup/Plugin.php
Creating plugin schema
Migrated: vendor/aimeos/aimeos-core/setup/Plugin.php (48.51ms)
Migrating: vendor/aimeos/aimeos-core/setup/Rule.php
Creating rule schema
Migrated: vendor/aimeos/aimeos-core/setup/Rule.php (54.37ms)
Migrating: vendor/aimeos/aimeos-core/setup/StockMigrateProductId.php
Migrate product code to product ID in stock table
Migrated: vendor/aimeos/aimeos-core/setup/StockMigrateProductId.php (56.46ms)
Migrating: vendor/aimeos/aimeos-core/setup/Stock.php
Creating stock schema
Migrated: vendor/aimeos/aimeos-core/setup/Stock.php (69.35ms)
Migrating: vendor/aimeos/aimeos-core/setup/Tag.php
Creating tag schema
Migrated: vendor/aimeos/aimeos-core/setup/Tag.php (44.91ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddTypeData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddTypeData.php (25.84ms)
Migrating: vendor/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: vendor/aimeos/aimeos-core/setup/default/MShopAddTypeDataDefault.php (89.47ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddCodeData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddCodeData.php (19.83ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddCodeDataDefault.php
Adding default code data for site "default"
Checking "customer/group" codes
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddCodeDataDefault.php (24.06ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoAddCustomerData.php
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoAddCustomerData.php (19.76ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexPrepareSimplePrice.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexPrepareSimplePrice.php (19.59ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexPrepareSimpleText.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexPrepareSimpleText.php (19.87ms)
Migrating: vendor/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: vendor/aimeos/aimeos-core/setup/IndexRemoveCtimeEditor.php (225.13ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexRemoveIndexes.php
Remove old indexes from mshop_index_* tables
Migrated: vendor/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (34.63ms)
Migrating: vendor/aimeos/aimeos-core/setup/Index.php
Creating index schema
Migrated: vendor/aimeos/aimeos-core/setup/Index.php (96ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoAddTypeData.php
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoAddTypeData.php (18.08ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoAddSupplierData.php
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoAddSupplierData.php (17.71ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoAddProductData.php
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoAddProductData.php (22.84ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoAddServiceData.php
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoAddServiceData.php (19.17ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/DemoRebuildIndex.php
Rebuilding index for demo data
Migrated: vendor/aimeos/aimeos-core/setup/default/DemoRebuildIndex.php (18.03ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexCreateSQLSrvFulltext.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexCreateSQLSrvFulltext.php (17.71ms)
Migrating: vendor/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php
Migrated: vendor/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (23.04ms)
Migrating: vendor/aimeos/aimeos-core/setup/Job.php
Creating job schema
Migrated: vendor/aimeos/aimeos-core/setup/Job.php (20.62ms)
Migrating: vendor/aimeos/aimeos-core/setup/JobMigratePath.php
Migrated: vendor/aimeos/aimeos-core/setup/JobMigratePath.php (20.88ms)
Migrating: vendor/aimeos/aimeos-core/setup/JobRemoveIndexes.php
Remove job indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/JobRemoveIndexes.php (58.11ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveIndexes.php
Remove indexes from mshop_locale
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveIndexes.php (149.97ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleRemoveIndexes2.php
Remove locale indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/LocaleRemoveIndexes2.php (119.21ms)
Migrating: vendor/aimeos/aimeos-core/setup/LocaleUpdateSiteTheme.php
Allow NULL for "theme" column in "mshop_locale_site"
Migrated: vendor/aimeos/aimeos-core/setup/LocaleUpdateSiteTheme.php (23.16ms)
Migrating: vendor/aimeos/aimeos-core/setup/LogRemoveIndexes.php
Remove log indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/LogRemoveIndexes.php (57.38ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddAttributeData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddAttributeData.php (29.98ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddAttributeDataDefault.php
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddAttributeDataDefault.php (36.1ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddCatalogDataDefault.php
Adding MShop catalog data for site "default"
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddCatalogDataDefault.php (26.16ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddDataAbstract.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddDataAbstract.php (21.92ms)
Migrating: vendor/aimeos/aimeos-core/setup/MShopAddPluginData.php
Migrated: vendor/aimeos/aimeos-core/setup/MShopAddPluginData.php (19.83ms)
Migrating: vendor/aimeos/aimeos-core/setup/default/MShopAddPluginDataDefault.php
Adding default plugin data
Adding data for MShop plugins
Migrated: vendor/aimeos/aimeos-core/setup/default/MShopAddPluginDataDefault.php (27.25ms)
Migrating: vendor/aimeos/aimeos-core/setup/MediaAddFsname.php
Populating "fsname" column in media table
Migrated: vendor/aimeos/aimeos-core/setup/MediaAddFsname.php (38.59ms)
Migrating: vendor/aimeos/aimeos-core/setup/MediaMigratePreview.php
Migrating preview column in media table
Migrated: vendor/aimeos/aimeos-core/setup/MediaMigratePreview.php (21.87ms)
Migrating: vendor/aimeos/aimeos-core/setup/MediaRemoveIndexes.php
Remove media indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/MediaRemoveIndexes.php (432.33ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderAddWeekday.php
Populate weekday column in order table
Migrated: vendor/aimeos/aimeos-core/setup/OrderAddWeekday.php (19.32ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderMigrateServiceAttributeTypes.php
Migrating attribute types of order services
Migrated: vendor/aimeos/aimeos-core/setup/OrderMigrateServiceAttributeTypes.php (18.62ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderMigrateStatus.php
Migrate order product payment/delivery status
Migrated: vendor/aimeos/aimeos-core/setup/OrderMigrateStatus.php (18.82ms)
Migrating: vendor/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: vendor/aimeos/aimeos-core/setup/OrderMigrateTaxrate.php (23.6ms)
Migrating: vendor/aimeos/aimeos-core/setup/OrderRemoveIndexes.php
Remove order indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/OrderRemoveIndexes.php (522.78ms)
Migrating: vendor/aimeos/aimeos-core/setup/PluginRemoveIndexes.php
Remove plugin indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/PluginRemoveIndexes.php (242.99ms)
Migrating: vendor/aimeos/aimeos-core/setup/PriceMigrateTaxrate.php
Migrating taxrate column in price table
Migrated: vendor/aimeos/aimeos-core/setup/PriceMigrateTaxrate.php (22.48ms)
Migrating: vendor/aimeos/aimeos-core/setup/PriceMigrateTaxRateName.php
Migrating taxrate name in price table
Migrated: vendor/aimeos/aimeos-core/setup/PriceMigrateTaxRateName.php (21.81ms)
Migrating: vendor/aimeos/aimeos-core/setup/PriceRemoveIndexes.php
Remove price indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/PriceRemoveIndexes.php (438.78ms)
Migrating: vendor/aimeos/aimeos-core/setup/ProductMigrateCatalog.php
Migrating category references to product domain
Migrated: vendor/aimeos/aimeos-core/setup/ProductMigrateCatalog.php (24.12ms)
Migrating: vendor/aimeos/aimeos-core/setup/ProductMigrateSupplier.php
Migrating supplier references to product domain
Migrated: vendor/aimeos/aimeos-core/setup/ProductMigrateSupplier.php (20.66ms)
Migrating: vendor/aimeos/aimeos-core/setup/ProductRemoveIndexes.php
Remove product indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/ProductRemoveIndexes.php (451.14ms)
Migrating: vendor/aimeos/aimeos-core/setup/Queue.php
Creating queue schema
Migrated: vendor/aimeos/aimeos-core/setup/Queue.php (17.3ms)
Migrating: vendor/aimeos/aimeos-core/setup/Review.php
Creating review schema
Migrated: vendor/aimeos/aimeos-core/setup/Review.php (144.18ms)
Migrating: vendor/aimeos/aimeos-core/setup/ReviewRemoveIndexes.php
Remove review indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/ReviewRemoveIndexes.php (117.54ms)
Migrating: vendor/aimeos/aimeos-core/setup/RuleRemoveIndexes.php
Remove rule indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/RuleRemoveIndexes.php (196.49ms)
Migrating: vendor/aimeos/aimeos-core/setup/ServiceRemoveIndexes.php
Remove service indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/ServiceRemoveIndexes.php (292.88ms)
Migrating: vendor/aimeos/aimeos-core/setup/StockAddTypeDomainValue.php
Add stock type domain values
Migrated: vendor/aimeos/aimeos-core/setup/StockAddTypeDomainValue.php (18.99ms)
Migrating: vendor/aimeos/aimeos-core/setup/StockRemoveIndexes.php
Remove stock indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/StockRemoveIndexes.php (149.47ms)
Migrating: vendor/aimeos/aimeos-core/setup/Subscription.php
Creating subscription schema
Migrated: vendor/aimeos/aimeos-core/setup/Subscription.php (135.31ms)
Migrating: vendor/aimeos/aimeos-core/setup/SubscriptionMigratePeriod.php
Updating period count in subscriptions
Migrated: vendor/aimeos/aimeos-core/setup/SubscriptionMigratePeriod.php (23.5ms)
Migrating: vendor/aimeos/aimeos-core/setup/SubscriptionMigrateProductId.php
Updating product ID in subscriptions
Migrated: vendor/aimeos/aimeos-core/setup/SubscriptionMigrateProductId.php (21.16ms)
Migrating: vendor/aimeos/aimeos-core/setup/SubscriptionRemoveIndexes.php
Remove subscription indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/SubscriptionRemoveIndexes.php (103.76ms)
Migrating: vendor/aimeos/aimeos-core/setup/SupplierRemoveIndexes.php
Remove supplier indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/SupplierRemoveIndexes.php (369.46ms)
Migrating: vendor/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: vendor/aimeos/aimeos-core/setup/TablesMigratePropertyKey.php (273.37ms)
Migrating: vendor/aimeos/aimeos-core/setup/TagRemoveIndexes.php
Remove tag indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/TagRemoveIndexes.php (163.65ms)
Migrating: vendor/aimeos/aimeos-core/setup/TextRemoveIndexes.php
Remove text indexes with siteid column first
Migrated: vendor/aimeos/aimeos-core/setup/TextRemoveIndexes.php (225.19ms)

[aimeos]

Make sure that the mshop_order_address, mshop_order_coupon, mshop_order_product* and mshop_order_service* tables are not present in your Aimeos 23.10 database before you run the setup tasks.

[robert63]

Wonderful. Repeated it and now it was successful. Thanks for the great support.