Sort by date?
Quote from Summersby on May 30, 2019, 1:39 amHey,
I’m new with the forum-software and have to set an old forum to the Asgaros-software. So I’d imported all the stuff from old forum (more than 230.000 posts) via database. That seems to work well and I build SQL where oldest posts are first and newest are last (and also set right post-date to each post).
My problem now: The forum doesn’t show newest posts first. They are mixed. I put the topics to wp_forum_topics and the posts to wp_forum_posts. All user_ids are set, the date/date_edit is allways the same. parent_id is set the topic_id and forum_id to the wp_forum_forums_id. What could go wrong here?
Best regards
Andreas
Hey,
I’m new with the forum-software and have to set an old forum to the Asgaros-software. So I’d imported all the stuff from old forum (more than 230.000 posts) via database. That seems to work well and I build SQL where oldest posts are first and newest are last (and also set right post-date to each post).
My problem now: The forum doesn’t show newest posts first. They are mixed. I put the topics to wp_forum_topics and the posts to wp_forum_posts. All user_ids are set, the date/date_edit is allways the same. parent_id is set the topic_id and forum_id to the wp_forum_forums_id. What could go wrong here?
Best regards
Andreas
Quote from Asgaros on May 30, 2019, 3:52 pmHello @summersby
The topics and posts are sorted based on auto-incrementing post-IDs – which means: Older posts have a smaller ID than newer posts. It is possible that you have imported a data-set in which the post-ordering was messed up so that the oldest posts were imported after newer ones.
Hello @summersby
The topics and posts are sorted based on auto-incrementing post-IDs – which means: Older posts have a smaller ID than newer posts. It is possible that you have imported a data-set in which the post-ordering was messed up so that the oldest posts were imported after newer ones.