When setting up a new campaign’s Email Marketing start date and time via the Campaign wizard it doesn’t set the correct date or time.
In the wizard if I set Schedule Date & Time to 10/20/2016 at 7:00 am and hit next and complete the wizard the View Details screen will show 10/20/2016 at 3:00am
If I go back to the wizard and set it again to 10/20/2016 at 7:00am and hit next and complete the wizard the View Details screen will show. 10/19/2016 7:00am. The day I was running this was the 19th.
Other times I set it and hit next and I will get an error saying “Missing required field: Start Date” and everything I entered was blanked out.
I have looked at both the apache and suite error logs and nothing is being logged when this happens.
I upgraded to 7.7.6 and still have the same issue. When go through the Campaign Email marketing Wizard and I get to the Marketing portion of the wizard and I set “Scheduled Date & Time” field which run “conbo_date_start.update()” on filed change. If I set the time to 7:00am it always get stored as 3:00am.
Is anyone else having trouble changing the Campaign email scheduled send time?
Sorry I missed this when troubleshooting before. Below are the errors logged to suitecrm.log when setting the email schedule date and time:
Tue Oct 25 19:07:18 2016 [8775][1][DEPRECATED] Formatting correction: EmailMarketing->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Oct 25 19:07:18 2016 [8775][1][DEPRECATED] Formatting correction: EmailMarketing->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Oct 25 19:07:18 2016 [8775][1][ERROR] convert: Conversion of 10/27/2016 07:00am 03:00am from m/d/Y h:ia to Y-m-d H:i:s failed
Tue Oct 25 19:07:18 2016 [8775][1][DEPRECATED] Formatting correction: EmailMarketing->date_start had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Oct 25 19:07:18 2016 [8775][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
I changed the date.timezone setting in php.ini file and then I stopped getting “[ERROR] convert: Conversion of 10/27/2016 07:00am 03:00am from m/d/Y h:ia to Y-m-d H:i:s failed” and I was able to change the email schedule time value.
The date.timezone was set to “UTC” and I changed it to “America/New_York” and then restarted the apache server.
I’m still getting “Missing required field: Start Date” when hitting next in the wizard but I can live with that. I just enter the date again and it takes.