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
If you change that, does it then work as expected?
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
Now it comes to the UPDATE part but in the process function the $colname is null because siteId is varchar and not integer https://github.com/aimeos/aimeos-core/b ... d.php#L125
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 a dependency issue now because you've migrated parts of the database before. Can you perform the migration on your original database content from Aimeos 2018.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
Now I get this exception in the upgrade wizard:
"An exception occurred while executing 'ALTER TABLE fe_users_address CHANGE siteid siteid VARCHAR(255) DEFAULT NULL': SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'mtime' at row 1"
"An exception occurred while executing 'ALTER TABLE fe_users_address CHANGE siteid siteid VARCHAR(255) DEFAULT NULL': SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'mtime' at row 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
I tried again with my old 18.10.11 database and Aimeos 22.7.2 and get the same error message.
But maybe you can do more with the longer error message.
But maybe you can do more with the longer error message.
Update failed!
An exception occurred while executing 'ALTER TABLE fe_users_address ADD `birthday` DATE DEFAULT NULL, CHANGE siteid siteid VARCHAR(255) 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': SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'mtime' at row 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
Hm, seems like a default value is added in the mtime column in the first record. Can you check your values in the mtime column?
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
Here is a cutout of my 18.10.11 table.
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
Try to change the ctime and mtime values of "0000-00-00 00:00:00" to something else.
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 changed mtime and ctime to the minimum date '0001-01-01 00:00:00'.
Then the upgrade wizard was successfully.
But all entries in fe_users_address with that minimum date have no siteId. Is that correct?
And in the backend I saw now only customers with a siteid. Before in 18.10.11 all fe_users was displayed.
Then the upgrade wizard was successfully.
But all entries in fe_users_address with that minimum date have no siteId. Is that correct?
And in the backend I saw now only customers with a siteid. Before in 18.10.11 all fe_users was displayed.
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
Check if the siteid is an empty string, 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