On Mon, 09 Jan 2012 17:56:03 -0800, John W. Foster
<jfoster81747(a)verizon.net> wrote:
On Sat, 2012-01-07 at 05:55 -0800, Daniel Friesen
wrote:
On Sat, 07 Jan 2012 05:45:27 -0800, John W.
Foster
<jfoster81747(a)gmail.com> wrote:
I was running the php runjobs.php to refresh the
links as Ive been
editing heavily. I noticed that as it completed each check it time
stamped the entry in the terminal screen. It was 7:40:13 A.M. actual
time but the time stamp read 13:40:13 Anyone know what is causing
this.
I don't think it causes an issue but just
seems strange.
Thanks!
frosty
Ever heard of time zones and UTC?
https://en.wikipedia.org/wiki/UTC
Though I doubt your reply was expected to yield any positive result...It
was indeed exactly what I needed to find the issue. It seems there is a
call from within the script to my MySQL database for a time stamp the
matches that of the DB. It interprets that answer into a format that is
supposed to work withing Mediawiki.
private function runJobsLog( $msg ) {
$this->output( wfTimestamp( TS_DB ) . " $msg\n" );
wfDebugLog( 'runJobs', $msg );
}
Now that I've identified the problem & am certain that there is no real
issue. And especially since I'm not very adept at programming...Can
someone tell me what to do to correct this? I did look at the functions
listed in Manual:WfTimestamp for the explanation and determined that I
need to correct this in MySQL. An examination of the DB system settings
indicate this is likely an issue to be resolved with assistance from my
MySQL friends, so I'll ask there as well. Thanks for the tip!
frosty
*facepalm*
Timestamps outputted by runJobs are in the UTC timezone NOT your local
timezone so of course it's not going to match local time. There is NO bug.
And wfTimestamp( TS_DB ) DOES NOT query the MySQL database for a time, it
returns the current time in a format that we can insert into a database.
--
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [