Empty date range values are not stored correctly in database

Created on 2 May 2023, over 1 year ago

Updated 4 May 2023, over 1 year ago

Problem/Motivation

I ran into an issue with a query on a single datetime picker (date range) field and noticed an issue where empty string values are saved to the database after emptying an existing field value (with "allow blank" option enabled).

This should instead be set to a NULL value, to be in line with core date fields' empty state.

Proposed resolution

I added a quick patch that sets empty values to NULL during the massage form values step.

🐛 Bug report

Status

Needs review

Version

2.0

Component

Code

Created by

🇧🇪Belgium Chewi3

Live updates comments and jobs are added and updated live.

Comments & Activities

Issue created by @Chewi3
Comment over 1 year ago →
🇧🇪Belgium Chewi3
Status changed to Needs review over 1 year ago8:01am 4 May 2023
Open in Jenkins → Open on Drupal.org →
Environment: PHP 8.1 & MySQL 5.7
last update over 1 year ago
Checkout Error
Comment over 1 year ago →
🇳🇱Netherlands idebr
Possibly related to 🐛 Optional End Date not compatible Needs work

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024