Upgrade 2021 to 2023 DB Error

[derJu]

Hello,
The following database errors occur in the database upgrade process. Does anyone have an idea how to fix them?

Update failed!
Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php Migrate type columns Add new type columns Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Drop old unique indexes Checking index "unq_msattr_sid_dom_cod_tid": Checking index "unq_msattli_sid_dm_rid_tid_pid": Checking index "unq_msattpr_sid_tid_lid_value": Checking index "unq_mscatli_sid_dm_rid_tid_pid": Checking index "unq_mscusli_sid_dm_rid_tid_pid": Checking index "unq_mcuspr_sid_tid_lid_value": Checking index "unq_msmedli_sid_dm_rid_tid_pid": Checking index "unq_msmedpr_sid_tid_lid_value": Checking index "unq_msplu_sid_tid_prov": Checking index "unq_msprili_sid_dm_rid_tid_pid": Checking index "unq_msproli_sid_dm_rid_tid_pid": Checking index "unq_mspropr_sid_tid_lid_value": Checking index "unq_msserli_sid_dm_rid_tid_pid": Checking index "unq_mssto_sid_pcode_tid": Checking index "unq_mssupli_sid_dm_rid_tid_pid": Checking index "unq_mstag_sid_dom_tid_lid_lab": Checking index "unq_mstexli_sid_dm_rid_tid_pid": Migrate typeid to type Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Drop typeid columns Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/TypesMigrateColumns.php (1799.14ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/AttributeMigrateKey.php (28.66ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (30.6ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (30.81ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (30.34ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (30.89ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php Migrate typeid to type for TYPO3 Add new type columns for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Drop old unique indexes for TYPO3 Checking index "unq_t3feuli_sid_dm_rid_tid_pid": Checking index "unq_t3feupr_sid_tid_lid_value": Migrate typeid to type for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Drop typeid columns for TYPO3 Checking table "fe_users_list": Checking table "fe_users_property": Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (160.12ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Attribute.php (33.85ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (674.08ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (58.44ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (95.73ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Cache.php Creating cache schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Cache.php (34.77ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Catalog.php (33.5ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (445.73ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (102.77ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (34.63ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (102.6ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Coupon.php (38.58ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (358.25ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php Remove left over TYPO3 fe_users references Remove records from fe_users_address Remove records from fe_users_list Remove records from fe_users_property Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (40.84ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (35.6ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Customer.php Creating customer schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Customer.php (34.49ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Media.php Creating media schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Media.php (35.69ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Price.php Creating price schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Price.php (34.61ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Product.php Creating product schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Product.php (35.31ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (104.56ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/ServiceUniqueCode.php (33.85ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Service.php Creating service schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Service.php (31.17ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Supplier.php (31.27ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Text.php Creating text schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Text.php (61.39ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php Update lists "key" columns Checking table mshop_attribute_list Checking table mshop_catalog_list Checking table mshop_customer_list Checking table mshop_media_list Checking table mshop_price_list Checking table mshop_product_list Checking table mshop_service_list Checking table mshop_supplier_list Checking table mshop_text_list Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (823.61ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (107.24ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (99.24ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (792.88ms) Migrating: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first Migrated: /var/www/html/vendor/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (603.51ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/LocaleMigrateSite.php (41.89ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (40.93ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (40.86ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Locale.php Creating locale schema Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/Locale.php (188.25ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php Add locale data for languages and currencies Adding data for MShop locale languages Adding data for MShop locale currencies Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (39.28ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php Adding data for MShop locale domain Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (34.38ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php (34.26ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php (33.8ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderAddProductParentid.php (33.19ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderConnectTables.php (34.21ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (33.58ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (33.36ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php Rename "suppliername" to "vendor" in "mshop_order_base_product" table Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (104.11ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameTables.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameTables.php (366.69ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameType.php Migrated: /var/www/html/vendor/aimeos/aimeos-core/setup/OrderRenameType.php (33.63ms) Migrating: /var/www/html/vendor/aimeos/aimeos-core/setup/Order.php Creating order schema -> ALTER TABLE mshop_order_product ADD `parentprodid` VARCHAR(36) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, ADD `scale` DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, CHANGE prodid prodid VARCHAR(36) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, CHANGE prodcode prodcode VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, CHANGE stocktype stocktype VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT 'default' NOT NULL COLLATE `utf8mb4_bin`, CHANGE name name VARCHAR(255) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_unicode_ci`, CHANGE quantity quantity DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE price price NUMERIC(12, 2) DEFAULT '0', CHANGE costs costs NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE rebate rebate NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE tax tax NUMERIC(14, 4) DEFAULT '0.0000' NOT NULL, CHANGE taxrate taxrate VARCHAR(255) CHARACTER SET utf8 DEFAULT '{}' NOT NULL COLLATE `utf8_unicode_ci`, CHANGE taxflag taxflag SMALLINT DEFAULT 1 NOT NULL, CHANGE flags flags INT DEFAULT 0 NOT NULL, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE description description TEXT CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_unicode_ci`, CHANGE notes notes TEXT CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_unicode_ci`, CHANGE parentid parentid BIGINT NOT NULL An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\x95(' for column `db`.`mshop_order_product`.`prodcode` at row 37129 #0 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1939): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1881): Doctrine\DBAL\Connection->handleDriverException() #2 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1213): Doctrine\DBAL\Connection->convertExceptionDuringQuery() #3 /var/www/html/vendor/aimeos/upscheme/src/Schema/DB.php(771): Doctrine\DBAL\Connection->executeStatement() #4 /var/www/html/vendor/aimeos/aimeos-core/setup/Order.php(30): Aimeos\Upscheme\Schema\DB->up() #5 /var/www/html/vendor/aimeos/upscheme/src/Up.php(341): Aimeos\Upscheme\Task\Order->up() #6 /var/www/html/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks() #7 /var/www/html/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks() #8 /var/www/html/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks() #9 /var/www/html/vendor/aimeos/upscheme/src/Up.php(328): Aimeos\Upscheme\Up->runTasks() #10 /var/www/html/vendor/aimeos/upscheme/src/Up.php(172): Aimeos\Upscheme\Up->runTasks() #11 /var/www/html/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\Upscheme\Up->up() #12 /var/www/html/vendor/aimeos/aimeos-typo3/Classes/Setup.php(148): Aimeos\Setup->up() #13 /var/www/html/vendor/aimeos/aimeos-typo3/Classes/Setup.php(77): Aimeos\Aimeos\Setup::execute() #14 /var/www/html/vendor/typo3/cms-install/Classes/Service/UpgradeWizardsService.php(275): Aimeos\Aimeos\Setup->executeUpdate() #15 /var/www/html/vendor/typo3/cms-install/Classes/Controller/UpgradeController.php(1099): TYPO3\CMS\Install\Service\UpgradeWizardsService->executeWizard() #16 /var/www/html/vendor/typo3/cms-install/Classes/Middleware/Maintenance.php(234): TYPO3\CMS\Install\Controller\UpgradeController->upgradeWizardsExecuteAction() #17 /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(111): TYPO3\CMS\Install\Middleware\Maintenance->process() #18 /var/www/html/vendor/typo3/cms-core/Classes/Middleware/NormalizedParamsAttribute.php(41): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #19 /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(162): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process() #20 /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php(70): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #21 /var/www/html/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php(80): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle() #22 /var/www/html/vendor/typo3/cms-install/Classes/Http/Application.php(46): TYPO3\CMS\Core\Http\AbstractApplication->handle() #23 /var/www/html/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php(92): TYPO3\CMS\Install\Http\Application->handle() #24 /var/www/html/public/typo3/install.php(19): TYPO3\CMS\Core\Http\AbstractApplication->run() #25 /var/www/html/public/typo3/install.php(20): {closure}() #26 {main}

[aimeos]

Seems like one of your ordered products contains a product code with an escape sequence, so check your data.