@johnhiler
I want to correct something here. Bbpress latests discussion is a wordpress plugin, not a bbpress plugin. It should not conflict with any bbpress function. 
Are you using the “Admin can post anything” plugin? I heard that was causing a problem like this once.
https://bbpress.org/forums/topic/error-when-is-used-in-post
https://bbpress.org/forums/topic/error-while-posting#post-10925
Or:
https://bbpress.org/forums/topic/can-someone-explain-this-bbpress-database-error#post-14463
I’ve heard of a single quote causing problems like this in the past but I don’t think we ever had enough data on the types of server, MySQL and PHP version, PHP config, etc, to figure it out.
Two questions:
1) Do you still get that error if you deactivate the bbPress Latest Discussion plugin?
2) Did you try upgrading the bbPress Latest Discussion plugin to the latest version?
<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 ‘t posted was that when is Rugby Canada going to have a stadium policy. Are we go’ at line 1]
INSERT INTO bb3_posts (topic_id,post_text,post_time,poster_id,poster_ip,post_status,post_position,forum_id) VALUES (’57’,”,’2009-06-01 05:18:02′,’13’,’24.80.235.218′,’0′,’4′,’2′)
Warning: Cannot modify header information – headers already sent by (output started at /home/content/a/l/e/alexander9999/html/forums/bb-includes/db-mysql.php:130) in /home/content/a/l/e/alexander9999/html/forums/bb-includes/pluggable.php on line 232>
Here is message minus the post. The forum is on this site Canadianrugby.ca
there doesn’t seem to be a problem with latest discussions but with postings on the Forum it seems that a long message and perhaps punctuation such as , or apostrophe can cause the error and the post not posting
@englishlangprof please start a new topic for that question. Thanks.
Looked in the archives here and couldn’t find a topic specifically about this…
I am fairly well versed in HTML and CSS. I have no programming experience though. I’ve been using bbPress for a couple years now, and have used WordPress for much longer.
I want to learn PHP but I don’t have previous programming/coding experience. I’d probably just use this to write plug-ins.
Can you recommend a good book or online tutorial for the absolute newb?
Thanks!
Just noticed – according to the developer notes on the bbPress Latest Discussion plugin, earlier versions of the plugin were using the “wrong table name for 9.0.4”:
https://bbpress.org/plugins/topic/bbpress-latest-discussion-for-wp/other_notes/
This has been fixed in the latest version of the plugin (1.3.9). I noticed you mentioned you were using version 1.3 along with bbPress 9.0.4, which would create a problem… I’m guessing that upgrading to the latest version of the plugin might resolve the issue?
If you deactivate the bbPress Latest Discussion plugin, does the error go away?
Actually I made such a mess of it all that I uninstalled and started again!! I only had a few posts.
Thanks guys!
My real need is to have nice big comment boxes like these ones on this page under my blog posts in my blog http://englishforuniversity.com
Does that mean that I have to choose a whole new theme do you think?
Just trying to get my head wrapped around the issue: so bbPress is working fine for you… it’s just that when you activate the bbPress Latest Discussion plugin, you get the error you mentioned?
The URL (for one that’s not active yet) is http://letsdoo.org I’ve just switch Bad Behaviour back on, and IE7 is just sitting there ticking away. Chrome still loads it fine though. I haven’t had anything like this before, and am on Vista Home Premium with the default firewall active.
Can anyone help me with this issue. I knew that BBpress.org didn’t have paid support but I thought I could get some assistance from the forum or community. My developer can’t get it fixed and I need some assistance. Now the problem is that when you make a post it says that it is interfering with the topic header and the post is left blank. Here is the error message.
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 ‘t posted was that when is Rugby Canada going to have a stadium policy. Are we g’ at line 1]
INSERT INTO bb3_posts (topic_id,post_text,post_time,poster_id,poster_ip,post_status,post_position,forum_id) VALUES (’57’,’
Warning: Cannot modify header information – headers already sent by (output started at /home/content/a/l/e/alexander9999/html/forums/bb-includes/db-mysql.php:130) in /home/content/a/l/e/alexander9999/html/forums/bb-includes/pluggable.php on line 232
URL?
I’ve see IE 6 behind a firewall be a bit tetchy about Bad-B before. You can Contact Michael about generic errors like that. I suspect it’s IE and/or your ISP.
Thanks _ck_. This thread can be dumped unless you think it’s of use to others.
Akismet has been getting worse and worse each week with false positives and unfortunately some of your posts fell victim to it. I have restored them.
I updated a thread (http://bbpress.org/forums/topic/new-minimalist-theme-available) as I’d added some files, but can only see the last two posts when I’ve logged-in. Has something gone wrong, or have they been hidden as they’re multi-posts or something? As I said in one, it’d help if we could edit for 24 hours to save double posting. Also, a theme upload link similar to the plugin one would be useful.
Not sure I grasp all that, but I’ll have a shot at it and see where it goes, so thanks for the advice. Hacking around in the files is as good a start as any. Not sure what you mean by ‘do a global’ though… (Never done any php programming, and am new to bbPress too).
A related question (for anyone); is there any simple documentation for how to hook things into bbPress via plugins, etc., that is, the correct way?
This would be a very good beginners plugin to write, it’s very simple (other than the admin interface).
bbPress fetches stickies via a separate query (which I have always found to be a waste, except for this case) and you could manipulate the results before the final template is loaded.
For example on the front-page if you looks at index.php
you’ll see that
$super_stickies = get_sticky_topics();
and then there is
do_action( 'bb_index.php', '' );
so you hook the action bb_index.php
and then you do a global on $super_stickies
and then you manipulate the order of the array as desired.
for forum pages it’s
$stickies = get_sticky_topics( $forum_id, $page );
and
do_action( 'bb_forum.php', $forum_id );
same concept
That part would take less than an hour to write.
and you’d store the order in the topicmeta
But the part that will take much more time is the admin interface.
Instead you could simply add an extra field on the post edit page that only admin would see and let them chose the topic stickiness priority.
(this is not a plugin I will be writing)
@parallax view;
my provider uses subdomain vhosts …
i presume the problem is in cookies / vhosts + bbpress + wordpress
Ouch. I’m pretty savvy at some computer stuff, but not php or css. I’ve been working on two forums for community groups, one of which may grow quite large if it works out as hoped. So, I tested just about every forum package out there. I settled on Vanilla, but had problems with plugins crashing it, and having to hack around for days to try and get something working. Their support is good from a few community members, but there isn’t enough and it often isn’t timely.
I’ve settled with bbPress because I found it very simple to install and set up. My problems were minor, forum members have helped me very quickly indeed, and in a non-geeky manner. I’ve read lots of other posts where people have had WP integration issues, and the help given has been quite extensive. One other thing that I like is the fact that they use it with 100,000 members and 500,000 posts, and it’s still zippy. Also, modifying themes isn’t so bad if you delve into just a few files and play around. I love simplicity as well as my user group, so I created a vanilla clone(ish), which you can get at https://bbpress.org/forums/topic/new-minimalist-theme-available. (Check the posts at the bottom).
If you have some spare time and a nice cup of tea/coffee, click ‘integration’ in the front page tag list and have a good read. I don’t use WP, but I get the impression that many haven’t found it too difficult with a little assistance. There’s an integration plugin too. PS. Read some of your blog; just a body? Nooo…
I wonder how hard it would be to do something like a bbMU? Not hosted (like wordpress.com) but just like WMPU?
The complexity of discussion boards simply exceeds my patience level for user “Unfriendly” software. I have played with a few of them (phpBB, SMF,bbpress) and have concluded that they are just to damn difficult to integrate into a web site. Most will install easy enough, and the default themes are about as ugly as you can get. Every one of them claims to have easy configuration etc. What a pile of crap. The worst of the lot is the BBpress board. Which is surprising since their blog is so easy to install and changing themes is a snap.
The “how to” support pages for all of them must have been developed by computer geeks who rarely speak English. Instructions which should be simple are garbled and about as user friendly as a wet cat.
My intention was to attempt to integrate a discussion board with my blog (http://woodlandstar.net/WSblog/): something Word Press should have developed a long time ago. How difficult can it be to extend Comments into a simple discussion board? Until something is developed that easily installs and easily integrates with the existing web site, I will hold off on using BB.
Thx, bruinfelix!
I’ve read a post about installing languages into the bb-includes/languages folder in in bbpress, but it simply doesn’t work for me. I think it was an older version (not 1.0 RC, which I currently use). In the RC your setting was the good solution. (“my-languages” folder). And of course the editing of define(‘BBLANG’, ”); in the config.php.
You should just be able to edit your bb-config.php in /forum/bbpress/
Look for $bb_table_prefix = ‘englisl5_’; and change englisl5_ to what ever is set in your WordPress wp-config.php
I tested Vanilla for a while, and liked its simplicity, as do one group I’ve set up a forum for. One neat thing Vanilla has is a Sticky Order plugin. It allows you to drag-move sticky topics in Admin, so that important ones stay where you want them. I can’t find anything like this for bbPress. Is anyone up to creating it? (Hey, _ck_!)
Vanilla’s plugin modifies the sticky db field from 0/1 to 0-9, then uses the value in outputting sticky topics. I’m not up to coding it, but I’m sure many would find it very useful.
