OEMR 5.0.2 Merge Error

Support
#1

Situation
Describe your problem here
Merge is not working properly

OpenEMR Version
I’m using OpenEMR version 5.0.2

Browser:
I’m using: Chrome

Operating System
I’m using: Server Ubuntu/WS Ubuntu

UPDATE clinical_rules_log SET pid = ? WHERE pid = ? (5)
UPDATE employer_data SET pid = ? WHERE pid = ? (1)
DELETE FROM history_data WHERE pid = ? (1)
DELETE FROM insurance_data WHERE pid = ? (3)

Query Error

ERROR: query failed: SHOW COLUMNS FROM keys WHERE Field LIKE ‘pid’ OR Field LIKE ‘patient_id’

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘keys WHERE Field LIKE ‘pid’ OR Field LIKE ‘patient_id’’ at line 1

/var/www/html/openemr/interface/patient_file/merge_patients.php at 216:sqlQuery

#2

Samething on Development Demo 5.0.3-dev

UPDATE clinical_rules_log SET pid = ? WHERE pid = ? (1)
UPDATE employer_data SET pid = ? WHERE pid = ? (1)
DELETE FROM history_data WHERE pid = ? (1)
DELETE FROM insurance_data WHERE pid = ? (3)

Query Error

ERROR: query failed: SHOW COLUMNS FROM keys WHERE Field LIKE ‘pid’ OR Field LIKE ‘patient_id’

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘keys WHERE Field LIKE ‘pid’ OR Field LIKE ‘patient_id’’ at line 1

/var/www/localhost/htdocs/a/openemr/interface/patient_file/merge_patients.php at 216:sqlQuery

OpenEMR 5.0.2 Patch
#3

Hi @APerez ,

Thanks for the report. Fixed here:

This fix will be in next 5.0.2 patch.

-brady