[blandow]

So it didn’t work…
(The results I get when I start the import is no topics to import, no threads to import, etc)

This is my config.php file:

<?php
/*======================================================================*\
|| #################################################################### ||
|| # vBulletin 3.7.1 Patch Level 1 – Licence Number REDACTED
|| # —————————————————————- # ||
|| # All PHP code in this file is ©2000-2008 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # —————- VBULLETIN IS NOT FREE SOFTWARE —————- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| #################################################################### ||
\*======================================================================*/

/*——————————————————-*\
| ****** NOTE REGARDING THE VARIABLES IN THIS FILE ****** |
+———————————————————+
| If you get any errors while attempting to connect to |
| MySQL, you will need to email your webhost because we |
| cannot tell you the correct values for the variables |
| in this file. |
\*——————————————————-*/

// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type.
$config[‘Database’][‘dbtype’] = ‘mysql’;

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config[‘Database’][‘dbname’] = ‘insidestlforums_beta’;

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config[‘Database’][‘tableprefix’] = ”;

// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$config[‘Database’][‘technicalemail’] = ‘insideSTL_host@insideSTL.com’;

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to “true” disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config[‘Database’][‘force_sql_mode’] = true;

// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config[‘MasterServer’][‘servername’] = ‘localhost’;
$config[‘MasterServer’][‘port’] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config[‘MasterServer’][‘username’] = ‘redacted’;
$config[‘MasterServer’][‘password’] = ‘redacted’;

// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config[‘MasterServer’][‘usepconnect’] = 1;

// ****** SLAVE DATABASE CONFIGURATION ******
// If you have multiple database backends, this is the information for your slave
// server. If you are not 100% sure you need to fill in this information,
// do not change any of the values here.
$config[‘SlaveServer’][‘servername’] = ”;
$config[‘SlaveServer’][‘port’] = 3306;
$config[‘SlaveServer’][‘username’] = ”;
$config[‘SlaveServer’][‘password’] = ”;
$config[‘SlaveServer’][‘usepconnect’] = 0;

// ****** PATH TO ADMIN & MODERATOR CONTROL PANELS ******
// This setting allows you to change the name of the folders that the admin and
// moderator control panels reside in. You may wish to do this for security purposes.
// Please note that if you change the name of the directory here, you will still need
// to manually change the name of the directory on the server.
$config[‘Misc’][‘admincpdir’] = ‘admincp’;
$config[‘Misc’][‘modcpdir’] = ‘modcp’;

// Prefix that all vBulletin cookies will have
// Keep this short and only use numbers and letters, i.e. 1-9 and a-Z
$config[‘Misc’][‘cookieprefix’] = ‘bb’;

// ******** FULL PATH TO FORUMS DIRECTORY ******
// On a few systems it may be necessary to input the full path to your forums directory
// for vBulletin to function normally. You can ignore this setting unless vBulletin
// tells you to fill this in. Do not include a trailing slash!
// Example Unix:
// $config[‘Misc’][‘forumpath’] = ‘/home/users/public_html/forums’;
// Example Win32:
// $config[‘Misc’][‘forumpath’] = ‘c:\program files\apache group\apache\htdocs\vb3’;
$config[‘Misc’][‘forumpath’] = ”;

// ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
// The users specified here will be allowed to view the admin log in the control panel.
// Users must be specified by *ID number* here. To obtain a user’s ID number,
// view their profile via the control panel. If this is a new installation, leave
// the first user created will have a user ID of 1. Seperate each userid with a comma.
$config[‘SpecialUsers’][‘canviewadminlog’] = ‘1’;

// ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
// The users specified here will be allowed to remove (“prune”) entries from the admin
// log. See the above entry for more information on the format.
$config[‘SpecialUsers’][‘canpruneadminlog’] = ‘1’;

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config[‘SpecialUsers’][‘canrunqueries’] = ”;

// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$config[‘SpecialUsers’][‘undeletableusers’] = ”;

// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$config[‘SpecialUsers’][‘superadministrators’] = ‘1’;

// ****** DATASTORE CACHE CONFIGURATION *****
// Here you can configure different methods for caching datastore items.
// vB_Datastore_Filecache – to use includes/datastore/datastore_cache.php
// vB_Datastore_APC – to use APC
// vB_Datastore_XCache – to use XCache
// vB_Datastore_Memcached – to use a Memcache server, more configuration below
// $config[‘Datastore’][‘class’] = ‘vB_Datastore_Filecache’;

// ******** DATASTORE PREFIX ******
// If you are using a PHP Caching system (APC, XCache, eAccelerator) with more
// than one set of forums installed on your host, you *may* need to use a prefix
// so that they do not try to use the same variable within the cache.
// This works in a similar manner to the database table prefix.
// $config[‘Datastore’][‘prefix’] = ”;

