Skip to:
Content
Pages
Categories
Search
Top
Bottom

Major problem with Topic Posts

  • and BBPress Latest Discussions. It says someone posting and there name and then their name and post is not appearing inside the topic. In BBPress Latest Discussion will say last post by So and So and then that persons post does not appear and a different topic will then be displayed. Also the number of posts is incorrect. I am not sure if this means that Database is corrupted. Also reputation cannot be fixed unable to have it take away reputation points.

    Anyone able to look into this offer solutions. I need this on a emergency basis. Thanks

Viewing 18 replies - 1 through 18 (of 18 total)

  • chrishajer
    Participant

    @chrishajer

    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

    Sounds just like the problem I have. Check out this topic:

    http://bbpress.org/forums/topic/not-able-to-make-new-posts-database-error

    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.


    Windhamdavid
    Member

    @windhamdavid

    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

    http://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


    chrishajer
    Participant

    @chrishajer

    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


    _ck_
    Participant

    @_ck_

    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.


    johnhiler
    Member

    @johnhiler

    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


    johnhiler
    Member

    @johnhiler

    If you deactivate the bbPress Latest Discussion plugin, does the error go away?


    johnhiler
    Member

    @johnhiler

    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″:

    http://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


    johnhiler
    Member

    @johnhiler

    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?


    chrishajer
    Participant

    @chrishajer

    Are you using the “Admin can post anything” plugin? I heard that was causing a problem like this once.

    http://bbpress.org/forums/topic/error-when-is-used-in-post

    http://bbpress.org/forums/topic/error-while-posting#post-10925

    Or:

    http://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.

Viewing 18 replies - 1 through 18 (of 18 total)

You must be logged in to reply to this topic.