So, I used a third-party service to convert our Drupal data to XF data. Unfortunately, some of the threads have this problem where all the posts in the the thread are aggregated to the first page (without proper pagination) and the remaining pages are 'blank.' I figure that this is probably just a simple database fix but what I'm wondering is what database column am I looking for? I'm checking out the xf_thread table and I don't really see anything that indicates any sort of pagination. I guess I'm not exactly looking at the right spot?
IIRC, I believe this was doing this before the add-ons were installed. However, I just turned off the add-ons and it looks like it's still doing it. Something potentially key to note is that after the first post, every other post thereafter is listed as "#2."
Looks like the above works as far as ordering the posts. Just need to figure out a better query to do it in one batch. I'm still not sure yet if it'll fix pagination but I think it just might. I'm guessing all the posts are on the first page only because the posts are considered the same number.