[isaacgreenspan]

Having just read the thread over here, I went and rechecked that my WordPress “secret” setting as listed in /wp-admin/options.php matched the setting in my bbPress admin-stettings-wp-integration screen and found that somehow they no longer matched. My best guess is that in the database “update” with the 2.5.1 upgrade of WP, it regenerated the database secret, thus killing the integration.

[berfarah]

Me too >.< I thought it was just me… heh

[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

[jethrokapinksy]

i wish i knew enough to offer an opinion. i’ve known about mod_rewrite for years from trying to configure drupal and wordpress. never heard of/used multiviews… hope that helps.

[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.

[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.

[mrhoratio]

Hey CK, I’m very much interested in this plugin. Also, it’d be great if you can get it to work with WordPress. So, that you can have the ability to promote a forum topic to a show up in a WordPress loop.

[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

[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?

[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/

[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?

[pulk99]

just upgraded to 0.9.0.2, and it’s working again. not sure if it was the bbpress update or the 2.5.1 wordpress update.

[affacat]

Not sure what you mean – the code I had above should do what I say it did, it just didn’t do what I wanted.

That said? I now have it working the way I wanted.

This code:

Gets the bbPress avatar, if it exists.

Checks to see if it’s an Identicon…

No? Display it.

Yes? Display Gravatar… but with the URL of the Identicon set as the default in case none exists.

Problem solved.

Note: I believe Gravatar recently integrated Identicons as a default setting, so you can probably do this now without Identicons setup in bbPress by modifying the code some. But this works.

PROFILE.PHP:

$ava = avatarupload_get_avatar($user->ID,1,1,0);

if ( avatarupload_get_avatar($user->ID) && !(usingidenticon($user->ID) )) {

avatarupload_display($user->ID);

}

else {

echo bb_get_avatar($user->ID,48,$ava[0]);

}

POST.PHP:

$ava = avatarupload_get_avatar(get_post_author_id(),1,1,0);

if ( avatarupload_get_avatar(get_post_author_id()) && !(usingidenticon(get_post_author_id()) )) {

avatarupload_display(get_post_author_id());

}

else {

post_author_avatar(48,$ava[0]);

}

[kikloo]

Hi,

I am looking for a similar theme to wordpress blog’s default theme. Anyone has it for bbpress ?

Thanks.

[enquirer32]

I’m using the latest versions of bbpress and WordPress. I intalled bbpress to be integrated with WP. however, when I click over from the WordPress site to the bbpress site I am not already logged in. Is there a list to troubleshoot to see why this happening? I have done as much as I can do so far (eg checking secret words etc).

More irritatingly I find that I’ve been logged out of the WP site when I go back.

Thx.

[gerikg]

It was me the last time. The problem with adding

<?php bb_head(); ?>

is that you get this when you visit the main site which is wordpress.

Fatal error: Call to undefined function: bb_head() in /homepages/0/d188981313/htdocs/kiaspeed2/wordpress/wp-content/themes/colorimetry/header.php on line 10

[baptiste]

I tried to post this in the comments off the plugin homepage, but Extend won’t recognize my login. Weird.

Anyway – if you are running 0.9 and plugin browser, you probably see no version listed for all plugins in the ‘Local’ column. This is due to a change in how bbpress stores the plugin paths in the DB (_ck_ clued me into that) The fix is easy. In the main plugins-browser.php file, add ‘user#’ before pb– or pb– on lines 681 (in the preg_replace statement) and line 698 ($plugin) Once I did that, the browser worked fine with correct version info, showed updates that existed, and installed them no problem.

I’m sure the WordPress plugin update stuff will make it into bbpress soon, negating the need for this plugin (to a point – the browse part is still great) but until then – this will get you going.