On Mon, 09 Jan 2012 17:56:03 -0800, John W. Foster <[email protected]> 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 >> <[email protected]> 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) [http://daniel.friesen.name] _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
