[Gautam Gupta]

Pretty much unexpected

[kevinjohngallagher]

http://www.kevinjohngallagher.com/2010/07/open-letter-to-automattic-regarding-bbpress-plug-in

If this has ANY code from bbPress in it, i’ll eat my hat

It’s daft to use the name for one product thats totally different, and it’s already caused more than a few unneccessary support questions and fear-mongering.

Instead, it’s just going to be the 6th product in 18months from AutoMattic which will be abbreviated to “bPress”. I decided to write this after emails to Matt, Jane and JJJ all went unanswered in the past month; and Westi didn’t comment on it in my email to him, though he did say that he didn’t know that bbPress was dependant on BackPress – and he’s the BackPress lead!! really lovely guy, but it hardly bodes well.

Pete and JJJ are graet coders and people who only want the best for the community, i’ve no doubt that this plugin will be great for those that want it. It just pains me that the lack of management/commonsense/planning that have plagued bbPress are going to be forced on them too

At least if they choose a different Development blog name, people won’t get too confused.

[kevinjohngallagher]

Hi Scott,

Just been through this with my WorldCup Fansite Forum after the final on Sunday night, so I’ve a few things to throw your way. I’m sorry about the slow and pedantic manner of this post too; but if it’s this or close yoru forum, we’ll just get through it!

My gut feeling is that this is a plugin and/or host issue. So lets see what we can do here:

First, lots of boring questions I’m afraid:

Is your website using WordPress at all?

If so, have you set up “deep integration”?

Did you do the installing/setup yourself?

Second, ask your host if they’re intentionally throttling you or if it’s automatic?

If it’s happening, ask them what the issue is (I doubt they’ll give you a huge run down but might find a specific issue you didn’t know was the ‘biggie’)

Third, Make backups

Copy a back up of every plugin and your theme on your hardrive somewhere, then log into bbpress and deactivate them all (apart from akismet) and change to the normal default theme.

Fourth, delete all of the plugins and themes.

Fifth, Tell your users

Write a post (then sticky to font) about how your website is going through an “upgrade” and in order to get the latest most secure most awesome software installed you’re having to accept the default theme for half a day.

Sixth, Lets have a look at those SQL queries.

Open up your bb-config.php file and add the following line before the database connection stuff (at around line 33):

define('SAVEQUERIES', true);

Seventh, edit your footer

open up your footer.php in (my-templates/kakumei/) and add this to the very bottom:

if (bb_current_user_can('administrate'))

{

global $bbdb;

print_r($bbdb->queries);

}

Apologies for this, but that last line is going to have something that looks like “->” in it. Please, make this into “-” and then a right arrow (usually shift+period). It’s a bug here on this forum – should be fixed soon.

Eight, load your forum.

At the bottom of your homepage you should see a big list of stuff, which will have lots of SQL commands.

This is a list of all the SQL commands that load, in order, along with the time taken to execute.

Do any of them look to be taking longer than the others?

Copy and paste this list into a text file and save on your desktop (there will be about 15 SQL commands with a few lines around them).

Nine, recount.

Log into your admin area and go to Tools.

Select ONE checkbox at a time and hit “RECOUNT ITEMS”.

Do this for all checkboxes going down the list.

Ten, load your forum (again).

Repeat Step 8.

Compare the results betwen the two text files.

Have any of the “times” come down?

Are any of them above 0.1 seconds?

Are any of them betwen 0.5 and 1 second?

[Ben L.]

Try installing this plugin: https://bbpress.org/plugins/topic/bb-benchmark/

And adding the following line to your bb-config.php:

define('SAVEQUERIES', true);

Then, you can view source on any forum page (when logged in as admin) and it will tell you the slowest query, along with the function that used it. It’s usually simple guessing to figure out which plugin a query came from after that.

[Ilalaina]

Thanks for the fast reply.

I tried to use the plugin but there’s no border for the image, and i’don’t kbow where to set the options for the plugin.

Excuse my English

Thanks

[zaerl]

