[qlister]

I’m using WordPress 2.6 and I was trying to install bbPress 0.9.0.2 and integrate it and it came up with this error at the end of the installation:

“Duplicate key name ‘user_nicename’

>>> User tables will already exist when performing a database integrated installation.”

My forum got installed, however when I try to click on the topics or the forums or tag, it doesn’t open anything, I can’t get to read any of those. It just stays on the same page.

The only function I am able to use is the add topic, but I can’t get to read anything I click.

What should I do? Any advice is greatly appreciated

[fandangoflip]

I’m working on a site for creatives (photographers, models, make up artists, film makers) to develop their craft and offer advice to those considering entrting an educational route, setting up a business or freelancing.

Its still under heavy development and most of the content is yet to be uploaded, but I’d love to hear any feedback or suggestions to make the site better… Particularly the wordpress & bbpress funtions as I’m hoping the community aspect to be rather strong.

http://www.creativelittlesoul.com

[chrishajer]

As far as I know, there is no plugin like that for bbPress. WordPress allows you to post by email, and even if updates were sent out via an RSS to Email solution, the person receiving that wouldn’t be able to reply and have that posted to the blog.

Sounds like a better application for a mailing list, not a forum.

Or, does Basecamp do all that already?

[eschen]

Something I could not find in this or any other thread concerning integration of 0.9.0.2 with wp 2.5. Problem is that a login to either bbPress or WordPress will log a user OUT of the other, can not be logged into both at same time. Common problem but different question. Several people have suggested adding the following to the bb-config.php:

$bb->usercookie = ‘wordpressuser’;

$bb->passcookie = ‘wordpresspass’;

Questions: are these really needed, should the full hash number (wordpressuser_full.hash.number) also be included and if so, where do I find the hash code? Using Firefox, the I see two cookies when logged into either bb or wp:

wordpress_test_cookie

wordpress_cabxxxxxxxxxxxx

The Secret keys are identical for both bb and wp config files. Also I have:

In bb-config file:

$bb->wp_table_prefix = ‘wp_’;

$bb->user_bbdb_name = ‘xxxxxxxxxx’;

$bb->user_bbdb_user = ‘xxxxxxxxxx’;

$bb->user_bbdb_password = ‘xxxxxxx’;

$bb->user_bbdb_host = ‘xxxxxxxxxxx’;

$bb->custom_user_table = ‘wp_users’;

$bb->custom_user_meta_table = ‘wp_usermeta’;

$bb->authcookie = ‘wordpress_cabxxxxxxx’; //identical to what is shown in Firefox cookie

$bb->cookiedomain = ‘.alleventsadviser.com’;

define(‘COOKIE_DOMAIN’, ‘.alleventsadviser.com’);

$bb->cookiepath = ‘/’;

define(‘COOKIEPATH’, ‘/’);

$bb->sitecookiepath = ‘/’;

In wp-config:

$table_prefix = ‘wp_’;

$wp->cookiedomain = ‘.alleventsadviser.com’;

define(‘COOKIE_DOMAIN’, ‘.alleventsadviser.com’);

$wp->cookiepath = ‘/’;

define(‘COOKIEPATH’, ‘/’);

$wp->sitecookiepath = ‘/’;

define(‘SITECOOKIEPATH’, ‘/’);

A registered user is shown in both bb and wp.

Thanks for any help.

[gogoplata]

Another option which I have had success with is to use bbPress 0.9 with WPMU 2.6.2 but only integrate the users, not the cookies. Users will need to login separately to the forums but their same login/password combination will work on WPMU and bbPress.

Hope that helps.

[iuxc]

I’m attempting to upgrade a website I run for a group to both WordPress and BBPress. I have integrated the two and the user accounts are in sync. Everything is working fine, except…

When a user logs in from the WordPress index page, it doesn’t log them in for BBPress. This is a problem, because I want to have administration links for accounts on the homepage of my website. I want a user to login and be able to click on ‘Settings’ and go to their BBPress settings page. Also, I want them to be able to click on “Messages” and go to their BBPress messages.

So, my question is – when a user logs in to the WordPress homepage, how can I make sure they are logged into the BBPress forums as well, without requiring them to log in a second time when they go to the forums?

Thanks for your help!

[chrishajer]

You are the only one who can resolve this, unless you have local help or remote help you trust to look at the connection details provided by your host, and you config, to find the problem.

