|
kgrimsby
New Member
USA
72 Posts |
 Posted - 16 November 2001 : 01:45:45
|
Moved here by HuwR
This is not a BUG, but has affected many people, so posting the scripts for peoples use.
This bug applies only to SQL Server databases.
When you update the properties of a forum, all replies to topics in that forum move to a single topic. This problem is very serious, since a single update can result in the misplacement of thousands of messages (which has happened to me and to many other users).
This problem has been discussed in this topic:
- Replies under wrong topic
The cause of the problem is that triggers in the SQL Server database perform a cascading update of the TOPICS and REPLY tables after the properties of the FORUM table have been updated in post_info.asp.
Only the following users of the Snitz Forums will have these triggers in their SQL Server database:
- Anyone who began using SQL Server with Snitz Forums 3 Final. The setup script supplied with that version of Snitz inserted the problematic triggers.
- Anyone who has upsized from Access to SQL Server. The upsizing wizard also inserts the problematic triggers.
These users will experience the mass migration of messages as soon as they enable the new features of the current version of Snitz, such as Subscribe to Topic. Any modification of a forum property results in the immediate migration of messages to a single topic.
I have written a script that deletes all triggers from the forum tables. I have posted the script to this topic:
- Upgrading "old" database
This script should be incorporated into the setup page as soon as possible, in order to prevent the mass migration of messages when users upgrade.
It would also be a good idea to provide this script as a separate download, to be applied even if the user isn't going to upgrade. All users in the two categories above will experience database corruption as soon as they modify a forum property, even if they have not upgraded to latest version.
Ken Grimsby |
|
Topic Locked
