Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
4 registered members (Ruben, sundance, isaac, BellaOnline), 64 guests, and 293 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 2,654
Joined: January 2004
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 14
Morgan 13
isaac 11
Ruben 10
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
Not synchronizing: database/guest post time bug? #260593
10/19/17 09:29 PM
10/19/17 09:29 PM
Joined: Mar 2015
Posts: 53
Canada, SK
M4TT Offline OP
journeyman
M4TT  Offline OP
journeyman
Joined: Mar 2015
Posts: 53
Canada, SK
Hi,

I've made a few recent posts on my forum and for example, when I view the post, it says it was created 1 hour ago, but on the category/forum listing view, the timestamp says it was made Yesterday at some random hour and time... I tried rebuilding forums and it didn't fix the time.

Quote
My Date & Time Settings:

Timezone For Guests
All times will be displayed to guests as if they were in this timezone.

Database Time: 20/10/17 1:28 AM
Database Timezone: UTC

Guest Time: 19/10/17 7:28 PM
Guest Timezone: America/Regina

Difference in hours: -6

Default Time Format

D M d, Y | g:i A

Available Time Formats

y/m/d | g:i A
d/m/y | g:i A
d/m/Y | H:i
D M d, Y | g:i A
m/d/y | g:i A
n/j/Y | g:i A
n/j/Y | H:i
Y-m-d | g:i A
Y-m-d | H:i

Use Relative Timestamps For Guests

Yes

Re: Database/Guest Post Time Bug? [Re: M4TT] #260594
10/19/17 10:04 PM
10/19/17 10:04 PM
Joined: Apr 2004
Posts: 1,157
California
isaac Online splat
UBB.threads Developer
isaac  Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,157
California
The math seems fine to me.

Database Time of:
10/20 1:28 AM -- UTC TIME

Minus:
6 hours -- America/Regina, aka, Capitol of Saskatchewan, Canada

Equals:
10/19 7:28 PM -- Time displayed to guests

---

By using relative time stamps, you are choosing to display times as hours/minutes RELATIVE to whatever the user's current time is. So, if you posted something an hour ago, it will display in relative time as, "1 hour ago" regardless of whatever you've set timezone to.

But if you disabled relative time stamps, each user would see the posted time (UTC) translated to match their current time offset. Guests would use the time offset you've preselected for them. In this case, you've selected "UTC-06:00 - America/Regina" for your guests.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
https http
by sundance. 05/22/18 05:46 PM
Want to Delete All Old Private Messages
by BellaOnline. 05/19/18 02:00 AM
How to remove Shout Chat
by Outdoorking. 05/17/18 08:37 AM
I am trying to put a banner ad on email template.
by sundance. 05/14/18 01:59 PM
Pruning Members Best Practices
by Shawn Grim. 05/10/18 05:36 PM
Forum Statistics
Forums36
Topics35,114
Posts191,269
Members12,075
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)