If there’s a failure to connect, maybe the host setting is incorrect? What are the settings in your WordPress config? If you’re using the same database, then the settings here will be the same, other than the table prefix, which comes later. That should be unique inside your database.

[Sam Bauers]

I’m not exactly sure what you mean. There comes a point where we can’t reduce query count any further without resorting to complex joins, and to allow ourselves flexibility we need to avoid those. Caching solutions prefer simple queries and 1.0 has much better caching capabilities thanks to the use of the object cache functions in BackPress.

Also take a look at the WordPress memcached plugin, which is a drop-in replacement for the BackPress object cache functions and class, which hooks into a memcache server.

MySQL query caching should alleviate most speed problems though.

[farleys-bow-tie]

I created a database with full privileges and a user on the host and then entered it into the script. I received a message saying there was a failure to connect to the database.

The user name and password fields were populated with the admin login and pass from my WordPress installation. I used that login and name to create a user for the database, and then I re-ran the script with the default entries. Still can’t connect.

Any help would be appreciated.

[chrishajer]

I think you could do something like this:

https://bbpress.org/forums/topic/wordpress-bbpress-register-plusgtgtgtgt

There are two different solutions there.

To redirect the member back where they came from after they’re done, you could do this:

https://bbpress.org/forums/topic/heres-a-trick-to-redirect-user-back-to-topic-after-login#post-14268

[finigan]

Hi,

I’ve successfully integrated WordPress 2.5.1 with bbPress 0.9.2, but I’ve encountered some issues with registering (display_name, multiple sign-ups with same email, etc.).

What I’m trying to do now is redirect all registration to the WordPress register page. My main questions are:

(1) how/where do I change the bbPress code to point to the WordPress register page.

(2) is there a way for the system to know where a user came from (forums or blog) and redirect the user appropriately after sign-up?

Thanks.

[Clicknathan]

Hello,

I’ve recently set up a BBPress forum for non-profit Bike Pittsburgh and their host, Pair Networks, shut down their database because of the load BBPress was putting on the server. Pair has since reinstated the db, but I was wondering if anyone could offer any insight as to how I might trim down the size of the queries that BBPress is putting through. A little background:

1. I used this method to convert a WordPress XDForum into BBPress. I know the author of that post mentions that the method he uses might not be the most efficient, however at this point (after the conversion), I wouldn’t think that BBPress is using any of this info any more, correct?
2. We’re running BBPress v. 0.9.0.2
3. We’re using the following plugins: Akismet, Use Display Name, BBPress Private Messaging, Post Count Plus, Forum Last Poster, and Images Allowed

The information from the host was this:

With that said, we wanted to provide a follow up in terms of the nature of the problem itself. The problem is that the database is running some very inefficient queries, trying to sort through 2.5 million rows and are returning very few to no results. These queries take a long time to run and are called “slow queries”. As you gain in traffic, the more of these slow queries that are run, the higher the load on the server, and therefore the more affect you have on other customers.

I’ve included some examples of these queries below for your review:

# Time: 080930 20:55:01

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 54 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 20:56:05

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 71 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 20:56:43

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 67 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 20:57:38

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 52 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 21:20:46

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 263 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 21:22:35

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 281 Lock_time: 0 Rows_sent: 0 Rows_examined: 1952752

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

As you can see, these queries are taking almost 300 seconds to complete

(query_time). This is an extremely high time, as a query on a shared server

should take under 10 seconds to complete.

I hope this helps provide some needed details for you. If we can be of any

further assistance, please do not hesitate to ask.

Any help as to what I might do in PHPMyAdmin or otherwise to help lower the load on the db would be VERY MUCH appreciated!

[beernews]

I believe this glitch occurs on fresh/re-installs? of the current stable version.

Rather than clear cookies and sign into EVERY site again (I go on like 20-30 sites, what a nightmare).

Use the search function when you’re in the cookie list and type in, “wordpress_bb”

You will see a list of them. Notice below the list there is info for each cookie. See where it says path? The cookie you need to remove will say ‘bb-admin’ somewhere in the path. Remove it. Click the admin link and you should be good to go.

I logged out and logged in and looked at a few pages and can still access admin. Havent closed the browser yet so we’ll see if this holds.

[Olaf Lederer]

