WENO Pharmacy List/Name Search Function

Support
, ,
1

Situation
I have installed patch 7.0.2 (2) and have installed and configured the WENO module as well, however, when trying to edit patient demographics. The search feature for the pharmacies does not work. I have downloaded the pharmacy database using the built in admin tool to no avail. It just stays blank and does not display the pharmacies.

OpenEMR Version
I’m using OpenEMR version 7.0.2 (2)

Browser:
I’m using: I have tested both Firefox and Chrome with the same results.

Operating System
I’m using: Linux/Windows

Search
Did you search the forum for similar questions? Yes, no issues.

Logs
Did you check the logs? Yes
Was there anything pertinent in them?
[Thu Nov 14 21:15:06.655264 2024] [php:notice] [pid 64391] [client ::1:39872] SQL Error with statement:query failed: SELECT Business_Name, state, ncpdp_safe, city, address_line_1 FROM weno_pharmacy WHERE (`Deleted` IS NULL OR `Deleted` = '') AND (state_wide_mail_order = 'Local') AND test_pharmacy = ? ORDER BY Business_Name ASC--Incorrect DATETIME value: ''==>/var/www/html/openemr/interface/modules/custom_modules/oe-module-weno/scripts/weno_pharmacy_search.php at 166:sqlStatement, referer: http://localhost/openemr/interface/patient_file/summary/demographics_full.php

2

I corrected this issue and the pharmacy search function is now working.

The solution was to change the datetime inside of the weno_pharmacy MySQL database to time.

1317×364 201 KB

I have no real understanding of why this works or why it fixed it but it did.

I hope this helps someone else down the road.