[bobbyh]

affacat, are you talking about the stars that indicate the ratings of particular plugins, e.g. https://bbpress.org/plugins/topic/unread-posts/ ?

[scooter7978]

I’m using Vanilla on my forums and since I like to change things every now and then, I’m going to move to BBPress in the near future. Since I’m testing at the moment, I thought I’d hand over the SQL statements for grabbing the categories, topics and posts and formatting them as best as possible for bbpress.

SQL to get the categories:

SELECT CategoryID, Name, REPLACE( LCASE( Name ) , ‘ ‘, ‘-‘ ) AS Slug, Description, Priority

FROM LUM_Category

SQL to get the topics:

SELECT DiscussionID, Name, REPLACE( Name, ‘ ‘, ‘-‘ ) AS Slug, AuthUserID,

(SELECT LUM_User.Name FROM LUM_User WHERE UserID = AuthUserID) AS PosterName,

LastUserID, (SELECT LUM_User.Name FROM LUM_User WHERE UserID = LastUserID) AS LastPosterName,

DateCreated, DateLastActive, CategoryID, Closed, Active, (SELECT 0) AS LastPostID, Sticky, CountComments, (SELECT 0) AS TagCount

FROM LUM_Discussion

SQL to get the discussions:

SELECT CommentID, LUM_Discussion.CategoryID AS ForumID, LUM_Comment.DiscussionID, LUM_Comment.AuthUserID, Body, LUM_Comment.DateCreated, RemoteIp

FROM LUM_Comment

JOIN LUM_Category ON LUM_Discussion.CategoryID = LUM_Category.CategoryID

JOIN LUM_Discussion ON LUM_Discussion.DiscussionID = LUM_Comment.DiscussionID

ORDER BY CommentID, ForumID

SQL to get the tags:

SELECT TagID, REPLACE( Tag, ‘ ‘, ‘-‘ ) , Tag, (SELECT 0) FROM LUM_DiscussionTags

From there you will need to fix up the slugs in the bb_topics table and in the bb_forums so that the web browser doesn’t have a conniption when it tries to load a forum thread but you can do that with a series of select(replace) queries like this:

update bb_topics set topic_slug = replace(topic_slug,’?’,”);

update bb_topics set topic_slug = replace(topic_slug,’.’,”);

update bb_topics set topic_slug = replace(topic_slug,’/’,”);

update bb_topics set topic_slug = replace(topic_slug,’&’,’and’);

update bb_topics set topic_slug = replace(topic_slug,’"’,”);

update bb_topics set topic_slug = replace(topic_slug,’\’,”);

update bb_topics set topic_slug = replace(topic_slug,'”‘,”);

update bb_topics set topic_slug = replace(topic_slug,’!’,”);

update bb_topics set topic_slug = replace(topic_slug,’,’,”);

update bb_topics set topic_slug = replace(topic_slug,”’,”);

update bb_topics set topic_slug = replace(topic_slug,’#’,”);

There might be a better or quicker way of doing the last bit but since it works fine on mine I am not too concerned.

I had to kludge some results in the queries like; SELECT 0 or SELECT 1 to get the answers I wanted or to pad out the columns to fit properly into the bbpress SQL layout. In most cases its just count fields or an active or open flag which is nearly always 1 or 0 anyway.

Generally this is all you need to get started, from there you can just export this table data to a CSV or something and then import it into the requisite bbpress table. If you go into the admin interface of bbpress and get the system to recount everything it should be ok from there. I only recommend doing this if you’re familiar with the inner workings of MySQL, otherwise you could bollocks things up and then noone wins.

Please remember too that this is the basics, if you’ve integrated with wordpress you’ve still got some work ahead of you to coordinate your wordpress ID’s with your forum ones. It can be done as I managed to do it, it’s just painful.

Cheers,

Scott

[kernow]

Thanks, I have upgraded OK, though I have a login/logout integration problem now with WordPress and bbpress. I’ll ask someone I know with more technical expertise for advice.

[kernow]

I unfortunately have the same problem

[enquirer32]

OK! Thanks for your help. I re-checked everything and there was a different ‘secret’ – found by visiting wordpresssite/options.php. I keyed this into the admin section of bbpress. I don’t know if this was the only thing as I tweaked the config file of WordPress to have two lines defining the cookie domain (it had only one). Anyway we have blast off.

[enquirer32]

thanks. still does not work.

1. upgraded bbpress to .9.0.2

2. yes

3. not sure how i can check this?

4. think so. added sthg to bbpress config shall i do the same to wp config?

5. yes

[domercmh]

This checklist was gold. Thanks.

I’m actually using an older version of WordPress (integrating wordpress 2.3.1 + aMember + bbPress). aMember doesn’t yet work with wP2.5. Had to follow bbPress instructions for older installs of WP.

After that, and confirming against your checklist, everything worked.

[yazerty]

Wow, there isn’t any tool to move from phpbb3 to bbpress ? How bad it is .

I hope there will be soon )…

[Bloggsbe]

I’ve made a plugin that lets you set your own default gravatar.

You can also choose to use Identicons, Wavatar or monsterID as the default gravatar.

You set the size and the rating you want.

This plugin overrides the built in Gravatar function, but you still have to choose to show the avatars in the standard options page, but all other gravatar options from that page is ignored.

I’ve tested it on bbPress 0.9.0.2 and 1.0-dev (from trunk), but it should work on all 0.9.x versions.

You can download the plugin from here.

I’ve also submitted it to the plugins list here on bbpress.org, and will (hopefully) show up there to

—

RG

[Michael Adams (mdawaffe)]

http://svn.automattic.com/bbpress-i18n/pt_BR/

Done. You should be able to check in content with your username (joildo) and password.

[jethrokapinksy]

Ok, I just realized that what worked for me only applied to a ‘clean’ top-level install, and what people are having issues with is installing bbpress in example.com/forums/, because example.com’s .htaccess is over-riding example.com/forums/ ‘s .htaccess file.

So here’s my example.com (permalinks work great):

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /index.php [L]

</IfModule>

chmod: 644

And here’s my example.com/forums .htaccess content:

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /forum/

RewriteCond %{REQUEST_FILENAME} !-f

RewriteRule ^([^/]+)/(.*)?$ /forum/$1.php [PT,QSA]

</IfModule>

Any ideas?

Thanks

[Sam Bauers]

Here’s a checklist:

1. You are running latest versions of WordPress (2.5.1) and bbPress (0.9.0.2)
2. You have matched SECRET_KEY in wp-config.php with BB_SECRET_KEY in bb-config.php
3. You have matched WordPress “secret” database option with bbPress “secret” database setting
4. You have setup compatible cookie domains and paths in config files (see instructions in bbPress admin)
5. You are successfully sharing user tables from WordPress with bbPress

[rhodzr]

!!There was a problem connecting to the database you specified.

Please check the settings, then try again.

hi i’m new to this.. i wanted to install bbpress but after providing the database name and user i get this error.. (on top)

[harryworld]

I have successfully integrated TinyMCE to my editor in bbpress, which I found that is so easy.

However, when doing the submit, TinyMCE submits the HTML code on behind to bbpress. I found that each line TinyMCE created a <p>…</p> tags, but bbpress is not allowing this. Finally, <p></p> comes to the screen when viewing the post.

Is there any workaround for this?

[ashishmohta]

kernow: Its better we did. As BBpress and WordPress both have ability to auto generate config file we get the benefit of getting the latest modifications.

[richcon]

I updated my web site today to bbPress 0.9.0.2 and WordPress 2.5.1. Cookie integration settings got out of whack and I put them back, but now the two are in conflict.

I’ve verified (by clearing cookies and watching as new cookies are registered) that both bbPress and WordPress are using the same cookie for login info — same name, path, etc.

However, when logging into WordPress I am logged out of bbPress, and when logging into bbPress I am logged out of WordPress. So they appear to be using the same cookie and overwriting it as I login to each section.

Note that the SECRET_KEY and BB_SECRET_KEY definitions in each respective config files are identical.

The cookie seems to be broken up into three parts: user name, a shortish numerical code (in decimal), and a long hexadecimal code. The name and shortish numerical code are identical between bbPress and WordPress but the long hex code changes every time. Does this help provide a clue?

[bobbyh]

It would depend on how often the RSS feed is cached by the WordPress plugin.

Good luck!

[mrhoratio]

Hey bobby, thanks for the links to RSS aggregator plugin. The only problem I see is synchronizing the feed. For example, if you edit the post in bbPress, will it automatically update it in the WordPress loop also? Or will you have to manuallly edit it in WordPress also. I will have to investigate and see.

[bobbyh]

That would work. A quick Google search found this under #3:

* http://www.makeuseof.com/tag/top-20-wordpress-plugins-for-power-users/

The download is here:

* http://www.makeuseof.com/files-shared/

I’ve never used it, but it looks like what you want.

Good luck!

[mrhoratio]

Now that I think about it, is there a way to do this by pulling the RSS free from bbPress into WordPress? What do you think?

[adaptiman]

Doreen – could you post the solution? It’s maddening to know you fixed it and yet didn’t share your solution.

[mrhoratio]

Hey bobby, thanks. This is close to what I want to do, but I’d like to be able to combine select forum posts and blog posts into a single list. Maybe there’s way to modify the plugin to do so?

[bobbyh]

This isn’t exactly what you’re looking for, but it lets you put a list of your bbpress topics in a sidebar on your WordPress site:

* https://bbpress.org/plugins/topic/bbpress-latest-discussion-for-wp/

[indymx]

How can I modify my bbPress so that it doesn’t show the IP Address posts are from?

[mrhoratio]

Hello everyone,

I want to display a bbPress forum topic within The Loop in WordPress. The idea is that it would appear as an excerpted blog entry like the others, but when you click the permalink, it would take you to the corresponding bbPress forum topic page where you can post comments.

For example, it would be great if there was to query bbPress forum topics that are tagged with “front page”, and display those forum posts together with blog posts within WordPress in chronological order.

The best scenario would be a little “Show in WordPress Loop” checkbox that you can check next to individual forum topics in bbPress. That way you can select certain topics to link to on the WordPress front page.

Does anyone have suggestions on how to do this? Would this be possible with a plugin of some kind?