Update 22 to 24 Errors

[randomdennis]

Hey, im trying to Update to Aimeos 24.10.2 and Typo3 12.4.23.

I have managed to complete the migration by making some database adjustments.
However, the former order invoices are missing and demo data has been added.

Error message during migration and my solution:

“Column not found: 1054 Unknown column 'mlocsi.rating'”
->
ALTER TABLE mshop_locale_site
ADD COLUMN rating DECIMAL(4,2) DEFAULT 0.00,
ADD COLUMN ratings INTEGER DEFAULT 0;

“parentid truncate problems”
->
SELECT * FROM mshop_order_product WHERE parentid IS NULL OR parentid = '';
remove product id 1 where parentid is null
SELECT * FROM `mshop_order_address` WHERE parentid IS NULL;
remove id 1

“DemoData no Price Error”
Here I had to comment out the following, why does it want to add demo data when activating the plugin in typo3 12? how can I prevent this?
typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddOrderData.php
protected function services()
/* foreach( $items as $item )
{
$price = $item->getRefItems( 'price', 'default', 'default' )->first();
$list[$item->getId()] = $manager->create()->copyFrom( $item )->setPrice( $price );
}*/


EDIT:
The invoices from Orders are not displayed in the overview, except for the demo data starting with 1. The invoices are missing in the former orders. Transaction section is empty. I get Error when i try to save something in Transaction View. When i add old Transaction ID to Order no changes in Backend.

EDIT: Class "\Aimeos\MShop\Service\Provider\Decorator\Verstecken" not found
Error in Backend seems my fault. I will adjust.

Thank you for your Time.

[aimeos]

To prevent demo data from being added, go to "Settings" in the left navigation, select "Configure extensions", then "aimeos" and in the "Basic" tab select "No action" for "Updates demo data":

aimeos-typo3-demo-overwrite.png (119.37 KiB) Viewed 24796 times

Then, go the the TYPO3 upgrade wizard and run the Aimeos setup tasks using your 22.10 database content. This will update to the latest version without adding the demo data again.

[randomdennis]

Thank you very much, do you think this is related to the lost invoices and billing addresses from orders or what could be the reason?

[aimeos]

Guess not. Did you overwrite some templates?
From 2022.x to 2023.x the mshop_order and mshop_order_base tables have been merged and the mshop_order_base_* tables renamed to mshop_order_* but this should be done automatically without any data loss. Can you check if the data is still in the new tables of your database?

[randomdennis]

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mlocsi.rating' in 'field list': SELECT mlocsi."id" AS "locale.site.id", mlocsi."siteid" AS "locale.site.siteid", mlocsi."parentid" AS "locale.site.parentid", mlocsi."label" AS "locale.site.label", mlocsi."code" AS "locale.site.code", mlocsi."status" AS "locale.site.status", mlocsi."id" AS "locale.site.position", mlocsi."level" AS "locale.site.level", mlocsi."config" AS "locale.site.config", mlocsi."icon" AS "locale.site.icon", mlocsi."logo" AS "locale.site.logo", mlocsi."rating" AS "locale.site.rating", mlocsi."ratings" AS "locale.site.ratings", mlocsi."refid" AS "locale.site.refid", mlocsi."theme" AS "locale.site.theme", mlocsi."ctime" AS "locale.site.ctime", mlocsi."mtime" AS "locale.site.mtime", mlocsi."editor" AS "locale.site.editor" FROM "mshop_locale_site" mlocsi WHERE ( mlocsi."status" < 1 AND ( mlocsi."siteid" LIKE '1.%' ESCAPE '#' AND ( mlocsi."level" = 0 ) ) ) GROUP BY mlocsi."id", mlocsi."siteid", mlocsi."parentid", mlocsi."label", mlocsi."code", mlocsi."status", mlocsi."level", mlocsi."config", mlocsi."icon", mlocsi."logo", mlocsi."rating", mlocsi."ratings", mlocsi."refid", mlocsi."theme", mlocsi."ctime", mlocsi."mtime", mlocsi."editor" ORDER BY mlocsi."id" ASC LIMIT 100 OFFSET 0

This is the first error message when I try to install the update.

i can do this:
ALTER TABLE mshop_locale_site
ADD COLUMN rating DECIMAL(4,2) DEFAULT 0.00,
ADD COLUMN ratings INTEGER DEFAULT 0;

then next error:
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'parentid' at row 1

