Globally change default sort field and order

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • floydian1
    Member
    • May 2006
    • 79
    • 3.5.x

    Globally change default sort field and order

    I want to globally change my Default Sort Field and Order to...

    Last Post Time (It is set to Thread Title)
    and
    Descending (It is set to ascending)

    What is the SQL statement?
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    Run these queries:

    Code:
    UPDATE forum
    SET defaultsortorder = 'desc'
    Code:
    UPDATE forum
    SET defaultsortfield = 'lastpost'
    Then you will need to update your forum info:

    Admin CP -> Maintenance -> Update Counters

    Comment

    • MSW
      New Member
      • Apr 2009
      • 26
      • 3.8.x

      #3
      How do I set it so that my default sort is based on the relevancy rules I setup in my AdminCP? It seems the default is just chronological, which seems odd to not have the default return msot relavent threads first.

      Comment

      • LEARNER29
        Senior Member
        • Nov 2001
        • 316
        • 3.6.x

        #4
        Originally posted by Jake Bunce
        Run these queries:

        Code:
        UPDATE forum
        SET defaultsortorder = 'desc'
        Code:
        UPDATE forum
        SET defaultsortfield = 'lastpost'
        Then you will need to update your forum info:

        Admin CP -> Maintenance -> Update Counters

        Thank you Jake. very appreciated.
        .

        Comment

        • Evan25
          New Member
          • Dec 2007
          • 7
          • 3.8.x

          #5
          Just wanted to say thanks for this thread. It's helped me as well.

          Comment

          • stonepilot
            Senior Member
            • Apr 2006
            • 195
            • 4.1.x

            #6
            This worked for vB 4.1.2, just FYI.

            Thumbs up!
            sigpic
            Life is just a Big Skid

            Comment

            • Deejay
              Member
              • Jun 2000
              • 34

              #7
              It should be set this way out of the box IMHO

              Comment

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