By Spartan on Monday, 16 January 2017
Posted in General
Likes 0
Views 152
Votes 0
I've had to manually import bbPress forums into the Discussions table in the database. After updating a post on the admin side, the change doesn't take effect, it still remains in the wrong category. Any suggestions?
Actually I have a little bit lost here, may i know how do you import those bbPress forums discussion data into your database Easydiscuss post table?

Is it those bbPress forum post table structure is same with Easydiscuss?
·
Monday, 16 January 2017 10:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Nope, they are not even close to being the same. I exported bbPress topics, posts and replies as a CSV file, and then manually cut/paste the data fields per row to match that of EasyDiscuss.

However, some recent developments: I forgot about the thread table, and only imported the stuff to the posts table. This caused a major problem, resulting in me totally deleting all information from both the thread table and the posts table. I am now in the process of re-trying the import.

If you have a better suggestion, I would love to hear it. Or maybe you have some magic tool to migrate from bbPress to EasyDiscuss because I couldnt find one.
·
Monday, 16 January 2017 11:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Currently we do not have any migrator for bbPress forums.

Based on your above step, I think you missed 1 thing which is `thread_id` and #__discuss_thread table, this is the main table the post listing always referring to :

1. Imagine if you import all the correct data into this post table -> #__discuss_posts , make sure `thread_id` columns all set to 0 , and category id must set as follow what you import from.

2. Once you done above then try go to backend > Easydiscuss > maintenance > script > select all > click execute script button.

See how it goes.
·
Monday, 16 January 2017 11:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Nope, doesnt show anything on the front end now, though I can see and edit posts in the back end.
·
Monday, 16 January 2017 11:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Okay, it should show perfectly now.

The reason why it didn't populate those imported post on your listing page is because all the `published` state value is set to 255 which is not correct, you can check my attached screenshot below.

I already updated all the post to correct value, can you give it a check?
·
Monday, 16 January 2017 12:42
·
0 Likes
·
0 Votes
·
0 Comments
·
OK, I had originally used 0, and that didn't work, so I tried various other numbers, thanks
·
Monday, 16 January 2017 12:48
·
0 Likes
·
0 Votes
·
0 Comments
·
do you mean you would like to update that `published` value to 0 from #__discuss_posts table?

If yes, you have to update this columns `published` value to 0 from this table `#__discuss_thread` table as well.
·
Monday, 16 January 2017 12:55
·
0 Likes
·
0 Votes
·
0 Comments
·
So that was for the topics, and I would just need to import the replies into the post table, and nothing else to the threads table, correct?
·
Monday, 16 January 2017 12:56
·
0 Likes
·
0 Votes
·
0 Comments
·
do you mean you would like to update that `published` value to 0 from #__discuss_posts table?

If yes, you have to update this columns `published` value to 0 from this table `#__discuss_thread` table as well.



No, I was just pointing out my mistake
·
Monday, 16 January 2017 13:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Oh, sorry for confusing, may i know is it everything work fine now?
·
Monday, 16 January 2017 13:09
·
0 Likes
·
0 Votes
·
0 Comments
·
Tomorrow morning I will import the replies, I must go to work now
·
Monday, 16 January 2017 13:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Alright, keep us update if you need further assistance on this.
·
Monday, 16 January 2017 16:02
·
0 Likes
·
0 Votes
·
0 Comments
·
OK, Just an update - thank you for your help first of all!

Got the replies imported, and minus a few issues like post numbers being one off (this is a bbPress problem) which are now corrected, all seems to be in order. Thank you
·
Tuesday, 17 January 2017 00:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating Spartan, glad that your issues are resolved now
·
Tuesday, 17 January 2017 00:36
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post