Internal Server Error from Manual import attempt

  • Resolved therber2

    (@therber2)


    8 years, 1 month ago

    I’m having a similar problem that the fella over here was having in a now closed thread:
    https://www.ads-software.com/support/topic/tablepress-saving-failed-ajax-call-failed-error-internal-server-error-try-a/

    His solution was:
    “I simply changed wp-content to 755 and the magic worked.”

    This did not work in my case unfortunately (actually this folder was already set to 755).

    So several things:
    1. I have no problem manually appending a prexisting table so long as the data I am adding in is a small amount.
    2. Thing were working just dandy early this morning and with even larger manual file uploads…replace current table manual uploads that is.
    3. I have no problem uploading 1000 or so row by 15-20 header/column data sets (I’m always just copying and pasting from excel…it always works fine and I’m not doing anything differently today).
    4. If I, in any manner, attempt to do say a 5000+ row data set, I get the following errror:

    Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

    Note: I have tried disabling all other plugins and I have the most recent version of wordpress. And again, I’ve uploaded files much larger than this via the manual copy and paste excel > tablepress method. I did this morning as a matter of fact.

    Last thing: I spent the last hour on chat with my hosting company. They tried checking error logs and they doubled my php something or other that they thought was relevant. They said they only thing left is to contact the plugin creator and see if there are some configuration settings that are preventing large file uploads that may have JUST been created.

    My website is https://www.procomputergambler.net by the way
    …and PS thanks for all you do Tobias. I’ve sent donations your way in the past for the time you’ve taken to help me.

    Thank you,
    Tom

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter therber2

    (@therber2)

    Update: Host technician just emailed me back with this:

    Hello,

    Thank you for your patience. I was able to determine that there were some mod_sec rules that were blocking the usage of your plugin. I have disabled these so you can continue to use the plugin. I do recommend however to monitor your site with these rules disabled, they are security blocks and with them disabled they can open security vulnerabilities on your site. In your cPanel you can use the ‘Virus Scanner’ to periodically scan your site with ClamAV to ensure there are no issues.

    If you have any other questions feel free to reach out to us at any time.

    Best Regards,
    xxxxx

    The 500 error persists exactly as it did before.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, I’m not sure how I can help here ??
    This is a server error, so most likely something like the PHP Memory Limit or the maximum execution time will be reached.
    One idea to maybe find out more would be to set the WP_DEBUG constant to true in the wp-config.php file.

    Note that using such large datasets is not something that TablePress is good at. You might want to consider an actual database table and custom PHP code to use/show it.

    Regards,
    Tobias

    Thread Starter therber2

    (@therber2)

    Tobias, thanks for the response. I’m a bit baffled by it, and I’m not sure really if you can even help here. My php memory limit is like 256MB and my “big” imports (csv copied and pasted right from excel) total up to no more than 200KB.

    I did a massive import the other morning. It worked fine; tried again same afternoon and I get the internal error for imports of roughly 215 or so KBs. Something like 150KB csv imports or existing table appends work fine.

    I’ve gone through wp-config.php and tried to expand the php memory limit. I create a phpinfo page on my domain and see that my max limit is 256MB…way way more than enough. I went into the new wordpress file in wp-includes where you set the php memory limits now. Tried ini. Reinstalled the plugin…

    I think it has to be something with the host. Maybe I trigged some false red flag or something. Oh yeah, I did try wp_debug as well and I went through cpanel error logs but didn’t find relevant errors.

    I’ll keep you updated. Just gotta keep at the hosting company (ASimpleOrange — actually has been a really great host).

    In the meantime, I do have a separate question/request for you. I will open a new thread…

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    well the memory limit is not really influenced by the file size here. It’s about the memory/RAM that is used in the import process. Depending on the internal data structures in PHP, this can quickly grow much bigger than the file size.

    Regards,
    Tobias

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi again,

    just to be sure: Which import format are you using? .xlsx or .csv? .csv should work better here.

    Regards,
    Tobias

    Thread Starter therber2

    (@therber2)

    Hey Tobias, I tried them all….however, this has to be the dumbest thread because things are working now. My host got back to be and said that they had recognized the error (the firewall false flag). They said they lifted it and just didn’t do it. So today they did and it works again.

    All in all, they’re a good hosting company, but stuff like this just embarrasses me. Mistakes happen though.

    I’m sorry to have wasted your time, as your plugin was not the issue.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    Awesome! Good to hear that this could be resolved! Yes, a firewall could indeed have caused this, e.g. if it blocks requests that are too large. I hadn’t thought about that as you mentioned that your host had already ruled out things like that. But good that everything is working now! ??

    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 ‘Internal Server Error from Manual import attempt’ is closed to new replies.