Upgrade from 18.10.11 to 22.7.1

[aimeos]

If you change that, does it then work as expected?

[Moritz]

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

[aimeos]

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?

[Moritz]

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"

[Moritz]

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

[aimeos]

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?

[Moritz]

Here is a cutout of my 18.10.11 table.

fe_users_address.png (58.48 KiB) Viewed 1891 times

[aimeos]

Try to change the ctime and mtime values of "0000-00-00 00:00:00" to something else.

[Moritz]

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.

[aimeos]

Check if the siteid is an empty string, not NULL