Page 1 of 1

Posts CSV import works but no pagination

Posted: Tue Mar 31, 2020 12:50 am
by mmac
Hi, I have searched everywhere and cannot find an answer to this. Thanks in advance for any help you can provide.

I took some email files from a Yahoo group that closed and put them into a CSV file. I edited the file so that it would import to phpMyAdmin with each email imported as a post. Each email is in its own row. I want to add the emails from the Yahoo group as individual posts in the forum so that the information is preserved and searchable on the forum. I made a column in the CSV for each column that exists in pbb_posts and populated the necessary ones. The import works (after much trial and error - I haven't done this before) but when I view the posts in the topic I created, there is no pagination, so it will only show 10 posts (or whatever I set in the ACP). The posts are in order, but at the bottom of the page, it says "one topic - page 1 of 1". My question is, how to I get the posts to paginate? Thank you!

Re: Posts CSV import works but no pagination

Posted: Tue Mar 31, 2020 8:32 am
by Mick
Can you show us say half a dozen lines of your CSV, obviously edit any sensitive information first.

Re: Posts CSV import works but no pagination

Posted: Tue Mar 31, 2020 9:12 am
by david63
I would suspect that you have not set the topic_last_post_id correctly in the topics table

Re: Posts CSV import works but no pagination

Posted: Tue Mar 31, 2020 1:59 pm
by mmac
Thank you, everyone. After I posted this, I figured it out. I went to the forum and clicked “resynchronize” and it worked.
Now, I’m having the issue of some of the posts not showing to users (I can see them from my admin account) and some requiring me to approve them. I made the import with a different user that has all the permissions.

Re: Posts CSV import works but no pagination

Posted: Tue Mar 31, 2020 1:59 pm
by Brf
More likely topic_posts_approved has not been set in the topics table.
There are probably a few other fields missing too.

Re: Posts CSV import works but no pagination

Posted: Tue Mar 31, 2020 2:12 pm
by mmac
Thank you. I’ll search for how to do that.