XF 1.1 Some Forum Threads Aggregate All Posts to First Page

denzil

Member
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?

Any help is appreciated. :)
 

denzil

Member
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."
 

Jeremy

Well-known member
Yes, its due to the way XenForo handles fetching posts (its position). You'll need a query to go through and renumber them. I'm not sure if this can easily be done with a query.
 

denzil

Member
Yeah, XF is still new to me and I don't really know the relations in the database too well. If I did, I think it could be somewhat straightforward.
 

denzil

Member
Thanks for that, I think I figured it out. The SQL query is: SELECT * FROM `xf_post` WHERE thread_id=number. "number" is the thread id number.

Going to do an update to see if it fixes things.
 

denzil

Member
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.
 

Jeremy

Well-known member
Yeah. It finds 1-20 on the first page. Since they are all #2, they all get found.
 

Mike

XenForo developer
Staff member
Go to tools > rebuild caches and rebuild threads, but select the "rebuild post position" option.
 
Top