A syntax highlighter in wordpress/bbpress is always a hard to do.

Geshi and tinyMCE = forget it

I have finally a parser in WP but need to work in code view only.

[chrishajer]

Regarding permalinks, you will find lots of people expressing some problem with permalinks on GoDaddy. Just check the tag for other discussions.

That .htaccess would not work for the forum directory. That just looks like the WordPress rewrite rules changed slightly for your forum directory. You need to follow these directions:

https://bbpress.org/documentation/faq/#pretty-permalinks

[chrishajer]

Norvu, those version are incompatible. You don’t integrate the cookies. If you want integrated logins, you need to use bbPress 0.9.* with WordPress 2.5 or bbPress Alpha with WordPress 2.6.

https://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101#post-17409

[norvu]

WordPress version 2.6.2 and bbPress version 0.9.0.2

[chrishajer]

Norvu – what versions of bbPress and WordPress are you using?

[kchealy]

I am hosting a site with bluehost. I installed bbpress with simplescripts. Although the installation seems to have gone correctly, I cannot log in. Every time I try, I’m just taken back to the log in page with no error message.

This is a standalone install – I have not attempted to integrate it with my wordpress install.

[keress]

You were right about the templates. I used Dreamhost’s webftp client to move my wordpress site. It tells you to create the folder first. I took that to mean the main folders, and didn’t create all the many subfolders. I’m assuming that had something to do with why our template folder was not quite there. I could see it in webftp, but my ftpclient on my computer wasn’t showing it. Once I’d ftp’d all the files back, the site reappeared.

Dreamhost is saying that can’t happen, but that’s what I experienced.

Thanks for the help.

[blankpoint]

I was thinking this might have something to do with the fact that when I log in through the WP admin, I do not have access to the bbpress admin interface (though I show up as logged in as admin there, and can do admin functions that are on the forum pages etc). I need to login through bbpress to be able to access the bbpress admin. But this DOES allow me access to the WP admin too (as it should).

[blankpoint]

I have a WordPress 2.6.2 installation (xxxxxxx.com) sharing a user tables with bbPress 1.0 Alpha (xxxxxxx.com/forum). There are two separate databases, and bbPress uses the user tables from the WP database. The installations are integrated, but something strange is happening.

If I try to integrate WordPress into bbpress (I need to for everything I am doing), using the following call at the beginning of bb-config.php:

require_once(‘/homepages/15/d202815449/htdocs/wordpress/wp-blog-header.php’);

then my keymaster accounts immediately become admin accounts (and lose the admin tabs of “design”, “settings”, and so on in the admin interface). They show up as admins instead of keymasters on the user page in bb-admin. As soon as I take the call to wp-blog-header.php out again, the accounts go back to keymaster status. Any idea why this could be happening?

[norvu]

So how does one integrate the cookies?

[chrishajer]

WordPress 2.6.* is not compatible with bbPress 0.9.0.2. The alpha bbPress release is cookie-compatible with WordPress 2.6.* and the 1.0 release will be compatible as well.

The solution is to use compatible versions of the software.

https://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101

[enrige]

Hello, I read the forums but I have not found a solution.

My wp-config.php is:

<?php

/* Don’t try to create this file by hand. Read the README.txt and run the installer. */

// ** MySQL settings ** //

define(‘DB_NAME’, ‘sito’); // The name of the database

define(‘DB_USER’, ‘root’); // Your MySQL username

define(‘DB_PASSWORD’, ”); // …and password

define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

define(‘DB_CHARSET’, ‘utf8’);

define(‘DB_COLLATE’, ”);

define(‘VHOST’, ‘no’);

$base = ‘/sito/’;

define(‘COOKIE_DOMAIN’, ”);

define(‘COOKIEPATH’, ‘/sito/’);

// Change each KEY to a different unique phrase. You won’t have to remember the phrases later,

// so make them long and complicated. You can visit http://api.wordpress.org/secret-key/1.1/

// to get keys generated for you, or just make something up. Each key should have a different phrase.

define(‘AUTH_KEY’, ‘3e4e2e456cd44f52600ea4e614e94a8acfa4c97995f339d818eb02dea01b1c05’); // Change this to a unique phrase.

define(‘SECURE_AUTH_KEY’, ‘355918119ed39b28e890f2da0419d51284517d99b701cb2d7be09d9bf7943bda’); // Change this to a unique phrase.