// It is also necessary to specify the hostname or IP address and the port the server is listening on
/*
$config[‘Datastore’][‘class’] = ‘vB_Datastore_Memcached’;
$i = 0;
// First Server
$i++;
$config[‘Misc’][‘memcacheserver’][$i] = ‘127.0.0.1’;
$config[‘Misc’][‘memcacheport’][$i] = 11211;
$config[‘Misc’][‘memcachepersistent’][$i] = true;
$config[‘Misc’][‘memcacheweight’][$i] = 1;
$config[‘Misc’][‘memcachetimeout’][$i] = 1;
$config[‘Misc’][‘memcacheretry_interval’][$i] = 15;
*/

// ****** The following options are only needed in special cases ******

// ****** MySQLI OPTIONS *****
// When using MySQL 4.1+, MySQLi should be used to connect to the database.
// If you need to set the default connection charset because your database
// is using a charset other than latin1, you can set the charset here.
// If you don’t set the charset to be the same as your database, you
// may receive collation errors. Ignore this setting unless you
// are sure you need to use it.
// $config[‘Mysqli’][‘charset’] = ‘utf8’;

// Optionally, PHP can be instructed to set connection parameters by reading from the
// file named in ‘ini_file’. Please use a full path to the file.
// Example:
// $config[‘Mysqli’][‘ini_file’] = ‘c:\program files\MySQL\MySQL Server 4.1\my.ini’;
$config[‘Mysqli’][‘ini_file’] = ”;

// Image Processing Options
// Images that exceed either dimension below will not be resized by vBulletin. If you need to resize larger images, alter these settings.
$config[‘Misc’][‘maxwidth’] = 2592;
$config[‘Misc’][‘maxheight’] = 1944;

/*======================================================================*\
|| ####################################################################
|| # Downloaded: 16:07, Tue Jun 17th 2008
|| # CVS: $RCSfile$ – $Revision: 26534 $
|| ####################################################################
\*======================================================================*/

[blandow]

I am trying to import an old vbulletin 3.8.4 message forum to bbPress. Over 1.8 Million posts.

What is the best method to get this done? I gave the import tool in wordpress a shot, but it kept saying nothing to import. Any guidance would be appreciated, as I have never worked with forum exports/imports before.

[Pascal Casier]

Ouch, ok, let me have another look

EDIT: In my 2.5.8 install of bbPress, I see vBulletin3 in the list, so I would say give it a try on a testsite. Get WordPress, bbPress then Tools > Forums > Import forums

Pascal.

[mikebare]

Yes I could upgrade but the vbulletin upgrade costs $200 which seems like a waste of money since I won’t be using vbulletin any longer. Anyone else?

[mikebare]

I would like to migrate my vBulletin v3 forum over to the latest version of bbPress. I tried the migration tool from bbPress but it says there is nothing to migrate.

Is vBulletin v3 supported? If not, is my only option to update to vBulletin v4 first? I would like to avoid that as the upgrade costs $200 and I wouldn’t be using the software.

Please help.

[Pascal Casier]

Hi,
You can start from https://codex.bbpress.org/getting-started/importing-data/import-forums/vbulletin/

If any issues, just get back here.

Pascal.

[rahilwazir]

Hi,

How can I migrate vBulletin forum data to WordPress bbPress forum? Is there any easy way around or any sort of plugin. I wanna know is anyone had done this before?

I found this plugin CMS2CMS: Automated vBulletin to bbPress Migrator but its free version is limited and I haven’t tried it yet though.

[Pascal Casier]

Hi,
bbPress has a converter from vbulletin. You can install the latest stable bbPress 2.5.8 as a plugin to your WordPress and start the conversion. I would however like to indicate that bbPress 2.6-alpha (so not yet stable) is however much improved for conversions, so it could be an option to do it with that version.
You can find information on installing and importing in the codex: https://codex.bbpress.org/getting-started/

[lxp149]

I’m considering moving my vbulletin forum to bbpress. But I want to be able programmatically create the forum because it’s impossible to migrate manually. Any suggestions? Where do I even start?

[superaven]

Hey willywonkabar,

Unfortunately, I never tried. As mentioned further up, the fix needed for us to do so was supposed to be rolled into v2.6 which was due out soon. You’ll note on the download page that after all this time, the latest stable release is still at 2.5.8, so unfortunately BBPress isn’t even an option for us yet. Really sucks, because we’ve lost massive amounts of traffic struggling with bridge options and so far none have been all that great. We moved from vBulletin and settled on Xenforo as at least there appeared to be plugins to bridge their forum system to WordPress, but we’ve found after paying and testing the top 3 or so, that all come with compromises of one sort or another. We’re actually in the process of a major development effort now to move from a fully custom theme to a commercial theme for the purposes of simplifying the complexity of everything and dropping the various plugins and custom development we’d been using for our authentication and member roles. Hoping this improves the situation with the bridge, but not holding my breath. I really wish I could move us to an integrated solution like BBPress so we no longer have to worry about hacked bridges and unreliable authentication, but until BBPress improves the methods of how data is stored, it isn’t an option for large / active forums.

