Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 V33(.02)+V33(.03) BUG+FIX Active.asp behavior
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 26 August 2001 :  07:03:17  Show Profile
I witnessed some weird behavior on active.asp this morning

gor
Retired Admin

Netherlands
5511 Posts

Posted - 26 August 2001 :  14:38:20  Show Profile  Visit gor's Homepage
BUG

When the Category and Forum ordering was introduced, the sorting of the active topics was also changed.
But when that was done, the forum-id was removed from the sort statement.
That was wrong, since it wasn't only used for sorting the topics, but also to group them together, so that all topics from the same forum were after each other.

FIX

Add the forum-id back to the sort.

In Active.asp change this line:

strSql = strSql & " ORDER BY C.CAT_ORDER, F.F_ORDER, T.T_LAST_POST DESC;"

to:

strSql = strSql & " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC "


Pierre
Join a Snitz Mailinglist
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 07 November 2001 :  15:17:17  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
fix in 3.4

---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 24 November 2001 :  11:42:10  Show Profile
Fixed in [v40b03patch001]...

Think Pink
Test Site not ready yet | Post v40b03 Patches
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000 Version 3.4.07