Upgrade from 18.10.11 to 22.7.1

Questions around the TYPO3 integration and plugins
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!
User avatar
aimeos
Administrator
Posts: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 21 Sep 2022, 07:25

If you change that, does it then work as expected?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Moritz
Advanced
Posts: 118
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 21 Sep 2022, 07:40

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.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 21 Sep 2022, 07:49

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, Image give us a star

Moritz
Advanced
Posts: 118
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 21 Sep 2022, 08:12

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"
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

Moritz
Advanced
Posts: 118
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 21 Sep 2022, 10:16

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.
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.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 21 Sep 2022, 12:23

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, Image give us a star

Moritz
Advanced
Posts: 118
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 21 Sep 2022, 12:35

Here is a cutout of my 18.10.11 table.

fe_users_address.png
fe_users_address.png (58.48 KiB) Viewed 243 times
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 21 Sep 2022, 15:02

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, Image give us a star

Moritz
Advanced
Posts: 118
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 22 Sep 2022, 08:16

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.
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 22 Sep 2022, 15:09

Check if the siteid is an empty string, not NULL
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply