Submission Date confusion

chalorlay · (This post was last modified: Jul 14th, 2015, 7:51 PM by chalorlay.)

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:05

When 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, Yes

Update
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, Yes

Is 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 AM

chalorlay · Jul 14th, 2015, 8:10 PM

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]

whtknt · (This post was last modified: Jul 23rd, 2015, 6:16 PM by whtknt.)

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.

chalorlay · Jul 23rd, 2015, 8:08 PM

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!

FORUMS