Sorry, the correct command is:
UPDATE bb_usermeta SET meta_value = 'a:1:{s:9:"keymaster";b:1;}' WHERE user_id = %%USERID%% AND meta_key = 'bb_capabilities' LIMIT 1
Replace %%USERID%% with user id
Do you have access to your database? If yes, then create a new user which you want to be the admin. Then open your database through phpMyAdmin and open the database used in your bbPress install. A lot of tables would load in the left, click on the box like thing in the left of bb_users (or TABLEPREFIXusers), see the user you just created and note the ID in the left of it. Next, click the box in the left of bb_usermeta and then in the above part of right, click the SQL tab. In the textbox that appears, paste this:
UPDATE bb_usermeta
SET meta_value = ‘a:1:{s:9:”keymaster”;b:1;}’
WHERE user_id = ‘%%USERID%%’ AND meta_key = ‘bb_capabilities’`
Don’t forget to replace %%USERID%% with the id you noted down before.
Day two of attempted upgrade.
I combed through the boards, without much luck in terms of issue resolution (gripe!). If I figure out the remedy to my issue, I will be sure to post it here (so we can benefit from my stupid mistakes). 
I re-read the upgrade directions, and thought I would give it a fourth try. This time, I restored my 0.9 install and files, logged into the Admin control panel – everything okay.
I then moved all the new 1.0.2 directories over & replaced the 0.9 files (since I knew my backup worked). I verified my bb-config file was still good (shouldn’t have been touched).
I then ran the ‘upgrade.php’ script forum/bb-admin/upgrade.php
and got the message that my DB needed upgrading – so I select ‘upgrade DB’ and then receive:
ERROR: Could not establish a database connection
So – if I’m able to login to my bbpress 0.9 install and have full access to the DB, and I’m using the same bb-config values (same file!) – why would I not be able to establish a DB connection?
BTW – in another post, someone mentioned clearing browser cache helping…which I did. Nothing positive…
Any ideas out there?
THIS!
Can anyone make that WP plugin a BBP plugin?
https://wordpress.org/extend/plugins/rpx/
I’ll give you a cookie 
Ok, they’re using prototype and the toggle function. That’s what you would need to use to get that look.
http://ajax.googleapis.com/ajax/libs/prototype/1.6/prototype.js
The element you would target is already there in the output, .bb-category.
I just tried including wp-load.php from another WordPress site on the same server, like this, and it worked just fine:
require_once('../../dev/wp-load.php');
Maybe our PHP or server configurations are different. But this worked fine and did not error out. I also tried just including a test.php file that I created in the same directory (the file is empty) and that works fine too. PHP doesn’t care what’s in that file (or if there is even anything in there at all), so long as there is no syntax error.
Can you try to require_once some other random file in the same directory as wp-load.php? Just create a file called test.php in the directory as wp-load.php and try requiring that without requiring the wp-load.php. If it does not error out, then you probably have the path right and the system is configured to allow this type of file inclusion.
Also, if anyone has access to php error logs, that will help pinpoint the problem. Or, you can temporarily display errors to the screen, or create a custom logging. The blank screen tells you there IS a problem, but not WHAT the problem is. We’re just guessing without knowing the actual error.
I know this post is rather old, but none of the above suggestions worked. The problem with using the post_author_link or even get_user_link filters is that those only filter the “href” attribute, not the entire “a” tag. That means you can’t add rel=”nofollow” using those filters.
I wasn’t able to figure out a way to get it done without editing the core. I suggest the post_author_link() function around line 1747 of bb-includes/functions.bb-template.php be edited to allow the option of only returning the link rather than echoing it. That way, you can output the author links in your template (post.php) using something like this:
<?php bb_rel_nofollow(post_author_link(false)); ?>
With the “false” parameter telling WordPress to return the link rather than echo it. I believe that would work for future releases.
As for now, I believe you’ll have to open bb-includes/function.bb-template.php and edit the post_author_link and post_author_avatar_link functions to add rel=”nofollow” to the “a” tags. Those functions begin around line 1747 of bb-includes/function.bb-template.php.
Hope that helps.
rlebowitz – Thanks for sharing the files!!!
I received four files: footer.php, header.php, login-form.php, and style.css.
I was surprised there was no plugin file, but then I realized: the programmer must have fixed the issue by editing the templates, not the plugin. I’m pretty sure most of the changes to the footer/style files are cosmetic… which leaves login-form.php and header.php as potential sources of the fix.
I haven’t finished auditing the files, but maybe the reason Instant Password doesn’t work in 1.0 is that there’s some sort of conflict between the login-form page and the plugin?
Here’s the edited login-form.php:
http://pastebin.com/S8bcsw13
Then header.php calls that file:
http://pastebin.com/kJCc7Cbv
Can someone on 1.0 try out these templates and see if it resolves the issue for you?
If anyone can figure out the exact change that fixes the plugin, that’d be even better!
I FOUND THE PROBLEM!! YAAAAAAAY!!!
I had to go into my mysql database and had to delete the last change in my bb_meta which was a change with sth. like wp_ prefix.
I’m so happy now. 
Zat.
JPEG’s:
That was the change I made which produced the error:
http://drp.ly/wuZ2p
This are screens after solving.
http://drp.ly/wuP7T
http://drp.ly/wuSg7
http://drp.ly/wuRd7
I emailed you!
If you send it over, I’d be happy to diff the latest code to yours and post details on what code changed…
Thanks!!
If you paid for the code and own it, please consider releasing it under the GPL2 license and having it added to the plugin repository. Thanks for getting this done.
Hi,
Frustrated at not being able to install Instant Password and getting it to work on either 0.9 or 1.0, I hired a coder. (Yes, I outsourced to Asia. Sorry.)
Anyway, since people have helped me here, I would be happy to forward for free the files to make it work to anyone who wants them. Email me at rlebowitzATyahoo.com as I don;t check these boards so often.
It works well now.
Thanks,
Robert
John,
Thanks so much for this post. I checked back too late though and hired someone to code instant password for me in 1.0. He did a nice job.
If anyone wants the files, I’d be happy to share, since people (like John) have been very kind to me here. Contact me at rlebowitzAT yahoo.com.
R.
hi, i’ve added the code require_once(‘/path/to/wp-load.php’); on my bb-config.php in a subdomain of my site but when i try to visit the site i see only a blank page… any idea to resolve this issue?
my installation is: wp 2.9.2 and bbpress 1.0.2
thanks!
Here is my bbPress resource page 
http://blog.ashfame.com/bbpress
I have one particular forum for which I would like the threads in that forum to NOT appear in the latest discussions list. Is there a small bit of code I can add to do this. I would also love it if there was an additional column that indicated the forum that the thread listed in “Latest Discussions” came from.
@karma1981 – That’s a bug with the plugins page… there are two issues:
1) The download only works if you are registered, for some reason. So first, you have to sign into the plugins install.
2) The signin isn’t automatic because bbpress.org/forums and bbpress.org/plugins are using different versions of bbPress and don’t have cookies integrated.
So in short: sign into the plugins page, and the download should work!
Oh you top man Tom! Yep, worked first time, perfect.
Over on the other forum at: https://bbpress.org/forums/topic/how-to-keep-just-display-name-which-links-to-profile-in-posts#post-58301
they tried this, which didn’t quite work;
<a href="http://www.example.com/forum/profile/<?php bb_get_profile_link(post_author()); ?>">
<?php bb_get_profile_link(post_author()); ?>
</a>
I’ll mark this thread as resolved then, and put a link to here on there. Nice one, thanks.
James
Usernames can have a space in them because there is also a user_nicename set. This is all lowercase and any spaces are replaced with underscores. If you look at the link to your member page here you’ll see it ending in ‘james-blacker’.
I presume you’re wanting a link to the profile page when you click on a username.
To do that you need to something along the lines of
<a href="<?php user_profile_link(get_post_author_id()); ?>"><?php post_author(); ?></a>
Ah, I’ll change that back to 10 then.
Thanks, Tom. Just having a read of the codex now.
Cheers,
James
Presumably if I changed (or removed) the spelling of the codes in the names (not that I will), it would break and any info people had put in previously would be lost.
Only if you changed the name of the value. i.e.
'first_name' => array(0, __('What do they call you?')),
should be fine, as long as the first_name stays intact.
And I’ve increased the number parameter at the end of your add_action(‘extra_profile_info’, ‘add_descriptions’,15); – even I could work out that was important.
That number is the priority that the function should get in relation to everything else that’s loading on the page. Read about that here: https://codex.wordpress.org/Function_Reference/add_action
My code, btw, was at point got from this forum somewhere, so I can’t take credit for it. But it shows that anything in the functions.bb-pluggable.php file is easily replaced or manipulated.
That’s great! That’s brilliant Tom, thanks very much. I was obviously missing a few commands there!
Thanks both of you, you just made a lot of integral practitioners very happy with their new found ability to register what they’re doing with their practice for mind, body, spirit and shadow on their new forum. Here’s the handiwork in action: http://wholelifewholeworld.com/forums/profile/james-blacker
Presumably if I changed (or removed) the spelling of the codes in the names (not that I will), it would break and any info people had put in previously would be lost.
And I’ve increased the number parameter at the end of your add_action(‘extra_profile_info’, ‘add_descriptions’,15); – even I could work out that was important.
Tom, if you’re on a roll, do you have an insight for the one I posted on why linking poster names to their Profile doesn’t support usernames with spaces? Presumably you’ve linked Posts to people’s Profiles on your forum having done the extra work to modify your own profile pages?: https://bbpress.org/forums/topic/are-usernames-with-spaces-sensible
Thanks again, both, greatly appreciated.
Cheers, James.
PS. Paul, no relation to my colleague, Gary Hawke, presumably? http://integral-uk-symposium.wholelifewholeworld.com/meet-the-people/gary-hawke/
