Watchlist.php only removes 1000 topics at once

[NotATether]

I am trying to clear my watchlist and keep only the topics I want, since I can't change the threads in "Show new replies to your posts". But I think I've run into a bug - I can't remove more than 1000 or so topics at once, even if I click "check all" and then "remove checked". Is this a forced limitation to avoid making the database a bottleneck?

[TryNinja]

Probably... The page is a bit unusable (lag) with how many items I have, around 59196 topics.

You can run this on your console to see how many you have:

Code:

document.querySelectorAll('input[type="checkbox"][name="topics[]"]').length;

theymos should probably add some pagination system to not overload both the client and the server. I could probably make a script that does removes them in chunks.

[PX-Z]

I am trying to clear my watchlist and keep only the topics I want, since I can't change the threads in "Show new replies to your posts". But I think I've run into a bug - I can't remove more than 1000 or so topics at once, even if I click "check all" and then "remove checked". Is this a forced limitation to avoid making the database a bottleneck?

How did you know that it's already 1000 or more? did you make a script to get those numbers? I have tested it upon writing this post, "select all" then "remove checked" it works, although a bit slower since it's so many list there.

[Donneski]

I am trying to clear my watchlist and keep only the topics I want, since I can't change the threads in "Show new replies to your posts". But I think I've run into a bug - I can't remove more than 1000 or so topics at once, even if I click "check all" and then "remove checked". Is this a forced limitation to avoid making the database a bottleneck?

Op, I don't think this is actually a bug, it’s a common PHP limit. Most servers only accept around 1000 form inputs at once so anything beyond that gets ignored. That’s why you can’t clear your whole watchlist in one go.

Quick fixes: try removing them in smaller batches (800–900 at a time) or maybe you should ask Theymos to increase the

Code:

max_input_vars

setting so the form can handle more checkboxes in one submission.

This I understand can be very annoying but it’s an easy server-side fix.