Cannot order by last post

[fabianv]

Hi, trust all is well with everyone here?


I just recently used impex on my forums and I'm not entirely sure this is anything directly linked to impex itself but I'll post this issue in this forum anyway.

I've now succesfully got my forum working again and everything seems fine apart from one thing.

By default its on order by thread... which is totally wrong it should be order by last post.

I tried all the ordering types and everything works but for some reason it does not allow me to order by last post.

Can anyone maybe tell me why this would possibly occur?

Thanks in advance.

[Steve Machol]

I think this is what you want. 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 - Newest First

To reset options for existing users:

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

Then click on 'Continue'.

And finally to do this just for yourself:

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

[fabianv]

Hi, thank you for your speedy response!


Followed your steps exactly. The settings did happen to be on oldest first and now that was set to newest.

It does seem though that this had no effect on the problem with "last post" when im viewing a forum. Usually as you know when you click on a certain type of ordering it puts a little icon next to it. It does so with everything but not "last post"

Hope you could help me resolve this issue.

[Steve Machol]

Can you provide a link to what you mean?

[fabianv]

Hey Steve,

With pleasure!

Here you go: http://www.cgcentral.net/community/general.chat/

[Steve Machol]

All the last post links I tried work fine. What is the problem exactly?

[fabianv]

No it does not work fine.

Ok you know the menu bar that says:

Thread / Thread Starter / Rating / Last Post / Replies / Views


They all work but not Last Post

Look at the dates.. theyre totally not ordered right.. the ordering is completely off from 5 days ago.. its showing very old threads all over the place.

04-01-2006
05-07-2006
17-07-2006
31-03-2006
08-12-2005
07-01-2006

It jumps from January to July then to March then December then January..

Something is really not right here.


Hope you can help

[Steve Machol]

Oh, I see what you mean. I thought you meant the last post links.

Not sure what is causing this. Try rebuilding the thread then forum counters, in that order:

Admin CP -> Maintenance -> Update Counters

[fabianv]

Hi,

That did not fix the problem :(

[fabianv]

Another issue Im having apart from the forum ordering being messed up is the posts in the threads themselves are showing oldest first...

I dont know whats going on with my forum I need to relaunch it and cant if its like this..

[Steve Machol]

Then perhaps you should clear out the imported data and redo the import. Make sure you download the latest copy of Impex and use that since it is updated frequently.

[fabianv]

How would I clear out the data?

[Steve Machol]

In the Import section there should be an option to clear out the imported data.

If not, then the only way to do this is to reinstall vB and start fresh.

[fabianv]

I'll consider this a last resort as I have spent the last 2 days updating the style and sorting the forum categories..

To your knowledge there have been no other people with this problem? Ive been searching all over the forum with no luck.

[Steve Machol]

No, I haven't seen this problem before.

[fabianv]

Is there a way to save my settings in admincp > vbulletin options > vbulletin options

and also admincp > usergroups> forum permissions ?

[Steve Machol]

For the vB Options settings, add this to config.php to enter into debug mode:

Under:
<?php

Add this line:
$config['Misc']['debug'] = 1;

Then go into vBulletin Options. You will see the new option to Download/Upload Settings

Remove or comment out the debug line when you are done.

I do not know of anyway to save the Forum Permissions. Sorry.

[fabianv]

Wow I've never seen debug mode.. why is it not like this by default?

Very useful!

[Jerry]

Another issue Im having apart from the forum ordering being messed up is the posts in the threads themselves are showing oldest first...

I dont know whats going on with my forum I need to relaunch it and cant if its like this..


This is why the instructions advise leaving the source forum running until test imports have been done.

http://www.vbulletin.com/forum/showthread.php?t=116398

[fabianv]

Hey Jerry,

Don't just assume I decided to down my site and do the impex to a new install. I was actually upgrading to the latest version from 3.5.4 and ran into database problems.. I troubleshooted it as much as I could and decided to rather just delete the ftp content and import the database into a fresh install. ;)

Great work on Impex though.. its such a great tool. I'm trying now for a second time and will keep you posted if I run into the same problems.


Steve: I saved my settings and just tried uploading it on the new install.. it says it doesnt recognise the .xml.. strange hey? Seems like I'll have to redo the settings.

[Jerry]

Hey Jerry,

Don't just assume I decided to down my site and do the impex to a new install. I was actually upgrading to the latest version from 3.5.4 and ran into database problems.. I troubleshooted it as much as I could and decided to rather just delete the ftp content and import the database into a fresh install. ;)

True enough, my bad :)

[Steve Machol]

Steve: I saved my settings and just tried uploading it on the new install.. it says it doesnt recognise the .xml.. strange hey? Seems like I'll have to redo the settings.

Same version of vB, right? If so I don't know what you cause that to happen.

[fabianv]

Yes same version. It doesnt matter now I redid all the settings anyway.

Ok so I've re-uploaded the forum and started the databases from scratch and did the impex import and everything works 100%

Its a little strange that as soon as I do any changes in the forum manager the forums themselves set themselves as default sort by thread... atleast this time it allows be to sort by last post unlike last time.

[Steve Machol]

So is everything okay now?

[fabianv]

I need to know if there is a sql query that sets all the forums to view by default as last post and not sort by thread.

[Steve Machol]

It should do that automatically by default. What does the 'Default Sort Field' show in the Forum Manager?