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