Forums

Database Limit for Posts (6 posts)

  1. jbbrwcky
    Member
    Posted 5 years ago #

    I've noticed this for a while now but I seem to get errors like this consistently when I post something:

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_bnbposts WHERE ID = '1094' LIMIT 1
    
    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_bnbposts WHERE ID = '1093' LIMIT 1

    Now bearing in mind I have more than 3000 posts on this blog, I was leaning towards thinking that that might have something to do with it. Is this correct?

    Is there something I can do to stop these errors? Incidentally, the post still gets posted...

  2. Chris_K
    Member
    Posted 5 years ago #

    What plugin do you have activated that uses a table named wp_bnbposts? That's not a "core" WP table.

  3. MichaelH
    Volunteer
    Posted 5 years ago #

    Maybe worthwhile running a check (or repair) on your tables. Please backup your database before doing anything.

    Another suggestion might be to approach your host to request a change to another server if the problem persists.

  4. Chris_K
    Member
    Posted 5 years ago #

    Pardon my dumb response! I'd guess that wp_bnb is your "prefix".

  5. jbbrwcky
    Member
    Posted 5 years ago #

    Sorry for the short delay in responding - yes the wp_bnb is our prefix, not sure why we did this but its too late to go back regardless.

  6. drmike
    Member
    Posted 5 years ago #

    What's your setup? Specifics please. The reason why I ask is it appears there was a recent "bug" with FreeBSD where the default open file handles limit was set too low. That might be what you're hitting.

Topic Closed

This topic has been closed to new replies.

About this Topic