Date error with MariaDB?

First of all, your expression is wrong on the screenshots. It must not be:

{{$_POST.IDMotore.default('null')}}

but

{{$_POST.IDMotore.default(null)}}

no quotes around null

I just tested this with the correct expression in an update record step and it works perfectly fine. Try correcting your expression and test again. If the expression disappears, try recreating the whole update step or the whole server action.

Look this video

And this without quotes around null

I canā€™t recreate this issue. Please recreate the step or the server action, something must have gotten corrupt. Or if you donā€™t want to recreate it, just edit this in the server action code.

But do I need to edit here?
Schermata 2024-03-31 alle 15.56.49

No, you need to edit it where the POST variable is.

This?

No Marzio, in the Server Action code ā€¦

Yes Teodor
But in the code IDMotore only find it once, as I posted earlier

If you want I can send you the action file

Sorry i am not following.
Just try recreating the server action if you donā€™t know how to edit it in code.
Obviously something is wrong with it, as I canā€™t recreate the issues youā€™re having.

Ok Teodor
I made this change, but due to error

Schermata 2024-03-31 alle 17.11.38

Schermata 2024-03-31 alle 17.13.12

Thereā€™s a comma missing at the end of the line before "value":

I tried all the solutions but without success
The insertion action works
The action of updates instead or delete the variations when it is saved, even if I act on the code
I would like to avoid having to create all the action, but I donā€™t know how to do it
Maybe if I go to manually edit the file on the server?

The last of the attempts is the following
I donā€™t know if itā€™s correct

Schermata 2024-03-31 alle 18.15.10

So whatā€™s the issue now? This looks correct.

This error Now
ā€œmessageā€: ā€œUndefined property: stdClass::$nameā€,
Maybe itā€™s because there are other fields with the same problem.
Now, knowing that it is correct I correct the fields that have this problem
Then Iā€™ll see if it will be ok

@Teodor
Hi Theodor
There are 20 fields in the record that must accept a null value (when updating the record) and I made the change for all of them by modifying the action code.
Now it still generates error but no longer for the 20 fields, but for an error in the validator file on line 51
This is line 51 of the file

Maybe I should add in the second part too ā€œnameā€: ā€œIDMotoreā€

Schermata 2024-04-01 alle 16.34.13

Something doesnā€™t seem correct in your server action, please recreate it from scratch.

Sorry Teodor
But I donā€™t understand anything anymore
I created a new action and uploaded database
I then changed the value of IDMotore (with default null)
But also with an action that has just begun the value appears with the quotes
And if I save and close the file, when the open the variation IDMotore value has

been deleted
Practically the error is always the same

This is because you need to enter this in the CODE part of the data picker!

Iā€™m sorry but i canā€™t recreate your issue, iā€™ve already tested it a few times.