Announcement

Collapse
No announcement yet.

Post Times

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #31
    Very odd in my case. The server time was out 12 hours and my board experienced the same problems as already posted. What was odd is that some members' posts including my own had the correct time while others had tomorrow's time with the effect that answers were posted before the questions. Thankfully my members are seeing the funny side of it.

    Comment


    • #32
      oddly enough, i thought my host had fixed it, however all of a sudden....all new posts are showing up AM instead of PM

      Peace
      IT'S WHERE THE NET COMES TO LOITER!

      Comment


      • #33
        Please start your own thread with all the relevant details. There is also a new cPanel issue. Please see this thread (you need to register first):

        http://forums.cpanel.net/showthread.php?t=59902
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #34
          My timestamp problem was still continuing - for example for some reason FlashChat was 8 hours behind. But a restart of MySQL and Apache cured the problems.

          Comment


          • #35
            Is there any fix to this problem?

            Have just submitted a ticket with my hosts, so hopefully they can sort it out quickly.

            Is there any way of correcting the mistimed posts?

            Comment


            • #36
              Originally posted by Jack Black View Post
              Is there any fix to this problem?

              Have just submitted a ticket with my hosts, so hopefully they can sort it out quickly.

              Is there any way of correcting the mistimed posts?
              Copied from the cpanel forum.
              vB Posts:
              UPDATE post SET dateline = dateline - 43200 WHERE postid <= ID OF LAST AFFECTED POST and postid >= ID OF FIRST AFFECTED POST

              Then you'll need to update your thread and forum counters in the vBulletin Admin CP

              Photopost Photos:
              UPDATE photos SET date = date - 43200 WHERE id <= ID OF LAST AFFECTED POST and id >= ID OF FIRST AFFECTED POST

              Photopost Comments:
              UPDATE comments SET date = date - 43200 WHERE id <= ID OF LAST AFFECTED POST and id >= ID OF FIRST AFFECTED POST

              I post these with no guarantee that they won't blow your server up, ruin your forum, steal your girlfriend, kill your fish etc! I recommend you do a backup and do a SELECT first to make sure you're affecting the right entries the database!

              EG: SELECT * FROM post WHERE postid <= ID OF LAST AFFECTED POST and postid >= ID OF FIRST AFFECTED POST

              Having said that, hope this helps someone!

              Edit: You can check the times of the timestamps in the database by using this convertor; http://www.onlineconversion.com/unix_time.htm
              But for some odd reason, posts that were 12 hours ahead are now correct on my board.
              ...steven
              www.318ti.org (vB3.8) | www.nccbmwcca.org (vB4.2)
              bmwcca.org/forum | m135i.net
              "I tried to clean this up but this thread is beyond redemption." - Steve Machol

              Comment


              • #37
                Originally posted by 1996 328ti View Post
                Copied from the cpanel forum.


                But for some odd reason, posts that were 12 hours ahead are now correct on my board.
                Did you run this

                UPDATE post SET dateline = dateline - 43200 WHERE postid <= ID OF LAST AFFECTED POST and postid >= ID OF FIRST AFFECTED POST

                Can anyone confirm this works?

                and how do I find the ID of the first and last affected post?

                Thanks.
                Selling my BigBoard GamerzNeeds.net/forums Threads: 193 502, Posts: 1 540 045, Members: 718 566 It is listed here http://forums.digitalpoint.com/showt...3#post18297060

                Comment


                • #38
                  Originally posted by hornstar6969 View Post
                  Can anyone confirm this works?

                  and how do I find the ID of the first and last affected post?

                  Thanks.
                  Yes it works.

                  You have to manually view each post to see which ones are correct and not - and take note of the post ID of each one that is messed-up. Once you find the screwed-up ones - you can then just change the last number in the URL and see if the next one/previous one is messed-up too.

                  ie - if say http://www.yourforum.com/forums/showthread.php?p=197789 was screwed-up - then change it to:
                  http://www.yourforum.com/forums/showthread.php?p=197788
                  then to:
                  http://www.yourforum.com/forums/showthread.php?p=197787
                  etc...

                  Then go the opposite way:
                  http://www.yourforum.com/forums/showthread.php?p=197790
                  http://www.yourforum.com/forums/showthread.php?p=197791
                  etc.

                  Once you go through them - you will know the post ID's of the 1st and last affected - so you would then enter: (if the above sample post ID's were right)

                  Code:
                  UPDATE post SET dateline = dateline - 43200 WHERE postid <= 197791 and postid >= 197787
                  If you miss any - you can do the manual edits to the Unix timestamps via phpmyadmin.

                  HTH,
                  *~AJ~*
                  [email protected]
                  AquariumPros.ca Forums

                  Comment


                  • #39
                    Thanks, appreciate you taking the time to explain it really carefully, it was really nice
                    Selling my BigBoard GamerzNeeds.net/forums Threads: 193 502, Posts: 1 540 045, Members: 718 566 It is listed here http://forums.digitalpoint.com/showt...3#post18297060

                    Comment

                    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                    Working...
                    X