Unable to get prescriptions after 7.0.4 upgrade

Support
1

Situation
When I try to add a prescription I get this error:

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 ((enddate IS NULL OR enddate = ‘’) OR enddate > ?) AND pid = ? ORDER BY lists.begdate ’

OpenEMR Version
I’m using OpenEMR version - 7.0.4

Browser:
I’m using: Firefox and Chrome

Operating System
I’m using: Linux, Ubuntu

Search
Did you search the forum for similar questions? yes

Logs
Did you check the logs? Yes

[Tue Feb 17 12:59:42.699440 2026] [php:notice] [pid 446252] [client 71.40.67.126:57900] DEBUG fragment: [ WHERE ((enddate IS NULL OR enddate = ‘’) OR enddate > ?) AND pid = ?], referer: http://71.40.67.126/controller.php?prescription&list&id=846

[Tue Feb 17 12:59:42.699461 2026] [php:notice] [pid 446252] [client 71.40.67.126:57900] DEBUG bindArray: Array
(
[0] => 2000-01-01 23:59:59.099900
[1] => 846
), referer: http://71.40.67.126/controller.php?prescription&list&id=846

[Tue Feb 17 12:59:42.711498 2026] [php:error] [pid 446252] [client 71.40.67.126:57900] PHP 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 ((enddate IS NULL OR enddate = ‘’) 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(214): OpenEMR\Common\Database\QueryUtils::sqlStatementThrowException()
#2 /var/www/html/openemr/src/Services/PatientIssuesService.php(97): 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

The debug logs show the correct date value (2000-01-01 23:59:59.099900) is being passed in the bind array, but MySQL is still receiving an empty string for the DATETIME comparison. This occurs in PatientIssuesService->getActiveIssues() when trying to load the prescription form.

2

Same problem here. Both for 7.04 and 8.0.0. Had to downgrade to 7.03 (restore the VM prior uograde)
Ubuntu 24.04,
mysql Ver 8.0.45-0ubuntu0.24.04.1 for Linux on x86_64 ((Ubuntu))
PHP 8.3.6 (cli) (built: Jan 7 2026 08:40:32) (NTS)

thank you

3

Thanks for the reports @nursejeff and @eumetaxas. Can you reproduce the issue on the main demo or this Alternate Demo or Another Alternate Demo please?

4

On this demo
https://demo.openemr.io/openemr/index.php

and this
https://demo.openemr.io/a/openemr/index.php

i cannot reproduce it.

Are these fresh installs?

Both of us have the same issue after upgrading from 7.0.3. to 7.0.4 or 8.0.0.

Thank you

Evgenios

5

Hi @eumetaxas, thanks for testing. Those demos run an upgrade with limited data from version 5 so might not be catching what’s in your db.

6

Thank you.
What’s the next step?

Evgenios

Στις Παρ 20 Φεβ 2026, 17:16 ο χρήστης Stephen Waite <noreply@mail.open-emr.org> έγραψε:

7

hi @eumetaxas, @adunsulag warned us in the comments above this line of code. Try replacing it with

$clauses[] = "(NULLIF(" . $searchField->getField() . ", '') IS NULL) ";

please.

8

Dear Stephen.
Thank you for your prompt reply.
I’ll try that next week and let you know. I will make a copy of my wm upgraded with 7.0.4 and see how it goes.
Have a great weekend.

Evgenios

Στις Παρ 20 Φεβ 2026, 17:57 ο χρήστης Stephen Waite <noreply@mail.open-emr.org> έγραψε:

9

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

10

Thanks for getting back. We’re tracking this issue and will head back to the drawing board :slight_smile: .

11

Situation
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 ((enddate IS NULL OR enddate = ‘’) OR enddate > ?) AND pid = ? ORDER BY lists.begdate 'OpenEMR Version
I’m using OpenEMR version 8.0.0

Browser:
I’m using:EDGE

Operating System
I’m using: Alma Linuex

Search
Did you search the forum for similar questions?

Logs
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 ((enddate IS NULL OR enddate = ‘’) OR enddate > ?) AND pid = ? ORDER BY lists.begdate ’

12

Taking a quick stab at this I’d bet those with the issue are using MySQL! If this is the case then it might explain not reproduceable on Demo’s if they are using MariaDB.
MySQL forbid null or empty dates on binding whereas MariaDB is more relaxed.
This may be the case but again I haven’t look into this but from a cursory POV.

13

Sorry, I’m not 100% what date setup difference is just know the two engines differ on how date is handled.

14

I am using, mysql Ver 8.0.45-0ubnutu0.24.04.1 for Linux on x86_64 ((Ubuntu))

15

I also could not replicate on the demos.

16

Hi Jeff, I’ll look into a bit to be convinced of my theory. Will get back to you guys.

17

text

Hi everyone,

I'm hitting the exact same (or very similar) issue as described in this thread after upgrading from **7.0.3** to **8.0.0**.

**Symptoms:**
- Dashboard loads up to the Allergies section, then fails when trying to load Medications/Prescriptions/Active Issues.
- Exact error: "SQL Statement failed on preparation" with this query:

SELECT lists.*, medications.lists_medication_id, ... FROM listsLEFT JOIN (SELECT lists_medication.id AS lists_medication_id, ... FROM lists_medication LEFT JOIN users ...) medications ON medications.list_id = lists.idWHERE ((enddate IS NULL OR enddate = '') OR enddate > ?) AND BINARY lists.pid = ? AND BINARY lists.type = ? ORDER BY lists.begdate

- Underlying PHP log: "Incorrect DATETIME value: ''" (from the `enddate = ''` literal).
- The bind value for `enddate > ?` is valid (e.g., a future date like '2000-01-01 23:59:59'), but preparation fails due to the static `''`.

**What I've Tried (all without success):**
- Ran sql_upgrade.php multiple times (reported success).
- Relaxed sql_mode globally to `ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION` (removed STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE) + restarted both DB and OpenEMR containers.
- Confirmed no zero/empty enddate records: `SELECT COUNT(*) FROM lists WHERE YEAR(enddate) = 0 AND MONTH(enddate) = 0 AND DAY(enddate) = 0;` → 0 rows.
- Docker setup (MySQL/MariaDB version: 8.0.45-0ubuntu0.24.04.1  ).

**Key New Finding:**
I spun up a **fresh OpenEMR 8.0.0 install** (clean Docker or manual) → created new test patients → the dashboard loads fully, Medications section works, no preparation errors.  
The **upgraded instance** has more SQL prep errors (same query + possibly others).

This strongly suggests the issue is **upgrade-specific** (partial schema migration, legacy data quirks, or mismatched column defaults/behavior on `enddate` in the `lists` table), not a general 8.0.0 bug.

**Questions:**
- Has anyone else seen this only on upgrades (not fresh installs)?
- Any known patch to remove or conditionalize the `OR enddate = ''` in the FHIR search builder (`PatientIssuesService` / `FhirSearchWhereClauseBuilder`) for date fields?
- Should I compare `DESCRIBE lists;` between fresh vs upgraded DBs to spot differences?

Thanks for any insights or dev input — happy to provide logs, schema diffs, or test further.

OpenEMR: 8.0.0 (upgraded from 7.0.3)  
DB: 8.0.45-0ubuntu0.24.04.1  
Environment: Docker
18

Looks like MySQL is running in strict mode and I don’t think it’s a good idea to turn of and the service running this query would need to be fixed upstream so since I don’t have MySQL setup in easy dev or local I can suggest you try this quick patch however from v8.0.0 so line numbers may not match.

In src/Services/PatientIssuesService.php around L-210(find if line number is wrong in 7.0.4) replace $sql .= $whereClause->getFragment() . " ORDER BY lists.begdate ";

$fragment = $whereClause->getFragment();
$fragment = str_replace("enddate = ''", "enddate = '0000-00-00'", $fragment);
$fragment = str_replace("`enddate` = ''", "`enddate` = '0000-00-00'", $fragment);
$fragment = str_replace("lists.enddate = ''", "lists.enddate = '0000-00-00'", $fragment);
$fragment = str_replace("lists.`enddate` = ''", "lists.`enddate` = '0000-00-00'", $fragment);

$sql .= $fragment . " ORDER BY lists.begdate ";

I think maintainers are aware of mysql strict mode and mainly how mariadb and mysql are diverging in some areas.

19

confirmed on easy dev with mysql8.0

services:
  mysql:
    restart: always
    image: mysql:8.0
    command: ['mysqld','--character-set-server=utf8mb4','--ssl-ca=/etc/ssl/ca.pem','--ssl_cert=/etc/ssl/server-cert.pem','--ssl_key=/etc/ssl/server-key.pem']
    ports:
    - 8320:3306
    volumes:
    - ../library/sql-ssl-certs-keys/easy/ca.pem:/etc/ssl/ca.pem:ro
    - ../library/sql-ssl-certs-keys/easy/server-cert.pem:/etc/ssl/server-cert.pem:ro
    - ../library/sql-ssl-certs-keys/easy/server-key.pem:/etc/ssl/server-key.pem:ro
    - databasevolume:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: root
    healthcheck:
      test:
        - CMD
        - mysqladmin
        - ping
        - -h
        - localhost
        - -u
        - root
        - -proot
      start_period: 1m
      start_interval: 10s
      interval: 1m
      timeout: 5s
      retries: 3
  openemr:
    restart: always
    image: openemr/openemr:flex
    ports:
    - 8300:80
    - 9300:443
    volumes:
    - ../..:/openemr:ro
    - ../..:/var/www/localhost/htdocs/openemr:rw
    - assetvolume:/var/www/localhost/htdocs/openemr/public/assets:rw
    - themevolume:/var/www/localhost/htdocs/openemr/public/themes:rw
    - sitesvolume:/var/www/localhost/htdocs/openemr/sites:rw
    - nodemodules:/var/www/localhost/htdocs/openemr/node_modules:rw
    - vendordir:/var/www/localhost/htdocs/openemr/vendor:rw
    - ccdanodemodules:/var/www/localhost/htdocs/openemr/ccdaservice/node_modules:rw
    - logvolume:/var/log
    - couchdbvolume:/couchdb/data
    environment:
      DEBUG_COLORS: "true"
      TERM: xterm-256color
      COLORTERM: truecolor
      MYSQL_HOST: mysql
      MYSQL_ROOT_PASS: root
      MYSQL_USER: openemr
      MYSQL_PASS: openemr
      OE_USER: admin
      OE_PASS: pass
      EASY_DEV_MODE: "yes"
      EASY_DEV_MODE_NEW: "yes"
      DEVELOPER_TOOLS: "yes"
      XDEBUG_ON: 1
      XDEBUG_PROFILER_ON: 1
      XDEBUG_CLIENT_HOST: host.docker.internal
      GITHUB_COMPOSER_TOKEN: c313de1ed5a00eb6ff9309559ec9ad01fcc553f0
      GITHUB_COMPOSER_TOKEN_ENCODED: Z2hwX0NpbnJ4aXlNd0NzcGZXWG1UWFUwcXhGa040elFKSDJoZGJXVw==
      GITHUB_COMPOSER_TOKEN_ENCODED_ALTERNATE: '103 104 112 95 57 54 108 115 88 116 87 72 51 75 81 105 69 88 88 119 97 79 80 78 109 69 66 115 85 97 106 78 112 71 49 81 90 102 74 121'
      SELENIUM_USE_GRID: "true"
      SELENIUM_HOST: selenium
      SELENIUM_FORCE_HEADLESS: "false"
      SELENIUM_BASE_URL: "http://openemr"
      OPENEMR_DOCKER_ENV_TAG: easy-dev-docker
      OPENEMR_SETTING_site_addr_oath: 'https://localhost:9300'
      OPENEMR_SETTING_oauth_password_grant: 3
      OPENEMR_SETTING_rest_system_scopes_api: 1
      OPENEMR_SETTING_rest_api: 1
      OPENEMR_SETTING_rest_fhir_api: 1
      OPENEMR_SETTING_rest_portal_api: 1
      OPENEMR_SETTING_portal_onsite_two_enable: 1
      OPENEMR_SETTING_ccda_alt_service_enable: 3
      OPENEMR_SETTING_couchdb_host: couchdb
      OPENEMR_SETTING_couchdb_port: 6984
      OPENEMR_SETTING_couchdb_user: admin
      OPENEMR_SETTING_couchdb_pass: password
      OPENEMR_SETTING_couchdb_dbase: example
      OPENEMR_SETTING_couchdb_ssl_allow_selfsigned: 1
      OPENEMR_SETTING_gbl_ldap_host: 'ldap://openldap:389'
      OPENEMR_SETTING_gbl_ldap_dn: 'cn={login},dc=example,dc=org'
      OPENEMR_SETTING_EMAIL_METHOD: SMTP
      OPENEMR_SETTING_SMTP_HOST: mailpit
      OPENEMR_SETTING_SMTP_PORT: 1025
      OPENEMR_SETTING_SMTP_USER: openemr
      OPENEMR_SETTING_SMTP_PASS: openemr
      OPENEMR_SETTING_SMTP_SECURE: ''
      OPENEMR_SETTING_SMTP_Auth: 'TRUE'
      OPENEMR_SETTING_practice_return_email_path: 'noreply@openemr.local'
      OPENEMR_SETTING_Patient_Reminder_Sender_Name: 'OpenEMR Reminders'
    depends_on:
      mysql:
        condition: service_healthy
    healthcheck:
      test:
      - CMD
      - /usr/bin/curl
      - --fail
      - --insecure
      - --location
      - --show-error
      - --silent
      - https://localhost/meta/health/readyz
      start_period: 3m
      start_interval: 10s
      interval: 1m
      timeout: 5s
      retries: 3
  selenium:
    restart: always
    image: selenium/standalone-chromium:4.40.0
    ports:
    - 4444:4444
    - 7900:7900
    environment:
      SE_VNC_PASSWORD: openemr123
      SE_SCREEN_WIDTH: 1920
      SE_SCREEN_HEIGHT: 1080
      SE_SCREEN_DEPTH: 24
      SE_START_XVFB: true
    volumes:
    - /dev/shm:/dev/shm
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:4444/wd/hub/status"]
      start_period: 30s
      interval: 30s
      timeout: 5s
      retries: 3
  phpmyadmin:
    restart: always
    image: phpmyadmin
    ports:
    - 8310:80
    environment:
      PMA_HOSTS: mysql
    depends_on:
      mysql:
        condition: service_healthy
  couchdb:
    restart: always
    image: couchdb
    ports:
    - 5984:5984
    - 6984:6984
    volumes:
    - ../library/couchdb-config-ssl-cert-keys/local.ini:/opt/couchdb/etc/local.ini:rw
    - ../library/couchdb-config-ssl-cert-keys/easy/ca.pem:/etc/ssl/ca.pem:ro
    - ../library/couchdb-config-ssl-cert-keys/easy/server-cert.pem:/etc/ssl/server-cert.pem:ro
    - ../library/couchdb-config-ssl-cert-keys/easy/server-key.pem:/etc/ssl/server-key.pem:ro
    - couchdbvolume:/opt/couchdb/data
    environment:
      COUCHDB_USER: admin
      COUCHDB_PASSWORD: password
  openldap:
    restart: always
    image: openemr/dev-ldap:easy
    environment:
      LDAP_TLS_VERIFY_CLIENT: try
      LDAP_TLS_CA_CRT_FILENAME: ca.pem
      LDAP_TLS_CRT_FILENAME: server-cert.pem
      LDAP_TLS_KEY_FILENAME: server-key.pem
  mailpit:
    restart: unless-stopped
    image: axllent/mailpit:latest
    ports:
    - 8025:8025
    - 1025:1025
    environment:
      MP_SMTP_AUTH_ACCEPT_ANY: 1
      MP_SMTP_AUTH_ALLOW_INSECURE: 1
      MP_MAX_MESSAGES: 5000
      MP_DATABASE: /data/mailpit.db
    volumes:
    - mailpitvolume:/data
    healthcheck:
      test: ["CMD", "wget", "--quiet", "--tries=1", "--spider", "http://localhost:8025/api/v1/messages"]
      start_period: 10s
      interval: 30s
      timeout: 5s
      retries: 3
volumes:
  databasevolume: {}
  assetvolume: {}
  themevolume: {}
  sitesvolume: {}
  nodemodules: {}
  vendordir: {}
  ccdanodemodules: {}
  logvolume: {}
  couchdbvolume: {}
  mailpitvolume: {}
1 Like
20

try changing this to

$clauses[] = "(" . $searchField->getField() . " IS NULL OR CAST(" . $searchField->getField() . " AS CHAR) = '') ";