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 thecontacts table, I see an entry that hasMaeva asfirst_name andnull aslast_name. Once in the Monica UI, look up forMaeva, and update the Last Name (sayJones). When I go back to my dev interface, close and re-open the db connection (successfully), access thecontacts table, theMaeva entry still showsnull aslast_name. But theaudit_logs table shows this:
{"contact_name":"Maeva Jones","contact_id":260} Now I understand thatcontact_name is fully updated, but what aboutfirst_name andlast_name since the info fromcontact_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 alast_name in front of eachfirst_name for dups manipulation. Anyone has clue on this? Thanks |