[spencerp]

IMHO, the best thing to do first is, make sure you’ve imported the phpBB stuff, into a fresh bbpress install, that doesn’t have the integration with WordPress.. then, integrate it with WordPress..

As is now, *some* people are still having problems with the bbpress+wordpress integratation deal.. again, IMHO.. I would just play it safe, by doing the phpBB (import) to a normal bbpress install first.. then go from there.. ?

Trent, what do you think?

spencerp

[rablake]

I’ve got my bbpress install (just a simple thing to test with) integrated into my WordPress database. I’d like to be able to import selectively for testing but no screw everything up — is that possible? I note that the script calls for importing into a FRESH NEW bbpress install.

[peiqinglong]

Does this help any? http://www.bui4ever.com/web-itecture/how_to_integrate_wordpress_and_bbpress/

[Trent Adams]

You want all the tags the same size? That is what the second code you have means. I guess it doesn’t like having tags all the same size. For reference, check out:

https://bbpress.org/forums/topic/67?replies=5#post-295

Trent

[Trent Adams]

Ok…I fixed the other errors (still waiting for Ardenfrost to see if they will work or if there is a better way), but I can’t get rid of the following error when I post or reply:

bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '19:54:11' at line 1]

SELECT * FROM bb_privatemessages WHERE id_sender = 14 AND created_on = 2006-12-09 19:54:11

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/forum/bb-includes/db.php:147) in /var/www/html/forum/bb-includes/pluggable.php on line 160

The error is generated from the following code in the plugin itself:

function pm_new_message( $id_receiver, $id_sender, $pmtitle, $message ){

global $bbdb, $bb_table_prefix;

$created_on = bb_current_time('mysql');

$bbdb->query("INSERT INTO ".$bb_table_prefix."privatemessages

(id_sender, id_receiver, pmtitle, message, created_on)

VALUES

('$id_sender', '$id_receiver', '$pmtitle', '$message','$created_on')");

$rmess = $bbdb->get_row("SELECT * FROM ".$bb_table_prefix."privatemessages WHERE id_sender = $id_sender AND created_on = $created_on");

return $rmess->pm_id;

}

I would ask anyone that might have an idea for me here to let me know. It doesn’t have a problem with the bb_current_time for posting normally, so I can’t understand why it doesn’t like the timestamp on this one. I have mySQL 4.1.21.

Anyone?

[marky]

Brilliant; thanks so much, jaim3!

[spencerp]

UPDATE: I’m getting the same errors as Trent had mentioned above sigh. The “solution” you posted above, didn’t seem to correct anything, but.. I could have done it wrong though..

If you want too, maybe join my board, and check em out..

http://spencerp.net/forums/

Also, when in a thread, and clicking the “PM This User” link, it spits out this database error message “

bbPress database error: [Table ‘mydatabase_name.bb_users’ doesn’t exist]

SELECT * FROM bb_users WHERE ID = 1

Any thoughts on this.. by the way, my board is basically setup like Trent’s board..

spencerp

[Anonymous User 133554]

Have a look at this: https://bbpress.org/forums/topic/402

[Trent Adams]

So far……

I noticed that there are some places where bb_users are called and for some of us that use wp_users, we will get some errors. I found this in message.php so far.

When I sent my first message, I got this error:

bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '23:45:07' at line 1]

SELECT * FROM bb_privatemessages WHERE id_sender = 14 AND created_on = 2006-12-08 23:45:07

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/forum/bb-includes/db.php:147) in /var/www/html/forum/bb-includes/pluggable.php on line 160

I found an error in /my-templates/postmsg.php on line 8:

Parse error: parse error, unexpected T_OBJECT_OPERATOR, expecting ',' or ';' in /var/www/html/forum/my-templates/postmsg.php on line 8

Still working on those right now……

Trent

[spencerp]

Nice job! This is awesome, thank you so much for sharing this, with everyone..

spencerp

[ardentfrost]

nice dude, when I first made the move, I looked at how different the db’s were and said “meh, screw it.” I got the users over easily, but very good job on dealing with topics and posts!

[Anonymous User 133554]

Hi,

I enhaced the excellent Bruno Torres’ script and made it able to import bbCode, as well as to cleanly import topics marked as closed, sticky and announcements, as well as some other improvements and bugfixing.

Have a look at this: https://bbpress.org/forums/topic/402

[Anonymous User 133554]

Hi!

I switched my site’s phpBB forum to bbPress, and I’ve released the script I used for this purpose under the terms of the GPL.

