Skip to:
Content
Pages
Categories
Search
Top
Bottom

‘User Database Table Prefix’ error in bbPress – Can’t Log in

  • 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

Viewing 2 replies - 1 through 2 (of 2 total)

  • Ben L.
    Member

    @nightgunner5

    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.

    Amazing. Fixed :) Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.