Sorry I don’t have better news for you.

[Stephen Edgar]

@excandesco The Xenforo import does NOT convert passwords

(I think its only bbPress 1.x, SMF, phpBB and vBulletin that convert passwords at this stage)

[invest0r7]

Hi All,

As the title says, I’m hoping there’s some way to preserve the same User IDs when importing forum users from vbulletin to WordPress. We’re starting a new site from scratch, but we have a ton of database info tied to specific user IDs.

Is this possible? Would be awesome to have this feature.

Thank you

[scorpnetwork]

Hello BBPress Community,

I am running a medium-sized vBulletin 4.2 Forum, which I want to migrate to BBPress for various Reasons.

The vBulletin Forum currently has 46k Topics with 490k Posts and 7k registered Users.

I am using the BBPress Built-in Importer to migrate my Forum, but I cant get it to work. The Importer runs smoothly until it gets to “Converting Replies”. It then just gets stuck somewhere in the middle of processing replies… I just see the rotating loading Symbol. At my last try to get this done, it already got stuck at “Converting Replies 0-99” …..
I know that I can press Stop and Start, but I have the feeling that this messes Things up… Take a look at my log:
———————–
Converting replies (200 – 249)
Starting Conversion
Converting replies (0 – 99)
———————–

The Script was converting Replies 0 – 99 when it got “stuck”. I pressed Stop and lowered the amount to 50, since I thought maybe 100 is too much? I pressed Start again, and it jumped to “200-249” … So where are replies 100-200 ???

Are there any other ways to migrate my Forum? Maybe a shell Script or php Script that is made to get run via shell, to prevent timeouts etc.?

Thanks for any help on this!

[Alex Seidanis]

Hello all,

several times I tried to import my vBulletin forum to bbpress, but it always seems to stall at some spot and starts outputting dashes. For some reason, it doesn’t always stall at the same spot. I have increased the memory limit, frequently refresh an admin page on a separate tab to keep the user session alive, but nothing seems to prevent those dashes from appearing. Stopping and restarting the process only produces more dashes where it left off; the only thing that does some trick is flushing the previous import data and starting clean.

Is there a mySQL / phpMyAdmin guide somewhere to help me out do that conversion the hardcore way, please? @netweb?

[lissyhunnybee]

After years of using vBulletin I am using BBPress on my newest site. This forum has been a really good resource while I am customising and getting used to the many differences lol

I’d love some constructive criticism and input on how it’s coming up so far. I am the type of person who constantly tweaks – a little change here and a little change there lol

http://www.lissyhunnybee.com/discussions/

[Pascal Casier]

@johnjamesjacoby thanks for the input.

@vinaynellagi keep us informed if you find something. I don’t know vBulletin, but is there a way to export only parts of it (like some months) to narrow down ?

Pascal.

[John James Jacoby]

With every iteration, bbPress writes to the _bbp_converter_query option to record the last successful query. You can use that to cross-check what the converter is putting out against what the records are that are being imported.

Usually when this happens, it’s a database encoding issue, and MySQL is getting stuck on a specific character in a specific record.

To confirm if this is the case, you’ll want to go back into phpMyAdmin (or your favorite database management tool) and bisect that range of posts to identify exactly which post in your vBulletin installation that bbPress is getting hung up on.

For example, when I converted bbPress.org from bbPress 1.2 to bbPress 2.0, it got stuck on 8 individual posts that had had encoding issues from 10 years ago when someone changed the encoding from whatever it was to latin1, and because WordPress usually expected to be UTF-8 and we have HyperDB in the middle to route queries around, bbPress’s converter would do exactly what yours is doing.

If it’s database encoding or some other anomaly, isolating what is goofy with exactly which post(s) is the only way to get around it. I’m anxious to hear what you figure out here, and very happy to improve our importer if there’s anything we can do on our end.

[vinaynellagi]

Hi, I am trying to import from vBulletin 4.2.2 to BBpress The forum is pretty big with Data of 2.4 GB.

Every time I start the import it gets stuck at 45458th record of topics with when it is executing this statement (I saw the number of records from WP Admin in under Topics section)

—————————
SELECT convert(thread.threadid USING “utf8mb4”) AS threadid,convert(thread.forumid USING “utf8mb4”) AS forumid,convert(thread.replycount USING “utf8mb4”) AS replycount,convert(thread.postuserid USING “utf8mb4”) AS postuserid,convert(post.ipaddress USING “utf8mb4”) AS ipaddress,convert(thread.title USING “utf8mb4”) AS title,convert(post.pagetext USING “utf8mb4”) AS pagetext,convert(thread.open USING “utf8mb4”) AS open,convert(thread.sticky USING “utf8mb4”) AS sticky,convert(thread.dateline USING “utf8mb4”) AS dateline,convert(thread.lastpost USING “utf8mb4”) AS lastpost FROM thread AS thread INNER JOIN post AS post USING (threadid) WHERE post.parentid = 0 LIMIT 45300, 100
—————————

I followed this but it stops again at every ~50 records.

But When I run this query in the PhpMyAdmin i get proper results of 100 records. I have tried to sanitize all the data that looked suspicious to me. Can someone please guide me to identify this offending data. What should I watch out for ?

I have setup my BBpress on it on my local server which sits on a RAMDisk of 10GB (Makes I/O, hence import process lighting fast). Is this an issue ?

Or are there any logs that I can inspect to see what error occurred ?

[barbarabax]

Hello, I need your help desperately! It’s one month now that i try to import my old forum into bbpress. Before, it was on vbulletin and i had no success. So i migrated vbulletin on a fresh phpbb installation and from there i’ve tryied again to migrate on bbpress. But this time is even worse!
I have the following problems:
forum repair recalculate the position of each reply gives me a blank page
on front page replies are not present, there’s just the first topic
on backend, if i try to access to replies, i have internal server error (when i’ve imported vbulletin i had the same 2 problems but at least i could access replies from backend)
I’m almost giving up as i lost so much time on it and i’m still stucked with the same problems.
Please help me!
Wordpress 4.3.1
BBPRESS 2.5.8
Theme: Hueman (issues are the same also on theme twenty twelve ecc)
noimamme.it/forums
Thanks
Barbara

[IbraheemSalem]

I Convert from vbulletin forums to WordPress,
I want ask if found Any method to makes passwords in wordpress same passwords in vbulletin for users transferred from vbulletin

[OutoftheHat]

I have a fairly large vbulletin 4.0.3 forum (sql dump installed locally), and am currently testing importing it into bbPress on a local xampplite install. I have a clean install of WordPress 4.3.1 and latest bbPress. Running the importer, it has run through 1600 users, 1300 topics and so far 4200 replies (100 at a time), at which it has paused, with the wheel turning happily. My question is, what’s causing the pause? Are there limits (such as sql queries per hour) that I can change to speed up the process? And if so, where do I change them? Given it’s a local install, I’m not worried about performance impact if I allocate max resources to this task. Any info welcome!

And how long should I let it spin before deciding it’s stuck and terminating it?

TIA

[summerfeeling]

Hello there,

I run at the time a vBulletin Forum with the version 4.2.2. I have placed a new WordPress installation today and bbPress install the latest version. I want to migrate all the data of vBulletin to bbPress.
Primarily are important to me, posts, attachments, users and especially the side structure (SEO).
I have the Importer with the correct credentials filled the Vbulletin Forum.

However, I get the following error message:

Repair any missing information: Continue
WordPress database error: [Table ‘dbxxxxx-11.forum’ does not exist]
SELECT convert (forum.forumid USING “utf8”) AS forumID, convert (forum.parentid USING “utf8”) AS parentid, convert (forum.threadcount USING “utf8”) AS thread count, convert (forum.replycount USING “utf8”) AS reply count, convert (forum.title USING “utf8”) AS title, convert (forum.title_clean USING “utf8”) AS title_clean, convert (forum.description USING “utf8”) AS description, convert (forum.displayorder USING “utf8 “) AS displayorder FROM Forum AS forum LIMIT 0, 100
No boards started to convert passwords reset Conversion

Why is that and how can I implement my plan successful? What am also very puzzled: Why is behind my database name, a point with forum added?

I would be your help very, very grateful. :))

[Robkk]

Nevermind I think you have to update to 4x, the other importer is for a much older version of vBull.

Make sure to have a backup saved before doing an import. You may try doing a backup on a test server also.

https://codex.bbpress.org/import-forums/vbulletin

Import Forums

Import Troubleshooting

[reminisce32]

Thanks for the response. Can you provide the link to convert a vbulletin 3.8? I only see the vBulletin v4.x Importer for bbPress.

[Robkk]

Pretty permalinks should work fine in bbPress if you have set up the permalinks to use the post name structure in Settings > Permalinks.

https://codex.wordpress.org/Settings_Permalinks_Screen

I don’t think it would be a step backwards, I am not sure all that the vbSEO plugin did SEO wise, but I bet there is a WordPress plugin that works fine with bbPress.

There are two different vBull converters, vBulletin and vBulletin3. The last one is what you would want to use.