How do I change Thread Display Mode to Oldest First?

[beansbaxter]

How do I change it on my forum so that the Thread Display Mode is set to Oldest First on every user's profile. I made a mistake and setup my config to make it so that every new user has Newest First and I fixed it there, but now I want to fix it all across the forum.

I am running 3.5.3 if it matters.

[Steve Machol]

To reset this and other options for existing users:

Admin CP -> Import & Maintenance -> Execute SQL Query -> Automatic Query

Then choose the appropriate query from the drop-down box and click on 'Continue'.

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'x';

...with x being your userid number (not username).

[Philosophy]

Thank you

Excellent! I too had the same problem and updated it with this query. Much appreciated Steve.