You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi everyone,
I currently experience an interesting discrepancy of data between my Monica UI and my MariaDB hosting the data.
Self-hosted install Monica 4.1.2 Maria DB 10.5
In the contacts table, I see an entry that has Maeva as first_name and null as last_name.
Once in the Monica UI, look up for Maeva, and update the Last Name (say Jones).
When I go back to my dev interface, close and re-open the db connection (successfully), access the contacts table, the Maeva entry still shows null as last_name.
But the audit_logs table shows this: {"contact_name":"Maeva Jones","contact_id":260}
Now I understand that contact_name is fully updated, but what about first_name and last_name since the info from contact_name is coming from both of them.
The real reason
of me asking this is because I want to "clean" my db and make sure there is a last_name in front of each first_name for dups manipulation.
Anyone has clue on this? Thanks
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Hi everyone,
I currently experience an interesting discrepancy of data between my Monica UI and my MariaDB hosting the data.
Self-hosted install Monica 4.1.2 Maria DB 10.5
In the
contactstable, I see an entry that hasMaevaasfirst_nameandnullaslast_name.Once in the Monica UI, look up for
Maeva, and update the Last Name (sayJones).When I go back to my dev interface, close and re-open the db connection (successfully), access the
contactstable, theMaevaentry still showsnullaslast_name.But the
audit_logstable shows this:{"contact_name":"Maeva Jones","contact_id":260}Now I understand that
contact_nameis fully updated, but what aboutfirst_nameandlast_namesince the info fromcontact_nameis coming from both of them.The real reason
of me asking this is because I want to "clean" my db and make sure there is a
last_namein front of eachfirst_namefor dups manipulation.Anyone has clue on this? Thanks
Beta Was this translation helpful? Give feedback.
All reactions