Good morning,
changed the file SearchFieldStatementResolver.php as proposed.
Error persists in 7.0.4
Did not try 8.0.0.
”SQL Statement failed on preparation: SELECT lists.* ,medications.lists_medication_id ,medications.list_id ,medications.usage_category ,medications.usage_category_title ,medications.drug_dosage_instructions ,medications.request_intent ,medications.request_intent_title ,medications.medication_adherence_information_source ,medications.medication_adherence ,medications.medication_adherence_date_asserted ,medications.is_primary_record ,medications.reporting_source_record_id ,medications.reporting_source_uuid ,medications.reporting_source_type FROM lists LEFT JOIN ( SELECT lists_medication.id AS lists_medication_id ,list_id ,usage_category ,usage_category_title ,drug_dosage_instructions ,request_intent ,request_intent_title ,medication_adherence_information_source ,medication_adherence ,medication_adherence_date_asserted ,is_primary_record ,reporting_source_record_id ,users.uuid AS reporting_source_uuid ,‘user’ AS reporting_source_type FROM lists_medication LEFT JOIN users ON users.id = lists_medication.reporting_source_record_id ) medications ON medications.list_id = lists.id WHERE ((NULLIF(enddate, ‘’) IS NULL) OR enddate > ?) AND pid = ? ORDER BY lists.begdate ’
Fatal error: Uncaught OpenEMR\Common\Database\SqlQueryException: Failed to execute statement. Error: Incorrect DATETIME value: ‘’ Statement: SELECT lists.* ,medications.lists_medication_id ,medications.list_id ,medications.usage_category ,medications.usage_category_title ,medications.drug_dosage_instructions ,medications.request_intent ,medications.request_intent_title ,medications.medication_adherence_information_source ,medications.medication_adherence ,medications.medication_adherence_date_asserted ,medications.is_primary_record ,medications.reporting_source_record_id ,medications.reporting_source_uuid ,medications.reporting_source_type FROM lists LEFT JOIN ( SELECT lists_medication.id AS lists_medication_id ,list_id ,usage_category ,usage_category_title ,drug_dosage_instructions ,request_intent ,request_intent_title ,medication_adherence_information_source ,medication_adherence ,medication_adherence_date_asserted ,is_primary_record ,reporting_source_record_id ,users.uuid AS reporting_source_uuid ,‘user’ AS reporting_source_type FROM lists_medication LEFT JOIN users ON users.id = lists_medication.reporting_source_record_id ) medications ON medications.list_id = lists.id WHERE ((NULLIF(enddate, ‘’) IS NULL) OR enddate > ?) AND pid = ? ORDER BY lists.begdate in /var/www/html/openemr/library/sql.inc.php:188 Stack trace: #0 /var/www/html/openemr/src/Common/Database/QueryUtils.php(162): sqlStatementThrowException() #1 /var/www/html/openemr/src/Services/PatientIssuesService.php(212): OpenEMR\Common\Database\QueryUtils::sqlStatementThrowException() #2 /var/www/html/openemr/src/Services/PatientIssuesService.php(98): OpenEMR\Services\PatientIssuesService->search() #3 /var/www/html/openemr/controllers/C_Prescription.class.php(1223): OpenEMR\Services\PatientIssuesService->getActiveIssues() #4 /var/www/html/openemr/controllers/C_Prescription.class.php(152): C_Prescription->getDiagnosisCodesList() #5 /var/www/html/openemr/library/classes/Controller.class.php(157): C_Prescription->edit_action() #6 /var/www/html/openemr/controller.php(6): Controller->act() #7 {main} thrown in /var/www/html/openemr/library/sql.inc.php on line 188
SearchFieldStatementResolver.php (16.1 KB)
”
check the file pls that i changed the line as suggested.
Everything else seems to function properly besides the insurance module as i did report last year
” Cannot edit insurance form - #2 by stephenwaite ”
This problem also persists.
Suggestions?
Thank you
Evgenios