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

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

radz2kradz2k Posts: 8Questions: 1Answers: 0

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

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 20,142Questions: 26Answers: 4,736

    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

  • tangerinetangerine Posts: 3,342Questions: 35Answers: 394

    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.

  • radz2kradz2k Posts: 8Questions: 1Answers: 0

    "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.

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Answer ✓

    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

  • radz2kradz2k Posts: 8Questions: 1Answers: 0

    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.

  • radz2kradz2k Posts: 8Questions: 1Answers: 0
    edited November 2021

    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.

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin

    Super - good to hear you've got it now :)

    Allan

  • tangerinetangerine Posts: 3,342Questions: 35Answers: 394

    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)?

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin

    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

Sign In or Register to comment.