search

OpenMage / magento-lts

Official OpenMage LTS codebase | Migrate easily from Magento Community Edition in minutes! Download the source code for free or contribute to OpenMage LTS | Security vulnerability patches, bug fixes, performance improvements and more.
https://www.openmage.org
Open Software License 3.0
866 stars 435 forks source link

Bug on created_at in customer_entity table on update #4069

Open sdecalom opened 2 months ago

sdecalom commented 2 months ago

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 image

Actual result (*)

The created_at date on customer_entity is 2024.07.01 17:00 image

ADDISON74 commented 2 months ago

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 commented 2 months ago

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

ADDISON74 commented 2 months ago

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 commented 2 months ago

Hello,

I manage this issue with this pull request: https://github.com/OpenMage/magento-lts/pull/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 GitHubhttps://github.com/OpenMage/magento-lts/issues/4069#issuecomment-2206544247, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAY7U4IUCTJ2TEVPCBV3NIDZKQJYDAVCNFSM6AAAAABKHSOIXCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMBWGU2DIMRUG4. You are receiving this because you modified the open/close state.