Seems installing the new Community Server :: Forums isn’t as ‘isolated’ as its documentation claims…

Ok, so any action you take against your database is your own responsibility… so this is my fault, but I’m still miffed.

I installed the new drop of the Forums code from Rob Howard and co… and one of the various bits of information I picked up from the support forum and the docs was that I could happily install this onto an existing database because (quoting from the readme here)… “All the objects in the Forums product use the forums_ prefix so there shouldn’t be any problem” . Whoops, guess they made a small mistake there, it should have been most of the objects use the forums_ prefix… their sql scripts happily drop any existing table named “Vote”… killing the vote table for my online polls… including all of the votes that had occured since my last export… ouch.

Now, as I said earlier, this is all my fault… I looked at a bit of the sql script and decided to trust the docs… which is a bit silly when it involves my own data… but perhaps learning about my folly will remind you to read any installation sql scripts carefully, even when they’ve been documented as safe…

Author: Duncan Mackenzie

I'm the Developer Lead for the Channel 9 team, formerly worked on MSDN as a developer, content strategist and author.

3 thoughts on “Seems installing the new Community Server :: Forums isn’t as ‘isolated’ as its documentation claims…”

  1. There are also some other objects without the forums prefix … I found this out while moving my webhosts earlier this week. Im actually really talking about the function HasReadPost.

Leave a Reply

Your email address will not be published. Required fields are marked *