Thanks for the reply. I added the line you suggested:
$wp_table_prefix = ‘wp_’;
I put this right after:
$bb_table_prefix = ‘bb_’;
But now I get the following error when logging in. It seems to me that there must be something in the config file or in a table that tells BBPress to use the WordPress usesrs table? I tried deleting the bb-users table whihc didn’t help.
bbPress database error: [Table ‘webdeadm_main.bb_users’ doesn’t exist]
SELECT ID FROM bb_users WHERE user_login = ‘admin’
bbPress database error: [Table ‘webdeadm_main.bb_users’ doesn’t exist]
SELECT * FROM bb_users WHERE user_login = ‘admin’
Was your bbpress setup before you installed WordPress?
Or did WordPress exist before bbPress? If you had bbPress first, the userbase is actually inside bbPress and not WordPress. It needs to be moved to WordPress (or some different settings in WordPress to use the user db in bbPress). I call that “reverse integration”.
But I’m missing a detail here – did you have working integration with WordPress+bbPress before you upgraded both to latest?
This might be an issue with the two parts of the “secret key” not being setup/synced properly between the two.
I think this is a similar problem posted here (that was never answered)
https://bbpress.org/forums/topic/bbpress-09-released#post-14973
Hey there,
my problem/question might be funny, but I just don’t get it. Just upgraded bbpress to 0.9.1 and set it up to be integrated with wordpress 2.5 (they both share the same DB).
in the bbpress config, i have the WP_ prefix set and everything seems to sync well.
But now all posts in the bbpress forums done by users that registered at the bbpress forums are signed as “Anonymous” and all these users are neither listed in the bbpress nor in the worspress admin.
To test, i removed the WP_prefix from the bbpress config, then these users are back, but for sure this is not the idea since i’d like to integrate both things.
Am I getting this all wrong, or is there any way to “import” the bbpress users into WP or something (without manually editing the database)?
Thanks!
Christophe
Yep, site is down…. not encouraging.
Wow, as I read your description of the problem initially I thought to myself, “sounds like a caching issue”.
A good note for the future. I assume you are loading WordPress inside bbPress then?
If bbPress and WordPress are in the same database then hopefully all you should have to do is add this line to your bb-config.php after the database definitions:
$wp_table_prefix = 'wp_';
I currently have bbpress .9.0.1. installed as well as wordpress 2.3.3. The user databases are integrated (I have mouldy old cookie and reverted back to the md5 hashing system). The only difference from a normal installation is that my table prefix for wordpress is nothing, not wp_. Now I set this correctly in order to integrate the user databases on the wordpress admin page, however I heard sambauers mention in another post that this could cause an issue with the bbpress role integrator? What is even wierder is if someone registers through bbpress they still do not get a role, and cannot post.
I currently have bbpress .9.0.1. installed as well as wordpress 2.3.3. The user databases are integrated (I have mouldy old cookie and reverted back to the md5 hashing system). The only difference from a normal installation is that my table prefix for wordpress is nothing, not wp_. Now I set this correctly in order to integrate the user databases on the wordpress admin page, however I heard sambauers mention in another post that this could cause an issue with the bbpress role integrator? What is even wierder is if someone registers through bbpress they still do not get a role, and cannot post.
Hey,
I just released my third bbPress theme! Let me know what you guys think!
Live Demo
Download
Matching WordPress theme on the way.
The user is not the keymaster. It is just a user who made another account because their account is unavailable since it is in the wp_users table.
Is it possible to just reinstall bb_press? Could I set WordPress integration while I installed a second time? I’m assuming the WP integration is what went wrong when I upgraded.
Hi Chris,
It is a WP blog, I just call it a website as I’ve tweaked a tad to be more websitesque and not bloggy.
Thank you for your help
This one had me stumped but I just figured it out. I should probably document the solve it here in case others encounter the same problem.
Like many people, I have bbpress installed in a subdirectory below wordpress:
/myblog/bbpress/
I also use the popular wp-super-cache plugin for wordpress. It turns out, you really need to add your bbpress directory to the list of rejected URI’s for wp-super-cache. For the above example, you’d want to add this line to the Rejected URI’s field:
/bbpress/
Otherwise, your bbpress board and the administration panel will be semi-randomly showing you old cached pages. Unsurprisingly, this can cause all sorts of strangeness including apparently activating/de-activating plugins, showing plugins that you’ve deleted, etc.
-Rob
OK, so it looks like you have matched the domains and paths correctly. Have you matched the bbPress “BB_SECRET_KEY” in bb-config.php to the WordPress “SECRET_KEY” in wp-config.php?
Do the secrets stored in each database match?
In bbPress it is the “secret” meta_key for topic “0” in bb_topicmeta.
In WordPress it is the “secret” meta_key in the wp_options table.
(Keep in mind that the cookie contents aren’t meant to be the same as they are hashed against the login time.)
Sam, I have both of these plugins running on the latest version of bbpress .9.0.1 and I’m using wordpress 2.3.3. Even before I installed any of your plugins, the user databases transferred between the two but the user roles have never been assigned correctly. Ever since I installed the moldy cookie plugin, I can login on my forums and go to wordpress but when I got from wordpress to bbpress it logs me out. In addition, I can only log onto bbpress now and not wordpress, wordpress says my password is invalid. So I can login through bbpress and go to wordpress fine, but I can’t do it vice versa. Any suggestions?
EDIT:
Scratch that, it works perfectly now, the problem was that I setup a subdomain forum.chroniccorner.net and it only carried the cookie if I made it chroniccorner.net/bbpress
thanks!
If it’s not a WordPress blog (I didn’t even really consider that), integrating with bbPress really won’t work out of the box. Integration just utilizes the wp_users and _usermeta tables. If you don’t have those tables since you don’t have a WordPress blog, then integration at this step doesn’t matter much. There is more work to do if you want an integrated look and integrated user logins.
Posts work now.
No longer have the admin option, I went to
/forums/bb-admin/
clicked upgrade, posts in forum now work
I no longer have admin privileges
Listed as member
Thanks, getting closer.
So when integrating with wordpress we use bb, not wp.
I also lost admin priv. in wordpress
I get: You do not have sufficient permissions to access this page. Doesn’t even give me choice to log in. I had no problem logging in as admin either place before changing the tables, etc
I did use the wordpress secret key phrase.
Used 0.9.0.1 downloaded fresh copy yesterday
Thanks Chris, I’ll give that a go.
Sam, I’m planning for bbpress to be part of an existing website, so I think (sorry, learning as I go along) that it means I need to integrate the two together.
Thank you both for your input.
You should skip step 2 unless you are specifically integrating your bbPress installation with a WordPress installation.
If you don’t know what a blog address is, then you don’t have one. There are lots of notes in the installer telling you exactly what the options are.
In wp-config.php, there is this line:
define('SECRET_KEY', 'put your unique phrase here');
Whatever value you have there is what you need for bbPress.
For WordPress address and Blog address, log into your WordPress control panel and under “Settings” you will find these two entries. Whatever is here is what you put into your bbPress installation.
They are entries three and four I believe.
http://www.example.com/wp-admin/options-general.php#siteurl
http://www.example.com/wp-admin/options-general.php#home
I just reinstalled BBPress. Now the forum appears with the correct style. But I still can not log in. I’m using WordPress 2.5. I installed the latest version of BBpress. I’m using the same password that I use with WordPress.
Is the secret different between WordPress and bbPress? I’m not sure how this works, but, I’m “willing to learn“.
I’m confused about what I should enter in the following boxes;
1) WordPress address
2) Blog address
3) Cookie secret key
I’m guessing the blog address is my website URL?………
But what about the other two?
Any help greatly appreciated!
Logging in to WP 2.5 logs me out of bbPress 0.9.0.1, and vice-versa.
Cookie information with bbPress .9
name: wordpress_613ba28cb41760cadf1f08a898f98620
contents: xxxx%7C1208969840%7C594bfc5f83a1e8af5dd70d130d4c0b89
website: coloradoboards.com
path: /appleswitcher/wp/
date: Wed, Apr 23, 2008 10:57:19 AM
Cookie information with WP 2.5
name: wordpress_613ba28cb41760cadf1f08a898f98620
contents: xxxx%7C1208969965%7Cba3e6d706d0ec0feff73e34afde5d9f0
website: coloradoboards.com
path: /appleswitcher/wp/
date: Wed, Apr 23, 2008 10:59:23 AM
…where xxxx is a not my username… just using that for security.
Looks like you got the $bb_table_prefix wrong when you installed, it should have been different to the wordpress prefix.
Change $bb_table_prefix
from “wp_” to “bb_” in bb-config.php then rename you bbPress tables thusly:
wp_forums -> bb_forums
wp_tagged -> bb_tagged
wp_tags -> bb_tags
wp_topicmeta -> bb_topicmeta
wp_topics -> bb_topics
.
Do not rename wp_posts
, wp_users
or wp_usermeta
!
This will still leave you without a bb_posts
table. So if you have a way to browse your database (e.g. phpMyAdmin) then go into the bb_topicmeta
table and look for the row with a meta_key
of bb_db_version
. Change the meta_value
of that row from 1234
to 1233
. Login to your bbPress (hopefully it works) then go to the admin section. You will be asked to upgrade, do so and check the log. You should see a log entry where your bb_posts
table is created.
That should do it.
i did that on my site
http://www.adityanaik.com
i added the wordpress loader php file to the bb-config file at the top
it works like a charm