+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Submission Date confusion (/showthread.php?tid=5243)
Submission Date confusion - chalorlay - Jul 14th, 2015
Code:
Submission ID PC Date (GMT+8) Database Submission Date
------------------------------------------------------------------
260484 2015-07-13 07:46:01 AM 2015-07-12 23:46:03
260485 2015-07-13 07:46:01 AM 2015-07-12 23:46:04
260486 2015-07-13 07:46:01 AM 2015-07-12 23:46:04
260487 2015-07-13 07:46:01 AM 2015-07-12 23:46:05When search data using Date (Submission Date) on the 13/07/2015, the 4 records above missing from the list.
PC Date is a field in the form that captures the PC's date when submit the form.
The logged in user that perform the search already set as +8 in the user setting.
I think the search by date is not searching by user's time zone setting but search instead based on the database date. How to repair this behaviour?
** I could be wrong. Shed some light pls on where to look for the relevant codes (I'm beginner with PHP, not 2 months old with time to spare!)
Code:
EDIT (forgot the setup info)
----------------------------
Form Tools Core Version: 2.2.5
Core Version Upgrade Track: 2.2.5
API Version: 1.1.4
PHP Version: 5.3.28
MySQL Version: 5.5.40-cll
PHP Sessions: Available
Suhosin Extension: Installed
Curl Extension: Available
SimpleXML Extension: Available
____________________________________
MODULES (name, version, enabled)
Core Field Types, 1.0.2, Yes
Export Manager, 2.1.1, Yes
File Upload, 1.1.0, Yes
Form Backup, 1.1.4, Yes
Pages, 1.2.6, Yes
Submission Accounts, 1.2.9, No
Swift Mailer, 1.1.2, Yes
System Check, 1.0.3, Yes
TinyMCE Field, 1.0.8, Yes
____________________________________
THEMES (name, version, enabled)
Classic Grey, 1.1.3, Yes
Default, 1.0.0, YesUpdate
Another finding today. Install new Formtool on another host of mine and test new submission. Submission Date now equals PC's date at +8GMT. The new setup is:
Code:
Form Tools Core Version: 2.2.7
Core Version Upgrade Track: 2.2.5,2.2.7-main-20140214
API Version: 1.1.4
PHP Version: 5.3.29
MySQL Version: 5.1.73-cll
PHP Sessions: Available
Suhosin Extension: Not Installed
Curl Extension: Available
SimpleXML Extension: Available
____________________________________
MODULES (name, version, enabled)
Core Field Types, 1.0.2, No
Data Visualization, 1.0.9, Yes
Export Manager, 2.1.1, Yes
Facebook Forms, 1.0.3, Yes
File Upload, 1.1.0, Yes
Form Backup, 1.1.4, Yes
Form Builder, 1.0.7, Yes
Pages, 1.2.6, Yes
Report Builder, 1.0.3, Yes
Submission Accounts, 1.2.9, No
Swift Mailer, 1.1.2, Yes
System Check, 1.0.3, Yes
TinyMCE Field, 1.0.8, Yes
____________________________________
THEMES (name, version, enabled)
Classic Grey, 1.1.3, No
Default, 1.0.0, YesIs it the server setting? Formtool setting or Version difference?
Hah...got a direction on what to look for.
Another Update
Code:
System Time Offset (server with the problem) : +8 hours 11:41 AM
System Time Offset (server with new installation): +8 hours 7:41 PM
It seems that there's problem with system date & time with the host.
Actual GMT : 3:41 AM
1st server at GMT : 3:41 AM
2nd server at GMT : 11:41 AMRE: Submission Date confusion - chalorlay - Jul 14th, 2015
Finally,
Ensure you get the correct date/time to your local time in the setting by adjusting the GMT offset. Not all server set the same and hey...you don't actually know where your host is located.
![[Image: ServerSystemDate.png]](http://mnh.my/data/upload/ServerSystemDate.png)
RE: Submission Date confusion - whtknt - Jul 23rd, 2015
I'm having a similar issue but it's even more perplexing! I've properly set the GMT offset, however when an email is generated upon a form submission, the submission time is 5 hours ahead of the actual time. What's strange is that if I go into the form to test it and I generate (display) a random submission, it displays the correct time there. However, when the actual email is sent upon form submission, a completely different time is used.
Any thoughts?
(Jul 14th, 2015, 8:10 PM)chalorlay Wrote: Finally,
Ensure you get the correct date/time to your local time in the setting by adjusting the GMT offset. Not all server set the same and hey...you don't actually know where your host is located.
RE: Submission Date confusion - chalorlay - Jul 23rd, 2015
My test installation is still on and I'll try to reproduce your issue this weekend.
While at it, also found out that my test installation is 2.2.7 that was removed from distribution due to unresolved Option List bug. I need to do installation again with version 2.2.6
With a matured (IMO), I believe where there are errors, must be something that we didn't set things correctly!