Table Press Won't Save Settings Changes

Hi there

I got help on making the wp-config.php file readable and writeable and added the line:

…but it didn’t change anything.

On my private pc I’m using Google Chrome withaout any extensions – and here the table makes Chrome crash on opening (we have discussed this before). Therefore I use another pc with IE 9 64bit version when using Tablepress (my own IE doesn’t work with it either) – and this have been working until this latest WP version. Now I can’t save anything in the table mentioned (I’m not even adding any new lines) – but gets the message “Saving failed: AJAX call failed: error – . Try again while holding down the “Shift” key.” – when trying.
When trying again while holding down the Shift key – the error message is: “Error. The table culd not be saved”.

best
Vivi

Hi Vivi,

okay, thanks for testing all that. My assumption is that there’s some sort of timeout being reached then, due to the table being so big.
I’ll run some more tests on the site.

Regards,
Tobias

Hi Vivi,

okay, I tried again now with the “Alle verdens chili” table in multiple browsers (Chrome and Firefox on Mac, Firefox and IE on Windows, Chrome on Linux), but could not reproduce the issue there. It took several seconds, but the changes that I made to the table for testing were saved without any errors.
Can you maybe try again on a different computer, to rule out any local interference?

Regards,
Tobias

Hi Tobias

It is strange.
It just tested again – and I got the same results as before.
I’m using the Chrome browser on my home PC – and this is the one where it crashes.
IE is on my work pc (can access it from home via VPN) – still the same errormessages. I just tried Chrome on this machine as well. The table also crashes it here.

I tested one of the smaller tables just to see if that still worked – and it did just fine (on both pc’s).

Can it bee that my pc’s are now too old (not enough RAM) or something like that?
It worked on the machine with IE until the latest WP update – so maybe now WP uses more memory when rendering the page (and that causes trouble with big tables)???

best
Vivi

Hi Vivi,

yes, a slow PC might be the reason then. I could imagine that the browser needs a long time to render the page (if there’s not enough memory), so that the request times out or something like that.
I have no clue how we could work around that though ??
The computers on which I tested are fairly new and have a lot of memory. I’ll try to test on my old and slow laptop later today, to see if low memory could indeed be causing this on the browser side.

Regards,
Tobias

Hi again

My own PC has 6GB RAM and the table makes Chrome crash on this PC.

We have now tried it in two different PC’s each with 8GB RAM – and here the table works – but painstakingly slow.
I can use one of those PC’es for a while – but the experience isn’t exactly great.

Do you have any idea if the plugin can/will be optimized in a way where this will be faster?

I really do like all the features of the plugin, so I would hate to change – but this is a bit difficult to work with for me.

best
Vivi

Hi Vivi,

ok, those computers with that memory should then indeed be fast enough. I have no clue why this happens then ?? On my Mac (with 8 GB RAM), I’m not having those severe issues in Chrome.

Now, I do have plans to make the “Edit” screen faster, but unfortunately, this will still take time and not happen in the near future ??
I can therefore only suggest the workaround with maintaining the tables e.g. in Excel and re-importing them after modifying them.
Sorry for not having better news ??

Best wishes,
Tobias

Hi,
I’ve had same ‘AJAX call successful, internal saving process failed’ error.
I tried many things, as apparently such errors was when my table was more than 140 rows [ trying the memory on /etc/php.ini, or on wordpress config files ].
Finally (after setting up php logs in /etc/php.ini with display_errors=On),I found that I was having errors on /var/log/messages :

Mar 10 00:30:13 opvmw01 suhosin[15772]: ALERT – configured request variable value length limit exceeded – dropped variable ‘tablepress[data]’ (attacker ‘10.115.64.145’, file ‘/var/www/html/wordpress/wp-admin/admin-ajax.php’)

This is in fact not an attack, but tablepress sending too big data..
I then changed /etc/php.d/suhosin.ini adding such lines:

suhosin.get.max_value_length = 650000
suhosin.post.max_value_length = 650000
suhosin.request.max_value_length = 650000

I don’t know which one is fixing the defect, but this is working now for me.
Hope this will fix for you too..

PS: I’m also having below error in /var/log/messages, annoying but not blocking:

Mar 10 00:52:24 opvmw01 suhosin[15810]: ALERT – configured request variable name length limit exceeded – dropped variable ‘wordpress_admin_default_language_1765eceb4e6cdb9bbe2f78a15c23882a’ (attacker ‘10.115.64.145’, file ‘/var/www/html/wordpress/wp-admin/admin-ajax.php’)

Hi ejyb,

thanks for sharing that solution! That looks like a very strict configuration of Suhosin on your server. Good to hear that you were able to relax it a bit!
Hopefully, this will be helpful for others.

Best wishes,
Tobias

I had around 350 Entries in my tables and I was having exactly same error. After reading your comments about possibly shortage of memory on server as cause for the error I thought to delete few unimportant rows entries (May be 10 or 12 I deleted) and then I tried to save table again.. and wolla !! It saved successfully

Hi,

great! Good to hear that you could confirm this! I suggest to also try the approach of increasing WP_MEMORY_LIMIT to make it possible to edit larger tables.

Best wishes,
Tobias