[chrishajer]

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

[Asbjørn Ulsberg]

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?

[livibetter]

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?

[livibetter]

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.

[Sam Bauers]

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.

[Sam Bauers]

> 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.

[alderete]

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?

[livibetter]

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.

[chrishajer]

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

[chrishajer]

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.

[livibetter]

Well I updated WP…

You probably need to ask in WordPress Support.

Here is a document: https://codex.wordpress.org/Upgrading_WordPress_Extended#Detailed_Upgrade_Instructions_for_1.5.x.2C_2.0.x.2C_2.1.x.2C_or_2.2.x_to_2.3.1

[hapikar]

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

[chrishajer]

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.

[ixray2]

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.

[Asbjørn Ulsberg]

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.

[chrishajer]

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?

[chrishajer]

You really, really, really need to upgrade your WordPress:

<meta name="generator" content="WordPress 1.5.1.2" />

Until then, I think it would be silly to try and fix any errors in your install.

Current WordPress version is 2.3.1: 1.5.1.2 was released 2.5 years ago and has security issues as well as limited functionality.

http://blog.taragana.com/index.php/archive/serious-security-vulnerabilities-of-wordpress-1512-and-below/

[hapikar]

hmmm, have no idea. just an amateur really hacking away. The problem is this install has caused my wordpress admin panel, under presentations/themes to show that error. Sorry was not being detailed enough in post.

[chrishajer]

Why is your bbPress calling a WordPress function?

wp-includes/functions.php

Is there more to your setup than it appears?

Actually, I just went to your forum and it is working?

[livibetter]

The workaround won’t work for plugins.

@sambauers: I think there is no complete working solution if you don’t touch the core files.

First, load_default_textdomain and load_plugin_textdomain are WordPress version, they only look language files in WordPress directories. So, in bbPress, all text won’t be translated since language file are not loaded because WordPress load_*_textdomain won’t find language files in bbPress’ directories.

Second, WordPress and bbPress both use default as textdomain when calling __() or _e() without assigning textdomain, that means we can only use either WordPress’ or bbPress’ language files at the same time, not both.

(edit: plugin’s problem can be solved by add a bb_load_plugin_textdomain, but bbPress’s part. If we don’t want to use something like bb__(), bb_e(), maybe we can try to merge bbPress translations into WordPress’ in runtime? or search bbPress’ first, then WordPress’ if can’t find)

[Sam Bauers]

streams.php and gettext.php are just libraries, so if they are loaded by WordPress, then they don’t need to be loaded again. Although “include_once” should take care of that.

The problem with the language file not loading is because of the next couple of lines. They say that if WordPress is loaded not to load the kses.php and l10n.php files. This means it is looking for yor language file for bbPress in the same place as the WordPress language file.

It’s possible (but I don’t know enough about how gettext works) that just dropping the bbPress mo file into the same place as the WordPress mo file will work… just call the bbPress mo file bbpress-de.mo or something like that.

I think someone solved this before… search a little harder through the forums I think.

[livibetter]

Seems you will use a lot of stuff from WordPress. If your WordPress template is already written in German, then you should have no problems. If not or some functions use gettext functions, then you will see many text in original language.

[livibetter]

This is a quick workaround:

if ( defined('BBLANG') && '' != constant('BBLANG') ) {

if ( function_exists('load_default_textdomain') ) :

global $l10n;



$locale = BBLANG;

$mofile = BBLANGDIR . "$locale.mo";



load_textdomain('default', $mofile);

else:

include_once(BBPATH . BBINC . 'streams.php');

include_once(BBPATH . BBINC . 'gettext.php');

endif;

}

if ( !( defined('DB_NAME') || defined('WP_BB') && WP_BB ) ) {  // Don't include these when WP is running.

require( BBPATH . BBINC . 'kses.php');

if ( !function_exists('load_default_textdomain') )

require( BBPATH . BBINC . 'l10n.php');

}

It should drops WordPress’ language file, and replaces with bbPress’. That means translations need to be done in WordPress won’t be translated since this code drops language file. This wont happen when you read your blog. However, I don’t have any language files, so this is coded by guessing.

This is not a solution, just a temporary fix. I will file a ticket.

[livibetter]

I think this needs to change bbPress core and even WordPress’.

What’s the WordPress function that you are planning to use?

[livibetter]

Then, you should trace in bbPress’ code to find out where causes an exit.

BTW, you can also test error_log(get_option('blogname')); to make sure WordPress loaded database correctly.

PS. debugging with no debugger is a crazy thing. You have to guess by experiences for best shot.