I believe that it was a problem with the way my host (GoDaddy) deals with .htaccess files. I was also having major issues with the same as this: https://bbpress.org/forums/topic/pretty-permalinks-not-working?replies=29#post-5247
All-in-all, I would say stay away from GoDaddy if you are trying to do a integrated wordpress/bbpress site. I have moved the site to another host and all issues have been resolved.
Maybe someone could port the “Live Comment Preview” plugin from wordpress to bbpress.
Too bad I don’t have the time at the moment
Hey Chris,
I had created a second bbpress database called bbpress2 to see if that was the problem, which it wasn’t. The error message is an older one. The one I’m getting now is in reference to bbpress, not bbpress2 like above. But everything else is the same:
bbPress database error: [Access denied for user 'disco'@'localhost' to database 'approachanxiety_com_bbpress']
SHOW TABLES;
bbPress database error: [Access denied for user 'disco'@'localhost' to database 'approachanxiety_com_bbpress']
CREATE TABLE bb_forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default '', forum_slug varchar(255) NOT NULL default '', forum_desc text NOT NULL, forum_parent int(10) NOT NULL default '0', forum_order int(10) NOT NULL default '0', topics bigint(20) NOT NULL default '0', posts bigint(20) NOT NULL default '0', PRIMARY KEY (forum_id) ) DEFAULT CHARACTER SET utf8
bbPress database error: [Access denied for user 'disco'@'localhost' to database 'approachanxiety_com_bbpress']
CREATE TABLE bb_posts
Question: can I use the same database as my WordPress database?
I may call my hosting provider to see if there is something wrong with the way mysql databases are set up. Perhaps I can connect but can’t create tables?
Thanks for all your work on this!
Eric
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
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!