SQL to fix forum sort order

[Sushubh]

After migration from IPB, it looks like my forum sorting is all messed up. Most of the forums are showing alphabetical posts.

Can anyone provide me the required SQL to run to convert all forums/subforums to be latest post and descending?

[snakes1100]

UPDATE forum SET defaultsortorder = 'desc'

Look for the Thread Display settings in vBulletin Options. This sets the default view mode for new members:

Admin CP -> vBulletin Options -> User Registration Options -> Thread Display Mode -> Linear - Oldest First

To reset options for existing users:

Admin CP -> Import & Maintenance -> Execute SQL Query -> Automatic Query -> Posts - Oldest First

Then click on 'Continue'.

And finally to do this just for yourself:

User CP -> Edit Options -> Thread Display Options -> Thead Display Mode -> Linear - Oldest First

[despo]

UPDATE forum SET defaultsortorder = 'desc'

Look for the Thread Display settings in vBulletin Options. This sets the default view mode for new members:

Admin CP -> vBulletin Options -> User Registration Options -> Thread Display Mode -> Linear - Oldest First

To reset options for existing users:

Admin CP -> Import & Maintenance -> Execute SQL Query -> Automatic Query -> Posts - Oldest First

Then click on 'Continue'.

And finally to do this just for yourself:

User CP -> Edit Options -> Thread Display Options -> Thead Display Mode -> Linear - Oldest First

Where to do that ?