Category with the same display_order disapeared in admin panel

[Migrated From Jforum.net]

In the CVS version, after I re-save the permission for each group, I can see the Category list and Foum list. Then I try to move up and down the Category item. The origial sequence of category item I created was, eg:
A, B, C. They are displayed as B, A, C. So, first I click the "up" button to move up A. Then A disapeared from the Category list.

I checked the database, now A and B has the same display_order = 1.

I manually update back their value to 1, 2, 3 and the Category list becomes normal. I think this is a bug.

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

The above post is made by me.

PS. Those categoried was created first in version 2.0.2's admin panel.
So, I don't know if category created by CVS will meet this bug.
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

2.0.2 has a bug with the order of categories. Run this command in your sql client:

UPDATE jforum_categories SET display_order = categories_id;

Then restart your servlet-container. It should do the job.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Great job with jforum!
I've stumbled on this same issue of ordering categories and forums. I'm using the built-in hsql database. Is there still a way to run the command line to fix this ordering bug? I don't believe there is an sql client included with hsql?

Please advise
Thanks!
[originally posted on jforum.net by Didas]

[Migrated From Jforum.net]

Yep, there is. Go do WEB-INF/config/database/hsqldb directory, using the command line, and then type

java -jar ..\..\..\hsqldb-xxx.jar org.hsqldb.util.DatabaseManagerSwing

then, choose "Standalone" and, int he connection string, put the database name you're using.

Rafael
[originally posted on jforum.net by Rafael Steil]