Upgrade from 18.10.11 to 22.7.1

Moritz · Post by **Moritz** » 17 Oct 2022, 12:55

If there's any ALTER TABLE statement, it will be printed after the output of "Creating customer schema".

I attached the output of "Creating customer schema" task.

customer_migration.zip: (1.43 KiB) Downloaded 151 times

Can you check if the fe_users.siteid and fe_users_address.siteid columns contains any records with siteid of NULL after the migration from 18.10 to 22.10?

After migration from 18.10 there are no records with NULL in column siteid.

Post by **aimeos** » 17 Oct 2022, 13:26

No clue why the siteid column of the fe_users_address table isn't set to NON NULL by Doctrine DBAL:

Code: Select all

ALTER TABLE fe_users_address ADD `birthday` DATE DEFAULT NULL,
	CHANGE address1 address1 VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`,
	CHANGE address2 address2 VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`,
	CHANGE address3 address3 VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`,
	CHANGE city city VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`,
	CHANGE state state VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`,
	CHANGE telefax telefax VARCHAR(32) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`,
	CHANGE longitude longitude DOUBLE PRECISION DEFAULT '0',
	CHANGE latitude latitude DOUBLE PRECISION DEFAULT '0',
	CHANGE pos pos SMALLINT DEFAULT 0 NOT NULL

Maybe it's a bug in Doctrine. Also, longitude and latitude should be DEFAULT NULL.

Moritz · Post by **Moritz** » 17 Oct 2022, 13:45

Ok strange...
Even the siteid and some other fields are missing in the ALTER TABLE statement, is that correct?
Here are much more specified https://github.com/aimeos/ai-typo3/blob ... stomer.php

And do you have a solution for the download problem?
Re: Upgrade from 18.10.11 to 22.7.1

Post by **aimeos** » 17 Oct 2022, 13:54

Moritz wrote: ↑17 Oct 2022, 13:45 Even the siteid and some other fields are missing in the ALTER TABLE statement, is that correct?
Here are much more specified https://github.com/aimeos/ai-typo3/blob ... stomer.php

The ALTER TABLE statements only contains the columns that need to be changed, not all.

Moritz wrote: ↑17 Oct 2022, 13:45 And do you have a solution for the download problem?
Re: Upgrade from 18.10.11 to 22.7.1

Solution: Re: Upgrade from 18.10.11 to 22.7.1
Type migration task is still part of 2022.10.x

Moritz · Post by **Moritz** » 17 Oct 2022, 14:01

The ALTER TABLE statements only contains the columns that need to be changed, not all.

Hm... Then I have to execute these changes manually...

Solution: viewtopic.php?p=18748#p18751
Type migration task is still part of 2022.10.x

Oh, because with the official 22.10.1 the "fe_users_list.typeid" is still INT after a fresh migration from 18.10.11.

Post by **aimeos** » 17 Oct 2022, 14:04

Moritz wrote: ↑17 Oct 2022, 14:01
Solution: viewtopic.php?p=18748#p18751
Type migration task is still part of 2022.10.x
Oh, because with the official 22.10.1 the "fe_users_list.typeid" is still INT after a fresh migration from 18.10.11.

Then, please check if this setup task executes correctly:
https://github.com/aimeos/ai-typo3/blob ... sTypo3.php

Moritz · Post by **Moritz** » 18 Oct 2022, 08:14

This is the log output of the migration.

: types_migration.png (16.96 KiB) Viewed 3466 times

Post by **aimeos** » 18 Oct 2022, 08:26

Seems to be correct, the type columns are created and data is migrated.
The typeid columns are not removed automatically to avoid data loss.

Moritz · Post by **Moritz** » 18 Oct 2022, 08:56

Ah ok, I misunderstood that.
The download function works now.

Thank you for the great support up to this point!

Moritz · Post by **Moritz** » 21 Oct 2022, 14:18

I still have the error when downloading files from existing order Re: Upgrade from 18.10.11 to 22.7.1
Here a more detailed stacktrace.

Code: Select all

/your-shop/my-account/download?ai%5Baction%5D=download&ai%5Bcontroller%5D=Account&ai%5Bdl_id%5D=2181
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("xxxxxxxx"."fe_users_list", CONSTRAINT "fk_t3feuli_typeid" FOREIGN KEY ("typeid") REFERENCES "fe_users_list_type" ("id") ON DELETE CASCADE ON UPDATE CASCADE):
INSERT INTO "fe_users_list" (
"parentid", "key", "type", "domain", "refid", "start", "end",
"config", "pos", "status", "mtime", "editor", "siteid", "ctime"
) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
["8","order|download|2181","download","order","2181",null,null,"\"count\":0",0,1,"2022-10-21 13:26:03","testuser","1.","2022-10-21 13:26:03"]
#0 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Lists/Base.php(236): Aimeos\Base\DB\Statement\DBAL\Prepared->execute()
#1 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Base.php(154): Aimeos\MShop\Common\Manager\Lists\Base->saveItem()
#2 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Base.php(224): Aimeos\MShop\Common\Manager\Base->save()
#3 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Base.php(224): Aimeos\MShop\Common\Manager\Decorator\Base->save()
#4 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/ListsRef/Traits.php(300): Aimeos\MShop\Common\Manager\Decorator\Base->save()
#5 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/src/MShop/Customer/Manager/Typo3.php(655): Aimeos\MShop\Customer\Manager\Base->saveListItems()
#6 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Base.php(154): Aimeos\MShop\Customer\Manager\Typo3->saveItem()
#7 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Base.php(224): Aimeos\MShop\Common\Manager\Base->save()
#8 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/src/MShop/Common/Manager/Decorator/Base.php(224): Aimeos\MShop\Common\Manager\Decorator\Base->save()
#9 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-controller-frontend/src/Controller/Frontend/Customer/Standard.php(432): Aimeos\MShop\Common\Manager\Decorator\Base->save()
#10 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Account/Download/Standard.php(243): Aimeos\Controller\Frontend\Customer\Standard->store()
#11 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Account/Download/Standard.php(116): Aimeos\Client\Html\Account\Download\Standard->checkDownload()
#12 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Exceptions.php(107): Aimeos\Client\Html\Account\Download\Standard->init()
#13 /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Base.php(153): Aimeos\Client\Html\Common\Decorator\Exceptions->init()
#14 /var/www/typo3/typo3conf/ext/aimeos/Classes/Controller/AccountController.php(43): Aimeos\Client\Html\Common\Decorator\Base->init()

I think that comes from the foreign key fk_t3feuli_typeid of table fe_users_list.
There is a ON UPDATE CASCADE, but I don't know what columns will be updated by this option.

: fe_users_list_foreign_key.png (31.07 KiB) Viewed 3356 times

Connect with your social network account