[Plugin: WP-Table Reloaded] Unable to upload or edit large tables

Hi,

thanks for your post.

There is no fixed limit for tables or files in the code, but for large tables, some restrictions on the server might come into effect. This could for example be file size limits or memory limits in the PHP configuration.
Unfortunately, there’s nothing I can do about this in the plugin, as this will require changes in the server configuration.

Also, for such large tables, I don’t really recommend to use WP-Table Reloaded, as it is better suited for not that large tables. You should probably look into a custom PHP/mySQL solution, with a database for your table.

Best wishes,
Tobias

Hi Tobias,

Thanks for the reply, I greately appreciated. I found a way around the upload issue by uploading the table to the site via ftp then calling it from WP-Table reloaded, works good but getting a new error when loading the webpage with the table being called. I contacted support with my ISP and hopefully we figure something out.

Do you have any recommendations for PHP/mySQL solutions for what I need?

Cheers,
Ali

One more thing Tobias,

Even a not so large 780kb excel file with about 1000 listings gives me an error as such;
Request Entity Too Large
The requested resource
/wp-admin/tools.php
does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.

I cannot edit hte file, I can upload it but not edit… any ideas?

Hi,

that error message indicates that there is indeed a limit in the server configuration that stops large requests (e.g. someone submitting a form with many textfields, like in a table) from being processed.
As that also is a server configuration issue, there’s nothing I can change in WP-Table Reloaded, sorry ??

For that PHP/mySQL solution: Well, basically, you will need to set up a database table that fits your table’s structure and then upload the data into it. You can then use a PHP script to access the database and render the data on the page.

Regards,
Tobias

Hi Tobias,

Once again, I appreciate your lightning quick replies. I have found a solution, it was 2 part;
1. I asked my HOST to increase the maximum amount of memory but it still didn’t solve the problem.
2. I went into my wp-config.php file and added the following code;
define(‘WP_MEMORY_LIMIT’, ‘128M’);

And that seemed to work, my table loads even though it is 3mb large and has over 4300 entries. However I did notice the speed is very slow to use and to load, any ideas on how I can optimize the table?

Cheers,
Ali

Hi Ali,

thanks for sharing that information. Good to see that this could be solved so easily with the help of your webhost.

About the speed: This very likely is also the result of the large table. The reason is that the data structure that is used internally is not the fastest, and on some systems it can be rather slow.
In those cases, and where speed is important, a custom PHP/mySQL solution might bring a better performance as well.

Regards,
Tobias

Hey Tobias,

Your a good guy, I appreciate your hardwork in making that plugin available. One last question, do you know where I can go to get started on learning how to do the PHP/mySQL table? I am fairly new to the world of databases… so any help would be much appreciated. Consider me fresh off the baot! I know where my SQL is, I can access it… so I know that much.

Ali

Hi Ali,

sorry for the late answer.

I don’t have specific recommendations, I simply suggest to search for introductions and tutorials on these topics in your favorite search engine.

Best wishes,
Tobias