I think that a WYSIWYG editor isn’t a must-have feature in a bullettin board and I don’t see a lot of forums with this functionality (I follow ~30 bb daily.) I have implemented my editor for bbPress only cause it’s boring to write the “a” tag (and others). Quicktags (bbcode or html) are the way to go IMHO.

[kevinjohngallagher]

I doubt people neither chose nor leave a forum because they’ve not implemented TinyMCE; which is not to say that some people don’t like WYSIWYG, but it’s importance is often overstated.

phpBB, as your example, seems to be doing ok without it. I’m sure I saw them hit their 10th birthday and gazillionth download not that long ago. Basiaclly, phpBB has been around since before Google.

you converted your forum from a wysiwyg based forum; vbulletin (native), phpbb (as plugin).. to bbpress, you loose lot of formatting

Why did you lose your formatting?

Thats not a bbPress thing, was it in the conversion (i haven’t done one yet)?

Is the formatting still in the post?

If it is, there are numerous bbCode plugins for bbPress for years now. Let us know what’s gone and I’ll try and help you sort that. I think that could be a nice fix for you!

it is not an option, it is a must-have feature in every successful board

http://www.kevinjohngallagher.com/2010/03/basic-versus-standard/

[Abdessamad Idrissi]

Hello there,

It would be really a nice thing to have a wysiwyg editor in bbpress, just like the one that wordpress have: TinyMCE, since it is open source.

the current editor is too much simple and complex at the same time especially when:

* you converted your forum from a wysiwyg based forum; vbulletin (native), phpbb (as plugin).. to bbpress, you loose lot of formatting.

* most of the users don’t know how to deal with bbcode.

* you need a fast way to copy-past formated text and images.

* currently no efficient wysiwyg plugin available in the bbpress plugins.

* it is not an option, it is a must-have feature in every successful board.

most phpbb forum owners criticized harshly the lack of wysiwyg in phpbb; people keeps asking for it and phpbb developers keep ignoring them and saying that they want to keep phpbb simple!!! so users leave to other forums!

for the people who like the current bbpress simple editor, bbpress can offer a switch in the dashboard to toggle wysiwyg editor on and off.

what do you think?

[kevinjohngallagher]

In terms of going forward as a standalone piece of software, yeah, it effectively is.

But the software you have and you can always use, and if it works for you, go for it. I, and all others here, are in the sme boat, and the basics of bbPress are quite brilliant.

I’d be suprised if you should have to change “localhost”, but if there’s no emails comign through from your goDaddy account at all, and you’re using the default mail(), then it’s at their end

Good Luck

[Sunnichka]

well, just had an answer that i should leave localhost. well, i uploaded back an old file and still nothing. and just read on your blog that bbPress is dead. very pity idea was very nice!

[kevinjohngallagher]

Bonjour,

Je ne parle pas couramment le français depuis son départ en 1980s. S’il vous plaît excuser ma tentative assez pauvre pour ne pas utiliser l’anglais

Ce plugin peut correspondre à vos besoins:

https://bbpress.org/plugins/topic/bavatars/

jean

[Sunnichka]

Yeah, I know that this topic is old, a pity it’s not very busy here Well, I wanted to use bbPress registration because there are more fields in it and i dnt want to mess up installing extra-plugins to WP to get all necessary datas from users when I could get all needed from bbPress.

All changes i was trying to do in class.mailer.php is to put registered email to $Sender end played with $Host because it’s not localhost at godaddy hosting.

It didnt work with WordPress before I started to change anything anyway.

Sorry, I’m not a hardcoder and this bloody thing causes me headache already a week. Didnt happen on testhosting

But thank you for reply!!!

[Sunnichka]

