Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 25 May 2011, 19:46
TWood's Avatar
TWood TWood is offline
Join Date: Mar 2009
Real name: Tom
How to get tag search result list to order by last post date?

Tag search results are ordered by the date of the original post in a thread, and ignores any more recent reply dates. How can I get it to order them by the last post date of any replies that might be in a thread? In the example below, the more recent post date of the reply in the circled post should move it to the top of the list.

Reply With Quote
Old 25 May 2011, 20:00
Lynne's Avatar
Lynne Lynne is offline
Join Date: Sep 2004
Real name: Lynne
Take a look at vb/search/searchcontroller/tag.php and you'll see the query there to edit. It currently sorts by dateline and you seem to want it by lastpost.
Former Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Old 25 May 2011, 20:19
TWood's Avatar
TWood TWood is offline
Join Date: Mar 2009
Real name: Tom
Thanks Lynne!

--------------- Added 26 May 2011 at 00:20 ---------------

Error message:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Last edited by TWood; 26 May 2011 at 00:29. Reason: Auto-Merged DoublePost
Reply With Quote
Old 26 Apr 2014, 20:16
B-runner B-runner is offline
Join Date: May 2013
Mega old thread bump.

What is suggested isn't exactly possible without more work, hence the error:
MySQL Error : Unknown column 'lastpost' in 'order clause'
The columns available in tagcontent are: tagid, contenttypeid, contentid, userid, dateline. There is no lastpost.

The dateline is the date the tag was added.
The userid is the user who added the tag (this could help track down a rouge tagger )
The contentid is an ID # based on when the content was created. This can allow you to sort based on when the thread was created, and not when the tag was applied. This is at least better for me since I can back-apply tags to old thread and it's not good to have those show up before new threads.

It looks like the contenttypeid determines if it is a forum post, blog or article.

For me, it looks like it puts posts before blog entries in results this list.

Note, as there is no "lastpost" in the tagcontent, and it won't make sense either since it only gets updated when a new tag is added. To get a lastpost one would have to take the contentid and then go to another table and query to get that based on the contentid, which would take hacking up the php a little more. I'm good with what I have for now.

(Adding info since this place is searched often and provides great info. Also, I don't get to contribute much elsewhere. )
Reply With Quote
Old 07 Nov 2016, 03:43
grey_goose grey_goose is offline
Join Date: Jun 2009
Pretty crazy this is so buried. Had to dig it up since we've been using tags more and more. The default behavior of sorting by when the tag was added rather than by thread/post dates is... a really strange decision.

Change line 95 to "ORDER BY threadid ASC" to get threads from oldest to newest.
Change line 95 to "ORDER BY threadid DESC" to get threads from newest to oldest.

Ordering results by last post date would require JOINing the thread table but that looks like it would require some extra evaluation of 'contenttype' -- I'm guessing for people with CMS/Blog, which I don't have.

Still, ordering by threadid (thread started) will put them in some semblance of order for most rather than the pure WTF-ery of sorting by tag-added date.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 23:29.

Layout Options | Width: Wide Color: