..not an expert here, but perhaps try the latest AF version? 4.3.4.. see if that helps. drew..

This issue occurs when the sort order values get corrupted in the database. If you would like to create a Help Desk ticket Jozef, I can discuss with you the details of your database.

http://www.activemodules.com/Commun...pdesk.aspx

Sounds similar to the bug I reported back in May of 2010: http://www.activemodules.com/active...ering-bug/

There is a workaround/fix in that thread. Use at your own risk.

I also am unable to re-order the forums, and it is very annoying to our users.  Also, I really don't care to about whether the cause is a bug or a database corruption.

I have reviewed the threads on this issue (e.g.,
http://www.activemodules.com/active...ring-bug/) but I do not see what the fix is.

Can an AF representative please post the fix?

Thank you.

I am having the same issue. Was the fix published somewhere? using AF 4.3.6

The only way to fix it is manually checking the database, and then resolving any problems. This is a brief overview of the problem, PLEASE do not run ANY SQL queries without first creating a backup of your site and database.

The most common problems are:

1. Sort orders with gaps (0,1,2,3,6,7,8)
2. Sub-Forums that belong to deleted forums
3. Forums with sub-forums next to forums with sub-forums. They can not be moved to replace one another.
4. Sort order duplications (0,1,2,3,3,4,5) - However there may be duplicated values as long as they have a different ForumGroupId or ParentForumId
5. Forums that belong to deleted groups

Run this query, replacing the # with the appropriate values:

SELECT ForumId, ForumGroupId, ParentForumId, ForumName, SortOrder FROM dbo.activeforums_Forums WHERE PortalId = '#' AND ModuleId = '###' ORDER BY ForumGroupId, SortOrder

This will give you a list of all the forums, in the same order that they are displayed in the module. Now you can check for those common problems. It may help to look in the control panel at exactly which forum you can not move up or down, then in the database look around this forum for the anomaly.

1. The sort order should always start with 0. They may restart at zero whenever there is a different forum group. This example would be for 5 forum groups total: (0,1,2,3,0,1,2,0,0,0,1,2,3,4,5) if there is a missing number, then the values will need to be changed until they are sequential.

2. Look at the ParentForumId column. Any zero means it is a regular forum. Any non-zero is a sub-forum. Sub-forums should appear directly below their parent forum in the list. If there is a sub-forum with a parentForumId that does not match an existing parent forum's ForumId then it will need to be changed or deleted.

3. The only way to resolve this would be to completely update the SortOrder column manually to move the forums to the order you desire. Problems moving forums with sub-forums to take the place of another forum w/ sub-forum is a limitation of the module that will be resolved in a future version.

4. Similar to issue one, look at the SortOrder column. The only number that should appear twice in a row is zero.

5. I have only seen this happen once, but the ForumGroupId value must match the GroupId an existing group in the activeforums_Groups table.

Any customers with an active Enterprise support agreement can send me a PM and I will resolve these issues in their database.

Thanks Ben!!!!!! Just what I needed.