FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » V2.7.5 - problem with error and sql log timestamps
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
V2.7.5 - problem with error and sql log timestamps [message #33687] Thu, 14 September 2006 18:39 Go to next message
Astoria is currently offline  Astoria   United States
Messages: 227
Registered: April 2004
Karma: 0
Senior Member
My error and mysql logs show timestamp value of Thu Jan 1 0:00:00 GMT 1970 for all messages.

Action log timestamps are correct.

Report message to a moderator

Re: V2.7.5 - problem with error and sql log timestamps [message #33692 is a reply to message #33687] Thu, 14 September 2006 19:08 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
FUDforum does not use MySQL timestamps, it uses unix timestaps stored inside INTs. I suspect use of MySQL date/time functions of this value without any conversion would yeild 1970 dates...

FUDforum Core Developer

Report message to a moderator

Re: V2.7.5 - problem with error and sql log timestamps [message #33701 is a reply to message #33692] Thu, 14 September 2006 20:20 Go to previous messageGo to next message
Astoria is currently offline  Astoria   United States
Messages: 227
Registered: April 2004
Karma: 0
Senior Member
Ilia wrote on Thu, 14 September 2006 12:08

FUDforum does not use MySQL timestamps, it uses unix timestaps stored inside INTs. I suspect use of MySQL date/time functions of this value without any conversion would yeild 1970 dates...


??

I'm referring to the timestamp values in the Error and SQL error logs that are accessible from the FUDForum Admin option "Error log browser" (called "Error log viewer" in the admin function list). Sorry for the confusion.

The timestamps in the "Admin Log" (admin option "Action Log viewer" in the list) display normally, as do post timestamps, etc on the forum.

Report message to a moderator

Re: V2.7.5 - problem with error and sql log timestamps [message #33741 is a reply to message #33701] Mon, 18 September 2006 16:49 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
It is possible your file contains old entries (old log format) that are being mis-parsed. You can try clearing those files and seeing if new errors have correct dates.

FUDforum Core Developer

Report message to a moderator

Re: V2.7.5 - problem with error and sql log timestamps [message #33750 is a reply to message #33741] Mon, 18 September 2006 22:30 Go to previous message
Astoria is currently offline  Astoria   United States
Messages: 227
Registered: April 2004
Karma: 0
Senior Member
OK; thanks. I cleared the logs the other day so we'll see what happens.

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: what's error ?
Next Topic: 2.7.5 -> 2.7.6 Upgrade problems
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 13:30:46 GMT 2024

Total time taken to generate the page: 0.02823 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software