[pastillasparaadelgazar]

Hi, our worpress site uses twenty fifteen theme and we want to add a forum to it. I am wondering if bbpress would be a good idea and will fit in the main content div without any problems. I read somewhere that bbpress has a strnage bahviour using this theme due to the big sidebar. Any experiences? Should we go with bbpress if we use this theme or better a separate forum script like phpbb? The site is this one Bellefem adelgazar. Thanks!!

[Yossi Aharon]

I recently migrated a phpBB forum to bbPress. I currently use 2.6 alpha version. The participants count of all topic is 0. When I try to run the fixing tool it reset all the topics to 1. Even if there are several participants and it happen also for a new topics on the forum after the migration. I think that it doesn’t count the gusets, the participants who don’t have account on the forum. It should also count the guest participants because for a forum that allow to guests to post topics there is no point to show the count of participants if all topics shows 0.

[Kolchak]

Here are the most common errors I’m seeing…

[09-Jun-2016 23:17:18 UTC] PHP Notice: Undefined index: salt in C:\wamp\www\oshh_testing\wp-content\plugins\bbpress\includes\admin\converters\phpBB.php on line 720

[09-Jun-2016 23:17:18 UTC] PHP Stack trace:

[09-Jun-2016 23:17:18 UTC] PHP 1. {main}() C:\wamp\www\oshh_testing\wp-admin\admin-ajax.php:0

[09-Jun-2016 23:17:18 UTC] PHP 2. do_action() C:\wamp\www\oshh_testing\wp-admin\admin-ajax.php:89

[09-Jun-2016 23:17:18 UTC] PHP 3. call_user_func_array:{C:\wamp\www\oshh_testing\wp-includes\plugin.php:525}() C:\wamp\www\oshh_testing\wp-includes\plugin.php:525

[09-Jun-2016 23:17:18 UTC] PHP 4. BBP_Converter->process_callback() C:\wamp\www\oshh_testing\wp-includes\plugin.php:525

[09-Jun-2016 23:17:18 UTC] PHP 5. BBP_Converter_Base->convert_users() C:\wamp\www\oshh_testing\wp-content\plugins\bbpress\includes\admin\converter.php:371

[09-Jun-2016 23:17:18 UTC] PHP 6. BBP_Converter_Base->convert_table() C:\wamp\www\oshh_testing\wp-content\plugins\bbpress\includes\admin\converter.php:885

[09-Jun-2016 23:17:18 UTC] PHP 7. call_user_func_array:{C:\wamp\www\oshh_testing\wp-content\plugins\bbpress\includes\admin\converter.php:1070}() C:\wamp\www\oshh_testing\wp-content\plugins\bbpress\includes\admin\converter.php:1070

[09-Jun-2016 23:17:18 UTC] PHP 8. phpBB->callback_savepass() C:\wamp\www\oshh_testing\wp-content\plugins\bbpress\includes\admin\converter.php:1070

[Kolchak]

Thanks for the suggestion. I turned on WP_DEBUG and the debug log has about 500,000 lines show up. Not sure I can pinpoint through that where the problem lies.

Just so I’m clear do I delete the first 4899 rows in phpbb_topics or phpbb_topics_posted?

Thanks again for any assistance.
John

[Kolchak]

I’m trying to import a phpbb forum with about 50,000 posts into a local dev site.

It continually stalls at “Converting topics (4900-4999)”

I’m trying to follow the instructions here:

Import Troubleshooting

which say to make a copy of the db and drop all records except within the offending range and try the import again to isolate the problematic row.

Should I go into phpbb_topics or phpbb_topics_posted to try and look for the offending problem?

Once I have the right table, do I then delete the first 4899 rows that appear in the db?

I’m using the latest WordPress and have tried both bbpress 2.5.9 and 2.6alpha.

Thanks for any help you can give me.

[Schoelje]

[Warning]: DO NOT DO THIS ON A PRODUCTION DATABASE!
My apologies for the caps, but this is really important 😉

[Assumptions]: Debian/Ubuntu developmachine with phpMyAdmin.

[Note]: Obviously I haven’t tested all Apache/MySql versions. This was done on SolydK (Debian Jessie). It is also not perfect. So, if somebody can improve on the code. Please, let me know.

After you’ve setup a development machine, imported the phpBB data and checked that everything is working fine, you still need to convert the phpBB internal links like “viewtopic.php?p=####” or “viewtopic.php?t=####” to the slugs that are being used by bbPress.

Let’s start!

1) First you’ll need to install and compile lib_mysqludf_preg.
Create a bash file install_preg.sh with this content:

#!/bin/bash
apt-get update
apt-get install libpcre3-dev libmysqlclient-dev build-essential libmysqld-dev libpcre3-dev
wget https://github.com/mysqludf/lib_mysqludf_preg/archive/testing.zip
unzip testing.zip
cd lib_mysqludf_preg-testing
./configure
make  install
make MYSQL="mysql -p" installdb
service mysql restart

Make it executable:
chmod +x install_preg.sh

And run it:
./install_preg.sh

2) Install the stored procedures.
In phpMyAdmin, select the database and the SQL tab.
Paste the following codes separately, creating three stored procedures on your database:

DELIMITER $$
CREATE PROCEDURE sp_cleanup_replies()
BEGIN
  -- declare cursor for reply url change
  DECLARE reply_cursor CURSOR FOR 
  SELECT DISTINCT old_post_id, REPLACE(<code>xkcom_posts</code>.<code>guid</code>, 'http://yoursite.com', '') AS new_url
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('/#p([0-9]+)/i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_post_id FROM <code>xkcom_posts</code>) AS t1
  INNER JOIN <code>xkcom_postmeta</code> ON <code>xkcom_postmeta</code>.<code>meta_value</code> = old_post_id
  INNER JOIN <code>xkcom_posts</code> ON <code>xkcom_posts</code>.<code>ID</code> = <code>xkcom_postmeta</code>.<code>post_id</code>
  WHERE <code>xkcom_postmeta</code>.<code>meta_key</code> = '_bbp_old_reply_id'
  AND old_post_id IS NOT NULL
  ORDER BY old_post_id DESC;
  
  SELECT 'sp_cleanup_replies: START';
  
  -- Change posts
  OPEN reply_cursor;
  BEGIN
    DECLARE old_reply_id MEDIUMINT;
    DECLARE new_url VARCHAR(255);
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH reply_cursor INTO old_reply_id, new_url;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9\.\-:\/&=\?\+]+#p', old_reply_id, '|i');
      SELECT CONCAT('sp_cleanup_replies: replace ', search_string, CONCAT(' with ', new_url));
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('#p', old_reply_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('#p', old_reply_id)) > 0;
    
    END LOOP;
  END;
  CLOSE reply_cursor;
  
  SELECT 'sp_cleanup_replies: DONE';
  
END$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE sp_cleanup_topics()
BEGIN 
  -- declare cursor for topic url change
  DECLARE topic_cursor CURSOR FOR 
  SELECT DISTINCT old_topic_id, REPLACE(<code>xkcom_posts</code>.<code>guid</code>, 'http://yoursite.com', '') AS new_url
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('/t=([0-9]+)/i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_topic_id FROM <code>xkcom_posts</code>) AS t1
  INNER JOIN <code>xkcom_postmeta</code> ON <code>xkcom_postmeta</code>.<code>meta_value</code> = old_topic_id
  INNER JOIN <code>xkcom_posts</code> ON <code>xkcom_posts</code>.<code>ID</code> = <code>xkcom_postmeta</code>.<code>post_id</code>
  WHERE <code>xkcom_postmeta</code>.<code>meta_key</code> = '_bbp_old_topic_id'
  AND old_topic_id IS NOT NULL
  ORDER BY old_topic_id DESC;
  
  SELECT 'sp_cleanup_topics: START';
  
  -- Change topics
  OPEN topic_cursor;
  BEGIN
    DECLARE old_topic_id MEDIUMINT;
    DECLARE new_url VARCHAR(255);
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH topic_cursor INTO old_topic_id, new_url;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9\.\-:\/&=\?\+]+t=', old_topic_id, '|i');
      SELECT CONCAT('sp_cleanup_topics: replace ', search_string, CONCAT(' with ', new_url));
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('t=', old_topic_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('t=', old_topic_id)) > 0;

    END LOOP;
  END;
  CLOSE topic_cursor;
  
  SELECT 'sp_cleanup_topics: DONE';
  
END$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE sp_cleanup_missing()
BEGIN
  -- declare cursor for reply url change
  DECLARE missing_cursor CURSOR FOR 
  SELECT DISTINCT old_post_id
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('|/&[a-z0-9=\+]+#p([0-9]+)|i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_post_id FROM <code>xkcom_posts</code>) AS t1
  WHERE old_post_id IS NOT NULL
  ORDER BY old_post_id DESC;
  
  SELECT 'sp_cleanup_missing: START';
  
  -- Change posts
  OPEN missing_cursor;
  BEGIN
    DECLARE missing_reply_id MEDIUMINT;
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH missing_cursor INTO missing_reply_id;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9&=\+]+#p', missing_reply_id, '|i');
      SELECT CONCAT('sp_cleanup_missing: remove ', search_string);
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, '#', <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('#p', missing_reply_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, '#', <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('#p', missing_reply_id)) > 0;
    
    END LOOP;
  END;
  CLOSE missing_cursor;
  
  SELECT 'sp_cleanup_missing: DONE';
  
END$$
DELIMITER ;

3) Run the stored procedures from terminal.
It is important that you check some example posts with links that need to change. First the post links like “viewtopic.php?some_parameters#p#####”, then topic links like “viewtopic.php?some_parameters&t=#####” and lastly the links to missing posts are removed.

mysql -u root -p -e 'CALL sp_cleanup_replies()' my_database

mysql -u root -p -e 'CALL sp_cleanup_topics()' my_database

mysql -u root -p -e 'CALL sp_cleanup_missing()' my_database

Now, check your posts and when you’re happy you can drop the stored procedures:

DROP PROCEDURE IF EXISTS sp_cleanup_replies;
DROP PROCEDURE IF EXISTS sp_cleanup_topics;
DROP PROCEDURE IF EXISTS sp_cleanup_missing;

Mod note: edited and changed dev site from contributer to yoursite.com

[Yossi Aharon]

Try to upgrade your phpBB forum before the import. When you chose to import the users, it should work fine as I checked. The only problem appear if you want just to import the posts without the users or if you delete the users, it show the author as “Anonymous” instead to show the username or nickname.

[giobby]

I’ve used 2.6 alpha for this import on a fresh wordpress installation. I’va also imported the users.
This behaviour was the same in the previous 2 versions.
I had more the 60000 posts affected over more than 300000.
I believe the parser failed to link the replies to the wordpress users under certain conditions but I haven’t been able to prove it yet.
I am using an old version of phpbb so probably this influenced as well.

[giobby]

After further investigations I’ve found a workaround that should work.

Just to recap on the error: it seems like several posts are left with the old phpBB poster id rather than using the new wordpress user_id (which really makes me think that somewhere in the converter code a wrong reference has been used).

The best way to work around the issue is the following (assuming a fresh installation):

1) before migration
– check what is the highest user_id in your phpBB installation (e.g.: 6235)
– insert a dummy row in wp_users with id grater than that (e.g.: 6236, or even better, round it up to 10000). In this way all the converted users will have their IDs starting from a higher value (e.g.: 10001, 10002, …) and it will be easy to spot the posts with wrong author (e.g. post_author < 10000).

2) launch migration as usual
3) after migration, create a temporary table that lists all the bbpress posts with wrong author

/* Get all posts with wrong author and correspondent right author from bbpress translator table */
create table TMP_ORPHANS as
select 
wp_posts.ID, 
wp_posts.post_author,
wp_bbp_converter_translator.value_id real_author, 
IFNULL(wp_posts.post_date, NULL) post_date,
IFNULL(wp_posts.post_date_gmt, NULL) post_date_gmt,
wp_posts.post_content, 
CASE 
	WHEN wp_posts.post_type = 'reply'
    THEN (SELECT tmposts.post_title from wp_posts as tmposts where tmposts.id = wp_posts.post_parent)
    ELSE wp_posts.post_title
END post_title, 
wp_posts.post_excerpt, 
pescasubac, 
wp_posts.quea.wp_posts.post_status, 
wp_posts.comment_status, 
wp_posts.ping_status, 
wp_posts.post_password, 
wp_posts.post_name, 
wp_posts.to_ping, 
wp_posts.pinged, 
IFNULL(wp_posts.post_modified, NULL) post_modified,
IFNULL(wp_posts.post_modified_gmt, NULL) post_modified_gmt,
wp_posts.post_content_filtered, 
wp_posts.post_parent, 
wp_posts.guid, 
wp_posts.menu_order, 
wp_posts.post_type, 
wp_posts.post_mime_type, 
wp_posts.comment_count,
	(	select wp_postmeta.meta_value 
		from wp_postmeta 
		where 
			wp_postmeta.meta_key = '_bbp_author_ip' and 
			wp_postmeta.post_id = wp_posts.id
	) user_ip
from wp_posts 
left join wp_users on wp_posts.post_author = wp_users.id
left join wp_bbp_converter_translator on wp_posts.post_author = wp_bbp_converter_translator.meta_value
where 
wp_posts.post_type in ('forum', 'reply', 'topic') and
(wp_users.id is null or 
wp_users.id = 1) and /* all posts of type forum looks to be assigned to the site admin (id=1 in my case)*/
wp_bbp_converter_translator.value_type = 'user' and 
wp_bbp_converter_translator.meta_key = '_bbp_old_user_id';

/* this is to be able to create indexes later */
ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);

/* indexes to speed up access to the table (some are useless) */
ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);

4) Now that you’ve got the list of posts with wrong authors, you can update your wp_posts table accordingly

/* Revert bad authors to good authors */
UPDATE 
wp_postsINNER JOIN TMP_ORPHANS 
ON wp_posts.id = TMP_ORPHANS.id
set wp_posts.post_author = TMP_ORPHANS.real_author 
where wp_posts.post_type in ('reply', 'topic') ;

Final consideration:
– this workaround seems to be working for me, but of course I don’t assume any responsibility in case it doesn’t work for you. The update trusts the converter table generated by the bbpress forum converter and assumes that a wrong author id matches the original author id of phpBB forum (I executed some checks and it seems like the problem is always the same = phpBB author id rather than new wordpress author id).
– the update doesn’t fix posts of type ‘forum’ because by default these are assigned to the wordpress site administrator. If you wish to assign them to the original phpBB author, just modify the where condition:
where wp_posts.post_type in ('forum','reply', 'topic') ;

message to the developers: I truly believe somewhere in the converter code a wrong reference is used under certain conditions. The pattern of the error is always the same: when the author doesn’t match it’s because the author id of the phpBB forum rather than the new converted author id.

@netweb

[giobby]

Hi Stephen

Just to let you know I’ve tried 2.6 alpha and the result is even worse in terms of post authors.
I’ve got plenty of anonymous and mismatching authors.

What I’ve noticed it’s again the same behaviour: several converted posts have an associated author id that is either 0 or that matches the author id of the imported forum.
Example:
PhpBB post’s author id is 1102
WP converted post’s author id is 1102 when it should be 18044

I’ve created a table that translates the phpbb user id to the bbpress user id by joining on email address. This in theory can allow me to set the post_author to the appropriate value.
The problem is to spot the affected posts.
I am trying a mix of criteria, by looking at the post creation date, user ip, etc. but it’s no simple.

I would be happy to provide additional info if you want.

Regards,

Gio

@netweb

[Fuskeduske]

Hi all,

On my forum, the latest Topic / freshest Topic sometimes shows the wrong topic as you can see here:
http://imgur.com/E1Y9Bu9 newest post is about 1 day, 18 hours old.

It always reverts back to the same thread, which was comverted from a phpbb forum.

I have tried recounting using the integrated tools, but that does not seem to work, however when i post a new topic it will work as intended showing the right post for about a day or two, and then go back.

[wdppoppe81]

Hi Schoelje,

Tnx for your help. I’ve imported my database from phpBB succesfully using the 2.6 alpha version of BBpress.

grtz

Willem

[giobby]

[I am just creating a new topic about this]

I’ve finally completed the conversion (took only 8 hours against the 2 days of the previous versions).

Nevertheless, big problem here: I can see no forum after the conversion.
I’ve been checking the database schema in which wordpress is installed and nothing….
I can only find an empty wp_bbp_converter_translator table and for the rest: no users converted, no posts, no forum and topics tables.

Does someone has any idea why this happened?
It actually looked like it was converting something and the number of interactions I’ve seen in the log during the conversion matches the actual numbers in PhpBB.

I would appreciate if someone can help.

Thanks,

Gio

[giobby]

Ok, I’ve finally completes the conversion (took only 8 hours against the 2 days of the previous versions).

Nevertheless, big problem here: I can see no forum after the conversion.
I’ve been checking the database schema in which wordpress is installed and nothing….
I can only find an empty wp_bbp_converter_translator table and for the rest: no users converted, no posts, no forum and topics tables.

Does someone has any idea why this happened?
It actually looked like it was converting something and the number of interactions I’ve seen in the log during the conversion matches the actual numbers in PhpBB.

I would appreciate if someone can help.

Thanks,

Gio

[Robkk]

@rnmartinez you can’t just use a phpbb theme for bbPress, you know different functionality for each forum system. You would have to remake the theme but for bbPress instead.

bbPress can have its own theme technically, by just using customized bbPress templates and custom styles and you can either put that in a custom/child theme or a plugin that creates a forum theme package, Robins plugin is a small example of the forum theme package thing.

[Robkk]

1. Its the WordPress Toolbar, used on all WordPress sites by default.

2. This plugin adds avatar suggestions, it might not be presented easily for users, but he expains it in this video.

3. bbPress by default doesn’t have the ability to upload files, for avatars that plugin I mentioned allows avatar upload.

4. You can filter the default wordPress smilies and use custom ones, their is emoji to use because of WordPress, also there a good plugin that has a feature to import phpBB smilies call WP-Monalisa.

[giobby]

Ok, I had to create manually all these columns.
Here what I did (I use ‘forum_’ as table prefix):

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_facebook varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_twitter varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_occupation varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_interests varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_location varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_youtube varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_skype varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_googleplus varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_website varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_aol varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_yahoo varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_icq varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_wlm varchar(255);

[giobby]

Just realised I didn’t post the right error.
Here it is…

Error Code: 1054. Unknown column ‘profile_fields_data.pf_phpbb_website’ in ‘field list’.

That column doesn’t exist in my profile_fields_data table.
Also, I was not getting that error with the previous version of the converter so i am wondering if the converter expects a specific/recent phpBB version to convert from

[giobby]

Hi everybody,

I’ve been trying as suggested bbpress 2.6 alpha but the PhpBB import fails right at the beginning.
I’ve been already importing successfully by using the latest 2 versions and I’ve never faced this error before.

Also take into account I am running the import in the same environment and against the same data set.
Here the error:

SELECT convert(users.user_id USING “utf8mb4”) AS user_id,convert(users.user_password USING “utf8mb4”) AS user_password,convert(users.user_form_salt USING “utf8mb4”) AS user_form_salt,convert(users.username USING “utf8mb4”) AS username,convert(users.user_email USING “utf8mb4”) AS user_email,convert(profile_fields_data.pf_phpbb_website USING “utf8mb4”) AS pf_phpbb_website,convert(users.user_regdate USING “utf8mb4”) AS user_regdate,convert(profile_fields_data.pf_phpbb_aol USING “utf8mb4”) AS pf_phpbb_aol,convert(profile_fields_data.pf_phpbb_yahoo USING “utf8mb4”) AS pf_phpbb_yahoo,convert(profile_fields_data.pf_phpbb_icq USING “utf8mb4”) AS pf_phpbb_icq,convert(profile_fields_data.pf_phpbb_wlm USING “utf8mb4”) AS pf_phpbb_wlm,convert(profile_fields_data.pf_phpbb_facebook USING “utf8mb4”) AS pf_phpbb_facebook,convert(profile_fields_data.pf_phpbb_googleplus USING “utf8mb4”) AS pf_phpbb_googleplus,convert(profile_fields_data.pf_phpbb_skype USING “utf8mb4”) AS pf_phpbb_skype,convert(profile_fields_data.pf_phpbb_twitter USING “utf8mb4”) AS pf_phpbb_twitter,convert(profile_fields_data.pf_phpbb_youtube USING “utf8mb4”) AS pf_phpbb_youtube,convert(users.user_jabber USING “utf8mb4”) AS user_jabber,convert(profile_fields_data.pf_phpbb_occupation USING “utf8mb4”) AS pf_phpbb_occupation,convert(profile_fields_data.pf_phpbb_interests USING “utf8mb4”) AS pf_phpbb_interests,convert(users.user_sig USING “utf8mb4”) AS user_sig,convert(profile_fields_data.pf_phpbb_location USING “utf8mb4”) AS pf_phpbb_location,convert(users.user_avatar USING “utf8mb4”) AS user_avatar FROM forum_users AS users LEFT JOIN forum_profile_fields_data AS profile_fields_data USING (user_id) WHERE users.user_type !=2 LIMIT 0, 100

Not sure yet what the problem is.
I’ll do my little investigation and I’ll let you know.

Gio

[Yossi Aharon]

Hello,
I want to migrate phpBB forum to bbPress. I use the default import tool of bbPress, I was able to migrate it successfully but the only problem is the author name shown as Anonymous in almost all topics. When I chose to import the users, the topics shown with the correct users besides the users in Hebrew that converted automatically to numbers and shown as Anonymous and that’s because WordPress doesn’t support Hebrew characters in the username.

I would like to convert it without the users but still keep the author name, as in archive forum. It’s also make sense to keep the original name of user who post even the user doesn’t exist in system. Any suggestions? Thanks.

[arrrstin]

I just realized this problem has to do with an old installation of phpbb. My bad!
Thanks

[Schoelje]

It took some time to make this topic visible on the forum. So, I’ve solved my own problem.

Instead of writing an htacces file I chose to write an alternative viewtopic.php script that collects the appropriate new bbPress URL from the database.

If your new bbPress forum is online, you place the following script in your old phpBB domain and save it as viewtopic.php (exactly where the old viewtopic.php used to be located) and don’t forget to replace the “my_xxxx” values with your information:

<?php
  // If all else fails, use this url.
  $defaulturl = "http://my_domain/forums/";
  
  // Your new bbPress database credentials.
  $host = "my_host";
  $db = "my_database";
  $dbuser ="my_database_user";
  $userpwd = "my_database_user_password";
  
  // Build the query according to url parameters p or t.
  $query = '';
  if (!empty($_GET['p'])) {
      $query = "SELECT xkcom_posts.guid FROM xkcom_postmeta 
                INNER JOIN xkcom_posts ON xkcom_posts.ID = xkcom_postmeta.post_id 
                WHERE xkcom_postmeta.meta_key = '_bbp_old_reply_id' 
                AND xkcom_postmeta.meta_value = '" . $_GET['p'] . "';";
  }else if (!empty($_GET['t'])) {
      $query = "SELECT xkcom_posts.guid FROM xkcom_postmeta 
                INNER JOIN xkcom_posts ON xkcom_posts.ID = xkcom_postmeta.post_id 
                WHERE xkcom_postmeta.meta_key = '_bbp_old_topic_id' 
                AND xkcom_postmeta.meta_value = '" . $_GET['t'] . "';";
  }
  
  // Set the new url to the default url
  $url = $defaulturl;
  
  // Check if we need to make a database connection.
  if (!empty($query)) {
    // Make a connection
    $mysqli = new mysqli($host, $dbuser, $userpwd, $db);
    
    // Check the connection.
    if (!$mysqli->connect_errno) {
      // Run the query.
      $result = $mysqli->query($query);
      
      // Get the new URL.
      if ($result) {
	$row = $result->fetch_array(MYSQLI_ASSOC);
	$guid = trim($row["guid"]);
	if (!empty($guid)) {
	  $url = $guid;
	}
      }

      // Free the result set.
      $result->free();

      // Close the connection.
      $mysqli->close();
    }
  }
  
  //var_dump($url);
  
  // Write the header.
  header("Location: " . $url, true, 301);
?>

[Schoelje]

I’ve successfully imported phpBB data into bbPress. Now, I’d like to redirect URLs like
http://my_phpbb_domain.com/viewtopic.php?f=1&t=2
to:
http://my_wordpress_domain.com/forums/topic/corresponding_topic/

I’ve search the web and have been experimenting with several solutions but without any luck. Anything I do throws a 404.

These are some of the links I tried out:

Rewriting URLs

Redirection to new bbPress board?

As you can see, these topics are at least 7 years old. On the other hand, I don’t expect that something has changed on how to write redirects in an htaccess file.

Does somebody here has some experience with this?

[Schoelje]

I’ve imported phpBB 3.1.9 into bbPress 2.6 alpha without problems.
I suggest you to create a development machine if you haven’t done so already and give it a try.

[wdppoppe81]

Hi All,

After configuring the importing form and clicking the start button, a failure message appears after amount of time;

Unknown column 'forums.forum_topics' in 'field list'

After clicking again on the start button only the reactions will be converted from phpBB to bbpress.

How can I import the topics and users properly, without encounter these failures?

Grtz.

Willem