Blog Documentation Book a Demo
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

[Solved] Controlling the thread order sort - descending, ascending, time, views, votes

unixherounixhero ✭
edited August 2012 in Vanilla 2.0 - 2.8

Hi

I'm new to Vanilla Forums.

Is there a way that the user, or the admin, can choose how to sort the threads/conversations in the forum?
Vanilla Forums has so many nice ways it could sort the threads, after time posted, how many views, how many upvotes

I am hoping at minimum to be able to make the forum stack the topics with the most recent posts at the top (time).
Right now it is not doing that (!???), and that has me a little confused...
Voting addon is disabled.

Tagged:

Comments

  • peregrineperegrine MVP

    the upcoming version 2.1 has this both option I believe for sorting

    Also there is a reverse comment sort plugin

    the default is most recent posts go to the top.

    if you imported

    http://vanillaforums.org/discussion/comment/165569/#Comment_165569

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • unixherounixhero ✭

    I imported from phpbb3. It's all very chaotic and not sorted after time posted.

    Could something have gone wrong with my import?

  • peregrineperegrine MVP

    if they are in reverse order -
    you can update the tables

    http://vanillaforums.org/discussion/comment/165576/#Comment_165576

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • unixherounixhero ✭

    New posts show up randomly in the "all posts" list and existing posts have no apparent sorting logic

  • peregrineperegrine MVP
    edited August 2012

    the best I can suggest if you want some kind of order for all existing posts

    is to use phpmyadmin and sort by discussion title.

    UPDATE GDN_Discussion SET DateLastComment = NOW( ) 
        ORDER BY Name ASC

    then the next ones should go in above according to time of last comment - assuming you are not embedding or having some magical comment insertion (feeds etc). assuming posters are posting the standard way and you are not using anonymouse.

    Also assuming you have your time set properly on your server

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • unixherounixhero ✭

    That kind of worked. But I didn't like it because it changed the metadata on ALL posts (obviously :) )... So I replaced the database with a backup, and sat down and looked at it. I found the root cause to my troubles.

    The ALL POSTS activity stream(or whatever it's called) puts all ANNOUNCEMENTS on top. My forum had more than 50 announced topics, and therefore it looked very chaotic and gave little sense.
    I guess we have to stop using announced topics, but that is a small price to pay. After I deannounced all topics, the forum sorts after latest post date.

    Great

  • x00x00 MVP

    50 announcements!!!

    yes announcements = sticky.

    grep is your friend.

  • UnderDogUnderDog MVP

    I think it has something to do with this problem you're having : http://vanillaforums.org/discussion/21111/after-importing-from-phpbb3-timestamps-only-show-month-and-year

    Was this your final import or just a test-run? Did you import with the Porter plugin or with Porter Plus?

    There was an error rendering this rich post.

  • unixherounixhero ✭
    edited August 2012

    I imported using the Import feature in Vanilla Core, using http://vanillaforums.org/addon/porter-core

    It proceeded with no errors.

    Anyways this is thread is [solved] now for my sake =)
    Thanks a lot

Sign In or Register to comment.