Billing Manager “date base queries” not working
Upgraded OpenEMR 5.0.2 to 6.0.0
- PHP 7.4.3
- MySQL 8.0.23-0
- Firefox 85.0
- Ubuntu 20.04
Billing queries seem to work for “non-date” Criteria such as Patient Name, Encounter, etc …
The default query of “Date of Service = Today” returns many many encounters in chronological order beginning with 2013-06-17. Other date base queries “Date of Service” and “Date of Billing” yield different results also in chronological order starting at other dates such as 2013-06-07 …
Cherry picking the most relevant items from the apache2/error.log just after a date base search …
-
PHP Notice: Undefined index: query_drop_down_master_billing_x12_partner_id
in /var/www/html/openemr/interface/reports/criteria.tab.php on line 128 -
PHP Notice: Undefined variable: returnval
in /var/www/html/openemr/library/patient.inc on line 309 -
PHP Notice: Trying to access array offset on value of type null
in /var/www/html/openemr/library/patient.inc on line 315 -
PHP Notice: Undefined index: ICD9
in /var/www/html/openemr/interface/billing/billing_report.php on line 1266
I had issues upgrading the database from OpenEMR 5.0.2 to 6.0.0 documented here …
Several “dates” in the mysql database are of value “zero” rather than NULL, I have cleaned some of these up with no effect on the search, other than the erroneous date not being displayed e.g. -0001-11-31 …
Any guidance where to debug my problem would be appreciated. I expect that it has something to do with the funky database upgrade, but I’m not sure where to start …
Thank you ~ Thomas E. Shepherd