While preparing to upgrade this blog from Subtext 1.5.2 to the latest 1.9.2 bits I discovered a bug in the Upgrade process - I hope you all made a backup of your database like Phil suggested!

Impact

When upgrading to 1.9.2 we move all comments and track/ping backs out of the subtext_Content database table, into the new subtext_Feedback table. All of the feedback items to get moved over to the new table, but it appears that some of the comments get transformed into trackbacks. DOH!

I've just checked in a fix, but I'll need to coordinate an updated release with Phil. Until we're able to release an updated version, I'd advise against upgrading to 1.9.2 as some of your comments may get turned into trackbacks.

Already Upgraded?

I did a little analysis of the data in the subtext_Feedback table and found that real trackbacks (not comments that were mistaken for trackbacks) don't have an associated IP Address. So, you should be able to run the following query against your 1.9.2 Subtext database and revert the transformed trackbacks to comments.

UPDATE subtext_FeedBack 
SET FeedbackType = 1 
WHERE FeedbackType = 2 AND 
  (NOT IpAddress IS NULL AND LEN(IpAddress) > 0)

Be Advised: Use this script at your own risk! I've tested it a few times and it seems to work exactly as expected - but you should still be sure to make a backup before trying this.

Next Steps

Stay tuned to this post as I'll be sure to post any news and/or updates regarding the bug.

I just pushed the latest bits out to the SourceForge download site - so go grab them here. Also, check out my Subtext 1.9.2.30 release announcement here for more details.