SQL to fix forum sort order

[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