[Trent Adams]

I managed to change around the mySQL queries a bit and got this plugin working with my site (except a few small things I can’t fix myself) and it seems to be fine for posting the WordPress posts in bbPress and placing a link. It wouldn’t be a problem if I didn’t have an old mySQL database!

[Trent Adams]

Not that you might even care, but some of the post above have sensitive information that maybe they want to ‘edit out’ so that it doesn’t turn into the wrong hands. I wouldn’t want my SQL database information on the net….

Trent

[Trent Adams]

Unless I am missing something, doesn’t it automatically work with Akismet without any additional files? All you need to do is edit your config.php file (already a section for akismet) and place in your API key. If I am missing something here, please someone tell me because I didn’t upload any additional files either…..

Trent

***Update****

I figured it out….Akismet is already in bb-includes right?

[Trent Adams]

I had this happen to me. I would imagine that the same thing is happening with you. What my problem was not with the actual integration because it even tells you that you are logged in, but that the ‘URL’ in the config.php file was wrong. I had to really look close at the directions. Using your URL from above I couldn’t make heads or tails because the link wouldn’t resolve, but it most likely is in the following section:

// If your bbPress URL is http://bbpress.example.com/forums/ , the examples would be correct.

// Adjust the domain and path to suit your actual URL.

// Just the domain name; no directories or path. There should be no trailing slash here.

$bb->domain = 'http://yourdirectory.yoursite.com'; // Example: 'http://bbpress.example.com'

// There should be both a leading and trailing slash here. '/' is fine if the site is in root.

$bb->path = '/forum/'; // Example: '/forums/'

Maybe check that out.

[Trent Adams]

It won’t say that if you have deleted the tables in the database. If you can drop the bbPress tables you will be OK to install the program again (only reason this is fresh is I had to do it about 4 times to get mine right)! ! !

[Trent Adams]

I have talked it over with the author of the plugin and we are trying to figure out some code for older mySQL databases. He wrote the plugin for mySQL over version 4 and I have 3.23.58. While the plugin works for me (with many errors) I just need to make a couple of changes to the mySQL statements in the plugin to get rid of the errors.

The plugin in question is located at:

http://dev.mbzeus.net/downloads/bbpress_post_en.zip

The first error I recieved was on the ‘admin page’:

WordPress database error: [You have an error in your SQL syntax near

'; ' at line 1]

SELECT forum_id,forum_name FROM bb_forums ;

The second errors were when I tried posting a topic in wordpress:

WordPress database error: [You have an error in your SQL syntax near

'; ' at line 1]

SELECT post_id FROM bb_posts WHERE forum_id=21 AND topic_id=242

AND poster_id=14 AND post_time = '2006-11-05 07:20:10' LIMIT 1;

WordPress database error: [You have an error in your SQL syntax near

'topic_posts=1 WHERE topic_id=242 LIMIT 1' at line 1]

UPDATE bb_topics SET topic_last_post_id=,topic_posts=1 WHERE

topic_id=242 LIMIT 1;

Warning: Cannot modify header information - headers already sent by

(output started at/www/html/wp-includes/wp-db.php:104) in

/www/html/wp-includes/pluggable-functions.php on line 269

If anyone could help me with this I would be greatly appreciated. I am sure it is just changing around the mySQL statements in their formatting, but I can’t seem to figure it out!