Title: Date saving doesn’t work Last modified: January 22, 2019 --- # Date saving doesn’t work * Resolved [ilpanzio](https://wordpress.org/support/users/ilpanzio/) * (@ilpanzio) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/) * I filled my database records uploading a csv file and all informations in Participant List are ok. Now I want to edit one single record changing a date field but it doesn’t work. I’m using Italian language. In general wordpress settings i have date format “j F Y” and in my record I see this field value 13 aprile 1985 * I tried to change it to 10 marzo 1985 but after Apply the value is back again to 13 aprile 1985. * But the most strange thing is that if I change the next field, that is a simple text field, after Apply the text field is correctly updated but the date field is changed to the previous day so i see 12 aprile 1985 * How can i try to resolve this issue? * These are wordpress and plugin versions WordPress: 4.8.1 Plugin: 1.8.4.5 * Thanks Viewing 8 replies - 1 through 8 (of 8 total) * Thread Starter [ilpanzio](https://wordpress.org/support/users/ilpanzio/) * (@ilpanzio) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11117435) * 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 * Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/) * (@xnau) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11118633) * 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. * Thread Starter [ilpanzio](https://wordpress.org/support/users/ilpanzio/) * (@ilpanzio) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11129911) * 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/](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 [http://www.camminandomontievalli.it/test.php](http://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 * Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/) * (@xnau) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11131811) * 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. * Thread Starter [ilpanzio](https://wordpress.org/support/users/ilpanzio/) * (@ilpanzio) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11133803) * 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 * Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/) * (@xnau) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11134343) * 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. * Thread Starter [ilpanzio](https://wordpress.org/support/users/ilpanzio/) * (@ilpanzio) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11147594) * 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 * Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/) * (@xnau) * [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11150306) * Glad to hear it! Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Date saving doesn’t work’ is closed to new replies. * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807) * [Participants Database](https://wordpress.org/plugins/participants-database/) * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq) * [Support Threads](https://wordpress.org/support/plugin/participants-database/) * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/) * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/) * 8 replies * 2 participants * Last reply from: [Roland Barker](https://wordpress.org/support/users/xnau/) * Last activity: [7 years, 4 months ago](https://wordpress.org/support/topic/date-saving-doesnt-work/#post-11150306) * Status: resolved