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