Changes are not saved on a large table

  • Resolved apolyd

    (@apolyd)


    1 week, 3 days ago

    Hello,

    I am trying to edit a large table that contains about 3.800 rows and 11 columns. While I can upload the excel file, whenever I try to do a simple change and edit something, for instance add a scrollbar and then save it, I always get one of the two following errors:
    “Unfortunately, an error occurred. There was a problem with the server, HTTP response code 400 ().”
    “Request Method POST Status Code 413 Content Too Large.”
    I could not find the error code in the frequently asked questions and I have already increased all relevant PHP limits on the server (memory_limit, max_input_vars, post_max_size, upload_max_filesize, max_execution_time, and max_input_time) to ensure that TablePress can handle large tables as suggested in another post. Is there something else I should check?

    Thank you in advance

    • This topic was modified 1 week, 3 days ago by apolyd.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Tim Crull

    (@galanos)

    1 week, 3 days ago

    Hi @apolyd,

    Thanks for your post and sorry for the trouble!

    Judging from the error, submitting your table indeed seems to hit some size limitations. However, your table is large, but not enormously so. May I ask what kind of data it contains and how large your source file is?

    If increasing the values of the PHP settings you named didn’t help, the limiting factor could be on the server or proxy level. Apache has “LimitRequestBody” (https://httpd.apache.org/docs/current/mod/core.html#limitrequestbody), Nginx has “client_max_body_size” (https://nginx.org/en/docs/http/ngx_http_core_module.html#client_max_body_size). You won’t be able to check those server settings via WordPress or PHP, so please ask your host to verify that they’re set to a value that allows receiving your table’s data—and then some. They could also take a look at your site’s error logs to see if the bottleneck becomes apparent there.

    If traffic to your site is going through a proxy or WAF like Cloudflare, they might have POST limitations in place, too. In that case, see if you can bypass the service when working in your backend.

    Let me know if that helps 🙂

    Best wishes,
    Tim

    Thread Starter apolyd

    (@apolyd)

    1 week, 2 days ago

    Hi,

    Thank you for your reply. The file is an .xlsx file that is 260kb and contains data from theatrical perfomances like the name of the theatrical performance and the city or date it took place. I have contacted the host of the site to check the solution you provided and hopefully that will fix the issue.

    Thanks!

    Plugin Support Tim Crull

    (@galanos)

    1 week, 2 days ago

    Hi @apolyd,

    Thank you for trying that approach and contacting your host.

    That file size isn’t particularly huge. Another possibility is that the import went wrong. Can you please check how many columns and rows (including empty ones) you see on the “Edit Table” screen for that table, and whether those numbers match the ~3.8k rows and 11 columns you see in Excel?

    Thanks!

    Best wishes,
    Tim

    Thread Starter apolyd

    (@apolyd)

    6 days, 12 hours ago

    Hi,
    It seems that the problem was resolved after the host of the site made the changes you suggested. The server also probably needed a restart or something but now I can edit the table and save the changes.

    Thank you!

    • This reply was modified 6 days, 11 hours ago by apolyd.
    Plugin Support Tim Crull

    (@galanos)

    6 days, 12 hours ago

    Hi @apolyd,

    Thank you for the update, that’s great to hear!

    Best wishes,
    Tim

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

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

You must be logged in to reply to this topic.