vb.org Archive - SQL to fix forum sort order

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - SQL to fix forum sort order (https://vborg.vbsupport.ru/showthread.php?t=148244)

Sushubh

05-27-2007 05:03 PM

SQL to fix forum sort order

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

05-27-2007 11:05 PM

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

05-28-2007 10:28 AM

Quote:

Originally Posted by snakes1100 (Post 1255808)

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 ?

All times are GMT. The time now is 11:53 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01062 seconds Memory Usage 1,714KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: