[Robkk]

do i need both bbpress and buddypress?

Depends on what you might need for your site, but technically no.

assuming i don’t “need” both, is it advantageous to have both?

Having BuddyPress allows you to use Group Forums, wordpress toolbar notifications for new topics and replies, better profile and custom profile fields, Members page, and a bunch of other stuff that might be useful if you want a more featureful forum.

do i need a wordpress page? i thought this was the case, so i registered and signed up for an annual wordpress account.. now that i’ve installed bbpress, it appears that i don’t actually need a wordpress page or an annual account, is this correct?

You don’t need a page, its not on the recommeded requirements for set up in my opinion. It might be required for a workaround for a theme/bbPress related bug. What do you mean by annual account? Just so you know bbPress won’t work on wordpress.com sites, and only self hosted ones.

how do i import a phpbb 3.1 forum into wordpress? i read the tutorial but a phpbb import tool isn’t included among the other import tools…

for 3.1 phpbb forums look into using bbPress 2.6 alpha, because the current version of the phpbb import in the stable version of bbPress does not work for version 3.1 phpbb forums.

my goal is to set up a phpbb-type forum/discussion, i’m not interested a wordpress blog or the like, just a discussion board. is this something i can achieve with bbpress, bbbuddy, the combo of both?

Its possible to create a forum with some features sort of like phpbb with the help of BuddyPress and bbPress, and quite possibly some other plugins that might be useful.

[aeneas1]

no experience with wordpress or bbpress but it looked great so i installed it… next up was an attempt to “import” my phpbb data to bbpress using the dashboard import tool but, sadly, a phpbb install plugin was not among those listed in the dashboard so i had to search the plugins directory… not knowing which one was best, i blindly chose the “CMS2CMS: phpBB to bbPress Forum Convertor” and began the migration process.. well surprise, surprise, shortly after the program began the migration a popup window reared its ugly head asking for $38 in order to complete a full migration… what the f is that all about? so is the wordpress life? wordpress plugin life? plugins are listed with no indication that they cost x amount of dollars until after you install the thing and try to use it? what sort of nonsense is that? how does this practice fly with wordpress? it’s enough to send a prospective wordpress user running in the direction of other alternatives, good grief…

[aeneas1]

i’m having a bit of a tough time understanding the wordpress flow and my exact needs in order to setup a standalone wordpress-based forum…..

– do i need both bbpress and buddypress?
– assuming i don’t “need” both, is it advantageous to have both?
– do i need a wordpress page? i thought this was the case, so i registered and signed up for an annual wordpress account.. now that i’ve installed bbpress, it appears that i don’t actually need a wordpress page or an annual account, is this correct?
– how do i import a phpbb 3.1 forum into wordpress? i read the tutorial but a phpbb import tool isn’t included among the other import tools…

my goal is to set up a phpbb-type forum/discussion, i’m not interested a wordpress blog or the like, just a discussion board. is this something i can achieve with bbpress, bbbuddy, the combo of both? or for a standalone forum is phpbb actually recommended over a wordpress-based option? thank you for your time.

[Robkk]

1. An answer to this is really a personal opinion on what you prefer specifically from each.

2. For WordPress you need a theme, Im sure its the same for others.

3. Just so you know WordPress is the CMS and bbPress is just piggybacking and using APIs from such. WordPress is updated quite frequently. You can allow bbPress to update automatically if you want through some plugin.

4. I don’t know why you brought up phpbb here, but bbPress can be automatically updated using a plugin. WordPress is updated automatically for security releases, and sometimes hosts cann allow you to just allow it to update automatically all the time.

5. Blog functionality comes packaged with WordPress, you can add other features using plugins or themes.

6. Read this for hardening WordPress.

https://codex.wordpress.org/Hardening_WordPress

7. For captcha plugins that work with bbPress check out this guide.

https://codex.bbpress.org/getting-started/forum-moderation/dealing-with-spam/#registration-spam

8. Use a plugin, or online service, or check your hosting provider.

https://codex.bbpress.org/getting-started/before-installing/backing-up-your-database-and-files/

9. Yes this forum has more than 100k topics. Users you will be fine.

Also which plugins will be better for users and forums so that their updation does not affect the live site once it is launched.

IF you are talking about plugin/theme/WordPress updates. Try to avoid automatic updates so you do not come across issues during an update and check to see if the update does not have any issues below rolling it out. Or just take frequent backups to avoid update issues and just roll back to a previous state.

[giobby]

Hi everybody,

I’ve just finalised the migration from PhpBB to BBpress.
I’have noticed that when I open a read a topic for the first time, there’s some processing happening in the background the takes time depending on the number of replies in that topic.

– hundred of replies can take more than 10 seconds. Once I am in the topic, if I open it again with another user, it’s fast.
– thousand of replies can end up in a ” PHP Fatal error: Maximum execution time of 30 seconds exceeded”
– also, a test I did on a topic with about 40K replies ended up in an “Allowed memory size of XXXX bytes exhausted (tried to allocate 4096 bytes) in Unknown on line 0” error.

I am on a dedicated server and I can change all the memory and execution time limits parameters, but I have the feeling this should not be the solution.
I don’t understand why there0s so much processing happening.

After a second look, I’ve noticed that the replies are not paginated. So the system tries to return all the replies in one shot.
I’ve tried to change the pagination settings and also to deactivate/reactivate the plugin but it didn’t fix the issue.

Even when I move a topic in the thrash, there’s some php logic that eliminates the replies one by one and can take a minute when the topic has 40 replies.

Is this normal?

Anyone who can help?

Thanks,

Gio

[Robin W]

You will need to change a template, so if you can edit a file and know FTP then you can amend this

create a directory on your theme called ‘bbpress’
ie wp-content/themes/%your-theme-name%/bbpress

where %your-theme-name% is the name of your theme

find
wp-content/plugins/bbpress/templates/default/bbpress/loop-single-topic.php
Make a copy of this file, and put in in the directory called bbpress that you created above, so you end up with
wp-content/themes/%your-theme-name%/bbpress/loop-single-topic.phpbbPress will now use this template instead of the original and you can amend this.

Now go to line 68, which says

<span class="bbp-topic-started-in"><?php printf( __( 'in: <a href="%1$s">%2$s</a>', 'bbpress' ), bbp_get_forum_permalink( bbp_get_topic_forum_id() ), bbp_get_forum_title( bbp_get_topic_forum_id() ) ); ?></span>

and delete this and save the file

[peter-hamilton]

Give it a shot, I prefer it over phpbb as it is much easier to adjust to needs.

Just install and give it a shot, should work fine

[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