Situation
The Front Office Receipts Report (/interface/reports/front_receipts_report.php) is crashing and failing to generate, though the standard Payments report works perfectly fine. Because of how the SQL query is formatted in the logs (grouping by r.dtime and r.pid but selecting non-aggregated columns like p.fname and p.lname), I suspect this is crashing due to an ONLY_FULL_GROUP_BY strict mode violation in the database. How can I figure out exactly what is crashing this and if there is user entered data I need to delete for it to function again?
OpenEMR Version
I’m using OpenEMR version 8.1.0
Browser:
I’m using: Chrome
Operating System
I’m using: Debian / Docker (Server)
Search
Did you search the forum for similar questions? Yes, searched for “Front Office Receipts Report crash” and “ONLY_FULL_GROUP_BY”.
Logs
Did you check the logs? Yes, checked the internal log viewer.
Was there anything pertinent in them? There are no explicit PHP errors logged because the script appears to fatally crash immediately after running the report’s SQL query.
Please paste them here:
2026-09-11 13:43:37 patient-record-Query Billing ablaty Administrators 0 1 Query r.pid, r.dtime, SUM(r.amount1) AS amount1, SUM(r.amount2) AS amount2, MAX(r.method) AS method, MAX(r.source) AS source, MAX(r.user) AS user, p.fname, p.mname, p.lname, p.pubpid FROM payments AS r JOIN form_encounter AS fe ON fe.encounter=r.encounter LEFT OUTER JOIN patient_data AS p ON p.pid = r.pid WHERE r.dtime >= ? AND r.dtime <= ? AND fe.facility_id = ? AND fe.provider_id = ? AND 1 GROUP BY r.dtime, r.pid ORDER BY r.dtime, r.pid ('2026-09-10 00:00:00','2026-09-11 23:59:59','3','5')