[castresana]

Hello everybody!

I have a bbPress 0.9.0.7 forum running that works great. http://elanillounico.com/v5/foro
It has it’s users linked to my WordPress 3.4.2. http://elanillounico.com/

I wanted to migrate the bbPress to bbPress 2.1.2 (actual version) but I guess I am doing something wrong.
The new url for the forum is: http://elanillounico.com/forums

WHAT I AM DOING…

First of all I’m installing bbPress 2.1.2 plugin and I activate it in my WordPress.

Second I go to Tools – Forums – Import Forums, I select the bbPress1, I insert the db options and select all the options that suit my server so it doesn’t overload.

I start the process and I wait until it finishes saying “No tags to convert” and then… I am getting this error 🙁

WordPress database error: [Table 'my_database_forum.bb_term_relationships' doesn't exist]
SELECT convert(term_relationships.object_id USING "utf8") AS object_id,convert(term_taxonomy.term_taxonomy_id USING "utf8") AS term_taxonomy_id,convert(terms.name USING "utf8") AS name FROM bb_term_relationships AS term_relationships INNER JOIN bb_term_taxonomy AS term_taxonomy USING (term_taxonomy_id) INNER JOIN bb_terms AS terms USING (term_id) LIMIT 0, 1000

Apart from this, the installation does not go right. When I go to my forums, the forums themselves are all right. But the topics are all mixted up. It looks like if the answers to the original topics are now topics as well, so I have the forums with all of the messages as if they were topics, they are not linked as if they were lost the id that linked them.

Any idea of what this means and why this happened??

Question I have: Do I have to upgrade first to version bbPress 1.1 before I upgrade to bbPress 2.1.2?

Thank you very much! 🙂
Juan C.

• This topic was modified 12 years, 3 months ago by castresana. Reason: needed to complete the issue

[@johnjamesjacoby Keymaster 12 years, 3 months ago]

Exactly. You’ll want to update to bbPress 1.1 first.

[@castresana Participant 12 years, 3 months ago]

Thanks for the quick reply!

I just updated the bbPress to 1.1 version (last one available in Legacy).

After upgrading bbPress1 I tryed to import it from bbPress2.1.2 and this time, the importer didn’t give me any errors, but the importation didn’t go right.

The result is having the forums okay but in the transition the posts and replies are mixted up.
It looks like the script has converted all the replies into new posts, and actually, it has not maintained the post/reply respective users, now all of the posts and even the replies of the original post (that now are new posts as well, not considered as reply), are written by first post user.

So if we go to http://elanillounico.com/v5/foro/topic.php?id=9454#post-312800
(this is the original forum, not it’s a bit mixted up, it’s the template),

Anyway, in the lopic we saw, the user Aragorn_II began a topic and Wolfimbul replied and some other users as well.

When we go to but that thread in the new forum for example, you have this forum view:

So when you are entering first post available on the list, it is the original topic:

And when you enter the second post available, you see the first reply, and it is written by Aragorn_II but it should be written by Wolfimbul.

So, in the end, I do not know what I am doing wrong, any ideas?

Thank you!

[@castresana Participant 12 years, 3 months ago]

Just tried again and the reply the window gives me is:


Repair any missing information: Continue

Conversion Complete

No replies to convert

No tags to convert

Converting topics (47000 - 47999)

Any ideas? Thanks!

[@netweb Keymaster 12 years, 3 months ago]

Did you run ‘Repair Forums’ after the import?
https://codex.bbpress.org/repair-forums/

Is this the correct URL for your new forums? httpp://elanillounico.com/forums

[@markus-pezold Participant 12 years ago]

Hi castresna,

i’ve the same problem you describe above. After importing from bbPress 1.2 the replys and topics are mixed up. I’ve tried it a ten times – but no results.

How have you solved this problem for your forum?

I appreciate any advice. 🙂
Thanks.

[@johnjamesjacoby Keymaster 12 years ago]

You’ll want to fully update to bbPress 1.1/1.2 first. Make sure your forums work after having done so. As long as the 0.9 to 1.1 migration was successful, moving to 2.x should be exactly as described above.

The data schema changed from 0.9 to 1.1, and the converter in 2.0 is not for 0.9.

[@markus-pezold Participant 12 years ago]

Hi John,

in my situation is the correct version not the problem.
The original forum is on version 1.1 since months. And updated to 1.2 yesterday.
It’s an old forum (since 2002) – migrated to bbPress 0.9 and then 1.0 -> 1.1.
Since May 2011 the forum was deactivated – after some problems with an user. 🙁

Hmmm… I think the problem may lie in the fact that the forum has a lot of anonymous posters. In 0.9 there was an plugin for anonymous posters with meta data. But in version >0.9 these posts were all anonoymous posts without an user.

I’ll test the convertion on a blank installation of WordPress 3.5 today (without any other plugins). And the i’ll report again.

By the way. JJJ – carry on with your great work on bbPress. 🙂

[@markus-pezold Participant 12 years ago]

Hi JJJ,

after studying the bbPress 1.1 converter code and an deep look into the mySQL data I know the error. In my installation the field post_position is set for all old post to ‘0’. It’s possible that this is an error form the originally convert from phpBB to bbPress 0.9 some years ago.

From the import:
‘join_expression’ => ‘USING (topic_id) WHERE posts.post_position IN (0,1)’

So for now – i’m searching for an solution to reset the post_position.

[@markus-pezold Participant 12 years ago]

Alright. Everything fixed. 😉

To set the post positions new​​, I created a curious script using the function ‘bb_update_post_positions’ and an sql-query to get all topics by id. I loop through the topics and make an function call for an modified ‘bb_update_post_positions’.

I describe here only my approach to solve the problem. My php code itself could be dangerous. 🙂

But if someone has the same problems importing old data (bbPress 1.x)  I’ll help via email.

 

 

 

 

[@netweb Keymaster 12 years ago]

Glad you hacked found both your problem and a solution 😛

[@packzap Participant 10 years, 1 month ago]

Just want to add my notes in updating from dinosaur version 0.9.0.7 to 1.2 for anyone going thru the process. Follow the steps in https://codex.bbpress.org/legacy/updating/ (shown below).

At step four, these additional steps need to happen:

4-b) In bb-includes on the server create a drectory called backpress. Copy all the backpress files from the download of “backpress-1.2-bbpress\includes”. Copy the folder “schema” to \\bb-includes\backpress\ on the server.

