Topics order

[Migrated From Jforum.net]

I am using JForum 2.1.5/sqlserver 2000. For some reason there is no any particular order for posts and sticky message is not at the top. Is this bug?
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Anonymous wrote:I am using JForum 2.1.5/sqlserver 2000. For some reason there is no any particular order for posts and sticky message is not at the top. Is this bug?

Most definitely. I don't use that environment and am therefore unable to reproduce. Maybe someone like Cagin could provide some thoughts/advice?
[originally posted on jforum.net by fcgreg]

[Migrated From Jforum.net]

Somebody called my name

I'm working on sql server support, but for the time being I don't have any problems in post order, they are ordered ascending (latest post at the bottom). You may need to download latest sqlserver.sql from CVS.

I'm working on sqlserver.sql, and will post to Rafael as soon as I get a working copy.
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

OK, I changed some parts of sqlserver.sql file, and attached it to this message. Could you try this file? (Just download it and replace with the original one in \WEB-INF\config\database\sqlserver).

Let me know if it works...

7.11.05: Removed attached file sqlserver.sql. It was downloaded 20 times. See below for the new one.
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

Ok, added to the cvs!

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

[Migrated From Jforum.net]

Thanks! Still having problems...

Last message column is not descending order. Member Listing does not show other page than first.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Last message column is not descending order.

What do you mean by this?

Regarding to member listing page, could you try the files attached?

NOTE: In my local tests, first page of the Member Listing displays 9 users (when it is configured to display 10). I guess it doesn't display anonymous user. But next pages display correctly.
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

Changed
-------------------
TopicModel.selectAllByForumByLimit2 = t.topic_id \
FROM jforum_topics t, jforum_users u, jforum_posts p, jforum_posts p2, jforum_users u2 \
WHERE t.forum_id = ? \
AND t.user_id = u.user_id \
AND p.post_id = t.topic_first_post_id \
AND p2.post_id = t.topic_last_post_id \
AND u2.user_id = p2.user_id) \
ORDER BY t.topic_type DESC, t.topic_time ASC, t.topic_last_post_id ASC
-------------------
to
-------------------
TopicModel.selectAllByForumByLimit2 = t.topic_id \
FROM jforum_topics t, jforum_users u, jforum_posts p, jforum_posts p2, jforum_users u2 \
WHERE t.forum_id = ? \
AND t.user_id = u.user_id \
AND p.post_id = t.topic_first_post_id \
AND p2.post_id = t.topic_last_post_id \
AND u2.user_id = p2.user_id \
ORDER BY t.topic_type DESC, t.topic_time DESC, t.topic_last_post_id DESC \
) ORDER BY t.topic_type DESC, t.topic_last_post_id DESC, t.topic_time DESC \
-------------------

and now last created/replied message is topmost.

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

testing
[originally posted on jforum.net by Anonymous]