I have no idea what the problem is, but this right here is a funny 404 page:
http://approachanxiety.com/404.htm
This database is listed in the first error:
approachanxiety_com_bbpress2
But you are connecting to approachanxiety_com_bbpress in the second example. Was that changed along the way?
And you said you’re integrating with WordPress, but are you using a different database (i.e. why approachanxiety_com_bbpress if it’s an existing WP database?)
Not sure what it is yet, but I am curious.
Thanks for the response.
Okay, I tried to patch all the files with the changes in that ticket and I seem to get the same error.
Here is my config.php:
<?php
// ** MySQL settings ** //
define('BBDB_NAME', 'approachanxiety_com_bbpress'); // The name of the database
define('BBDB_USER', 'disco'); // Your MySQL username
define('BBDB_PASSWORD', 'xxxx'); // ...and password
define('BBDB_HOST', 'localhost'); // 99% chance you won't need to change these last few
define('BBDB_CHARSET', 'utf8'); // If you are *upgrading*, and your old config.php does
define('BBDB_COLLATE', ''); // not have these two contstants in them, DO NOT define them
// If you are installing for the first time, leave them here
// Change the prefix if you want to have multiple forums in a single database.
$bb_table_prefix = 'bb_'; // Only letters, numbers and underscores please!
// The full URL of your bbPress install
$bb->uri = 'http://approachanxiety.com/bbpress/';
// What are you going to call me?
$bb->name = 'New bbPress Site';
// This must be set before you run the install script.
$bb->admin_email = 'ericmonse@yahoo.com';
// Set to true if you want pretty permalinks, set to 'slugs' if you want to use slug based pretty permalinks.
$bb->mod_rewrite = false;
// The number of topics that show on each page.
$bb->page_topics = 30;
// A user can edit a post for this many minutes after submitting.
$bb->edit_lock = 60;
// Your timezone offset. Example: -7 for Pacific Daylight Time.
$bb->gmt_offset = 0;
// Change this to localize bbPress. A corresponding MO file for the
// chosen language must be installed to bb-includes/languages.
// For example, install de.mo to bb-includes/languages and set BBLANG to 'de'
// to enable German language support.
define('BBLANG', '');
// Your Akismet Key. You do not need a key to run bbPress, but if you want to take advantage
// of Akismet's powerful spam blocking, you'll need one. You can get an Akismet key at
// http://wordpress.com/api-keys/
$bb->akismet_key = ''; // Example: '0123456789ab'
// The rest is only useful if you are integrating bbPress with WordPress.
// If you're not, just leave it as it is.
$bb->wp_table_prefix = ''; // WordPress table prefix. Example: 'wp_';
$bb->wp_home = ''; // WordPress - Options->General: Blog address (URL) // Example: 'http://example.com'
$bb->wp_siteurl = ''; // WordPress - Options->General: WordPress address (URL) // Example: 'http://example.com'
/* Stop editing */
if ( !defined('BBPATH') )
define('BBPATH', dirname(__FILE__) . '/' );
require_once( BBPATH . 'bb-settings.php' );
?>
When I run the testdb.php I get
Connection Results
Connection: Successful!
Database Selection: Successful!
Enter Your MySQL Information
MySQL Hostname localhost
MySQL Username disco
MySQL Password xxxx
MySQL Database approachanxiety_com_bbpress
Here is the text php file that connects to the database and works:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>MySQL Test Script</title>
<style>
body { font-family: Verdana; font-size: 10pt; }
td { font-size: 10pt; }
th { font-size: 8pt; }
</style>
</head>
<body>
<?php
if ( isset ( $_POST['submit'] ) ) {
?>
<table border="1" summary="" cellpadding="2" cellspacing="0" style="border-collapse: collapse;">
<tr>
<th bgcolor="#F2F2F2" colspan="2"><center><b>Connection Results</b></center></td>
</tr>
<?
if (!$link = @mysql_connect($_POST['mysql_hostname'], $_POST['mysql_username'], $_POST['mysql_password'])) {
?>
<tr>
<td>Connection:</td>
<td bgcolor="red"><font color="white"><?php echo mysql_error(); ?></font></td>
</tr>
<?
} else {
?>
<tr>
<td>Connection:</td>
<td bgcolor="green"><font color="white">Successful!</font></td>
</tr>
<?
}
if (!$dblink = @mysql_select_db($_POST['mysql_database'], $link)) {
?>
<tr>
<td>Database Selection:</td>
<td bgcolor="red"><font color="white"><?php echo mysql_error(); ?></font></td>
</tr>
<?
} else {
?>
<tr>
<td>Database Selection:</td>
<td bgcolor="green"><font color="white">Successful!</font></td>
</tr>
<?
}
@mysql_close($link);
?>
</table>
<?
}
?>
<form method="post">
<table border="1" summary="" cellpadding="2" cellspacing="0" style="border-collapse: collapse;">
<tr>
<th bgcolor="#F2F2F2" colspan="2"><center><b>Enter Your MySQL Information</b></center></td>
</tr>
<tr>
<td>MySQL Hostname</td>
<td><input type="text" name="mysql_hostname" size="40" value="<?php echo $_POST['mysql_hostname']; ?>"></td>
</tr>
<tr>
<td>MySQL Username</td>
<td><input type="text" name="mysql_username" size="40" value="<?php echo $_POST['mysql_username']; ?>"></td>
</tr>
<tr>
<td>MySQL Password</td>
<td><input type="text" name="mysql_password" size="40" value="<?php echo $_POST['mysql_password']; ?>"></td>
</tr>
<tr>
<td>MySQL Database</td>
<td><input type="text" name="mysql_database" size="40" value="<?php echo $_POST['mysql_database']; ?>"></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" name="submit" value="Submit"> <input type="reset" name="reset" value="Reset"></center></td>
</tr>
</table>
</form>
</body>
</html>
I am installing bbPress to integrate with an existing WordPress. After the second step of install I get this error:
Second Step
Now we’re going to create the database tables and fill them with some
default data.
bbPress database error: [Access denied for user 'disco'@'localhost' to
database 'approachanxiety_com_bbpress2']
SHOW TABLES;
bbPress database error: [Access denied for user 'disco'@'localhost' to
database 'approachanxiety_com_bbpress2']
CREATE TABLE bb_forums....
It seems to be similar to this post,
http://bbpress.org/forums/topic/step-two-database-error?replies=4
And this one,
http://bbpress.org/forums/topic/db-access-problem-in-the-first-installation-step?replies=19
I tried to resolve it by replacing db-mysqli.php with db.php in the bb-includes folder and that didn’t work.
The username and password are correct. They are the same as for my original wordpress blog. And the database is correct as well. When I change it to something else I can’t even get to the second step.
Any help would be greatly appreciated!!!
is bbPress 0.8.3 compatible with WordPress MU 1.3?
Include bb in wp-config.php
like so:
require_once('path/to/bb-load.php');
thanks, yeah, i am not using bbpress + wordpress on the installation i’m trying to disable posts and registration on.. that’s the old one that’s getting moved to the new site that has wordpress.
0.8 doesn’t have plugin activation, i guess everything’s just enabled by default (someone correct me if i’m wrong). i’ll have to check out capabilities.php tomorrow (i’m off to a halloween party!). thanks for the help.
I set up an integrated BBPress and MU WordPress on Nginx. There may be a better way of doing the rewrites but these work well for me.
Here are the BBPress Nginx rewrites:
location /forums/ {
root /home/YOURDIRECTORY/public_html/forums;
index index.php;
if (!-e $request_filename) {
rewrite ^/forums/topic/(.*)$ /forums/topic.php?q=$1 last;
rewrite ^/forums/forum/(.*)$ /forums/forum.php?q=$1 last;
rewrite ^/forums/profile/(.*)$ /forums/profile.php?q=$1 last;
rewrite ^/forums/view/(.*)$ /forums/view.php?q=$1 last;
rewrite ^/forums/tags/(.*)$ /forums/tags.php?q=$1 last;
rewrite ^/forums/rss/(.*)$ /forums/rss.php?q=$1 last;
rewrite ^/forums/bb-admin/ /forums/bb-admin/index.php last;
rewrite ^/forums/ /forums/index.php last;
break;
}
}
Here’s a full write up here:
http://dev.honewatson.com/bbpress-wordress-mu-integration-nginx-pretty-urls-rewrites/
Ditto – replacing /bb-includes/db-mysqli.php did the job.
I wish I would have seen this earlier.
I just hacked in gravatar support by using the wordpress plugin. Since I didn’t see any listed in the extensions section I went ahead and applied to have mine added. I will go ahead and delete mine since their is really no point in having two.
If you have any use for the code I used let me know I can send it on.
Great software – I love the approach take with WordPress and BBpress – simple, clean and elegant.
Are you planning on adding photo upload capability for forum posters?
Livibetter, thanks, but I’m still a bit confused, as that looks like what I did type. Also, I installed bbPress as a subdirectory in the WordPress folder, so it was path/to/wordpress and then path/to/wordpress/bbPress. Does this make a difference?
majea,
You used require_once
in a wrong way. If you installed WordPress in /path/to/wordpress and bbPress in /path/to/bbpress, then you should use
require_once '../wordpress/wp-blog-header.php'
.
You normally use require/include
for local .php.
PS. I don’t use WordPress and bbPress together.
I am trying to integrate bbPress with WordPress. I installed it on my local test environment first, in order to work out any kinks. bbPress is in the same database as WordPress. The installation went fine, it seemed, and I ended up with a basic version of bbPress — left-aligned black font on a plain white background. Is this what I am supposed to see?
However, when I tried to point it to WordPress, using “require_once(‘http://localhost:8888/wordpress/wp-blog-header.php’);” in the config.php file, I only got a blank screen. Any idea what I’m doing wrong?
I sort of fumble my way through all this web design stuff, so there is a good chance the answer is painfully easy, but I can’t seem to find it. Thanks.
I thinking to start developping a plugin.
I’m not a real coder but i’ll try.
Anyway, I think the problem is that bbpress uses names and not levels (like wordpress) for roles, so it will be hard to do, no ?
If you have ideas, if you want to help me, please feed this threat !
WP answers to requests to domain.com
I followed the WP instructions on serving WP from a different directory than it’s installed in (WP Admin -> Options).
I put bbPress inside wp/ like the general consensus here recommends, and the syncing works very well. Cookies work fine etc. I’m very pleased with this. I didn’t want to have problems with syncing, so I didn’t do the parallel method.
WordPress:
http://appleswitcher.com
bbPress:
http://appleswitcher.com/wp/forum
bbPress, ideally:
http://appleswitcher.com/forum
I am on the same boat here. Actually I didn’t upgrade to 0.8.3 because of Forum Restriction breaking. I already have some sections of the forum pupulated, which need to be hidden from the general user, so upgrading is just not plausible for me right now. I am using it in conjunction with Private Forums plugin (which feels much better to me). If that plugin could be integrated with Roles it would be the best solution by far.
I am at a dead end for now. I can’t upgrade WordPress to 2.3 because bbPress breaks, and I can’t upgrade bbPress because I would be opening some important forums to everyone.
I was having problems in deleting post that are posted other user. I’ll get the “you do not have permission” error when trying to delete the post on Firefox, Safari. While on IE 6 , IE 7 I can delete the post but when I refresh the post comes back.
After a couple of hours trying to figure out what’s wrong I finally found the culprit . It was the WordPress Integration Plugin (0.7). Just a little heads up for you guys if you having problems to delete post on your forum.
Andy
If your WP installation is at http://www.domain.com/wp/ then if you install the forum at http://www.domain.com/forum/ they are parallel. The bbPress installation would not be in a subfolder of WordPress.
Does WordPress come up at http://www.domain.com or http://www.domain.com/wp/ ?
There is probably a way to do it with mod_rewrite on apache, but I’m not sure I understand the question.
I’ve looked through the (two) plugins that allows us to restrict forums, and sadly, it seems your guesses are correct. The first one which allows you to allow users in to a forum based on member names is hardly compatible with the latest version of bbPress (and seems dead). I almost got it working right, except for the fact that it messed up my forum hierarchy, and some other bugs, which meant that threads couldn’t be posted to a certain forum without being in that forum, which was enough for me to rule it out.
The other option, private forum as you tried out yourself, doesn’t allow us to do anything but restrict it to either members, mods or admins, which is the most viable solution to me at this point. It does mean however that I will need to give all my members who need access to the restricted forum moderator capabilities. Hardly ideal, but I’ll have to go with it for now.
I’ll be looking at it this weekend though, and hopefully I can find a sort of solution to it. Right now I’m thinking of finding a way to strip moderators of actual moderating powers, but I really don’t know. Adding another usergroup (pretty simple) should work too, but it has to be reflected in the plugin as well, but I don’t have the coding skills (I don’t have any coding skills) to do that.
Hopefully a gifted plugin developer will step in and solve this for us
Hi JRussell,
Although, I don’t use WordPress and bbPress in the same time. But I think if you can provide web server logs like error.log from your hosting service provider. We will have more clues.
I’m going crazy trying to get this to work.
I tried
http://wordpress.org/extend/plugins/comment-quicktags/
AND
http://www.40annibuttati.it/comment-quicktags-for-bbpress/
that.
STILL no quicktags. I activate them, de-activate them, re-upload them. Everything I can think of I do.
Help!