0

While checking last_post timestamp in the returned json, I noticed a discrepancy of around 5 hours of the 'now' time and a 'just posted' time. AFAIK unix timestamp is UTC - so constant and timezone independent. Are DW timestamps modified to EST or have I messed up again with my calculations?

3
Contributors
9
Replies
64
Views
4 Years
Discussion Span
Last Post by diafol
0

DaniWeb timestamps are supposed to be GMT time but I think there might actually be a bug over the past few months where they were US central time instead. I'll look into it tomorrow. Sorry for the confusion!

0

My apologies!! I actually introduced this bug accidentally yesterday, so all of the timestamps from the past ~35 hours are off by 5 hours. Grrr.

0

Thank you so much for catching this bug! Thank goodness it was only saving timestamps with the wrong GMT offset for a little over a day, so it was not the end of the world to have to update every table in the database. UGH.

0

yesterday, so all of the timestamps from the past ~35 hours are off by 5 hours. Grrr.

When I look at the total count post it was reset at 8pm EST instead of 1am EST.

Does it have to do with the bug?

I was really surprise it did reset.

0

Total post count?! Huh? Where??

Nevermind you fixed it.

It was reset at 8pm EST meaning the post count for the whole week was added together and it create a new column for next week.

But now it's fixed.

You can forget about it. It was like that for an hour or 90 minutes ago.

0

Huh?? Please explain. It might still be a bug.

I think you might have fixed it

What I meant 8pm EST reset means the total count for the whole week was added and create a new column for next week.

Diafol was right about the 5 hours differences.

Every week the post count starts at Sunday 12:00am CST and ends at Saturday 11:59pm CST.

Once it hits Sunday 12:00am CST it create a new column for the post count for the following week.

Couple hours ago the post count was reset at 8pm EST / (7pm CST) it should have reset at 1am EST / (12am CST)

I think you fixed it already.

I don't know how you did but you can check the log on you server to see how it got reset at 8pm EST for the post counts.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.