[meobeou]

I am importing an arabic vbulletin 3.x forum into bbpress.I am facing character encoding.vbulletin db has latin1 charset so I converted all tables to latin1_swedish_ci.after importing topics gose weird with blank titles.Any body help

Lee!

[budget101]

I was importing from my Vbulletin 4 and it went through converting topics, then it started converting tags and hung about 12,900. Is this a known bug? What’s the best way to do this over without losing the imported content and without taking risks of missing content not being imported initially on the hang up?

I’m a day late and a dollar short, but I thought I’d answer this for anyone else experiencing a similar issue.

vB4 tables originally used latin1_swedish_ci Collation, so when they’re imported certain characters don’t import properly causing the import to hang.

If the bbpress converter hangs up you can see what the last query was running. go to your WordPress MySQL Database:

Find the wp_options table (note that your table prefix may be different)

1. Shut off the importer (hit the STOP Button)
2. Go to the wp_options table & do a search for %converter% – it will return 3 tables

  a. _bbp_converter_query
  b. _bbp_converter_start
  c. _bbp_converter_step

Select both _bbp_converter_start AND _bbp_converter_query and click edit. Look to see where the tags got hung up in the option value field-

(here’s an example from my own database):

SELECT convert(tagcontent.contentid USING "utf8mb4") AS contentid,convert(tagcontent.tagid USING 
"utf8mb4") AS tagid,convert(tag.tagtext USING "utf8mb4") AS tagtext FROM tagcontent AS tagcontent INNER JOIN tag AS tag USING (tagid) LIMIT 2750, 50

In this case, it’s getting hung while imported tags 2750, 50 rows at a time.