define(‘SECURE_AUTH_SALT’, ’46ee307c3c9059000a578808454e176be6d185443fc8c9f8dcb3f95d2e4fc08b’); // Change this to a unique phrase.

define(‘LOGGED_IN_KEY’, ‘f5a5bc795a85bdcb7511ad0f1fd849c2e50aab8b413505f62a7188f6f215cddd’); // Change this to a unique phrase.

define(‘SECRET_KEY’, ‘313aa0bc3b2494acc5aef9ffacd3f34e205f2f4af13ef31d8249ab0a9a5d2c7b’); // Change these to unique phrases.

define(‘SECRET_SALT’, ’18a040b3d856fe9c91b03a63cbdfc4ad60360e9eb46532d8df5d016013283faa’);

define(‘LOGGED_IN_SALT’, ‘6f4751395b14e1a2e3ef6ea948afa8815f35053466d1378ee5f885d878c06235’);

// double check $base

if( $base == ‘BASE’ )

die( ‘Problem in wp-config.php – $base is set to BASE when it should be the path like “/” or “/blogs/”! Please fix it!’ );

// You can have multiple installations in one database if you give each a unique prefix

$table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!

// Change this to localize WordPress. A corresponding MO file for the

// chosen language must be installed to wp-content/languages.

// For example, install de.mo to wp-content/languages and set WPLANG to ‘de’

// to enable German language support.

define (‘WPLANG’, ”);

// uncomment this to enable wp-content/sunrise.php support

//define( ‘SUNRISE’, ‘on’ );

// Uncomment and set this to a URL to redirect if a blog does not exist or is a 404 on the main blog. (Useful if signup is disabled)

// For example, browser will redirect to http://examples.com/ for the following: define( ‘NOBLOGREDIRECT’, ‘http://example.com/&#8217; );

// define( ‘NOBLOGREDIRECT’, ” );

define( “WP_USE_MULTIPLE_DB”, false );

/* That’s all, stop editing! Happy blogging. */

if ( !defined(‘ABSPATH’) )

define(‘ABSPATH’, dirname(__FILE__) . ‘/’);

require_once(ABSPATH . ‘wp-settings.php’);

?>

My bb-config.php is:

<?php

// ** MySQL settings ** //

define(‘BBDB_NAME’, ‘sito’); // The name of the database

define(‘BBDB_USER’, ‘root’); // Your MySQL username

define(‘BBDB_PASSWORD’, ”); // …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 bb-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 BB_SECRET_KEY to a unique phrase. You won’t have to remember it later,

// so make it long and complicated. You can visit https://www.grc.com/passwords.htm

// to get a phrase generated for you, or just make something up.

// If you are integrating logins with WordPress, you will need to match the value

// of the “SECRET_KEY” in the WordPress file wp-config.php

define(‘BB_SECRET_KEY’, ‘313aa0bc3b2494acc5aef9ffacd3f34e205f2f4af13ef31d8249ab0a9a5d2c7b’); // Change this to a unique phrase.

define(‘BB_AUTH_KEY’, ‘3e4e2e456cd44f52600ea4e614e94a8acfa4c97995f339d818eb02dea01b1c05’); // Change this to a unique phrase.

define(‘BB_SECURE_AUTH_KEY’, ‘355918119ed39b28e890f2da0419d51284517d99b701cb2d7be09d9bf7943bda’); // Change this to a unique phrase.

define(‘BB_LOGGED_IN_KEY’, ‘f5a5bc795a85bdcb7511ad0f1fd849c2e50aab8b413505f62a7188f6f215cddd’); // Change this to a unique phrase.

// If you are running multiple bbPress installations in a single database,

// you will probably want to change this.

$bb_table_prefix = ‘bb_’; // Only letters, numbers and underscores please!

// 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 BB_LANG to ‘de’

// to enable German language support.

define(‘BB_LANG’, ”);

/* Stop editing */

if ( !defined(‘BB_PATH’) )

define(‘BB_PATH’, dirname(__FILE__) . ‘/’ );

require_once( BB_PATH . ‘bb-settings.php’ );

?>

Why if I access at bbpress (login) I don’t access at WordPress MU?

This is a problem of “cookie”, ok… but you can fix it?

Is there a new plugin?

Will be solved by bbpress 1.0?

Thank you