Upgrade from 18.10.11 to 22.7.1
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Re: Upgrade from 18.10.11 to 22.7.1
I attached the output of "Creating customer schema" task.If there's any ALTER TABLE statement, it will be printed after the output of "Creating customer schema".
After migration from 18.10 there are no records with NULL in column siteid.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?
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
Re: Upgrade from 18.10.11 to 22.7.1
No clue why the siteid column of the fe_users_address table isn't set to NON NULL by Doctrine DBAL:
Maybe it's a bug in Doctrine. Also, longitude and latitude should be DEFAULT NULL.
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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Upgrade from 18.10.11 to 22.7.1
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
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
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
Re: Upgrade from 18.10.11 to 22.7.1
The ALTER TABLE statements only contains the columns that need to be changed, not all.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
Solution: Re: Upgrade from 18.10.11 to 22.7.1Moritz 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
Type migration task is still part of 2022.10.x
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Upgrade from 18.10.11 to 22.7.1
Hm... Then I have to execute these changes manually...The ALTER TABLE statements only contains the columns that need to be changed, not all.
Oh, because with the official 22.10.1 the "fe_users_list.typeid" is still INT after a fresh migration from 18.10.11.Solution: viewtopic.php?p=18748#p18751
Type migration task is still part of 2022.10.x
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
Re: Upgrade from 18.10.11 to 22.7.1
Then, please check if this setup task executes correctly:
https://github.com/aimeos/ai-typo3/blob ... sTypo3.php
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Upgrade from 18.10.11 to 22.7.1
This is the log output of the migration.
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
Re: Upgrade from 18.10.11 to 22.7.1
Seems to be correct, the type columns are created and data is migrated.
The typeid columns are not removed automatically to avoid data loss.
The typeid columns are not removed automatically to avoid data loss.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Upgrade from 18.10.11 to 22.7.1
Ah ok, I misunderstood that.
The download function works now.
Thank you for the great support up to this point!
The download function works now.
Thank you for the great support up to this point!
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
Re: Upgrade from 18.10.11 to 22.7.1
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.
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.
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()
There is a ON UPDATE CASCADE, but I don't know what columns will be updated by this option.
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3
PHP 7.4.30
Typo3 v11.5.21 LTS
Aimeos web shop 22.10.4-pre3