# Front Office Receipts Report crashing

**URL:** <https://community.open-emr.org/t/front-office-receipts-report-crashing/27046>\
**Category:** Support\
**Tags:** billing, database\
**Created:** [September 11, 2026, 6:51pm UTC](https://community.open-emr.org/t/front-office-receipts-report-crashing/27046 "2026-09-11T18:51:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sundog](https://community.open-emr.org/letter_avatar_proxy/v4/letter/s/d2c977/32.png) [@sundog](https://community.open-emr.org/u/sundog)\
**Post date:** [September 11, 2026, 6:51pm UTC](https://community.open-emr.org/t/front-office-receipts-report-crashing/27046/1 "2026-09-11T18:51:50Z")

</div>

**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:

```auto
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')

```

---

<div class="post-metadata">

**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\
**Post date:** [September 14, 2026, 9:54pm UTC](https://community.open-emr.org/t/front-office-receipts-report-crashing/27046/2 "2026-09-14T21:54:51Z")

</div>

Hi @sundog , thanks for the report. Could you try upgrading to OpenEMR v8.4.0?