The
          Legel
            Report

11/16 ☼ 4:44 a.m.
MjL
11/16 ☼ 2:53 a.m.
MjL
11/16 ☼ 2:52 a.m.
MjL
11/16 ☼ 2:46 a.m.
MjL
11/16 ☼ 2:45 a.m.
MjL
11/16 ☼ 2:42 a.m.
MjL
11/16 ☼ 2:39 a.m.
MjL
11/15 ✿ 6:56 a.m.
Michael T.
11/15 ✿ 4:51 a.m.
MjL
11/15 ✿ 4:47 a.m.
MjL
11/15 ✿ 3:02 a.m.
MjL
11/15 ✿ 2:58 a.m.
MjL
11/15 ✿ 2:57 a.m.
MjL
11/15 ✿ 2:55 a.m.
MjL
11/15 ✿ 2:53 a.m.
MjL
11/14 ✡ 2:53 a.m.
MjL
11/14 ✡ 2:30 a.m.
MjL
11/14 ✡ 2:29 a.m.
MjL
11/14 ✡ 2:26 a.m.
MjL
11/14 ✡ 2:19 a.m.
MjL
11/14 ✡ 2:15 a.m.
MjL
11/14 ✡ 2:13 a.m.
MjL
11/14 ✡ 2:10 a.m.
MjL
11/13 ☯ 8:09 a.m.
Michael T.
11/13 ☯ 7:28 a.m.
Michael T.
11/13 ☯ 5:45 a.m.
MjL
11/13 ☯ 4:13 a.m.
MjL
11/13 ☯ 3:57 a.m.
MjL
11/13 ☯ 3:55 a.m.
MjL
11/13 ☯ 3:51 a.m.
MjL
11/13 ☯ 3:46 a.m.
MjL
11/13 ☯ 3:44 a.m.
MjL
11/13 ☯ 3:42 a.m.
MjL
11/13 ☯ 3:37 a.m.
MjL
11/12 ★ 4:32 a.m.
MjL
11/12 ★ 4:25 a.m.
MjL
11/12 ★ 2:25 a.m.
MjL
11/12 ★ 2:08 a.m.
MjL
11/12 ★ 2:07 a.m.
MjL
11/12 ★ 2:02 a.m.
MjL
 

Blog date 04/04/2014

Tech Geek Nerd Confusion

I have been having time travel problems with my Blog of late. Hopefully I have FINALLY figured out what was going on. Goodness knows the tech support people were absolutely clueless and of no help whatever. It is all about time and time zones. If I don’t properly control the time used to comment on the Blog weird things begin to happen. Not only is it nice to know what time somebody made a comment, but it is also important to not have questions answered before they are asked.

For example —— suppose I make a comment or ask a question and my son Noah, who lives in Phoenix, answers it. If I don’t standardize the time his answer or reply will appear to come before my question or comment. Not good. That’s the time travel part.

For a while now time stamps and the order of comments were changing all over the Blog and I knew it was about the time zones, but not how to fix it.

Now comes some of the geeky think parts —— time zones and computer software. My Blog is on servers. Not just ONE server, but MANY. This is because the server people have many, many servers and they all have mirrors of my stuff so that if one gets too busy, breaks down, or whatever - it just shunts to a different server. So it became clear that one or more of these servers is set to a different time zone and is creating these changes.

So began the experiments in code changes on my web page comment system because I couldn’t get ANY information from the tech support people. And did I ever end up learning more about time manipulation than I had ever thought I would or wanted.

First, I discovered there are two entirely different and separate programs used just to display my Blog stuff. One is called PHP and it is a web page programming language.

The other is MySQL which maintains the database of information for the web page. And these two don’t communicate well. And worse yet, there are several upgrades and versions that don’t seem to be compatible either. I eventually discovered where the problem was with a series of test scripts. And I THINK I have it under control. But I have absolutely no idea what is causing the problems - I am just treating the symptom.

Just for fun I decided not to delete the test page I was using to display the different results as I was working out this problem. The top part shows results using PHP code and the bottom shows results with MySQL code. The very bottom should always read that the results are the same —— but sometimes it would read “not the same”. So I had to figure out WHAT was not the same and have my code change the time base in response so I wouldn’t have to do it manually like I have been doing several times a day for the past month or so.

/comments/comments/timezonetest.php
MjL 04 Apr 2014, 9:15 a.m.

Comment Guidelines     Hashtags     Help

*Name:
Email:
Notify me about new comments on this page
Hide my email
*Text: