Multi-row editing doesn't work for more then about 35-40 rows.

radz2k

Datatables version: 1.11.3
Editor version: 2.0.5

I have just ralized that for my all tables, while I'm trying to edit rows using 'Multi-row editing' function, there is always a critical amount of rows I can edit successfully. For example, if I select 34 rows, then multi-row editing is working perfectly fine (I'm using server side processing + PHP/Laravel library), but if select 35th row, then there is an error: "system error has occurred (More information).". I have posted it as a bug, because it seems that error occurs on the JS plugin side, because for mentioned 34 rows, when you take a look at the debugged POST information, there is an "action" => "edit" parameter included in the request, but for 35 rows or more the "action" parameter is missing. This bug is repeatable for my all tables, but the critical amount of rows I can edit differs. My first thought was that the problem would be related eg. to the 'max_input_vars' variable in the php.ini settings, but it seems that "action" parameter is missing earlier, while posting by ajax.

Have you encountered such a problem before?

Best Wishes,
Kamil

kthorngren

Have you followed the troubleshooting steps in the technote link in the error?
https://datatables.net/manual/tech-notes/12

Let us know what you find. According to the technote the response form the server is not as expected.

Kevin

tangerine

FWIW I think the above scenario also applies to multiple deletes.
A while ago I tried to delete a pagefull (probably 50) and got the "system error" message. I didn't follow it through at the time as I was busy elsewhere in my code.

radz2k

"According to the technote the response form the server is not as expected." - Yes, the response from the server is not as expected, but it's obvious in this case, because server side can not handle the request while "action" parameter is missing.

The bug here is that while editing 34 rows "action" paramter in the sent request is included, but while editing 35 rows or more "action" parameter is missing.

allan

My guess is that your server isn't allowing that many parameters to be submitted. PHP has a max_input_vars parameter which you might well be hitting. Details on that parameter are available here.

Allan

radz2k

PHP has a max_input_vars parameter which you might well be hitting.

That was my first thought too as I mentioned in the report description:

My first thought was that the problem would be related eg. to the 'max_input_vars' variable in the php.ini settings, but it seems that "action" parameter is missing earlier, while posting by ajax.

radz2k

Thank you Allan, you've prompted me to re-check, and yes it was related to the max_input_vars. I had to forgot to restart Apache or sth. Btw. system error has occurred (More information) error is only present for DataTables-1.10.21, for latest version DataTables-1.11.3 there is a precise message Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0. I've missed this message, because after update to the latest version I was focused on the debugger, and the result was same as on the previous version.

allan

Super - good to hear you've got it now

Allan

tangerine

Can this specific error message also be applied to multiple deletes, which are still showing "system error" (although the correct error is shown in the error log)?

allan

Yes, it is possible as we send the row information that Editor knows about on delete, rather than just the row id's to be deleted. So it would be possible to hit a max_inputs_vars issue if you are doing a large number of deletes.

Allan