Skip to:

‘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 – 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

    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

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


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

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

    Amazing. Fixed :) Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.