It’s largely based on the excellent starting point from Bruno Torres, to which I added some new features — like bbCode conversion with clean XHTML 1.1 compliant output, smily to text transcription, and the ability to import topics marked as closed, sticky and announcements as such.

I made also some little bugfixing, and the resulting script was able to cleanly import almost everything valuable from my old phpBB database.

You can have a look here if interested: http://www.iteisa.com/phpbb2bbpress/

Hope it helps to spread bbPress and web standards all around!

[thomasklaiber]

Ah … sorry for that wrong link -.-“

Trent … i have no idea at the moment. did this plugin work anytime before? … which version of bbpress are you using? …

[Trent Adams]

Ok….try this as it must be in main .htaccess and not seperate.

get rid of the .htaccess in bbpress directory and try this in .htaccess for wordpress.

# BEGIN WordPress

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /index.php [L]

# END WordPress

RewriteBase /bbpress/

RewriteRule ^forum/([0-9]+)/page/([0-9]+)$ /bbpress/forum.php?id=$1&page=$2 [L,QSA]

RewriteRule ^forum/([0-9]+)$ /bbpress/forum.php?id=$1 [L,QSA]

RewriteRule ^topic/([0-9]+)/page/([0-9]+)$ /bbpress/topic.php?id=$1&page=$2 [L,QSA]

RewriteRule ^topic/([0-9]+)$ /bbpress/topic.php?id=$1 [L,QSA]

RewriteRule ^tags/(.+)/page/([0-9]+)$ /bbpress/tags.php?tag=$1&page=$2 [L,QSA]

RewriteRule ^tags/(.+)/?$ /bbpress/tags.php?tag=$1 [L,QSA]

RewriteRule ^tags/?$ /bbpress/tags.php [L,QSA]

RewriteRule ^profile/([0-9]+)/page/([0-9]+)$ /bbpress/profile.php?id=$1&page=$2 [L,QSA]

RewriteRule ^profile/([0-9]+)/([a-z]+)$ /bbpress/profile.php?id=$1&tab=$2 [L,QSA]

RewriteRule ^profile/([0-9]+)/([a-z]+)/page/([0-9]+)$ /bbpress/profile.php?id=$1&tab=$2&page=$3 [L,QSA]

RewriteRule ^profile/([0-9]+)$ /bbpress/profile.php?id=$1 [L,QSA]

RewriteRule ^view/([a-z-]+)/page/([0-9]+)$ /bbpress/view.php?view=$1&page=$2 [L,QSA]

RewriteRule ^view/([a-z-]+)$ /bbpress/view.php?view=$1 [L,QSA]

RewriteRule ^rss/$ /bbpress/rss.php [L,QSA]

RewriteRule ^rss/forum/([0-9]+)$ /bbpress/rss.php?forum=$1 [L,QSA]

RewriteRule ^rss/topic/([0-9]+)$ /bbpress/rss.php?topic=$1 [L,QSA]

RewriteRule ^rss/tags/([a-z]+)$ /bbpress/rss.php?tag=$1 [L,QSA]

RewriteRule ^rss/profile/([0-9]+)$ /bbpress/rss.php?profile=$1 [L,QSA]

</IfModule>

Trent

[spudnutsncoffee]

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /bbpress/

RewriteRule ^forum/([0-9]+)/page/([0-9]+)$ /bbpress/forum.php?id=$1&page=$2 [L,QSA]

RewriteRule ^forum/([0-9]+)$ /bbpress/forum.php?id=$1 [L,QSA]

RewriteRule ^topic/([0-9]+)/page/([0-9]+)$ /bbpress/topic.php?id=$1&page=$2 [L,QSA]

RewriteRule ^topic/([0-9]+)$ /bbpress/topic.php?id=$1 [L,QSA]

RewriteRule ^tags/(.+)/page/([0-9]+)$ /bbpress/tags.php?tag=$1&page=$2 [L,QSA]

RewriteRule ^tags/(.+)/?$ /bbpress/tags.php?tag=$1 [L,QSA]

RewriteRule ^tags/?$ /bbpress/tags.php [L,QSA]

RewriteRule ^profile/([0-9]+)/page/([0-9]+)$ /bbpress/profile.php?id=$1&page=$2 [L,QSA]

RewriteRule ^profile/([0-9]+)/([a-z]+)$ /bbpress/profile.php?id=$1&tab=$2 [L,QSA]

RewriteRule ^profile/([0-9]+)/([a-z]+)/page/([0-9]+)$ /bbpress/profile.php?id=$1&tab=$2&page=$3 [L,QSA]

