I have now installed wordpress2.3 at http://new.tnlotteryresults.com/ and bbpress 0.8.3 at http://talk.tnlotteryresults.com/ They are located in two physically separate directories using two different databases with no .htaccess in any parent directory. Matter of fact, all parent directories between root and each of the sites are empty. Pretty permalinks work on http://new.tnlotteryresults.com/ and fail on http://talk.tnlotteryresults.com/
I have edited the .htaccess with both methods shown in the installation instructions as well as making sure that I had ‘slugs’ in the config.php
Why does WordPress implement pretty permalinks so easily and bbpress is so resistant?
Using the currently available packaged release of bbPress has got to be frustrating a lot of people. Most people, I would guess, just want to download something and have it work, not deal with patches or trying to guess which revision is best suited (is it 980 or 971?) to their situation based on the WordPress version and whether or not they’re integrated.
At the very least, it should be a FAQ or sticky that explains how to do it, before the questions come…
Thanks for the correction Sam. Any thoughts on this post I made with regard to a new bbPress release to fix all these database issues people are having?
Revision [971] is the best option to integrate with WordPress 2.3.1 in my opinion.
Trunk will not be compatible with WordPress 2.3.1 again. Maybe not ever. It will be compatible with the upcoming WordPress 2.4 when that is released (or soon after).
As I’ve written elsewhere, I’ve gotten everything up and running with trunk. As it might not be compatible with the release of WordPress I’m using (2.3.1), I’m wondering when a release of bbPress that fixes these problems and is compatible with WP 2.3.1 (or with the then latest available release of WP) will be available?
Anyone ever figure a way to do this? As I’ve got lots of topics, I’d love for users to be able to click through pages going back in time, as you can in WordPress.
@chrishajer
I’m not sure that’s the right advice. The latest development versions will definitely break integration as they are geared towards integration with the current WordPress trunk. There are lots of differences in password hashing and cookie storage.
Revision [971] might be OK to use for this specific problem, but I can’t guarantee it. And it won’t fix socket connection under MySQLi.
I have kept reading this forums for about a month. I saw many similar processes of solving the same problem.
Not long ago, I asked Sam Bauers a question about bbpulp.org on IRC:
<livibetter> can we (users) expand it? like FAQ, troubleshooting, theme modifications?
<livibetter> there are many questions asked again and again on forums. If we can systematically organize a collection of these, then may be easily to give a solution for their questions.
<sambauers> Yeah, go ahead.
<sambauers> It is a wiki after all 
<sambauers> Although it was focused on being a developers resource.
<livibetter> Thanks! I will post a post for this, and hope many other user will do the same thing.
<sambauers> If you wanted to look at the actual bbPress.org documentation
<sambauers> you are welcome to suggest additions and edits of the pages there
<livibetter> I see
<sambauers> It makes more sense to compile FAQs there for instance
<sambauers> And installation/integration notes
<sambauers> Which will soon need updating anyway
<livibetter> means 0.8.4 coming soon?
<sambauers> Probably not until WordPress 2.4
If we can collect and organize these solutions well, we can be more easier to help. I did a small change on the main page, not really start to write something. I took a while to write those new entries, it’s harder than I can imagine. I can’t make them systematic. And that’s still not good, but collaboration can correct mistakes and build a great stuff.
So, Let’s collaborate!
It is fixed in the latest development version, I believe. There just hasn’t been a release that includes that functionality.
https://bbpress.org/forums/topic/db-access-problem-in-the-first-installation-step?replies=26#post-12711
The problem is; I’ve never explicitly told bbPress to connect via a local socket, and since I’m not a Unix expert, I didn’t really comprehend the error message. I now understand a bit more of what it says and that I should instruct bbPress to connect via TCP/IP instead. However, isn’t this something bbPress should have available as an option in the config.php file somehow? Or even just as an automatic switch it figures out based on whether BBDB_HOST is set (or is different from localhost) or not?
Yes, you surely can’t, cite from man mysql
· --socket=path, -S path
For connections to localhost, the Unix socket file to use, or, on
Windows, the name of the named pipe to use.
No remote IPC, if you can communicate via TCP/IP from remote, why use unix socket?
I don’t think you can connect to a remote MySQL server via unix socket. Please use TCP/IP.
And don’t forget to grant the user for connecting from remote IP.
You can have it now if you use trunk.
At the moment revision [980] is the most stable.
ZIP file is at the bottom of this page:
https://trac.bbpress.org/browser/trunk?rev=980
If you are integrating with WordPress at the moment I don’t recommend using trunk though.
> I suspect bbPress of having hard coded a connection to localhost and thus configuring define(‘BBDB_HOST’, ‘…’) to be something else than localhost doesn’t really matter.
That’s simply not the case.
Yeah, I guess it would work for now, we only have a few forums. But I’m reluctant to put that kind of thing into the templates, where it’s hard to update, and prone to typo problems, etc., if the conditional code gets accidentally mucked up.
Is there any way to add arbitrary meta attributes to things in bbPress, the way you can add them to posts in WordPress?
Check Step 2 of https://codex.wordpress.org/Installing_WordPress#Detailed_Instructions
It’s written for WordPress, but you can use it for installing bbPress.
It doesn’t look like you upgraded the installation properly. But your issue so far has nothing to do with bbPress. All those errors are from WordPress.
That looks to be a pretty common error:
http://www.google.com/search?hl=en&q=Table+*wp_terms+doesn%27t+exist
You could extract all the email addresses from the database with a tool like phpMyAdmin. I don’t know of a plugin that does this. If it’s a onetime thing, I would just grab the email addresses from the database with a query like:
SELECT DISTINCT user_email
FROM bb_users
ORDER BY user_email ASC
With all the email addresses, then just send out a mass email with your email client putting their email addresses in the BCC field.
Are you looking to do this regularly, and are you thinking this should be a plugin? I guess you’d need to know if the installation were integrated or not, then query the correct table, and also if it is an integrated installation, you’d need to separate out the bbPress registrations from the WordPress registrations.
Here are the errors I’m getting now.
WordPress database error: [Table ‘hk-wp.wp_terms’ doesn’t exist]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’) AND tr.object_id IN (0) ORDER BY t.name ASC
Warning: Cannot modify header information – headers already sent by (output started at /var/www/vhosts/hapikar.com/httpdocs/wp-includes/wp-db.php:160) in /var/www/vhosts/hapikar.com/httpdocs/wp-includes/pluggable.php on line 391
When using a socket, you need something like this:
https://bbpress.org/forums/topic/cannot-select-db-error?replies=11#post-12434
It’s OK to start a new topic as well. All these recent topics dredging up old problems that are sort of close make it hard to solve the latest problem, your problem. A lot of the earlier advice in this thread doesn’t apply to your specific problem.
Okay, here is another problem:
Ever since I’ve integrated WordPress as detailed above, I can’t access the bb-admin .. it’s just a blank page.. as soon as I remove WordPress integration, it’ll work again.
I have the same problem and overwriting db-mysqli.php with db.php didn’t help. Just for completeness, here’s the error messages I encounter:
Warning: mysql_get_server_info() [function.mysql-get-server-info]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/<snip>/bbpress/bb-includes/db-mysqli.php on line 73
I suspect bbPress of having hard coded a connection to localhost and thus configuring define('BBDB_HOST', '...') to be something else than localhost doesn’t really matter. I don’t have MySQL and Apache installed on the same physical server, so I have to access MySQL through a hostname and thus localhost won’t work.
It looks like you just installed WordPress based on the age of the blog posts. How did you end up with such an old version? Is that something the host installed for you?
