Bug on created_at in customer_entity table on update

[sdecalom]

Preconditions (*)

1.OpenMage 19.4.23
2.Mysql 8.0

Steps to reproduce (*)

Update a customer created on 2024-07-01 at 15:00.

Expected result (*)

The date of created_at on customer_entity should be 2024.07.01 15:00

Actual result (*)

The created_at date on customer_entity is 2024.07.01 17:00

[addison74]

You have a very old version, unmaintained.

I confirm with the cloned version of the repository from today I cannot reproduce it. I created a customer account in the Backend and the created_at column shows correct information. I updated an existing customer then the column changes with the correct timestamp.

Please try reproducing this issue in a test environment just with the latest version without any extension, modules, or custom work.

[sdecalom]

OK thank you for your support, I will try with the latest version.

[addison74]

Did you manage to solve this issue?

In my tests I used MariaDB and Percona, but I will try to MySQL 8 in order to reproduce this issue.

[sdecalom]

Hello, I manage this issue with this pull request: #4070

…

________________________________ De : ADDISON ***@***.***> Envoyé : mercredi 3 juillet 2024 17:25 À : OpenMage/magento-lts ***@***.***> Cc : Sébastien DECALOM ***@***.***>; State change ***@***.***> Objet : Re: [OpenMage/magento-lts] Bug on created_at in customer_entity table on update (Issue #4069) Did you manage to solve this issue? In my tests I used MariaDB and Percona, but I will try to MySQL 8 in order to reproduce this issue. — Reply to this email directly, view it on GitHub<#4069 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AAY7U4IUCTJ2TEVPCBV3NIDZKQJYDAVCNFSM6AAAAABKHSOIXCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMBWGU2DIMRUG4>. You are receiving this because you modified the open/close state.

[ma4nn]

Why is the created_at column on the customer_entity table set to on update current_timestamp() at all?
I noticed this coincidentally after doing a manual UPDATE on the table and now all customer created dates are overwritten. This must be a bug, right?

[sreichel]

@ma4nn its not only customer_entity ... its for all entity tables. Seems not correct to me. updated_at should be updated.