Announcement

Collapse
No announcement yet.

Globally change default sort field and order

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

  • Deejay
    replied
    It should be set this way out of the box IMHO

    Leave a comment:


  • stonepilot
    replied
    This worked for vB 4.1.2, just FYI.

    Thumbs up!

    Leave a comment:


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

    Leave a comment:


  • LEARNER29
    replied
    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.

    Leave a comment:


  • MSW
    replied
    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.

    Leave a comment:


  • Jake Bunce
    replied
    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

    Leave a comment:


  • floydian1
    started a topic Globally change default sort field and order

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X