I have a functionla site at http://www.theindiansabroad.com using WP 2.7.1

Today I downloaded installed bbpress under http://www.theindiansabroad.com/forum and i was able to login and I received email with user and pwd info. as expected after the account was set.

The problem started right after I integrated bb to WP . I can login to wp but when I try to go to bb (/forum), it gives me a weird error at the top left corner. If I try to recover the pwd, it says email sent but I receive nothing…basically I cannot login.

The error format is

bbPress database error: [Table ‘XXX_forum.wp_users’ doesn’t exist]

SELECT ID FROM wp_users WHERE user_login = ‘host’

bbPress database error: [Table ‘XXX_forum.wp_users’ doesn’t exist]

SELECT * FROM wp_users WHERE user_login = ‘host’

The XXX_forum is my database and user name (and it is not wp_forum). the user name was host before the inegration. I cannot change my firsr part of database or username in MYSQL (from XXX to wp) as it is assigned by my hosting (justhost.com) company.

Could you please tell me how to fix this.

Thanks.

[@ipstenu Moderator 15 years, 7 months ago]

It looks like you have separate databases for your forum and blog. Do you also have an XXX_blog or XXX_wordpress database?

[@theindiansabroad Member 15 years, 7 months ago]

Yes, the database for wordpress is XXX_wrdp1 . Could you please tell me what is the most graceful way of fixing it? I don’t want to affect my operational site on wordpress, just want to integrate BBpress with it.

Thanks in advance.

[@ipstenu Moderator 15 years, 7 months ago]

You have to tell bb, when you set it up, where wp is Default assumption is that it’s the same folder. You’re going to need phpMyAdmin or something to fix it.

Go into your XXX_forum database and open up the bb_meta table.

Look for:

user_bbdb_name

user_bbdb_user

user_bbdb_password

The first one is the NAME of your WordPress database (so XXX_wrdp1), the second is the ID used to access said database (sounds like XXX_wrdp1 from your post) and the third is (heh) your password for that ID.

Set those up to point to WP and you should be able to log in.

[@theindiansabroad Member 15 years, 7 months ago]

where can I find bb_meta. I don’t see functions.bb_meta.php in bb-includes directory.

Yhx

[@ipstenu Moderator 15 years, 7 months ago]

It’s not in your folder, it’s in your SQL database.

As I said, you’re going to need phpMyAdmin or something to fix it.

[@theindiansabroad Member 15 years, 7 months ago]

Thanks.

When I go to phpMyAdmin, I do see bunch of tables under XXX-forum. For example, when I open bb_usermeta, it shows some entries such as umeta_id, User_id; but when I try to ‘browse’ them , I don’t see the the contents where I can see user name etc, instead I see something like:

SQL query:

SELECT COUNT( * ) AS Rows , user_id

FROM bb_usermeta

GROUP BY user_id

ORDER BY user_id

LIMIT 0 , 30

Is there a guide as to how I can work with this. Or do you know what is the best way to delete bbpress without affecting my wordpress, I will try to re-install it.

Thx.

[@theindiansabroad Member 15 years, 7 months ago]

For what it is worth, from my XXX_forum database in phpMyAdmin.

-I can get my username and pwd from bb_users, but when I enter it at my actual forum, it does not work.

-in bb_usermeta, i can find (or change) umeta_id, user_id, meta_key and met_value ; but I don’t see any file with format similar to what you said above, e.g:

user_bbdb_name

user_bbdb_user

user_bbdb_password

All I am looking for a way to back-out/unistall or fix it by changing the datbase mapping or any other trick you brainiacs may have up your sleeve.

Thanks

[@ashfame Participant 15 years, 7 months ago]

If you are using the stable release of bbPress (0.9.0.4), then my guide should be enough : http://blog.ashfame.com/2009/05/integrate-bbpress-forum-with-your-wordpress-setup/

Let me know if you need more help.