RewriteRule ^profile/([0-9]+)$ /bbpress/profile.php?id=$1 [L,QSA]

RewriteRule ^view/([a-z-]+)/page/([0-9]+)$ /bbpress/view.php?view=$1&page=$2 [L,QSA]

RewriteRule ^view/([a-z-]+)$ /bbpress/view.php?view=$1 [L,QSA]

RewriteRule ^rss/$ /bbpress/rss.php [L,QSA]

RewriteRule ^rss/forum/([0-9]+)$ /bbpress/rss.php?forum=$1 [L,QSA]

RewriteRule ^rss/topic/([0-9]+)$ /bbpress/rss.php?topic=$1 [L,QSA]

RewriteRule ^rss/tags/([a-z]+)$ /bbpress/rss.php?tag=$1 [L,QSA]

RewriteRule ^rss/profile/([0-9]+)$ /bbpress/rss.php?profile=$1 [L,QSA]

</IfModule>

OK the above code is what I placed in HTACCESS, and I did as you suggested by uploading this file to my bbpress folder.

I then logged back into my site and I am still getting the 404 errors

Here is the actual error:

The page you tried to access does not exist on this server. This page may not exist due to the following reasons:

You are the owner of this web site and you have not uploaded (or incorrectly uploaded) your web site. For information on uploading your web site using FTP client software or web design software, click here for FTP Upload Information.

The URL that you have entered in your browser is incorrect. Please re-enter the URL and try again.

The Link that you clicked on incorrectly points to this page. Please contact the owner of this web site to inform them of this situation.

[pilkster]

Trent,

I changes the cookie domain as you recommended removing the period, then deactivated the plugin, deleted it from the server, refreshed my plugins page to ensure that it had gone, uploaded it again, activated it and set the bb_ prefix.

I’m still not having any luck with registering on either one & the account carrying to the other. Did you register both on WP and bb? because I can log into either with my admin username and the cookie carries as you say. I cannot, however, log out whilst on the bbPress dashboard.

Yours confusedly, Simon (or pilks, sorry for switching names halfway through a thread)

[Trent Adams]

Simon,

I would change the cookie domain to be just awspress.com (without the period before it).

That should get the logout link on bbPress working better. I was not able to login as TrentAdams and come back to WP with an account created in bbPress, but when I created an account Trent with WP and then went back to bbPress, the user worked and so did the integration. It didn’t matter which program I logged in Trent with, it worked going back and forth.

That seems to me that the wordpress-integration plugin in bbPress is working and the bbpress-integration plugin in WP is not. I would uninstall that plugin and reinstall it after updating the cookie information in the config.php file for bbPress.

Let me know how you make out and I can test it some more.

Trent

[pilkster]

I have the following tables in my bb_ database:

bb_forums

bb_posts

bb_tagged

bb_tags

bb_topicmeta

bb_topics

wp_usermeta

wp_users

wp_users has 8 users, none of which coincide with the 3 users in my wp_users table in wordpress.

I am using wp2.05.

I can now log in/out of bbpress with no problem, maybe I was seeing things before, sorry!

Cheers – Simon

[Trent Adams]

That link is the way that that it comes up. Just look at the URL of this post for instance. It seems to me that you have the .htaccess just in your main root of http://totalphysiqueonline.com right? You need the one for wordpress there and a completely seperate .htaccess file in the bbpress folder containing the bbpress part. Each system needs their own.

Try that.

Trent

[spudnutsncoffee]

I tried the mod rewrite and it did not work for me.

I have this in my htaccess

# BEGIN WordPress

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /index.php [L]

</IfModule>

# END WordPress

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /bbpress/

RewriteRule ^forum/([0-9]+)/page/([0-9]+)$ /bbpress/forum.php?id=$1&page=$2 [L,QSA]

RewriteRule ^forum/([0-9]+)$ /bbpress/forum.php?id=$1 [L,QSA]

RewriteRule ^topic/([0-9]+)/page/([0-9]+)$ /bbpress/topic.php?id=$1&page=$2 [L,QSA]

RewriteRule ^topic/([0-9]+)$ /bbpress/topic.php?id=$1 [L,QSA]

RewriteRule ^tags/(.+)/page/([0-9]+)$ /bbpress/tags.php?tag=$1&page=$2 [L,QSA]

RewriteRule ^tags/(.+)/?$ /bbpress/tags.php?tag=$1 [L,QSA]

