Most Ever On-line reset by itself, not working?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rolando
    New Member
    • Jan 2006
    • 21
    • 3.5.x

    Most Ever On-line reset by itself, not working?

    My most ever on line in the who's online stats area reset to

    Most users ever online was 1, 12-31-1969 at 07:00 PM
    Not sure what happened, how to do I get it back to normal? I don't recall changing anything. I have 3.6.4 and have this on a Unix dedicated server the database is on a separate backend server. I have four other VB forums on the same server, different databases but same db server, the other three are just fine. Thanks, rg.
    A Lexar Elite Photographer, writer for Studio Photography magazine
    & Author for Amherst Media
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    Run this query on your database. This should work:
    Code:
    UPDATE datastore SET data = 'a:2:{s:9:"maxonline";s:2:"[B]63[/B]";s:13:"maxonlinedate";s:10:"[B]1069899814[/B]";}' WHERE title = 'maxloggedin'
    Change the bold text appropriately. The first number is the number of logged in users. The second number is the date in unix timestamp format.

    If you use table prefixes then you need to change datastore to include the prefix.

    You can find a calculator to change a date & time to a unix timestamp here: http://www.onlineconversion.com/unix_time.htm
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • rolando
      New Member
      • Jan 2006
      • 21
      • 3.5.x

      #3
      as a non-coder, non-programmer, what do I change the bold text too? My apologies. Also, I run the query under maintenance? Execute SQL Query? Just copy and paste in then execute? Thanks, rg.
      A Lexar Elite Photographer, writer for Studio Photography magazine
      & Author for Amherst Media

      Comment

      • Paul M
        Former Lead Developer
        vB.Com & vB.Org
        • Sep 2004
        • 9886

        #4
        You set it to the number you want to appear, so in Waynes example, your forum would show "Most users ever online was 63".

        Yes, you run it as you asked.
        Baby, I was born this way

        Comment

        • stuartn
          Member
          • May 2006
          • 67
          • 3.5.x

          #5
          i've ran this reset a couple of times, within hours it gone back to a fixed date in 1970....

          any clues why

          Comment

          • Paul M
            Former Lead Developer
            vB.Com & vB.Org
            • Sep 2004
            • 9886

            #6
            You have an old piece of custom code (written for pre vb3.6) breaking it - do you have CMPS installed by any chance ?
            Baby, I was born this way

            Comment

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