4-c) In /bb-includes/backpress/ on server create a folder called “pomo”. Copy the 5 files from the download of “Glotpress pomo” into it.

Updating

These instructions cover upgrading to version 1.2

• First, you should always back up your files and your database in case something goes wrong.
• Second, deactivate all plugins.
• Third, keep the following files and directories.

  bb-config.php
  my-plugins/ (if you have it)
  my-templates/ (if you have it)
  my-languages/ (if you have it)
  also backup your existing .htaccess file if you have modified it, then delete everything else.

• Fourth, upload the newest version of bbPress to your server.
• Fifth, log in and visit your bbPress admin area. If you see an upgrade link instead of the normal screen, click it. If you don’t see an upgrade link (it would have been really obvious), continue to the next step.
• Sixth, visit the new “Settings” area of the admin and edit any details or settings in the “General” section. Also visit the “Permalinks” section to regenerate your .htaccess file if necessary. Also reactivate your plugins one by one (some may need to be upgraded as well).
• Seventh, sit back and relax; you’re done!

These downloads are for legacy versions of bbPress and are no longer in active development but still available for download if you’re feeling nostalgic. You can find the WordPress plugin bbPress here
bbPress 1.2

The latest 1.x stand-alone version of bbPress is 1.2 (.zip / trac / svn)

The latest bbPress 1.2 specific BackPress package is backpress-1.2-bbpress (.zip / trac / svn)

(You will also need the GlotPress ‘pomo’ folder from here.)