Forum Layout

[grim]

My VB forum for some reason shows me threads not in order. Such as

Last Post
Today
Today
5-09-08
5-21-08
Today
5-27-08

I have hit the Last Post link to change it to by last post, this however is not permanent.

Is there a setting somewhere to control this forum wide?

Admin control panel?

[Colleen]

Below the thread listings for one.

In the admin, each individual forum can be adjusted separately.

And lastly, admincp, execute sql query in the last box on the left side, you then choose the one to sort it however you want, it's supposed to then change all the forums.

Next you have to run the thread and forum update counters.

[grim]

I don't get it.

GRIM added 1 Minutes and 9 Seconds later...

Ok how the fuxx did the forums get set up to that, I do not see how to do them all together, guess I'll have to manually check each one.

GRIM added 1 Minutes and 54 Seconds later...

Ok all that were imported from mybb are setup wrong, I get it now.

GRIM added 2 Minutes and 28 Seconds later...

I am still confused as Fuxx, setting it to 'Last post time' flipped it so the oldest is first.

[Colleen]

Merging causes that, so we usually run the query they made to change them all, or perhaps that just changes everyone's personal settings and not the forums themselves. Yes, mybb imported forums always import with an alphabetical sort order I believe.

[grim]

I do not see a query to change them all.

[Colleen]

Perhaps you're own settings are adding to it, your cookies, etc because of how it was previously set so I suggest clearing your cache, etc.

Kalina added 0 Minutes and 21 Seconds later...

Then I guess you're stuck manually doing them.

[grim]

Even manually doing them is not working.

I guess it's just fuxxed

[Colleen]

Then check your own options in your profile as well, be sure nothing else is overriding the main settings.

Kalina added 2 Minutes and 41 Seconds later...

Make sure any parent forums of the problem forums are also set "Default Sort Field: Last Post Time"

Kalina added 4 Minutes and 34 Seconds later...

You can try this query:
UPDATE `forum` SET `defaultsortfield` = 'lastpost' WHERE `defaultsortfield` ='title'

IF it's currently sorting itself by title, if not, then change the "title" part accordingly.

Next you MUST update the counters or none of this will even appear to work to you. Doesn't work, then clear your cache, close the browser, etc.

[grim]

I tried manually doing each and every single one, it is in reverse though last I checked.

Now the newest post is the last in the thread.

[Colleen]

You sorted the wrong thing.

Kalina added 0 Minutes and 22 Seconds later...

Do you need help?

[grim]

How did I sort the wrong thing? That was the only option and what you said to do.

[Colleen]

You changed this "Default Sort Order" You were supposed to change only this "Default Sort Field".

Kalina added 0 Minutes and 48 Seconds later...

These two options are one above the other, sounds like you changed "Descending" to "Ascending"

[grim]

I changed the 'Default Sort Field'

GRIM added 0 Minutes and 45 Seconds later...

I did not touch the 'descending or ascending' options.

GRIM added 0 Minutes and 51 Seconds later...

some are set as ascending, I however did not touch that. What a fuxxing mess.

[Colleen]

Ok, and you ran the counters and also visited individual forums and made sure the boxes at the bottom weren't still preset to something else based on your previous settings? That's why you need to log out, clear the cache, etc and visit it as if you're brand new to see.

[grim]

Is there a way to auto set them all to descending?

GRIM added 0 Minutes and 21 Seconds later...

Yes C, plus I used a different browser all together to check

GRIM added 0 Minutes and 42 Seconds later...

I'll fuxx with it later, getting sick to my stomach and a headache from manually editing each and every single fuxxing one.

[Colleen]

Backup first, I didn't test this, but it's pretty general.

You can run this query.

UPDATE `forum` SET `defaultsortorder` = 'descending' WHERE `defaultsortorder` = 'ascending'

[grim]

Tried it, it did nothing.