Situation
When i try to add a related person i get this error “SQL Statement failed on preparation: SELECT * FROM contact_telecom WHERE contact_id = ? ORDER BY rank ASC, is_primary DESC’“
OpenEMR Version
I’m using OpenEMR version 8.0.0, Mysql
Browser:
I’m using: Firefox
Operating System
I’m using: Ubuntu 24.04
Search
Did you search the forum for similar questions? Yes
The and the columns exist in Mysql
Logs
Did you check the logs?sudo grep “contact_telecom” /var/log/apache2/error.log
[Fri Mar 06 14:11:16.959309 2026] [php:notice] [pid 10007] [client 192.168.10.34:33626] [2026-03-06T14:11:16.959008+02:00] OpenEMR.ERROR: Error loading relations for display {“foreign_table”:“patient_data”,“foreign_id”:“2601”,“error”:“Failed to execute statement. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ASC, is_primary DESC’ at line 1 Statement: SELECT * FROM contact_telecom WHERE contact_id = ? ORDER BY rank ASC, is_primary DESC”} , referer: http://192.168.10.134/openemr/interface/patient_file/summary/demographics_full.php
[Fri Mar 06 14:22:08.668655 2026] [php:notice] [pid 10500] [client 192.168.10.34:38988] [2026-03-06T14:22:08.668532+02:00] OpenEMR.ERROR: Error loading relations for form {“foreign_table”:“patient_data”,“foreign_id”:“2601”,“error”:“Failed to execute statement. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ASC, is_primary DESC’ at line 1 Statement: SELECT * FROM contact_telecom WHERE contact_id = ? ORDER BY rank ASC, is_primary DESC”} , referer: http://192.168.10.134/openemr/interface/patient_file/summary/demographics_save.php
[Fri Mar 06 14:22:35.053257 2026] [php:notice] [pid 10129] [client 192.168.10.34:59436] [2026-03-06T14:22:35.053215+02:00] OpenEMR.ERROR: Error loading relations for display {“foreign_table”:“patient_data”,“foreign_id”:“2601”,“error”:“Failed to execute statement. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ASC, is_primary DESC’ at line 1 Statement: SELECT * FROM contact_telecom WHERE contact_id = ? ORDER BY rank ASC, is_primary DESC”} , referer: http://192.168.10.134/openemr/interface/patient_file/summary/demographics_full.php
[Fri Mar 06 14:22:44.845034 2026] [php:notice] [pid 10230] [client 192.168.10.34:59462] [2026-03-06T14:22:44.844836+02:00] OpenEMR.ERROR: Error loading relations for form {“foreign_table”:“patient_data”,“foreign_id”:“2601”,“error”:“Failed to execute statement. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ASC, is_primary DESC’ at line 1 Statement: SELECT * FROM contact_telecom WHERE contact_id = ? ORDER BY rank ASC, is_primary DESC”} , referer: http://192.168.10.134/openemr/interface/patient_file/summary/demographics_save.php
The finder works nicely - it can search and find existing patients.
Could not replicate in demos. First time i try to use so i do not know if it was working properly before
Thank you