Posted 4 months ago #
Wp table reloaded version: 1.9.3
In a table with 288 entries I am getting an 503 error when I try to update this table. Other tables are not affected (less entries). Exporting the data and creating a new table give the same error.
Any idea on what this might be?
Hi,
thanks for your report.
This very likely is a server configuration issue, e.g. like this one:
http://wordpress.org/support/topic/plugin-wp-table-reloaded-wp-331-breaks-wp-table
It's probably Suhosin or Apache's mod_security that block the large POST request and raise that error.
Regards,
Tobias
Posted 4 months ago #
Thanks. Any chance for me to edit the tables through MySQL? I tried finding the tables in the WP database but to no avail.
On the side, I will try to fix Suhosin and the Apache issue however I need to add info to the table.
Hi,
no, editing directly in mySQL is not possible, as WP-Table Reloaded does not use own tables there.
You could try to export the table to a CSV file, open and edit that in (e.g.) Excel, and then re-import that file, and choosing to replace the existing table.
Regards,
Tobias
Posted 3 months ago #
Hi Tobias,
tried several things but it is not Suhosin luckily. I am trying to modify the Apache's mod_security now. Any idea on what should be the best setting?
Second question; is there a way I can alter the table properties (show pages, allow sorting) in MySQL? Importing a table is fine but I am running into issues with the other properties.
Thanks!
Arvid
Hi Arvid,
no, I'm not familiar with mod_security, sorry :-(
But it's probably something related to the request size or similar.
Altering the table options is also not possible in mySQL, unfortunately. (Well, in theory it is, but the complexity is higher than doing it via the interface, and the risk of corrupting the table is not to be neglected... It would involve search/replace in the table fields, but I really don't recommend that and do not encourage you to try.)
Regards,
Tobias
You must log in to post.
