Update 22 to 24 Errors

[randomdennis]

Thank you very much!

How can i download this for legacy?

[aimeos]

Replace the linked file in your installation for testing until a new version has been released.

[randomdennis]

If i override my OrderAddProductParentid with the new one it works and i get the next/last error:

(1/3) #1265 Doctrine\DBAL\Exception\DriverException
An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'parentid' at row 1

in /var/www/typo3_src-12.4.23/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 118

at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Doctrine\DBAL\Driver\PDO\Exception), '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', array(), array())

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.28ms) 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 (62.01ms) 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 (56.4ms) 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 (64.97ms) 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 (60.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 (64.02ms) 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 (1272.62ms) 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.06ms) 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 (183.86ms) 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 (58.22ms) 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 (65.02ms) 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 (771.37ms) 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 (179.96ms) 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 (55.33ms) 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 (191.03ms) 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 (60.74ms) 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 (624.59ms) 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 (65.26ms) 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 (55.52ms) 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 (60.42ms) 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 (56.48ms) 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 (59.89ms) 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 (62.38ms) 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 (64.01ms) 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 (171.03ms) 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 (69.2ms) 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 (53.65ms) 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 (58.4ms) 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 (127.78ms) 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 (1241.28ms) 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 (191.49ms) 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 (186.5ms) 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 (1455.84ms) 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 (1157.94ms) 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 (56.38ms) 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 (68.11ms) 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 (55.38ms) 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.69ms) 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 (125.28ms) 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 (65.11ms) 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.24ms) 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.62ms) 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 (56.11ms) 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 Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php (212.81ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php -> ALTER TABLE mshop_order_base_address DROP FOREIGN KEY fk_msordbaad_baseid -> DROP INDEX unq_msordbaad_bid_type ON mshop_order_base_address -> ALTER TABLE mshop_order_base_address ADD `parentid` BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_address DROP baseid -> ALTER TABLE mshop_order_base_coupon DROP FOREIGN KEY fk_msordbaco_baseid -> ALTER TABLE mshop_order_base_coupon ADD `parentid` BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_coupon DROP baseid -> ALTER TABLE mshop_order_base_product DROP FOREIGN KEY fk_msordbapr_baseid -> DROP INDEX unq_msordbapr_bid_pos ON mshop_order_base_product -> ALTER TABLE mshop_order_base_product ADD `parentid` BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_product DROP baseid -> ALTER TABLE mshop_order_base_service DROP FOREIGN KEY fk_msordbase_baseid -> DROP INDEX unq_msordbase_bid_sid_cd_typ ON mshop_order_base_service -> ALTER TABLE mshop_order_base_service ADD `parentid` BIGINT DEFAULT NULL -> ALTER TABLE mshop_order_base_service DROP baseid -> ALTER TABLE mshop_subscription ADD `orderid` BIGINT DEFAULT NULL -> ALTER TABLE mshop_subscription DROP baseid Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php (1829.91ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (53.08ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (53.94ms) 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 (169.2ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameTables.php -> ALTER TABLE mshop_order_base_product_attr DROP FOREIGN KEY fk_msordbaprat_parentid -> ALTER TABLE mshop_order_base_service_attr DROP FOREIGN KEY fk_msordbaseat_parentid -> DROP INDEX idx_msordbaprat_si_cd_va ON mshop_order_base_product_attr -> DROP INDEX unq_msordbaprat_oid_aid_ty_cd ON mshop_order_base_product_attr -> DROP INDEX unq_msordbaseat_oid_aid_ty_cd ON mshop_order_base_service_attr -> DROP INDEX idx_msordbaseat_si_cd_va ON mshop_order_base_service_attr Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameTables.php (659.16ms) 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 (56.17ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php Creating order schema -> CREATE TABLE `mshop_order_basket` (`id` VARCHAR(255) NOT NULL, `siteid` VARCHAR(255) NOT NULL, `customerid` VARCHAR(36) DEFAULT '' NOT NULL, `content` MEDIUMTEXT DEFAULT '' NOT NULL, `name` VARCHAR(255) DEFAULT '' NOT NULL, `mtime` DATETIME NOT NULL, `ctime` DATETIME NOT NULL, `editor` VARCHAR(255) NOT NULL, INDEX `idx_msordca_custid` (`customerid`), INDEX `idx_msordca_mtime` (`mtime`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB -> CREATE TABLE `mshop_order_service_tx` (`id` BIGINT AUTO_INCREMENT NOT NULL, `siteid` VARCHAR(255) NOT NULL, `parentid` BIGINT NOT NULL, `type` VARCHAR(16) DEFAULT '' NOT NULL, `currencyid` VARCHAR(3) NOT NULL, `price` NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, `costs` NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, `rebate` NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, `tax` NUMERIC(14, 4) DEFAULT '0.0000' NOT NULL, `taxflag` SMALLINT DEFAULT 1 NOT NULL, `status` SMALLINT DEFAULT -1 NOT NULL, `config` TEXT DEFAULT NULL, `mtime` DATETIME NOT NULL, `ctime` DATETIME NOT NULL, `editor` VARCHAR(255) NOT NULL, INDEX `fk_msordsetx_parentid` (`parentid`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB -> ALTER TABLE `mshop_order_service_tx` ADD CONSTRAINT `fk_msordsetx_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order_service` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> ALTER TABLE mshop_order_coupon CHANGE parentid parentid BIGINT NOT NULL -> ALTER TABLE mshop_order_coupon ADD CONSTRAINT `fk_msordco_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE INDEX `idx_msordco_pid_code` ON mshop_order_coupon (`parentid`, `code`) -> CREATE INDEX `fk_msordco_parentid` ON mshop_order_coupon (`parentid`) -> ALTER TABLE mshop_order_product_attr ADD `price` NUMERIC(12, 2) DEFAULT '0' -> ALTER TABLE mshop_order_product_attr ADD CONSTRAINT `fk_msordprat_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order_product` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_msordprat_pid_aid_ty_cd` ON mshop_order_product_attr (`parentid`, `attrid`, `type`, `code`) -> CREATE INDEX `fk_msordprat_parentid` ON mshop_order_product_attr (`parentid`) -> ALTER TABLE mshop_order_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

[aimeos]

Can you please check if your mshop_order_base_product.parentid column still has NULL values? If yes, check if there are records in the mshop_order_base_product table of the original database which doesn't have a corresponding record in the mshop_order_base table any more.

[randomdennis]

After the failed update, there is an entry with ParentID NULL in the mshop_order_product:



But i dont find missing entries or null/ empty string as baseid:
SELECT p.*
FROM mshop_order_base_product p
LEFT JOIN mshop_order_base b ON p.baseid = b.id
WHERE b.id IS NULL;

The Entry before:

[aimeos]

The "id" value of that row is "1", which means that it's part of the first order you've ever done. If you find out what's wrong there and fix it, your migration is likely to succeed.

[randomdennis]

mhm if i remove the first order/items before update i get:

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 (247.85ms) 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 (52.58ms) 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 (51.21ms) 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 (52.13ms) 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 (55.1ms) 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 (62.51ms) 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 (1189.88ms) 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 (114.5ms) 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 (161.97ms) 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 (55.83ms) 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 (56.27ms) 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 (742.8ms) 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 (165.11ms) 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 (63.15ms) 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 (172.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 (54.24ms) 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 (574.27ms) 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.32ms) 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 (55.11ms) 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 (57.16ms) 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.1ms) 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 (54.45ms) 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 (64.62ms) 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 (70.51ms) 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 (178.84ms) 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 (63.07ms) 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 (53.9ms) 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 (62.95ms) 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 (117.57ms) 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 (1206.63ms) 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 (186.4ms) 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 (179.12ms) 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 (1377.03ms) 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 (1081.85ms) 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.14ms) 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 (54.61ms) 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 (56.95ms) 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 (109.06ms) 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 (122.6ms) 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 (58.7ms) 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 (53.67ms) 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 (55.68ms) 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 (59.25ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php (54.31ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderConnectTables.php (57.12ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (54.32ms) Migrating: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php Migrated: /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (54.53ms) 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 (173.5ms) 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 (449.43ms) 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 (56.65ms) 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 An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'parentid' at row 1 #0 /var/www/typo3_src-12.4.23/vendor/doctrine/dbal/src/Connection.php(1939): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #1 /var/www/typo3_src-12.4.23/vendor/doctrine/dbal/src/Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 /var/www/typo3_src-12.4.23/vendor/doctrine/dbal/src/Connection.php(1213): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'ALTER TABLE msh...', Array, Array) #3 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Schema/DB.php(826): Doctrine\DBAL\Connection->executeStatement('ALTER TABLE msh...') #4 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php(36): Aimeos\Upscheme\Schema\DB->up() #5 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(364): Aimeos\Upscheme\Task\Order->up() #6 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(351): Aimeos\Upscheme\Up->runTasks(Array, Array) #7 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(351): Aimeos\Upscheme\Up->runTasks(Array, Array) #8 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(351): Aimeos\Upscheme\Up->runTasks(Array, Array) #9 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(351): Aimeos\Upscheme\Up->runTasks(Array, Array) #10 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(351): Aimeos\Upscheme\Up->runTasks(Array, Array) #11 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(351): Aimeos\Upscheme\Up->runTasks(Array, Array) #12 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(351): Aimeos\Upscheme\Up->runTasks(Array, Array) #13 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/upscheme/src/Up.php(191): Aimeos\Upscheme\Up->runTasks(Array) #14 /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/Setup.php(84): Aimeos\Upscheme\Up->up() #15 /var/www/typo3conf/ext/aimeos/Classes/Setup.php(148): Aimeos\Setup->up('default', 'default') #16 /var/www/typo3conf/ext/aimeos/Classes/Setup.php(77): Aimeos\Aimeos\Setup::execute() #17 /var/www/typo3_src-12.4.23/typo3/sysext/install/Classes/Service/UpgradeWizardsService.php(275): Aimeos\Aimeos\Setup->executeUpdate() #18 /var/www/typo3_src-12.4.23/typo3/sysext/install/Classes/Controller/UpgradeController.php(1099): TYPO3\CMS\Install\Service\UpgradeWizardsService->executeWizard('aimeos', Array) #19 /var/www/typo3_src-12.4.23/typo3/sysext/install/Classes/Middleware/Maintenance.php(234): TYPO3\CMS\Install\Controller\UpgradeController->upgradeWizardsExecuteAction(Object(TYPO3\CMS\Core\Http\ServerRequest)) #20 /var/www/typo3_src-12.4.23/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(111): TYPO3\CMS\Install\Middleware\Maintenance->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #21 /var/www/typo3_src-12.4.23/typo3/sysext/core/Classes/Middleware/NormalizedParamsAttribute.php(41): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #22 /var/www/typo3_src-12.4.23/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #23 /var/www/typo3_src-12.4.23/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(70): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #24 /var/www/typo3_src-12.4.23/typo3/sysext/core/Classes/Http/AbstractApplication.php(83): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #25 /var/www/typo3_src-12.4.23/typo3/sysext/install/Classes/Http/Application.php(46): TYPO3\CMS\Core\Http\AbstractApplication->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #26 /var/www/typo3_src-12.4.23/typo3/sysext/core/Classes/Http/AbstractApplication.php(95): TYPO3\CMS\Install\Http\Application->handle(Object(TYPO3\CMS\Core\Http\ServerRequest)) #27 /var/www/typo3_src-12.4.23/typo3/install.php(19): TYPO3\CMS\Core\Http\AbstractApplication->run() #28 /var/www/typo3_src-12.4.23/typo3/install.php(20): {closure}() #29 {main}

[aimeos]

The error is still the same:

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 An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'parentid' at row 1

[randomdennis]

I had an mshop_order_base with ID 1 that had no more friends. I deleted it, the update is going through (again completely clean at the first attempt). It looks better, but the invoice numbers are still missing.





If i try to sort by Invoice Nr i get this error somehow. (I had to change customerref from NULL to empty string to fix this)
Aimeos\MShop\Order\Item\Standard::getCustomerReference(): Return value must be of type string, null returned
in /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Order/Item/Standard.php line 298


If i try to set the old Invoicenumber i get: Error saving data/ Necessary parameter “id” missing
Maybe CustomerID or something like that?

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1757-1' for key 'unq_msordpr_pid_pos'

[aimeos]

I had an mshop_order_base with ID 1 that had no more friends. I deleted it, the update is going through (again completely clean at the first attempt). It looks better, but the invoice numbers are still missing.

OK, so the migration problems are fixed now. The invoice number is empty because in your old installation it didn't exist. In 2024.10, the invoice number is shown instead of the order ID column by default but you can change that in the column selector. The transactions are always empty because you created to refunds yet.

If i try to sort by Invoice Nr i get this error somehow. (I had to change customerref from NULL to empty string to fix this)
Aimeos\MShop\Order\Item\Standard::getCustomerReference(): Return value must be of type string, null returned
in /var/www/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Order/Item/Standard.php line 298

This will be fixed with the next release.

And also since my first attamp, the Charts in Backend dont load:
typo3/module/web/aimeos/Jsonadm/index?token=6c33af1ab6ce34d4806569e4a9ff8d63038cdc2c&ai%5Bsite%5D=default' because it violates the document's Content Security Policy.
Refused to connect to '<URL>' because it violates the following Content Security Policy directive: "connect-src 'self' <URL>

The Aimeos extension contains a set of CSP rules in the JQAdm Fluid template:
https://github.com/aimeos/aimeos-typo3/ ... dm.html#L7

Can you check if you left-click into the Aimeos backend and select "Show frame source" (e.g. in Chrome). There must be a line in the HTML head beginning with:

Code: Select all

<meta http-equiv="Content-Security-Policy" content="default-src ...

A possible problem might be if you use http://127.0.0.1/typo3 but TYPO3 allows only http://localhost/typo3 (e.g. in the PHP file for the TYPO3 settings)