RewriteRule ^tags/?$ /bbpress/tags.php [L,QSA]

RewriteRule ^profile/([0-9]+)/page/([0-9]+)$ /bbpress/profile.php?id=$1&page=$2 [L,QSA]

RewriteRule ^profile/([0-9]+)/([a-z]+)$ /bbpress/profile.php?id=$1&tab=$2 [L,QSA]

RewriteRule ^profile/([0-9]+)/([a-z]+)/page/([0-9]+)$ /bbpress/profile.php?id=$1&tab=$2&page=$3 [L,QSA]

RewriteRule ^profile/([0-9]+)$ /bbpress/profile.php?id=$1 [L,QSA]

RewriteRule ^view/([a-z-]+)/page/([0-9]+)$ /bbpress/view.php?view=$1&page=$2 [L,QSA]

RewriteRule ^view/([a-z-]+)$ /bbpress/view.php?view=$1 [L,QSA]

RewriteRule ^rss/$ /bbpress/rss.php [L,QSA]

RewriteRule ^rss/forum/([0-9]+)$ /bbpress/rss.php?forum=$1 [L,QSA]

RewriteRule ^rss/topic/([0-9]+)$ /bbpress/rss.php?topic=$1 [L,QSA]

RewriteRule ^rss/tags/([a-z]+)$ /bbpress/rss.php?tag=$1 [L,QSA]

RewriteRule ^rss/profile/([0-9]+)$ /bbpress/rss.php?profile=$1 [L,QSA]

</IfModule>

I still get 404 errors no matter what link I click in my blog.

Installed fine. Dashboard and all that stuff in place.

Can go to admin. and all the other places, I just cannot get links to work.

I know in my config file I made sure pretty links was enabled but it doesn’t look like it worked

Here is the default first post link

http://totalphysiqueonline.com/bbpress/topic/1?replies=1

Doesn’t look like a pretty link, does it?

[Trent Adams]

I have no trouble logging in and out of bbPress, just not integrated with the wp_users table. You are using Wp 2.05 as well?

Trent

[Trent Adams]

I would imagine that you need to check the database and see if bbpress has it’s own bb_users table or if it doesn’t exist. I created a user in bbPress and it didn’t move over to WP. That would mean that the cookies are not moving right and the plugin isn’t working. If it was working, WP would know that I exist. When I went to ‘forgot password’ in WP, the user didn’t even exist. That would mean that users are being created in bbPress.

I would check the database and see what tables exist for bbPress and report back.

Trent

[pilkster]

Hi Trent

I tried this, one additonal problem is that the logout function on the forums doesn’t work now, I have to log out from a WP page. Other than that, nothing has changed! Would it be easier if I were to delete the account from my server and try again, or do you enjoy the challenge?

<?php

// ** MySQL settings ** //

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

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

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

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

// Change the prefix if you want to have multiple forums in a single database.

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

$bb->cookiedomain = ‘.awspress.com’; // Thanks Trent! https://bbpress.org/forums/topic/12?replies=10

$bb->cookiepath = ‘/’; // Thanks Trent! https://bbpress.org/forums/topic/12?replies=10

// 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://awspress.com&#8217;; // Example: ‘http://bbpress.example.com&#8217;

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

$bb->path = ‘/forums/’; // Example: ‘/forums/’

// What are you going to call me?

$bb->name = ‘Amazon plugin for WordPress’;

// This must be set before running the install script.

$bb->admin_email = ”;

// Set to true if you want pretty permalinks.

$bb->mod_rewrite = true;

// 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 = ”;

// The rest is only useful if you are integrating bbPress with WordPress.

// If you’re not, just leave the rest as it is.

$bb->wp_table_prefix = ‘wp_’; // WordPress table prefix. Example: ‘wp_’;

$bb->wp_home = ‘http://awspress.com&#8217;; // WordPress – Options->General: Blog address (URL) // No trailing slash

$bb->wp_siteurl = ‘http://awspress.com&#8217;; // WordPress – Options->General: WordPress address (URL) // No trailing slash

/* Stop editing */

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

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

?>

[Trent Adams]

The plugins, especially bbpress-integration (goes in WP plugins and has option page once installed to choose bb_ as database prefix), tells bbPress to use the WordPress users. Therefore, if you login to each program (either/or), it uses the WP users. All registrations in bbPress make users in WP users. It is simple.

As for the login working in both, the settings in config.php in bbPress tells bbPress to use the WP cookies so they share the same one. Therefore, both programs know to use the same user without having to login again.

Trent