CS Nuggets

This blog is for addons, bugs, fixes, and issues pertaining to Community Server.

CS: BUG FIX: Forum Read/Unread Flags

UPDATE 03/01/2007: Click here for the latest update 

This bug fix corrects the non-functioning read/unread flags in the forums.  It corrects issues in 4 different stored procedures in CS 2.1 SP2.  It has not been tested in a CS 2.1 RTM or CS 2.1 SP1 environment as I don't currently have either enviroment to test it on.  The names of the stored procedures that have been changed are:

  • cs_forums_Post
  • cs_forums_threads_ThreadsRead
  • cs_Post_CreateUpdate
  • cs_Section_MarkRead

UPDATE 01/08/2007:  While working with Shaan and his very large database, I have identified some performace issues and some issues with 3rd party patches or addons.  If you have a 3rd party patch/addon, you will need to incorporate those changes into this bug fix.  If you have any problems or questions, please contact me.

If you have a small to medium sized database, you should not have any problems with the fix that is currently available.  However, if you have a large database, please contact me before you attempt to implement this bug fix.  With Shaan's help, things are looking good and I hope to post an update soon.

WARNING: This bug fix was written for CS 2.1 SP2 and has not been tested on any other version. 

You should backup your current database and/or these stored procedures as standard practice before applying any code changes.  Click here to download the latest version of the bug fix.

Posted: Fri, Dec 8 2006 12:00 AM by Bill Bosacker | with 6 comment(s) |

Comments

CADman said:

I hope Telligent takes this fix as well as your other bug fixes for the next CS release. Thank you for the excellent work!

# December 30, 2006 3:22 PM

Bill Bosacker said:

Thanks CADman,

I believe that Dave entered into their bug tracking system, so we'll see what happens with CS 3.0.  I'm not sure if there is going to be another service pack before it is released, so we have to just wait an see on that as well.

Take it easy,

Bill

# December 30, 2006 3:38 PM

CADman said:

Bill,

I had to roll back the changes due to a problem that popped up when users were logging in or trying to use the NotRead.aspx as it caused exceptions on my CS 2.1 Sp2 .NET 1.1. Shoot me an email if you want to discuss more details. I did notice however the icons were for once in a very very longtime working as expected but the side effect exceptions cause me to sadly roll back.

Shaan

# December 30, 2006 7:17 PM

Bill Bosacker said:

Well, it appears that we have fixed Shaan's issue.  He is using the NNTP Gateway addon and a 3rd party made some changes to one on the stored procedures that I fixed, to correct some issues with the gateway.  Once those changes were added to to my corrections, everything worked.

# December 31, 2006 3:28 PM

Bill Bosacker said:

UPDATE:  While working with Shaan and his very large database, I have identified some performace issues and some issues with 3rd party patches or addons.  If you have a 3rd party patch/addon, you will need to incorporate those changes into this bug fix.  If you have any problems or questions, please contact me.

If you have a small to medium sized database, you should not have any problems with the fix that is currently available.  However, if you have a large database, please contact me before you attempt to implement this bug fix.  With Shaan's help, things are looking good and I hope to post an update soon.

# January 8, 2007 1:53 PM

Bill Bosacker said:

UPDATE 03/01/2007:

The download has been updated to the version that has been incorporated into CS 2007.  There is a new blog post about the changes, but it should now be compatible with very large databases.  Please take a look at the new post and be sure to read all of the download information.

# March 1, 2007 12:50 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)