No, WordPress dsnt send them as well (((

Well, host said that it’s a script error and they can’t help. Only thing they wrote and I posted it above is:

“If you use the mail() function in your PHP, you do not need to specify an outgoing mail server. If you are using some other method besides mail() in your PHP code, use relay-hosting.secureserver.net for your relay server.”

[kevinjohngallagher]

Hi Sunnie,

The first thing to check is if WordPress can send registration emails.

If it can, then we have a bbPress issue.

If it can’t then it’s a server issue, and the quickest resolution is to contact your hosts and use the WordPress support forum (as there are more people on there).

Test and let us know

[kevinjohngallagher]

There is not to the best of my knowledge.

This has been discussed before, at length as I recall, on a few occasions. Sadly you’ll have to do a bit of searching to find it, but you should get some good info out of it.

It basically comes down to this:

RSS is a pull technology, not a push one. So you’d need to have some form of cron job to check for an update in the blog feed, and then have code to write a post to your forum. In honesty this wouldn’t be too difficult, but it’s got relatively limited value, so i doubt there is an existing plugin (I may be totally wrong)

EDIT: I’ve actually just thought of a brilliant use for such a plugin. Dammit. This goes on the list.

bbPress1.0 comes with the ability to handle XML-RPC, which is like cross-sever posting (in laymans terms). You could get a WordPress plugin that ‘pings’/’posts/ to bbPress when a new post is written. Not uite sure how elegant this would be with scheduled posts etc.

I’d definately look around the WordPress plugin directory for this, but I’m 99% certain it will require some coding at your end.

Good luck, and shout if you’ve any specific questions.

[honestscott]

Hi,

My bbpress 1.0.2 forum is causing a lot of slow queries, and I had to shut it down because my host Monster Host was Throttling my account big time.

Is there a fix for this, I am not running many plug-ins that would use the database except for bbpm, but I tried disabling this plug-in, and I still get clobbered with slow queries and CPU throttling.

I hate to have to shut the forum down, but I am not a php coder or a database administrator.

I tried moving my sites to a semi-dedicated server (to get more server resources) but their Myphp interface clashed somehow with all my WP databases.

I was on NTC hosting and their support team told me it was a problem with my WP sites, although I did get one blog to work half way decent, but my bbpress forum would not.

I was using Blue Host when I created my sites, so I went to Monster Host (their sister company) and loaded my files and DB’s and they came up just fine, but I am back to the DB strangulation with slow queries.

I check the slow queries log on my server and I see a lot of forum queries in there, but the logs don’t really pin-point a cause (plug-in or script).

Here’s a list of the plugins I have on my forum:

ajaxed quote

adsense for bbpress

bbcode buttons

bbcumulus

bbpm

bbpress signatures

bb-smiles

check for updates (not activated)

delete all bozos

mass delete users

members online

php4bb

super search

approve registration

bb-avatars

bbcode lite

bb twitter (not active)

google analytics

human test

moderator notification

new user notification

restrict registration

I would appreciate any, and all ideas so I could save my forum from the trash bin.

Thanks for your time,

Scott

[chrishajer]

Can you post your code and a link to your site (post the code at pastie.org or equivalent, since it will be munged here)? There are probably many people who could benefit from your solution. Thanks

[kevinjohngallagher]

If you’re running bbPress1.0.1, bbPress1.0.2 is a very minor upgrade (less than 100 lines of code) and include some bug fixes.

bbPress1.0.3 / bbPress1.1 shouldn’t break that many plugins. My last trunk download caused some theme issues (minor), but up until the end of April there it was stable and looking might fine.

I strongly suggest you make a local copy of your current forum, and install the latest version from the trunk; and test against your plugins. Given the list that you have, there’s a good chance some may fail; and others like “Subscribe to Topic” won’t really be needed.

When/if this new bbpress plugin comes out, will there be a way to convert my bbpress installation into teh plugin or otherwise make it compatable?

None of us have any idea. Matt announced that the bbPress plugin was going to happen in January, then left the project. Any other information you can garnish from the WordPress blogs updates will give you more information than people involved with this project have been given.

Either way, i’m not panicing. Just irked by the lack of communication, as you’re not alone in asking, and i feel for the bbPress users who are in a form of limbo.

[kevinjohngallagher]

The bbPress Live plugin by Sam, was released and last updated around bbPress1.0alpha3.

It appears to me that the plugin makes a wrong call (possibly a bbPress to BackPress issue – as there were major changes for bbpress1.0alpha6) because it returns an empty set. On top of that, it’s aimed for WordPress before WP2.7, which itself had a large number of under the hood changes.

I’d be surprised if this plugin was even close to being fit for purpose these days; and without a doubt the solution is to pull the information from the Database directly.

bbPress and WordPress are 2 stand-alone software solutions that can share the same database/logins. Leveraging this data without adding the overhead (and potential issues) of the other will make life easier in the long run

(not to mention save 50+ SQL calls every time you load a bbpress page)

[kevinjohngallagher]

Good catch Chris,

Yahoo Traffic Server doesn’t use .htaccess files.

Though that might change in the future after Yahoo donated TS to the Apache Foundation, though they still have the source code in-house.

As I recall though, YTS has quite an extensive plugin library, and so there might (probably?) be an alternative method out there. It’s beyond me though.

[kevinjohngallagher]

Hi Adam,

Make sure you take a backup of your MySQL data at every oppertunity when talking to your host.

If you can get one from PHPmyAdmin great, if not ask your host for backups.

Don’t overwrite them, and rename them with the day/time and after which correspondance you got the backup.

When this is all sorted, load the .sql backup into a text editor (and you can sift through the code). Might not be pretty but you’ll at least see the extent of the issue.

If it’s gone south, and the host can’t help, you’re in for a long slog. That said, one of the positives here is that the bbPress table structure (while a bit… not optomized – bad english for bad table design) is easy to read and replace/backup. I’ve had to do it myself, and we can offer tips if it comes to it, but it’s not as bad as it sounds if you get some forum of backup/old DB.

[kevinjohngallagher]

Hi Chris,

It appears to be working.

Has it been fixed in the last few hours, or do you have a new link you could provide us with. Fingers crossed it’s been fixed

[chrishajer]

Can’t create/write to file ‘/tmp/#sql_e93_0.MYI’ (Errcode: 22)

That is a problem with MySQL. That is something your host needs to address. MySQL cannot write to that MYI file on the /tmp partition for some reason. This is something they need to resolve.

I’m afraid your problems are larger than bbPress. The trouble with bbPress and your earlier loss of categories and the plugin problem in WordPress are all symptoms of a larger problem and something your host needs to resolve.

Are you on a Windows host? I can’t find reference to it on Linux at all. It could be something as simple as out of space on the device, but it’s something for the host to resolve.

[chrishajer]

Friday 9th July:

==================

matt states that bbPress has been upgraded to latest trunk version

Where did that come from? I didn’t see that posted online.

The code running here is certainly not updated to the latest trunk. From the source of the page:

[meta name="generator" content="bbPress 1.1-alpha-2453" /]

When it’s updated, the BackPress fix will be in.

[adammurphy]

Yes that’s a good point – didn’t think of the FTP.

Plugins:

admin add user

allow images

bb-wysisyg editor

force login

hidden forums

wordpress integration

The problems I had on the main site:

My host are insisting that they didn’t touch it, and I certainly didn’t, so I’m not sure if it’s been hacked, or it’s some sort of database glitch or what. On the WP site, all of the categories were reset to “uncategorized” which, for a site running comicpress, which is category-based, was a bit of a disaster. Just as I was panicking, it seemed to find the categories again, and reset the site to 6th July (which I assumed was them rolling back altough they insist they haven’t). I also noticed the category order plugin giving the following error:

WordPress database error: [Can’t create/write to file

‘/tmp/#sql_e93_0.MYI’ (Errcode: 22)]

SHOW COLUMNS FROM wp_terms LIKE ‘term_order’

WordPress database error: [Duplicate column name ‘term_order’]

ALTER TABLE wp_terms ADD term_order INT( 4 ) NULL DEFAULT ‘0’

Again, if this suggests anything to you, or I can provide any more info, I’d be most grateful,

Adam.