Date saving doesn’t work

I activated debug plugin so i have other informations.
I’m trying to modify field data_di_nascita.
After activating plugin I wrote
23 aprile 1985
and in log file i read
UPDATE wp_participants_database SET date_updated = NOW(),……, email = ”, data_di_nascita = ‘483044400’, luogo_di_nascita = ‘LoretoXXXXX___(AN)’,…..
but in Unix Time 483044400 = 22 aprile 1985 and not 23 aprile 1985

Then I tried again and i wrote
25 maggio 1985
and in log file i read
UPDATE wp_participants_database SET date_updated = NOW(),……., email = ”, luogo_di_nascita = ‘LoretoXXXXX___(AN)’,…….
but in UPDATE query my field data_di_nascita is missing!

I suppose that there is some problem when plugin generates update string.

Here is the complete log
Log file initiated at: 22 January 2019 14:32 UTC
[01/22/19 2:32pm UTC]
PDb_List_Admin::initialize
list query: SELECT * FROM wp_participants_database p ORDER BY p.last_name asc
[01/22/19 2:33pm UTC]
Participants_Db::process_form storing record: UPDATE wp_participants_database SET date_updated = NOW(), last_name = ‘Acquaroli’, first_name = ‘Miriam’, address = ‘Via Buonarroti, 12’, city = ‘Montecosaro(MC)’, zip = ‘62010’, phone = ”, phone2 = ”, email = ”, data_di_nascita = ‘483044400’, luogo_di_nascita = ‘LoretoXXXXX___(AN)’, state = ”, country = ”, mailing_list = ‘Yes’, dummy = ”, guida_tessera = ‘Giovanni’, anno_validita = ‘2019’, dafare_tessera = ‘no’, note = ‘Si’, note2 = ”, approved = ‘no’, photo = ”, website = ”, interests = ” WHERE id = 768
[01/22/19 2:33pm UTC]
PDb_List_Admin::initialize
list query: SELECT * FROM wp_participants_database p ORDER BY p.last_name asc
[01/22/19 2:35pm UTC]
PDb_List_Admin::initialize
list query: SELECT * FROM wp_participants_database p ORDER BY p.last_name asc
[01/22/19 2:35pm UTC]
Participants_Db::process_form storing record: UPDATE wp_participants_database SET date_updated = NOW(), last_name = ‘Acquaroli’, first_name = ‘Miriam’, address = ‘Via Buonarroti, 12’, city = ‘Montecosaro(MC)’, zip = ‘62010’, phone = ”, phone2 = ”, email = ”, luogo_di_nascita = ‘LoretoXXXXX___(AN)’, state = ”, country = ”, mailing_list = ‘Yes’, dummy = ”, guida_tessera = ‘Giovanni’, anno_validita = ‘2019’, dafare_tessera = ‘no’, note = ‘Si’, note2 = ”, approved = ‘no’, photo = ”, website = ”, interests = ” WHERE id = 768

The problem with the date is due to a timezone mismatch, depending on the time of day, it can be off by a day. This is not usually a problem, since it zeroes out the time.

You can try unchecking the “Sync php Timezone” setting in the plugin settings under the Advanced tab, that may help.

I have unchecked the “Sync php Timezone” setting but nothing is changed.

I read your document about this kind of issue
https://xnau.com/date-shifting-and-other-timezone-related-issues-in-participants-database/
and i have contacted my web host to verify PHP timezone and to make sure that that setting is active in all directories.

They told me that all settings are ok. They put in my root a php test page where you can verify php settings
https://www.camminandomontievalli.it/test.php

They were very helpful. They told that if you specify the plugin’s part of saving the dates, they will do other checks directly on your plugin

If the date is not saving at all, as shown in the log, this usually means the plugin could not parse the submitted date string. If localization is working correctly the Italian month names should not be a problem. It would help to set the WordPress date format to match the date format that is input in the form if they are different.

The date format is j F Y both in wordpress settings and in your plugin settings and it is correct.
I noticed that if i change the day but not the month the date is saved one day before.
If i change the month the date is not saved at all.

If you can’t give me more help, could you specify the plugin’s part of saving the dates? My web host will debug the problem.
Thanks

If it’s not saving the date when you change the month, then that suggests the localization is not set up right. The code uses get_locale() to get the current php locale setting so it knows how to parse a localized date string.

Date parsing id handled in the PDb_Date_Parse class if your host wants to take a look at it.

This issue is fixed!
You were right: there was a problem in host server settings.
My web host said that the settings were all correct but the plugin did not work. So they tried to move all my site to a different server and now everything works.
Unlucky we did not understand what was the wrong setting but the important thing is that your plugin works properly now.

Thank you

Glad to hear it!