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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 		 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 14:39 Go to next message
Astoria is currently offline  Astoria   United States
Messages: 225
Registered: April 2004
Karma: 0
Senior Member
 add to buddy list
ignore all messages by this user
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 15: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
 add to buddy list
ignore all messages by this user
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 16:20 Go to previous messageGo to next message
Astoria is currently offline  Astoria   United States
Messages: 225
Registered: April 2004
Karma: 0
Senior Member
 add to buddy list
ignore all messages by this user
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 12: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
 add to buddy list
ignore all messages by this user
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 18:30 Go to previous message
Astoria is currently offline  Astoria   United States
Messages: 225
Registered: April 2004
Karma: 0
Senior Member
 add to buddy list
ignore all messages by this user
OK; thanks. I cleared the logs the other day so we'll see what happens.

Report message to a moderator

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Wed Apr 25 04:47:18 EDT 2018

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

Powered by: FUDforum 3.0.8.
Copyright ©2001-2018 FUDforum Bulletin Board Software