Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter ategy

    (@ategy)

    lol .. looks like we posted at almost the same time .. thanks so much for the explanation.

    Just one thing .. you wrote:
    ” This is indeed a resource limit, but of the database, but of the memory (RAM) that PHP uses on the server.”

    I’m assuming you meant to write:
    ” This is indeed a resource limit, *NOT* of the database, but of the memory (RAM) that PHP uses on the server.”

    Ironically my financial situation has been a huge mess for a few years due to death of a side-business partner, being off work for a few months twice in the last 2 years unpaid for health reasons, and a flooding. (Don’t ask .. lol). But finally built up a tiny buffer and my usage of TablePress has helped with that. I can’t contribute a lot, but I just send you a little something via PP! More importantly I want to say thanks .. often overlooked, tables help present data .. and in this world of garbage hearsay and more opinion than fact news, facts and data are crucial at shinning the light of truth on things. So while it might not seem like it, you are indeed a hero to the world! 🙂

    Thread Starter ategy

    (@ategy)

    Update .. since Google is our friend, I looked around a bit. I used to program literally 30 years ago, so while I don’t know the specifics of PHP, I can bumble around and *SOMETIMES* figure out what’s what. In this case I saw a quick fix was to add the following to wp-config.php (assuming default was 256):

    “define( ‘WP_MAX_MEMORY_LIMIT’ , ‘512M’ );”

    When giving this fix, the person also indicated it’s a short term band-aid, and that the real issue is that the code in question should be changed because 256 is already a lot.

    All that said .. I’m not sure what memory that is refering to? Is it max table size? Just internal RAM? Or something else? (Note even if you answer, I might still not have a clue how to fix it .. lol)

    Anyhow .. thanks again. Short term my situation is resolved, but I will keep coming back here to help figure out the larger issue.

    For those finding this in the future getting the same error, note that I added “define( ‘WP_MAX_MEMORY_LIMIT’ , ‘512M’ );” directly below the keys and salts in wp-config.php (I’m not sure if placement is important or not, so figured I’m specify)

    Thread Starter ategy

    (@ategy)

    Hi .. thanks for getting me started. Done. Here are the errors:

    Attempt to access “All Tables”:
    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 397312 bytes) in /home/{xxxxxxxxxxxx}/public_html/wp-includes/wp-db.php on line 1989

    Attempt to access “Import a Table” and “Export a Table”:
    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 475136 bytes) in /home/{xxxxxxxxxxxx}/public_html/wp-includes/wp-db.php on line 1989

    Note I replaced {xxxxxxxxxxxx} which is my “Current User” alphanumeric string in cPanel

    Could this simply be a database size limit issue? If so it seems kinda weird because I didn’t even get to the point of starting to upload, I simply can’t get to the actual “Import” page.

    For the record my DB is pretty big .. specifically my “posts” table (456 mb) and “options” table (289 mb).

    Overall my db is 757 mb .. and in theory my limit is supposed to be 1 gb.

    Thanks again for any additional thoughts or direction! 🙂

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