Win a copy of Terraform in Action this week in the Cloud forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Topics order

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok, added to the cvs!

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
testing
[originally posted on jforum.net by Anonymous]
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic