Monica updates contact updated_at date when listed - Githubissues

monicahq / monica

Personal CRM. Remember everything about your friends, family and business relationships.

https://beta.monicahq.com

GNU Affero General Public License v3.0

21.51k stars 2.15k forks source link

Monica updates contact updated_at date when listed #7068

Open radenui opened 9 months ago

radenui commented 9 months ago

⚠️ This issue respects the following points: ⚠️

[X] This is a bug, not a question or a configuration/webserver/proxy issue.
[X] This issue is not already reported on Github (I've searched it).
[X] I agree to follow Monica's Code of Conduct.

Bug description

Monica updates contact updated_at date when listed

Steps to reproduce

When listing contacts in version 4.x
All displayed contacts are uptated
Typical request executed in DB: 15163 Prepare update contacts set uuid = ?, contacts.updated_at = ? where id = ? 15163 Execute update contacts set uuid = '2917ce9d-2830-44cc-9548-7e9dfadb3929', contacts.updated_at = '2023-12-15 08:47:40' where id = 1

Expected behavior

At list, no modification has been done into the contact. I should expect no update.

Besides, this slows down list drastically!

Environment

Your own self-hosted instance (monica v4)

Version of Monica

4.0.0

Installation method

Docker image

Web server

Nginx

Database engine version

MariaDB

Additional info

No response

FOFANA12 commented 8 months ago

Thank you for reporting this issue. I am working on fixing this issue. Expect a pull request soon!