Situation
Merge Patient moves data from source to target but doesn’t delete source
OpenEMR Version
I’m using OpenEMR version 6.0.0(2)
Browser:
FF98.02
Operating System
I’m using: Ubuntu 18.04
Logs
Did you check the logs? Yes
Was there anything pertinent in them? Yes
‘’’[Fri Apr 01 09:33:51.606640 2022] [php7:notice] [pid 18983] [client 192.168.1.125:63278] SQL Error with statement:query failed: UPDATE patient_birthday_alert SET pid = ? WHERE pid = ?–Duplicate entry ‘3133-3’ for key ‘PRIMARY’==>/var/www/html/openemr/interface/patient_file/merge_patients.php at 91:sqlStatement, referer: https://192.168.1.100/openemr/interface/patient_file/merge_patients.php’’’
What is the safest, easiest way to delete the duplicate (empty) entry?