Bug Fixes

BUG FIX: Read/Unread Flags 1.1

Bill Bosacker — Fri, 09 Mar 2007 21:42:04 GMT

UPDATE: This bug fix was incorporated into CS 2007 RTM and does not need to be added.

WARNING: This bug fix was written for CS 2.x RTM versions and CS 2007 BETA 1 only.

You should backup your current database and/or these stored procedures as standard practice before applying any code changes.

Please read the "CS: BUG FIX: Read/Unread Bug 1.1" blog post before downloading this patch. This patch is actually 2 different patches as described in the blog post. You will need to download the patches, decide which patch you need to run, and then run all of the sotred procedures in that patch against your database. Please be sure to post any comments that you have at the end of the blog post.

Differences between the 2 versions:

The proposed version will update the read flags for NNTP clients, while the current version does not.
If you are having issues with any "Mark as read" functionality (i.e. a forum was marked as read, then a single post was added and many of those threads are now showing unread), the proposed version may correct this.
If you are seeing any type of random wierdness related to the read status of posts, the proposed version may correct this.

The names of the stored procedures that have been added or changed in the current version are:

cs_forums_Post
cs_MarkThreadAsRead (new)

The names of the stored procedures that have been added or changed in the proposed version are:

cs_forums_Post
cs_forums_threads_ThreadsRead
cs_MarkThreadAsRead (new)
cs_Post_CreateUpdate
cs_Section_MarkRead

BUG FIXES: Themes

Bill Bosacker — Fri, 12 Jan 2007 07:33:34 GMT

This bug fix also re-adds some functionality to the forums that existed in CS 2.0, but was removed in CS 2.1. It includes 3 themes, "default", "basic blue", and "Genus Order" which is a modified "basic blue" theme that I use for the Genus Order web site. There were some major changes/fixes to the CSS files, so if you are expecting to only use some of the .ascx files, be aware that you may need to update your CSS files as well.

One thing that you will notice is that some of the "basic blue" .ascx files that were in the original CS 2.1 release are not included in this fix. The reason for that is that they are not needed. CS 2.1 added a new piece of functionality to themes. If the file doesn't exist in the theme being used, then it is pulled from the "default" theme. Since the "basic blue" theme did not need to change the functionality that was provided by some of the "default" theme files that it was overriding (after they were fixed), I removed them. The themes in this zip are complete and do not need any additional files to function.

Here is a final note about CS 3.0. From what I have seen thus far, the theming engine of CS 3.0 is going to be a thousand times easier to work with and you will actually be able to create/design almost every single page of the site (admin pages may be the exception). Telligent is just beginning to inform people about the changes and they are looking great.

BUG FIX: Read/Unread Flags 1.0

Bill Bosacker — Thu, 21 Dec 2006 07:40:37 GMT

UPDATE 03/09/2007 @ 02:00pm PT
There is a new patch "BUG FIX: Read/Unread Flags 1.1" available for download. This download is now obsolete.

UPDATE 03/08/2007 @ 02:30pm PT
We are working on a new version of this fix as there were some misunderstandings as to what was actually checked in on 03/01/2007. The next update will take care of the last performance issue and is recommended for all CS 2.x and CS 2007 BETA 1 sites. Also, this will not work for any version after CS 2007 BETA 1 as the code that code is no longer compatable due to some changes to views.

UPDATE 03/01/2007
Jose Lema contacted me to incorporate this bug fix into CS 2007. After a few emails going back and forth, we made a few slight changes that will hopefully reduce the load on very large databases. I have changed this download to incorporate those changes and ask that you report any feedback you have in regards to this bug fix. If you have made any changes to these stored procedures, or have any addons that have changed these stored procedures, you will need to incorporate those changes manually.

WARNING: This bug fix was written for CS 2.1 SP2 and CS 2007 BETA 1. It has not been tested on any other version, but should work for any CS 2.x release version.

You should backup your current database and/or these stored procedures as standard practice before applying any code changes.

This bug fix corrects the non-functioning read/unread flags in the forums. It corrects issues in 4 different stored procedures. Download the attachment and execute the SQL script against your CommunityServer database to update the scripts. The names of the stored procedures that have been changed are:

cs_forums_Post
cs_forums_threads_ThreadsRead
cs_Post_CreateUpdate
cs_Section_MarkRead