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
The siteid of both tables was NULL.
I set both to an empty string and now all users are displayed.
Are these changes become part of the upgrade wizard or do I still execute them manually?
And the change of this line https://github.com/aimeos/ai-typo3/blob ... o3.php#L49 to
I set both to an empty string and now all users are displayed.
Are these changes become part of the upgrade wizard or do I still execute them manually?
Code: Select all
UPDATE fe_users_address SET mtime = '0001-01-01 00:00:00' WHERE mtime = 0;
UPDATE fe_users_address SET ctime = '0001-01-01 00:00:00' WHERE ctime = 0;
UPDATE fe_users SET siteid = '' WHERE siteid IS NULL;
UPDATE fe_users_address SET siteid = '' WHERE siteid IS NULL;
Code: Select all
if( !$db->hasTable( 'mshop_locale_site' ) || !$db->hasColumn( 'mshop_locale_site', 'siteid' ) )
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
Can you investigate where the mtime/ctime values in your fe_users_address come from?Moritz wrote: ↑23 Sep 2022, 06:49 Are these changes become part of the upgrade wizard or do I still execute them manually?Code: Select all
UPDATE fe_users_address SET mtime = '0001-01-01 00:00:00' WHERE mtime = 0; UPDATE fe_users_address SET ctime = '0001-01-01 00:00:00' WHERE ctime = 0;
Guess, they are not inserted by Aimeos because otherwise, these columns wouldn't have "0" values.
This should be already done because of this line:
https://github.com/aimeos/ai-typo3/blob ... o3.php#L60
These lines have been added now to set the site ID values of the fe_users_address table correctly:
https://github.com/aimeos/ai-typo3/blob ... hp#L63-L65
This should not be necessary if you upgrade from scratch.Moritz wrote: ↑23 Sep 2022, 06:49 And the change of this line https://github.com/aimeos/ai-typo3/blob ... o3.php#L49 toCode: Select all
if( !$db->hasTable( 'mshop_locale_site' ) || !$db->hasColumn( 'mshop_locale_site', 'siteid' ) )
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
I think I can't...Can you investigate where the mtime/ctime values in your fe_users_address come from?
Guess, they are not inserted by Aimeos because otherwise, these columns wouldn't have "0" values.
The values was already there before the update.
Ah perfect.This should be already done because of this line:
https://github.com/aimeos/ai-typo3/blob ... o3.php#L60
In my v22.7.3-pre6 the tablename bugfix isn't fixed.
You can evaluate this better.This should not be necessary if you upgrade from scratch.
But is the logic correct?
You skip the migration task if mshop_locale_site has the column siteid?
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
There's still a dependency error. Currently, the TYPO3 siteid migration task runs after the general siteid migration task and thus, the column is already created and the TYPO3 task won't do anything. We've changed the dependency so the TYPO3 siteid migration task will be executed before the general siteid migration task. Then, it should be correct.
Here's a new package:
https://aimeos.org/fileadmin/download/a ... 3-pre7.zip
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
Thank you for the prerelease!
I found another issue when I want to download a file from order.
There is a foreign key on fe_users_list.type to fe_users_list_type.id of datatype integer.
The SQL tries to insert a string in this column.
The exception occurs in "aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Account/Download/Standard.php(243)".
Maybe there is a missing migration of the foreign key?
I found another issue when I want to download a file from order.
There is a foreign key on fe_users_list.type to fe_users_list_type.id of datatype integer.
The SQL tries to insert a string in this column.
The exception occurs in "aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Account/Download/Standard.php(243)".
Maybe there is a missing migration of the foreign key?
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 setup task for migrating the type columns in the fe_users_* tables had been removed by accident in 2022.04. Now, it's available again in the 22.10.1-pre1 pre-release. Please test if the typeid column in fe_users_list and fe_users_property is changed from INT to VARCHAR:
https://aimeos.org/fileadmin/download/a ... 1-pre1.zip
https://aimeos.org/fileadmin/download/a ... 1-pre1.zip
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
When installing v22.10.1-pre1 with my old v18.10.11 tables I get the following exception.
With v22.7.3-pre7 the upgrade wizard is successfully.
With v22.7.3-pre7 the upgrade wizard is successfully.
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
MySQL doesn't accept quotes in table and column names by default. Here's a new package:
https://aimeos.org/fileadmin/download/a ... 1-pre2.zip
https://aimeos.org/fileadmin/download/a ... 1-pre2.zip
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
The installation of v22.10.1-pre2 works now.
But there are some users missing again in the backend.
Also the entries in fe_users_address are away of these users.
Because of that I can't see any orders of those users in frontend account history.
In v22.7.3-pre7 that was working.
But there are some users missing again in the backend.
Also the entries in fe_users_address are away of these users.
Because of that I can't see any orders of those users in frontend account history.
In v22.7.3-pre7 that was working.
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 catalog tree to filter with by category isn't working too...
Edit: Or do you have changed the strukture of the template again?
I modified the styles to display the filter tree like a sidemenu.
Works also in v22.7.3-pre7 but not with v22.10.1-pre2.
Edit: Or do you have changed the strukture of the template again?
I modified the styles to display the filter tree like a sidemenu.
Works also in v22.7.3-pre7 but not with v22.10.1-pre2.
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