[gmrtech]

I looked at several other forum posts – but my problem is slightly different:

I have WordPress 2.7.1 and installed bbPress on a separate database. So I have 2 databases on my server (WP, and bbPress). My forum is http://www.waltribeiro.net/forum – and I can’t log in, create new user, etc.

In the ‘User Database Table Prefix’ section of the bbPress>Settings> I changed the WP Admin as Key Master, WP Editor as Moderator, etc. in User Role Map (according to http://wordpress.tv/2009/01/23/integrating-a-bbpress-forum-with-your-self-installed-wordpress/)

So I realize now that when I incorrectly entered ‘wp_’ as my Table Prefix instead of leaving it blank that bbPress can’t find the correct directory: ‘ForumWalt.wp_users’ should actually be ‘ForumWalt.users’ (right?)

As a result, I get this:

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

SELECT ID FROM wp_users WHERE user_login = ‘Walt’

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

SELECT * FROM wp_users WHERE user_login = ‘Walt’

So I can’t log in to fix it, and I trial-and- error the bb_config.php file to $bb_table_prefix = ‘bb_’; and $bb_table_prefix = ”; and $bb_table_prefix = ”;

but no luck. I tried going into myPHPadmin and changing the SQL names’ prefix.. still nothing.

Here’s the pic from myAdmin

http://waltribeiro.net/pictures/SQL-Problem_Screenshot.png

I’m convinced that somewhere its’ looking for wp_user when in fact it needs to look for bb_user or else it won’t find me. Should I reinstall, is the solution easier than what I’m making it out to be?

Any help?!

-Walt

[Ben L.]

First of all, if you already had members on the forum that aren’t on the blog, integration will lose them.

I suggest going into your database and running DELETE FROM bb_topicmeta WHERE meta_key=wp_table_prefix LIMIT 1 to remove the integration.

[gmrtech]

Amazing. Fixed Thanks!