Other way to reorder forums other than Ajax drag and drop?

[PPlanet]

Hi, I've recently upgraded from 3.4.5 to 4.2.7. I have thousands of subforums and while it has been less of a problem than what I imagined to deal with them for 4.2.7 in terms of loading the forum index, etc. I've just run into a tricky one using the ACP. My forum has a deep structure with few subforums at the top levels, and most of them in the deepest ones.

Tonight I created a new subforum as a child of one the biggest ones, and when I went to reorder it, I got a nasty message:

"Request-URI Too Long
The requested URL's length exceeds the capacity limit for this server."

Indeed the url I copied from the browser's address bar is over 10,000 characters. I have already opened a ticket with my host to see if the limit can be increased but I'm not feeling optimistic at this stage. (I think that apart from server limits, there are browser limits too)

So, my question is if any other way of reordering subforums exists (eg. query)

Thanks in advance.

 

 

[Nathan Explosion]

Get hacky with the database - 'forums_forums' table, 'position' column.

[PPlanet]

Hi Nathan, looks a bit daunting. But databases always scare me

If I changed the position of one forum there, wouldn't I need to change the position of all others that follow?

[Nathan Explosion]

17 minutes ago, PPlanet said:

If I changed the position of one forum there, wouldn't I need to change the position of all others that follow?

Yes.

[PPlanet]

I guess that rules it out. If everything else fails I guess I will subdivide the amount of subforums I have under the same parent (in other words, create a few more parents and spread them around so they are few of them in each). Cheers.