Announcement

Collapse
No announcement yet.

Globally change default sort field and order

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

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

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


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


      • #4
        Originally posted by Jake Bunce View Post
        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


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

          Comment


          • #6
            This worked for vB 4.1.2, just FYI.

            Thumbs up!
            sigpic
            Life is just a Big Skid

            Comment


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