BUG:: Data Validation not working

GCE-2.9.3
$crud->fieldType(‘invoice_date’, GroceryCrud::FIELD_TYPE_DATE);

how to replicate:

1. select any date from the date control. ( is curretly updated with selected
2. type any gibberish on the field
3. click ‘Save Changes’

image484×142 3.95 KB

{
“title”: “Laminas\Db\Adapter\Exception\InvalidQueryException”,
“type”: “Laminas\Db\Adapter\Exception\InvalidQueryException”,
“code”: 500,
“message”: “Statement could not be executed (22007 - 1292 - Incorrect date value: ‘01/1aa1/2021’ for column dev_db4.finance_invoices.invoice_date at row 1)”,
“file”: “C:\laragon\www\dev_pos4\vendor\laminas\laminas-db\src\Adapter\Driver\Pdo\Statement.php”,
“line”: 223,

was expecting the form not to submit (because of front end validation), or alternativelly, allows submit but fail submission rules and throw so sort of error (but not allow update to run).