change the values to the next bracket (but don’t alter any other data in the fields,:

_bbp_converter_start  2800
_bbp_converter_query 2800

and hit save

so now the option_value of the _bbp_converter_query looks like this:

SELECT convert(tagcontent.contentid USING "utf8mb4") AS contentid,convert(tagcontent.tagid USING 
"utf8mb4") AS tagid,convert(tag.tagtext USING "utf8mb4") AS tagtext FROM tagcontent AS tagcontent INNER JOIN tag AS tag USING (tagid) LIMIT 2800, 100

(note the new LIMIT number)

Then hit the START button on your Converter. IF, for some odd reason it doesn’t automatically restart, don’t freak out. Just hit the STOP button again, open a new page for the import

http://YOURDOMAINHERE.com/wp-admin/tools.php?page=bbp-converter

Re-enter your data, with the rows limit at 100, delay time the same as before & convert users STILL

Checked (if it was to begin with) DO NOT CHECK START OVER or PREVIOUS IMPORT.

Hit START and it will pick up where it left off.

Alternatively, you can
2. remove the offending tags from vbulletin –> /admincp/tag.php there are 45 per pg
3. update thread counters
4. Start the importer, see if it updates
5. If so- you’re all set *until next time* (and there WILL be a Next time!)

[budget101]

When it hangs it says something like: Importing Discussions (x-y) then all of a sudden it just prints “-” every 5 seconds or so and nothing is being imported,

Unfortunately this reply comes far too late to help the OP, but hopefully, this will help someone else down the road.

First, before you begin your transfer of vBulletin, add the following lines to the top of your wp-config.php just below <?php

define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', false );

This will create a debug log of any errors you encounter, you can access the log by visiting
https://YOURDOMAINHERE.com/wp-content/debug.log

keep in mind that if your wp install is within another folder, you’ll have to alter the path in the url to access the log.

Next, once you’ve encountered an error, check your debug log, if the error isn’t listed, you can go to your MySQL tables.

Hit STOP on the Importer. (Don’t navigate from the page, just hit the stop button).
Go to the wp_options table (might be slightly different prefix depending on your own database settings) and do a search for %converter%

You will find 3 rows within the wp_options table

a. _bbp_converter_query
b. _bbp_converter_start
c. _bbp_converter_step

The Step will show you which step # your install is hung up on. The Converter query will tell you precisely which line and the start is what tells the bbp_converter where you last left off.

View the steps in your wp-content>plugins>bbpress>includes>admin>converter.php file

Step 1 (about line 339)
Step 2 about line 360, etc

Most often the issue is due to character collation.

[Larry Lewis]

Been looking around about how to convert an old VBulletin forum into BBPress where all of the users in VB are already in WP. What I was planning on doing was processing the topics finding the WP user for the post and then adding it to BBPress.

Only there doesn’t seem to be an API type widget to add a post, is there a bit of a hint somewhere as to what I need to do that will let me add the topics (as topic or reply) so that I can do it diresctly if necessary?

Thanks
Larry

[Foliferous]

Hello,

I noticed a weird thing, the Admin profile has this empty DIV on its page:

Check it out.

Other profiles don’t have that. Check it out.

It seems to be this here:

<div class="comments-area"></div>

What is this and what is it doing there? How do I remove it? Is it some space for user comments on profiles? And why do other users don’t have that?

Thanks!

By the way I love bbpress, it’s awesome. I used a lot of other forum software (IPB, vBulletin, phpBB), but this one’s really the best!

[PHC Solutions]

I am currently testing the RC5 with a vBulletin 3 import and I am encountering fatal errors. Or should errors be indicated for a resolution?

[testato]

I imported a vbulletin 4.2.2 db

I choosed the vbulletin profile (not vbulletin3)

All is good, user topic replies, ecc, but i have a strange problem, the initial user of all topic is Anonymous.
Only the opening message, the reply instead have the corrected user.

May you help me to solve this problem ?

Thanks

[arshi82]

I am importing an arabic vbulletin 3.x forum into bbpress.I am facing character encoding.vbulletin db has latin1 charset so I converted all tables to latin1_swedish_ci.after importing topics gose weird with blank titles.Any body help

[TheBeliever]

Hello,

I have installed bbpress and everything is running smoothly for now. In future if I want to move my bbpress forum topics, users to other paid forum, can I do it?

I want to migrate every topic, reply and user profiles to invision or vbulletin or any other paid forum… is it possible?

[outdoorphoto]

WordPress v: 4.9.6
bbPress v: 2.5.14
Link: https://www.outdoorphoto.community/2018/
Theme: Avada (unrelated to the issue)

I am in the process of migrating a vBulletin DB to bbPress, however, some of the topics in the DB are very old and have been inactive for a number of years.
What are my options regarding the removal of these old entries from the DB?

I feel like I’m the only person that wants to do something like this since I have been unable to find anything relating to old content cleaning on your forum, Google, or the WordPress plugin repository.

[Brandon – Bsaweb]

PHP Fatal error: Access level to vBulletin3::setup_globals() must be public (as in class BBP_Converter_Base) in /xxxxxxxxxxx/wp-content/plugins/bbpress/includes/admin/converters/vBulletin3.php on line 0, referer: http://xxxxxx/wp-admin/tools.php?page=bbp-converter

[Brandon – Bsaweb]

Hello 🙂
I am currently testing the RC5 with a vBulletin 3 import and I am encountering fatal errors. Or should errors be indicated for a resolution?

[Brandon – Bsaweb]

Hello everyone 🙂
I am currently trying to migrate a vBulletin 3.8.1 to a BBpress.
The import this goes well via the vBulletin 3 import tools but from a certain moment after about 20h of import that if no more progress?

He’s always mooching to “Answer Conversion (363500 – 363599)”
No error message or other:(

Do you have any idea?
Info about my vBulletin table // https://ibb.co/mJunoy

[dirtydy2]

I almost had it done converting it to simple machine and then to BBPress but it kept getting an error at the end. I was converting to 4.4 (I believe) it was using the latest converter someone posted on the VB Forums. I apologize for not saving the links. I finally gave up. Went back to VB 5.0 and am hosting it myself. vBulletin is by far the best software out there for forums, but not great when you want integration. My forum was pretty good sized..

HH Forums Statistics

Topics: 59,495 Posts: 385,220

I didn’t use the cloud like I did and went back to self hosting like I had before. If you host vBulletin yourself you have total control over it and you can install 3rd party plugins. I use DragonByte. It is inexpensive and great customer support. With the new vBulletin interface and mobile support for apps it is again top of the line.

I waited well over a year for a solution to the problem and WordPress and BBPress were obviously not willing to take a good portion of the crowd wanting to jump from vBulletin. But they waited too long and vBulletin worked their issues out.

[StudentFilmmakers]

I sure would like help with this Vbulletin is to limited and hard to work with. 5.4.0 Help!

[6piston]

Hi all, I have converted my vbulletin forums to bbpress (a heavily pruned version of my big db)

– The conversion completed perfectly
– I ran the all repair jobs perfectly (except for user roles)
– The users are all imported perfectly
– the forum runs perfectly except..

The Problem:
All replies in every topic shows anonymous instead of user

is there any way to fix this?

thanks

[6piston]

Hi BBpress people!

Okay, it’s taken me days to go through with the conversion between vbulletin and bbpress. Until now, I have yet to see my complete forums in bbpress. The process stops eventually every time I restart.

180K Threads
4.2m Post
170 Users

What I have done is:
– copied the vbulletin site to vbulletincopy
– prune it down to 100K post (replies)
– start the conversion
– it’s taken me 8hrs and i’ve only got 18,000 replies converted.

Question 1:
How else can I do this conversion? I really want to get bbpress working.
Can I try this?:
– copy 4 or 5 copies of vbulletin db
– prune posts according to date (eg: 2018 – 2015 / 2015 – 2014)
– go through the conversion again with every “batch” and let it overwrite somehow?

Question 2:
How can I copy it in stages and let the forums operate with the latest data and I can overwrite with more old threads later?

Thanks!

[ipullrank]

Hey All,

I’m in the process of migrating an archaic and otherwise obsolete custom-built forum written in ASP to bbPress. The forum has been around for about 20 years and it was essentially a vBulletin clone. It has roughly 10 million posts and growing.

I’d exported CSVs of tables from the existing forum. We imported the users into the database and then associated them with the relevant posts. In the database now, wp_postmeta is 2.5 GB and wp_posts is 4.4 GB. Suffice to say everything is slower now, but the forum is 1200bps dialup modem slow.

I installed Query-Monitor to try and figure it out and this query is taking 53 seconds:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND wp_posts.post_parent = 36005
AND ( wp_postmeta.meta_key = ‘_bbp_last_active_time’ )
AND wp_posts.post_type = ‘topic’
AND ((wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘pending’
OR wp_posts.post_status = ‘closed’
OR wp_posts.post_status = ‘hidden’)
OR (wp_posts.post_status = ‘private’))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value DESC
LIMIT 0, 15

I spent time checking out this ticket https://bbpress.trac.wordpress.org/ticket/1925 but wasn’t really left with an idea of what I should be doing to fix this. Not really sure where I should start in thinking about how to get this down to normal speed. I have this running on pretty stacked machine and DB instances on Google Cloud, but I’m open to any input around what the specs of the boxes need to be to handle this.

Also, we’re also migrating our e-commerce site to WooCommerce from Shopify, so speed is definitely a huge issue and I don’t want to have the whole site be slow just because of the forum.

Thanks for any help!

[thealex626]

Hello. I have an forum on MyBB 1.8.12 with about 60.000 posts, 4.000 threads and 5.000 users. When I’m importing it into bbPress using the importer tool that comes with the plugin, it works really slow. I’m using 100 rows per cycle and it takes 80 seconds to do. I’ve estimated the time for the full conversion and it appears to be around 15 hours… Is this okay with bbPress? When I tried to convert the same forum into vBulletin, it took about 5 minutes.

[rogerlridge]

Is it possible to display my forums and sub forums the way they are displayed on vBulletin?

[Divvy]

Hello guys,

I’m migrating from vbulletin to wordpress.
In vbulletin, I have a feature showing under user avatar, that shows a image “My photos”, and when someone clicks there, goes to a list of topics created by the user in forums ID X and Y.
If no topics created there, the image “My photos” doesn’t show.

Is it possible to do this with bbpress?
Can someone give me a little help?

Thank you in advance 🙂

[rogerlridge]

Hey, I’m new to this forum so if I’ve posted this wrongly, please forgive me. I am just wondering is there a way to display how many users are currently viewing a particular forum. I would like to display it in the list of forums on the main forum page similar to the way it is displayed on VBulletin.

Thank you guys in advance.

[gainmojo]

I have tried importing my two Vbulletin forums into bbPress with varying degress of success and failure, mostly a combination of both.

When I first tried the import, I did get the forum to move over but the main forum would not display. It would instead redirect me to a specific thread. In that thread I could use tags to see topics displayed but that was as far as it went.

I tried to download some of your newer versions but that experience was worse and not better. It would sit at the timer waiting stage and never get any farther.

Thoughts? Prayers?

[tonezzz]

Hello everybody.

If this is off topic, pls help pointing me to the correct place.

This is the first time I’m working with bbPress, I’m trying to import from vBulletin now.

vBulletin = 3.8.6
bbPress = bbPress 2.5.12
WP = 4.7.5

I’ve been struggling for a few days already (I’ve also tried the 2.6-rc-3 without any luck). Just today, I found an advice to enable WP_DEBUG and WP_DEBUG_LOG so I did so and saw some error messages so I decided to look into the code and try to fix it myself.

Here’s the first one I found:

PHP Notice:  Undefined index: user_pass in ...\wp\wp-includes\user.php on line 1425

Here’s the code at line 1425:

$user_pass = wp_hash_password( $userdata['user_pass'] );

Should be changed to:

$user_pass = empty($userdata['user_pass'])?wp_hash_password(''):wp_hash_password( $userdata['user_pass'] );

There’re more errors I’m trying to fix right now. Pls let me know if it’s helpful and I should post them too.

Cheers,
Tony.

[sourfew]

Expect to notice slower performance but with a fast host, updated platform with PHP 7+, nginx etc it should work ok.
Elasticsearch or Solr for better and faster search.

The importer in 2.6 is much better than 2.5 but expect 10+ hours for the conversion.

I’am in the process of migrating from vbulletin to get a unified platform.