Announcement

Collapse
No announcement yet.

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

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

  • 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

  • #2
    Run this query on your database. This should work:
    Code:
    UPDATE datastore SET data = 'a:2:{s:9:"maxonline";s:2:"63";s:13:"maxonlinedate";s:10:"1069899814";}' 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 customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment


    • #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


      • #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


        • #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


          • #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...
            X