Low Reorder with > 1500 entries
I am having difficulty getting Low Reorder to save the correct order when dealing with very large numbers of entries. We are using Low Reorder to manage three channels which currently have a collective 1,579 entries (and growing). When I create the set, the exp_low_reorder_orders row for the set contains the correct number of entries in the sort_order field; however, as soon as I reorder the set, only 996 entries appear in the sort_order field - the first 583 entries shown in the reorder panel are completely missing from the database. Additionally, every time I save the set, the order changes; whichever entry was at position 1167 in the reorder panel suddenly shows up at the top of the display, while whichever was previously at the top of the display, shifts down to position 584 and is now listed as the first item in the sort_order field.
Interesting to note is that if I manually change the sort_order field after creating the set, but before saving it through the control panel, everything works as expected on the front-end, and the control panel displays the correct order. As soon as I save from the control panel, though, the problem returns.
I am using Low Reorder 2.3.0 on EE 2.9.2
Replies
Low 7 Mar 2015 09:03
I think you might be hitting the max_input_vars limit, which defaults to 1000. You should be able to overwrite that value in your .htaccess file:
However, I would recommend you somehow reduce the number of entries in a set, as this will get quite unwieldy.
LanceJohnson 7 Mar 2015 15:33
Indeed, that does fix the problem. I agree with you, a more restricted set would be better. It has already become unwieldy, but the client insists that they need to be able to re-order everything in the system. Thanks for the support.