Text befor Error:
...... Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (59.42ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php Rename "suppliername" to "vendor" in "mshop_order_base_product" table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (243.29ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameTables.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameTables.php (445.79ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php (66.9ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php Creating order schema -> ALTER TABLE mshop_order_product_attr CHANGE price price NUMERIC(12, 2) DEFAULT '0' -> ALTER TABLE mshop_order_product ADD `scale` DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL, CHANGE price price NUMERIC(12, 2) DEFAULT '0', CHANGE description description TEXT DEFAULT '' NOT NULL, CHANGE notes notes TEXT DEFAULT '' NOT NULL, CHANGE parentid parentid BIGINT NOT NULL

i can do
SELECT * FROM mshop_order_product WHERE parentid IS NULL OR parentid = '';
remove product id 1 where parentid is null

SELECT * FROM `mshop_order_address` WHERE parentid IS NULL;
remove id 1

but the invoice nr are missing

[aimeos]

The first error shouldn't occur at all. Can you please post the complete output when you migrate from your unchanged 2022.10 database?

[randomdennis]

Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php (235.78ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (57.07ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (63.79ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (60.36ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (57.7ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema -> CREATE UNIQUE INDEX `unq_msattpr_ty_lid_value_sid` ON mshop_attribute_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_msattpr_key_sid` ON mshop_attribute_property (`key`, `siteid`) -> ALTER TABLE mshop_attribute_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msattlity_dom_code_sid` ON mshop_attribute_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msattlity_status_sid_pos` ON mshop_attribute_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msattlity_label_sid` ON mshop_attribute_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msattlity_code_sid` ON mshop_attribute_list_type (`code`, `siteid`) -> ALTER TABLE mshop_attribute_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msattli_pid_dm_ty_rid_sid` ON mshop_attribute_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> ALTER TABLE mshop_attribute_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msattty_dom_code_sid` ON mshop_attribute_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msattty_status_sid_pos` ON mshop_attribute_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msattty_label_sid` ON mshop_attribute_type (`label`, `siteid`) -> CREATE INDEX `idx_msattty_code_sid` ON mshop_attribute_type (`code`, `siteid`) -> ALTER TABLE mshop_attribute_property_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msattprty_dom_code_sid` ON mshop_attribute_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msattprty_status_sid_pos` ON mshop_attribute_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msattprty_label_sid` ON mshop_attribute_property_type (`label`, `siteid`) -> CREATE INDEX `idx_msattprty_code_sid` ON mshop_attribute_property_type (`code`, `siteid`) -> CREATE UNIQUE INDEX `unq_msatt_dom_type_code_sid` ON mshop_attribute (`domain`, `type`, `code`, `siteid`) -> CREATE INDEX `idx_msatt_status_sid` ON mshop_attribute (`status`, `siteid`) -> CREATE INDEX `idx_msatt_label_sid` ON mshop_attribute (`label`, `siteid`) -> CREATE INDEX `idx_msatt_code_sid` ON mshop_attribute (`code`, `siteid`) -> CREATE INDEX `idx_msatt_type_sid` ON mshop_attribute (`type`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php (205.16ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first -> DROP INDEX unq_msatt_dom_sid_type_code ON mshop_attribute -> DROP INDEX idx_msatt_sid_status ON mshop_attribute -> DROP INDEX idx_msatt_sid_label ON mshop_attribute -> DROP INDEX idx_msatt_sid_code ON mshop_attribute -> DROP INDEX idx_msatt_sid_type ON mshop_attribute -> DROP INDEX unq_msattty_sid_dom_code ON mshop_attribute_type -> DROP INDEX idx_msattty_sid_status_pos ON mshop_attribute_type -> DROP INDEX idx_msattty_sid_label ON mshop_attribute_type -> DROP INDEX idx_msattty_sid_code ON mshop_attribute_type -> DROP INDEX unq_msattli_pid_dm_sid_ty_rid ON mshop_attribute_list -> DROP INDEX unq_msattlity_sid_dom_code ON mshop_attribute_list_type -> DROP INDEX idx_msattlity_sid_status_pos ON mshop_attribute_list_type -> DROP INDEX idx_msattlity_sid_label ON mshop_attribute_list_type -> DROP INDEX idx_msattlity_sid_code ON mshop_attribute_list_type -> DROP INDEX fk_msattpr_key_sid ON mshop_attribute_property -> DROP INDEX unq_msattpr_sid_ty_lid_value ON mshop_attribute_property -> DROP INDEX unq_msattprty_sid_dom_code ON mshop_attribute_property_type -> DROP INDEX idx_msattprty_sid_status_pos ON mshop_attribute_property_type -> DROP INDEX idx_msattprty_sid_label ON mshop_attribute_property_type -> DROP INDEX idx_msattprty_sid_code ON mshop_attribute_property_type Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (1390.53ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (129.55ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (178.62ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php Creating cache schema -> CREATE INDEX `unq_macacta_tname` ON madmin_cache_tag (`tname`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php (83.12ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema -> ALTER TABLE mshop_catalog CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mscat_code_sid` ON mshop_catalog (`code`, `siteid`) -> CREATE INDEX `idx_mscat_nlt_nrt_lvl_pid_sid` ON mshop_catalog (`nleft`, `nright`, `level`, `parentid`, `siteid`) -> CREATE INDEX `idx_mscat_status_sid` ON mshop_catalog (`status`, `siteid`) -> ALTER TABLE mshop_catalog_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mscatlity_dom_code_sid` ON mshop_catalog_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mscatlity_status_sid_pos` ON mshop_catalog_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mscatlity_label_sid` ON mshop_catalog_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mscatlity_code_sid` ON mshop_catalog_list_type (`code`, `siteid`) -> ALTER TABLE mshop_catalog_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mscatli_pid_dm_ty_rid_sid` ON mshop_catalog_list (`parentid`, `domain`, `type`, `refid`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php (109.2ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first -> DROP INDEX unq_mscat_sid_code ON mshop_catalog -> DROP INDEX idx_mscat_sid_nlt_nrt_lvl_pid ON mshop_catalog -> DROP INDEX idx_mscat_sid_status ON mshop_catalog -> DROP INDEX unq_mscatli_pid_dm_sid_ty_rid ON mshop_catalog_list -> DROP INDEX idx_mscatli_pid_dm_sid_pos_rid ON mshop_catalog_list -> DROP INDEX idx_mscatli_rid_dom_sid_ty ON mshop_catalog_list -> DROP INDEX unq_mscatlity_sid_dom_code ON mshop_catalog_list_type -> DROP INDEX idx_mscatlity_sid_status_pos ON mshop_catalog_list_type -> DROP INDEX idx_mscatlity_sid_label ON mshop_catalog_list_type -> DROP INDEX idx_mscatlity_sid_code ON mshop_catalog_list_type Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (864.67ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (192.22ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (62.78ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (174.95ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema -> CREATE UNIQUE INDEX `unq_mscouco_code_sid` ON mshop_coupon_code (`code`, `siteid`) -> CREATE INDEX `idx_mscouco_ct_start_end_sid` ON mshop_coupon_code (`count`, `start`, `end`, `siteid`) -> CREATE INDEX `idx_mscouco_start_sid` ON mshop_coupon_code (`start`, `siteid`) -> CREATE INDEX `idx_mscouco_end_sid` ON mshop_coupon_code (`end`, `siteid`) -> ALTER TABLE mshop_coupon CHANGE config config TEXT DEFAULT NULL -> CREATE INDEX `idx_mscou_stat_start_end_sid` ON mshop_coupon (`status`, `start`, `end`, `siteid`) -> CREATE INDEX `idx_mscou_provider_sid` ON mshop_coupon (`provider`, `siteid`) -> CREATE INDEX `idx_mscou_label_sid` ON mshop_coupon (`label`, `siteid`) -> CREATE INDEX `idx_mscou_start_sid` ON mshop_coupon (`start`, `siteid`) -> CREATE INDEX `idx_mscou_end_sid` ON mshop_coupon (`end`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php (104.46ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first -> DROP INDEX idx_mscou_sid_stat_start_end ON mshop_coupon -> DROP INDEX idx_mscou_sid_provider ON mshop_coupon -> DROP INDEX idx_mscou_sid_label ON mshop_coupon -> DROP INDEX idx_mscou_sid_start ON mshop_coupon -> DROP INDEX idx_mscou_sid_end ON mshop_coupon -> DROP INDEX unq_mscouco_sid_code ON mshop_coupon_code -> DROP INDEX idx_mscouco_sid_ct_start_end ON mshop_coupon_code -> DROP INDEX idx_mscouco_sid_start ON mshop_coupon_code -> DROP INDEX idx_mscouco_sid_end ON mshop_coupon_code Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (647.95ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php Rename mshop_customer_group to mshop_group Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php (510.17ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php Migrate TYPO3 "customer/group" domain to "group" Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php (65.08ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (56.26ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php Creating customer schema -> ALTER TABLE mshop_customer_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mscuslity_dom_code_sid` ON mshop_customer_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mscuslity_status_sid_pos` ON mshop_customer_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mscuslity_label_sid` ON mshop_customer_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mscuslity_code_sid` ON mshop_customer_list_type (`code`, `siteid`) -> ALTER TABLE fe_users_address ADD `type` VARCHAR(64) DEFAULT 'delivery' NOT NULL, ADD `mobile` VARCHAR(32) DEFAULT '' NOT NULL -> CREATE INDEX `idx_t3feuad_langid_sid` ON fe_users_address (`langid`, `siteid`) -> CREATE INDEX `idx_t3feuad_post_ci` ON fe_users_address (`postal`, `city`) -> ALTER TABLE mshop_customer_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mscusli_pid_dm_ty_rid_sid` ON mshop_customer_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> ALTER TABLE mshop_customer ADD `mobile` VARCHAR(32) DEFAULT '' NOT NULL -> CREATE UNIQUE INDEX `unq_mscus_code_sid` ON mshop_customer (`code`, `siteid`) -> CREATE INDEX `idx_mscus_langid_sid` ON mshop_customer (`langid`, `siteid`) -> CREATE INDEX `idx_mscus_last_first` ON mshop_customer (`lastname`, `firstname`) -> CREATE INDEX `idx_mscus_post_addr1` ON mshop_customer (`postal`, `address1`) -> CREATE INDEX `idx_mscus_post_city` ON mshop_customer (`postal`, `city`) -> CREATE INDEX `idx_mscus_city` ON mshop_customer (`city`) -> CREATE INDEX `idx_mscus_email` ON mshop_customer (`email`) -> CREATE UNIQUE INDEX `unq_mscuspr_pid_ty_lid_val_sid` ON mshop_customer_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_mscuspr_key_sid` ON mshop_customer_property (`key`, `siteid`) -> ALTER TABLE fe_users_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_t3feulity_dom_code_sid` ON fe_users_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_t3feulity_status_sid_pos` ON fe_users_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_t3feulity_label_sid` ON fe_users_list_type (`label`, `siteid`) -> CREATE INDEX `idx_t3feulity_code_sid` ON fe_users_list_type (`code`, `siteid`) -> ALTER TABLE fe_users_property_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_t3feuprty_dom_code_sid` ON fe_users_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_t3feuprty_status_sid_pos` ON fe_users_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_t3feuprty_label_sid` ON fe_users_property_type (`label`, `siteid`) -> CREATE INDEX `idx_t3feuprty_code_sid` ON fe_users_property_type (`code`, `siteid`) -> ALTER TABLE mshop_customer_property_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mscusprty_dom_code_sid` ON mshop_customer_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mscusprty_status_sid_pos` ON mshop_customer_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mscusprty_label_sid` ON mshop_customer_property_type (`label`, `siteid`) -> CREATE INDEX `idx_mscusprty_code_sid` ON mshop_customer_property_type (`code`, `siteid`) -> ALTER TABLE fe_users_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_t3feuli_pid_dm_ty_rid_sid` ON fe_users_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE UNIQUE INDEX `unq_t3feupr_pid_ty_lid_val_sid` ON fe_users_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_t3feupr_key_sid` ON fe_users_property (`key`, `siteid`) -> ALTER TABLE mshop_customer_address ADD `type` VARCHAR(64) DEFAULT 'delivery' NOT NULL, ADD `mobile` VARCHAR(32) DEFAULT '' NOT NULL -> CREATE INDEX `idx_mscusad_pid_type` ON mshop_customer_address (`parentid`, `type`) -> CREATE INDEX `idx_mscusad_langid_sid` ON mshop_customer_address (`langid`, `siteid`) -> CREATE INDEX `idx_mscusad_last_first` ON mshop_customer_address (`lastname`, `firstname`) -> CREATE INDEX `idx_mscusad_post_addr1` ON mshop_customer_address (`postal`, `address1`) -> CREATE INDEX `idx_mscusad_post_city` ON mshop_customer_address (`postal`, `city`) -> CREATE INDEX `idx_mscusad_city` ON mshop_customer_address (`city`) -> CREATE INDEX `idx_mscusad_email` ON mshop_customer_address (`email`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php (247.6ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php Creating media schema -> CREATE UNIQUE INDEX `unq_msmedpr_pid_ty_lid_val_sid` ON mshop_media_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_msmedpr_key_sid` ON mshop_media_property (`key`, `siteid`) -> ALTER TABLE mshop_media_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msmedty_dom_code_sid` ON mshop_media_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msmedty_status_sid_pos` ON mshop_media_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msmedty_label_sid` ON mshop_media_type (`label`, `siteid`) -> CREATE INDEX `idx_msmedty_code_sid` ON mshop_media_type (`code`, `siteid`) -> ALTER TABLE mshop_media_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msmedlity_dom_code_sid` ON mshop_media_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msmedlity_status_sid_pos` ON mshop_media_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msmedlity_label_sid` ON mshop_media_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msmedlity_code_sid` ON mshop_media_list_type (`code`, `siteid`) -> ALTER TABLE mshop_media_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msmedli_pid_dm_ty_rid_sid` ON mshop_media_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> ALTER TABLE mshop_media CHANGE preview preview TEXT DEFAULT NULL -> CREATE INDEX `idx_msmed_dom_mime_sid` ON mshop_media (`domain`, `mimetype`, `siteid`) -> CREATE INDEX `idx_msmed_label_sid` ON mshop_media (`label`, `siteid`) -> CREATE INDEX `idx_msmed_link_sid` ON mshop_media (`link`, `siteid`) -> ALTER TABLE mshop_media_property_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msmedprty_dom_code_sid` ON mshop_media_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msmedprty_status_sid_pos` ON mshop_media_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msmedprty_label_sid` ON mshop_media_property_type (`label`, `siteid`) -> CREATE INDEX `idx_msmedprty_code_sid` ON mshop_media_property_type (`code`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php (400.5ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php Creating price schema -> ALTER TABLE mshop_price_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msprity_dom_code_sid` ON mshop_price_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msprity_status_sid_pos` ON mshop_price_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msprity_label_sid` ON mshop_price_type (`label`, `siteid`) -> CREATE INDEX `idx_msprity_code_sid` ON mshop_price_type (`code`, `siteid`) -> ALTER TABLE mshop_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' -> CREATE INDEX `idx_mspri_dom_cid_val_sid` ON mshop_price (`domain`, `currencyid`, `value`, `siteid`) -> ALTER TABLE mshop_price_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msprility_dom_code_sid` ON mshop_price_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msprility_status_sid_pos` ON mshop_price_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msprility_label_sid` ON mshop_price_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msprility_code_sid` ON mshop_price_list_type (`code`, `siteid`) -> CREATE UNIQUE INDEX `unq_mspripr_pid_ty_lid_val_sid` ON mshop_price_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_mspripr_key_sid` ON mshop_price_property (`key`, `siteid`) -> ALTER TABLE mshop_price_property_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mspriprty_dom_code_sid` ON mshop_price_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mspriprty_status_sid_pos` ON mshop_price_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mspriprty_label_sid` ON mshop_price_property_type (`label`, `siteid`) -> CREATE INDEX `idx_mspriprty_code_sid` ON mshop_price_property_type (`code`, `siteid`) -> ALTER TABLE mshop_price_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msprili_pid_dm_ty_rid_sid` ON mshop_price_list (`parentid`, `domain`, `type`, `refid`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php (223.87ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php Creating product schema -> CREATE UNIQUE INDEX `unq_mspropr_pid_ty_lid_val_sid` ON mshop_product_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_mspropr_key_sid` ON mshop_product_property (`key`, `siteid`) -> ALTER TABLE mshop_product_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msproty_dom_code_sid` ON mshop_product_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msproty_status_sid_pos` ON mshop_product_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msproty_label_sid` ON mshop_product_type (`label`, `siteid`) -> CREATE INDEX `idx_msproty_code_sid` ON mshop_product_type (`code`, `siteid`) -> ALTER TABLE mshop_product_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msprolity_dom_code_sid` ON mshop_product_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msprolity_status_sid_pos` ON mshop_product_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msprolity_label_sid` ON mshop_product_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msprolity_code_sid` ON mshop_product_list_type (`code`, `siteid`) -> ALTER TABLE mshop_product_property_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msproprty_dom_code_sid` ON mshop_product_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msproprty_status_sid_pos` ON mshop_product_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msproprty_label_sid` ON mshop_product_property_type (`label`, `siteid`) -> CREATE INDEX `idx_msproprty_code_sid` ON mshop_product_property_type (`code`, `siteid`) -> ALTER TABLE mshop_product_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msproli_pid_dm_ty_rid_sid` ON mshop_product_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> ALTER TABLE mshop_product ADD `boost` DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE config config TEXT DEFAULT NULL, CHANGE rating rating NUMERIC(4, 2) DEFAULT '0' NOT NULL -> CREATE UNIQUE INDEX `unq_mspro_code_sid` ON mshop_product (`code`, `siteid`) -> CREATE INDEX `idx_mspro_id_stat_st_end_rt_sid` ON mshop_product (`id`, `status`, `start`, `end`, `rating`, `siteid`) -> CREATE INDEX `idx_mspro_stat_st_end_rt_sid` ON mshop_product (`status`, `start`, `end`, `rating`, `siteid`) -> CREATE INDEX `idx_mspro_rating_sid` ON mshop_product (`rating`, `siteid`) -> CREATE INDEX `idx_mspro_label_sid` ON mshop_product (`label`, `siteid`) -> CREATE INDEX `idx_mspro_start_sid` ON mshop_product (`start`, `siteid`) -> CREATE INDEX `idx_mspro_type_sid` ON mshop_product (`type`, `siteid`) -> CREATE INDEX `idx_mspro_end_sid` ON mshop_product (`end`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php (23789.98ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (266.94ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php (76.05ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php Creating service schema -> ALTER TABLE mshop_service_list CHANGE config config TEXT DEFAULT '{}' -> CREATE UNIQUE INDEX `unq_msserli_pid_dm_ty_rid_sid` ON mshop_service_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> ALTER TABLE mshop_service_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msserlity_dom_code_sid` ON mshop_service_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msserlity_status_sid_pos` ON mshop_service_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msserlity_label_sid` ON mshop_service_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msserlity_code_sid` ON mshop_service_list_type (`code`, `siteid`) -> ALTER TABLE mshop_service_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msserty_dom_code_sid` ON mshop_service_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msserty_status_sid_pos` ON mshop_service_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msserty_label_sid` ON mshop_service_type (`label`, `siteid`) -> CREATE INDEX `idx_msserty_code_sid` ON mshop_service_type (`code`, `siteid`) -> ALTER TABLE mshop_service CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_msser_siteid_code_sid` ON mshop_service (`code`, `siteid`) -> CREATE INDEX `idx_msser_stat_start_end_sid` ON mshop_service (`status`, `start`, `end`, `siteid`) -> CREATE INDEX `idx_msser_prov_sid` ON mshop_service (`provider`, `siteid`) -> CREATE INDEX `idx_msser_code_sid` ON mshop_service (`code`, `siteid`) -> CREATE INDEX `idx_msser_label_sid` ON mshop_service (`label`, `siteid`) -> CREATE INDEX `idx_msser_pos_sid` ON mshop_service (`pos`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php (314.08ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema -> ALTER TABLE mshop_supplier_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mssuplity_dom_code_sid` ON mshop_supplier_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mssuplity_status_sid_pos` ON mshop_supplier_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mssuplity_sid_label_sid` ON mshop_supplier_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mssuplity_sid_code_sid` ON mshop_supplier_list_type (`code`, `siteid`) -> ALTER TABLE mshop_supplier ADD `pos` INT DEFAULT 0 NOT NULL -> CREATE UNIQUE INDEX `unq_mssup_code_sid` ON mshop_supplier (`code`, `siteid`) -> CREATE INDEX `idx_mssup_label_sid` ON mshop_supplier (`label`, `siteid`) -> CREATE INDEX `idx_mssup_sid_stat_pos_label` ON mshop_supplier (`siteid`, `status`, `pos`, `label`) -> ALTER TABLE mshop_supplier_address ADD `type` VARCHAR(64) DEFAULT '' NOT NULL, ADD `mobile` VARCHAR(32) DEFAULT '' NOT NULL -> ALTER TABLE mshop_supplier_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mssupli_pid_dm_ty_rid_sid` ON mshop_supplier_list (`parentid`, `domain`, `type`, `refid`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php (129.72ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php Creating text schema -> ALTER TABLE mshop_text_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mstexty_dom_code_sid` ON mshop_text_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mstexty_status_sid_pos` ON mshop_text_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mstexty_label_sid` ON mshop_text_type (`label`, `siteid`) -> CREATE INDEX `idx_mstexty_code_sid` ON mshop_text_type (`code`, `siteid`) -> ALTER TABLE mshop_text_list_type ADD `i18n` TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mstexlity_dom_code_sid` ON mshop_text_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mstexlity_status_sid_pos` ON mshop_text_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mstexlity_label` ON mshop_text_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mstexlity_code` ON mshop_text_list_type (`code`, `siteid`) -> ALTER TABLE mshop_text CHANGE content content MEDIUMTEXT NOT NULL -> CREATE INDEX `idx_mstex_dom_stat_sid` ON mshop_text (`domain`, `status`, `siteid`) -> CREATE INDEX `idx_mstex_langid_sid` ON mshop_text (`langid`, `siteid`) -> CREATE INDEX `idx_mstex_label_sid` ON mshop_text (`label`, `siteid`) -> ALTER TABLE mshop_text_list CHANGE config config TEXT DEFAULT NULL -> CREATE UNIQUE INDEX `unq_mstexli_pid_dm_ty_rid_sid` ON mshop_text_list (`parentid`, `domain`, `type`, `refid`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php (655.29ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php Update lists "key" columns Checking table mshop_attribute_list Checking table mshop_catalog_list Checking table mshop_customer_list Checking table mshop_media_list Checking table mshop_price_list Checking table mshop_product_list Checking table mshop_service_list Checking table mshop_supplier_list Checking table mshop_text_list Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (1419.97ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (208.35ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (201.28ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first -> DROP INDEX unq_mscus_sid_code ON mshop_customer -> DROP INDEX idx_mscus_sid_langid ON mshop_customer -> DROP INDEX idx_mscus_sid_last_first ON mshop_customer -> DROP INDEX idx_mscus_sid_post_addr1 ON mshop_customer -> DROP INDEX idx_mscus_sid_post_city ON mshop_customer -> DROP INDEX idx_mscus_sid_city ON mshop_customer -> DROP INDEX idx_mscus_sid_email ON mshop_customer -> DROP INDEX idx_mscusad_sid_last_first ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_post_addr1 ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_post_ci ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_city ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_email ON mshop_customer_address -> DROP INDEX unq_mscusli_pid_dm_sid_ty_rid ON mshop_customer_list -> DROP INDEX unq_mscuslity_sid_dom_code ON mshop_customer_list_type -> DROP INDEX idx_mscuslity_sid_status_pos ON mshop_customer_list_type -> DROP INDEX idx_mscuslity_sid_label ON mshop_customer_list_type -> DROP INDEX idx_mscuslity_sid_code ON mshop_customer_list_type -> DROP INDEX fk_mscuspr_key_sid ON mshop_customer_property -> DROP INDEX unq_mcuspr_sid_ty_lid_value ON mshop_customer_property -> DROP INDEX unq_mcusprty_sid_dom_code ON mshop_customer_property_type -> DROP INDEX idx_mcusprty_sid_status_pos ON mshop_customer_property_type -> DROP INDEX idx_mcusprty_sid_label ON mshop_customer_property_type -> DROP INDEX idx_mcusprty_sid_code ON mshop_customer_property_type Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (1764.14ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first -> DROP INDEX idx_t3feuad_langid ON fe_users_address -> DROP INDEX idx_t3feuad_sid_last_first ON fe_users_address -> DROP INDEX idx_t3feuad_sid_post_addr1 ON fe_users_address -> DROP INDEX idx_t3feuad_sid_post_ci ON fe_users_address -> DROP INDEX idx_t3feuad_sid_city ON fe_users_address -> DROP INDEX idx_t3feuad_sid_email ON fe_users_address -> DROP INDEX unq_t3feuli_pid_dm_sid_ty_rid ON fe_users_list -> DROP INDEX unq_t3feulity_sid_dom_code ON fe_users_list_type -> DROP INDEX idx_t3feulity_sid_status_pos ON fe_users_list_type -> DROP INDEX idx_t3feulity_sid_label ON fe_users_list_type -> DROP INDEX idx_t3feulity_sid_code ON fe_users_list_type -> DROP INDEX fk_t3feupr_key_sid ON fe_users_property -> DROP INDEX unq_t3feupr_sid_ty_lid_value ON fe_users_property -> DROP INDEX unq_t3feuprty_sid_dom_code ON fe_users_property_type -> DROP INDEX idx_t3feuprty_sid_status_pos ON fe_users_property_type -> DROP INDEX idx_t3feuprty_sid_label ON fe_users_property_type -> DROP INDEX idx_t3feuprty_sid_code ON fe_users_property_type Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (1380.56ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php Creating log schema -> CREATE INDEX `idx_malog_time_sid` ON madmin_log (`timestamp`, `siteid`) -> CREATE INDEX `idx_malog_facility_sid` ON madmin_log (`facility`, `siteid`) -> CREATE INDEX `idx_malog_prio_sid` ON madmin_log (`priority`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php (297.88ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php Creating group schema -> CREATE UNIQUE INDEX `unq_msgro_code_sid` ON mshop_group (`code`, `siteid`) -> CREATE INDEX `idx_msgro_label_sid` ON mshop_group (`label`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php (79.75ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (60.49ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php Remove old indexes from mshop_index_* tables Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (126.42ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php Creating index schema -> ALTER TABLE mshop_index_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php (142.16ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php Creating job schema -> CREATE INDEX `idx_majob_ctime_sid` ON madmin_job (`ctime`, `siteid`) -> CREATE INDEX `idx_majob_status_sid` ON madmin_job (`status`, `siteid`) Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php (84.74ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php (59.19ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (65.36ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (61.15ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php Separate product ID and parent ID in order base product table

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mlocsi.rating' in 'field list': SELECT mlocsi."id" AS "locale.site.id", mlocsi."siteid" AS "locale.site.siteid", mlocsi."parentid" AS "locale.site.parentid", mlocsi."label" AS "locale.site.label", mlocsi."code" AS "locale.site.code", mlocsi."status" AS "locale.site.status", mlocsi."id" AS "locale.site.position", mlocsi."level" AS "locale.site.level", mlocsi."config" AS "locale.site.config", mlocsi."icon" AS "locale.site.icon", mlocsi."logo" AS "locale.site.logo", mlocsi."rating" AS "locale.site.rating", mlocsi."ratings" AS "locale.site.ratings", mlocsi."refid" AS "locale.site.refid", mlocsi."theme" AS "locale.site.theme", mlocsi."ctime" AS "locale.site.ctime", mlocsi."mtime" AS "locale.site.mtime", mlocsi."editor" AS "locale.site.editor" FROM "mshop_locale_site" mlocsi WHERE ( mlocsi."status" < 1 AND ( mlocsi."siteid" LIKE '1.%' ESCAPE '#' AND ( mlocsi."level" = 0 ) ) ) GROUP BY mlocsi."id", mlocsi."siteid", mlocsi."parentid", mlocsi."label", mlocsi."code", mlocsi."status", mlocsi."level", mlocsi."config", mlocsi."icon", mlocsi."logo", mlocsi."rating", mlocsi."ratings", mlocsi."refid", mlocsi."theme", mlocsi."ctime", mlocsi."mtime", mlocsi."editor" ORDER BY mlocsi."id" ASC LIMIT 100 OFFSET 0

[aimeos]

Can you please add to ./vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php for testing:

Code: Select all

	public function after() : array
	{
		return ['Locale'];
	}

[randomdennis]

Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php (236.44ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (54.52ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (75.33ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (66.54ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (67.49ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php (63.71ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (1373.31ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (125.9ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (192.78ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php Creating cache schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php (61.99ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php (57.52ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (844.88ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (180.22ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (78.23ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (194.09ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php (74.66ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (625.19ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php Rename mshop_customer_group to mshop_group Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRenameGroup.php (57.79ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php Migrate TYPO3 "customer/group" domain to "group" Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRenameGroupTypo3.php (65.2ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (58.5ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php Creating customer schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php (65.31ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php Creating media schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php (61.52ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php Creating price schema -> ALTER TABLE mshop_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php (69.22ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php Creating product schema -> ALTER TABLE mshop_product CHANGE rating rating NUMERIC(4, 2) DEFAULT '0' NOT NULL Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php (65.2ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (184.66ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php (64.94ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php Creating service schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php (58.52ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php (63.88ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php Creating text schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php (120.84ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php Update lists "key" columns Checking table mshop_attribute_list Checking table mshop_catalog_list Checking table mshop_customer_list Checking table mshop_media_list Checking table mshop_price_list Checking table mshop_product_list Checking table mshop_service_list Checking table mshop_supplier_list Checking table mshop_text_list Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (1259.48ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (193.21ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (178.52ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (1494.99ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (1190ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php Creating log schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php (59.66ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php Creating group schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Group.php (79.45ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (57.06ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php Remove old indexes from mshop_index_* tables Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (117.08ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php Creating index schema -> ALTER TABLE mshop_index_price CHANGE value value NUMERIC(12, 2) DEFAULT '0' Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php (140.56ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php Creating job schema Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php (71.5ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php (56.46ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (60.2ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (72.8ms)

Circular dependency for "Locale" detected. Task stack: DemoAddCatalogData, MShopSetLocale, Log, MShopAddLocaleData, MShopAddLocaleDataDefault, LocaleCreateSite, MShopAddLocaleLangCurData, Locale, Group, Index, Job, LocaleMigrateSite, LocaleRemoveCharConstraints, LocaleRenameSiteSupplier, Order, OrderAddProductParentid

[aimeos]

Can you please update to aimeos/aimeos-core:2024.10.x-dev? We've fixed the problem by rewriting the setup task:
https://github.com/aimeos/aimeos-core/b ... rentid.php