I need a sql query to set for all my forums the default sort order to last posting time and descending order. After update my board from 7.4 to 7.5 the default is topic decending
Its a pain to do it by hand for all forums
BTW, what means decending? newest posting on top or on bottom?
The following query will set ALL forums to be sorted by Last Post Time, descending. Keep in mind, once you run this query, it cannot be undone so make sure this is what you want to do before you do it.
SQL Query
update ubbt_FORUMS
set FORUM_SORT_FIELD = 'last', FORUM_SORT_DIR = 'des'