What version of bbPress, and what versions of the plugins are you using?
bbpress 0.9.04
wordpress latest post 0.20
Reputatioin 0.0.6
BBpress Latest Discussion 1.3
Anybody care to look into this. My developers don’t seem to be able to fix the problem. The main problem seems to be the disappearance of posts and the rotation of names. So it will say X made a post but in reality it was another user or no actual post will appear. It appears to be randomly circulating users as posters when actual posts have been made.
Disable all plugins! upgrade the bbpress RC-1,
try again. if persist it sounds like your user tables are mangled probably due to something similar to dragunoff
https://bbpress.org/forums/topic/not-able-to-make-new-posts-database-error
you try to clean up using – http://lesterchan.net/portfolio/programming/php/#wp-dbmanager
.. are you sharing tables with your wordpress installation?
I thought RC-1 is not recommended on a live site
It’s not recommended, but that doesn’t prevent people from recommending that you do it, and some people have done it as well.
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
unfortunately you’ve cropped the error, post it between backticks
the 2nd error, the warning, is caused by the first error, ignore it
I’d almost suspect the data isn’t being escaped properly before the mysql insert.
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?
This particular error occurs when I go to make a post on the forum comes up with this error and then posting is blank apart from the topic title
If you deactivate the bbPress Latest Discussion plugin, does the error go away?
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?
<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
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?
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.
@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. 
The issue has been resolved and no problem with BBPress Latest Discussion. Only issue is with the Reputation plugin. Can’t get to work in adding and deleting reputation points and developers don’t seem to know how to change so that it does not add reputation points for merely making a posting.
