Can’t access Import/Export

  • Resolved ategy

    (@ategy)


    6 years, 1 month ago

    Last night I uploaded a table without issues. (Haven’t done anything to WP or TablePress in any way since. Today I go to upload a new table and when I click to go to the Import Page I got the following error:
    “The site is experiencing technical difficulties. Please check your site admin email inbox for instructions.”

    I then updated both WP and TP and then the same issue but new error:
    “There has been a critical error on your website. Please check your site admin email inbox for instructions.”

    I’m totally baffled since I’ve done nothing since.

    More importantly all existing tables work just fine. I can also get “Add New Table” and doesn’t seem to be any functionality issue.

    So the only “bug” is that I can’t even get the import or export page to open. So it’s not even technically an “import/export” problem as far as I know because I can’t even get to the page where I can try. With everything else working I’m thinking that’s not the actual issue, but I’m completely baffled?

    Any ideas?

    Again, I did since update to see if it would help, but in between the last successful upload and this new error I did zero changes to anything with my hosting, with WP, nor with TP. That since getting the problem I did update, but same problem just a different error.

    Oh yeah .. and I didn’t get an email despite the error saying to check my inbox.

    Any thoughts would be greatly appreciated. Thanks.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 1 month ago

    Hi,

    thanks for your post, and sorry for the trouble.

    A good next step would be that we try to get more information about these error. For that, please try changing the value of the WP_DEBUG constant in your site’s “wp-config.php” file, with the help of https://ww.wp.xz.cn/support/article/editing-wp-config-php/#wp_debug
    After that, you should be getting more meaningful error messages.

    Regards,
    Tobias

    Thread Starter ategy

    (@ategy)

    6 years, 1 month ago

    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! 🙂

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 1 month ago

    Hi,

    nice find! That explains the issue. This is indeed a resource limit, but of the database, but of the memory (RAM) that PHP uses on the server.
    To work around this, you should increase the PHP Memory Limit on the server, which is also possible in wp-config.php. For example, change the WP_MEMORY_LIMIT constant to 512M, see https://ww.wp.xz.cn/support/article/editing-wp-config-php/#increasing-memory-allocated-to-php
    In addition, you should update PHP on the server to a modern version, like PHP 7.3 or even 7.4 as these new versions require much less memory to begin with.

    And then it could of course be good to optimize/shrink the database tables, if possible. In wp_posts, you could for example check if you can delete old post revisions.

    Regards,
    Tobias

    Thread Starter ategy

    (@ategy)

    6 years, 1 month ago

    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)

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 1 month ago

    Hi,

    yes, that’s basically what I meant in my previous reply 🙂 Please also try those other suggestions about updating PHP and reducing the database size.

    Regards,
    Tobias

    Thread Starter ategy

    (@ategy)

    6 years, 1 month ago

    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! 🙂

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 1 month ago

    Hi,

    yes, sorry, there’s a “not” missing there, in the database part of the sentence… My bad.

    And thanks for the donation, I really appreciate it!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

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

The topic ‘Can’t access Import/Export’ is closed to new replies.