[berfarah]

Me too >.< I thought it was just me… heh

[dexter78]

Hello people, I use bbpress but I don`t know how can I use in posts backticks…

[scooter7978]

On thinking about it a bit further, I went back to my SQL posts and kludged a statement which removes 9.5 hours from the various date fields that populate the bbpress database.

On restoring everything back, it’s ok now.

[scooter7978]

I’ve been playing with bbPress for a few days and noticed that when I started posting the time was set all wrong and the posts I imported were dated wrong (only ones from that day).

Since I’m in South Australia (+9.5 GMT) I had set the gmt_offset option in the admin interface to 9.5 to accomodate my differences but it wouldn’t set the post date/time to my timezone when posting.

The only way around it was to modify the bb_current_time function and change this line:

$d = gmdate(‘Y-m-d H:i:s’);

to this:

$d = gmdate(‘Y-m-d H:i:s’, time() + 3600*(bb_get_option(‘gmt_offset’)+date(“I”)));

So that it actually uses the GMT offset.

Of course, doing this only means that current posts are displayed at the right time but previous ones are wrong because they’re all set to the current time when posted and the system then adds 9.5hrs onto them when being read.

I’m assuming either I’ve missed something in the config or the time option just isn’t using the gmt_offset value from the db for anything.

Can someone confirm or refute this please? I’d like to be able to change it back and do it the proper way if possible.

[gerikg]

I would like to put some plugins from bbpress into the WP widget.

For example: The Simple Online By Thomas Klaiber would be great on a widget.

If I put the code on WP widget it errors when on WP but comes up when on BB.

I guess I just need an if-then statement? but I don’t know how to write it.

[bobbyh]

affacat, are you talking about the stars that indicate the ratings of particular plugins, e.g. https://bbpress.org/plugins/topic/unread-posts/ ?

[scooter7978]

I’m using Vanilla on my forums and since I like to change things every now and then, I’m going to move to BBPress in the near future. Since I’m testing at the moment, I thought I’d hand over the SQL statements for grabbing the categories, topics and posts and formatting them as best as possible for bbpress.

SQL to get the categories:

SELECT CategoryID, Name, REPLACE( LCASE( Name ) , ‘ ‘, ‘-‘ ) AS Slug, Description, Priority

FROM LUM_Category

SQL to get the topics:

SELECT DiscussionID, Name, REPLACE( Name, ‘ ‘, ‘-‘ ) AS Slug, AuthUserID,

(SELECT LUM_User.Name FROM LUM_User WHERE UserID = AuthUserID) AS PosterName,

LastUserID, (SELECT LUM_User.Name FROM LUM_User WHERE UserID = LastUserID) AS LastPosterName,

DateCreated, DateLastActive, CategoryID, Closed, Active, (SELECT 0) AS LastPostID, Sticky, CountComments, (SELECT 0) AS TagCount

FROM LUM_Discussion

SQL to get the discussions:

SELECT CommentID, LUM_Discussion.CategoryID AS ForumID, LUM_Comment.DiscussionID, LUM_Comment.AuthUserID, Body, LUM_Comment.DateCreated, RemoteIp

FROM LUM_Comment

JOIN LUM_Category ON LUM_Discussion.CategoryID = LUM_Category.CategoryID

JOIN LUM_Discussion ON LUM_Discussion.DiscussionID = LUM_Comment.DiscussionID

ORDER BY CommentID, ForumID

SQL to get the tags:

SELECT TagID, REPLACE( Tag, ‘ ‘, ‘-‘ ) , Tag, (SELECT 0) FROM LUM_DiscussionTags

From there you will need to fix up the slugs in the bb_topics table and in the bb_forums so that the web browser doesn’t have a conniption when it tries to load a forum thread but you can do that with a series of select(replace) queries like this:

update bb_topics set topic_slug = replace(topic_slug,’?’,”);

update bb_topics set topic_slug = replace(topic_slug,’.’,”);

update bb_topics set topic_slug = replace(topic_slug,’/’,”);

update bb_topics set topic_slug = replace(topic_slug,’&’,’and’);

update bb_topics set topic_slug = replace(topic_slug,’"’,”);

update bb_topics set topic_slug = replace(topic_slug,’\’,”);

update bb_topics set topic_slug = replace(topic_slug,'”‘,”);

update bb_topics set topic_slug = replace(topic_slug,’!’,”);

update bb_topics set topic_slug = replace(topic_slug,’,’,”);

update bb_topics set topic_slug = replace(topic_slug,”’,”);

update bb_topics set topic_slug = replace(topic_slug,’#’,”);

There might be a better or quicker way of doing the last bit but since it works fine on mine I am not too concerned.

I had to kludge some results in the queries like; SELECT 0 or SELECT 1 to get the answers I wanted or to pad out the columns to fit properly into the bbpress SQL layout. In most cases its just count fields or an active or open flag which is nearly always 1 or 0 anyway.

Generally this is all you need to get started, from there you can just export this table data to a CSV or something and then import it into the requisite bbpress table. If you go into the admin interface of bbpress and get the system to recount everything it should be ok from there. I only recommend doing this if you’re familiar with the inner workings of MySQL, otherwise you could bollocks things up and then noone wins.

Please remember too that this is the basics, if you’ve integrated with wordpress you’ve still got some work ahead of you to coordinate your wordpress ID’s with your forum ones. It can be done as I managed to do it, it’s just painful.

Cheers,

Scott

[kernow]

Thanks, I have upgraded OK, though I have a login/logout integration problem now with WordPress and bbpress. I’ll ask someone I know with more technical expertise for advice.

[kernow]

I unfortunately have the same problem

[enquirer32]

OK! Thanks for your help. I re-checked everything and there was a different ‘secret’ – found by visiting wordpresssite/options.php. I keyed this into the admin section of bbpress. I don’t know if this was the only thing as I tweaked the config file of WordPress to have two lines defining the cookie domain (it had only one). Anyway we have blast off.

[enquirer32]

thanks. still does not work.

1. upgraded bbpress to .9.0.2

2. yes

3. not sure how i can check this?

4. think so. added sthg to bbpress config shall i do the same to wp config?

5. yes

[domercmh]

This checklist was gold. Thanks.

I’m actually using an older version of WordPress (integrating wordpress 2.3.1 + aMember + bbPress). aMember doesn’t yet work with wP2.5. Had to follow bbPress instructions for older installs of WP.

After that, and confirming against your checklist, everything worked.

[yazerty]

Wow, there isn’t any tool to move from phpbb3 to bbpress ? How bad it is .

I hope there will be soon )…

[Bloggsbe]

I’ve made a plugin that lets you set your own default gravatar.

You can also choose to use Identicons, Wavatar or monsterID as the default gravatar.

You set the size and the rating you want.

This plugin overrides the built in Gravatar function, but you still have to choose to show the avatars in the standard options page, but all other gravatar options from that page is ignored.

I’ve tested it on bbPress 0.9.0.2 and 1.0-dev (from trunk), but it should work on all 0.9.x versions.

You can download the plugin from here.

I’ve also submitted it to the plugins list here on bbpress.org, and will (hopefully) show up there to

—

RG

[Michael Adams (mdawaffe)]

http://svn.automattic.com/bbpress-i18n/pt_BR/

Done. You should be able to check in content with your username (joildo) and password.

[jethrokapinksy]

Ok, I just realized that what worked for me only applied to a ‘clean’ top-level install, and what people are having issues with is installing bbpress in example.com/forums/, because example.com’s .htaccess is over-riding example.com/forums/ ‘s .htaccess file.

So here’s my example.com (permalinks work great):

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /index.php [L]

</IfModule>

chmod: 644

And here’s my example.com/forums .htaccess content:

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /forum/

RewriteCond %{REQUEST_FILENAME} !-f

RewriteRule ^([^/]+)/(.*)?$ /forum/$1.php [PT,QSA]

</IfModule>

Any ideas?

Thanks

[Sam Bauers]

Here’s a checklist:

1. You are running latest versions of WordPress (2.5.1) and bbPress (0.9.0.2)
2. You have matched SECRET_KEY in wp-config.php with BB_SECRET_KEY in bb-config.php
3. You have matched WordPress “secret” database option with bbPress “secret” database setting
4. You have setup compatible cookie domains and paths in config files (see instructions in bbPress admin)
5. You are successfully sharing user tables from WordPress with bbPress

[rhodzr]

!!There was a problem connecting to the database you specified.

Please check the settings, then try again.

hi i’m new to this.. i wanted to install bbpress but after providing the database name and user i get this error.. (on top)

[harryworld]

I have successfully integrated TinyMCE to my editor in bbpress, which I found that is so easy.

However, when doing the submit, TinyMCE submits the HTML code on behind to bbpress. I found that each line TinyMCE created a <p>…</p> tags, but bbpress is not allowing this. Finally, <p></p> comes to the screen when viewing the post.

Is there any workaround for this?

[ashishmohta]

kernow: Its better we did. As BBpress and WordPress both have ability to auto generate config file we get the benefit of getting the latest modifications.

[richcon]

I updated my web site today to bbPress 0.9.0.2 and WordPress 2.5.1. Cookie integration settings got out of whack and I put them back, but now the two are in conflict.

I’ve verified (by clearing cookies and watching as new cookies are registered) that both bbPress and WordPress are using the same cookie for login info — same name, path, etc.

However, when logging into WordPress I am logged out of bbPress, and when logging into bbPress I am logged out of WordPress. So they appear to be using the same cookie and overwriting it as I login to each section.

Note that the SECRET_KEY and BB_SECRET_KEY definitions in each respective config files are identical.

The cookie seems to be broken up into three parts: user name, a shortish numerical code (in decimal), and a long hexadecimal code. The name and shortish numerical code are identical between bbPress and WordPress but the long hex code changes every time. Does this help provide a clue?

[bobbyh]

It would depend on how often the RSS feed is cached by the WordPress plugin.

Good luck!

[mrhoratio]

Hey bobby, thanks for the links to RSS aggregator plugin. The only problem I see is synchronizing the feed. For example, if you edit the post in bbPress, will it automatically update it in the WordPress loop also? Or will you have to manuallly edit it in WordPress also. I will have to investigate and see.

[bobbyh]

That would work. A quick Google search found this under #3:

* http://www.makeuseof.com/tag/top-20-wordpress-plugins-for-power-users/

The download is here:

* http://www.makeuseof.com/files-shared/

I’ve never used it, but it looks like what you want.

Good luck!

[mrhoratio]

Now that I think about it, is there a way to do this by pulling the RSS free from bbPress into WordPress? What do you think?