Unhandled SqlException Invalid column name 'ModeratedBy'.

Oct 13, 2009 at 6:14 PM

I just downloaded the latest copy of BE from the trunk and ran the SQL setup scripts MSSQLSetup1.5.0.0.sql so I could use a db backed site instead of XML however on my first run I get Unhandled SqlException Invalid column name 'ModeratedBy'.for table be_PostComment which I can clearly see does not have a ModeratedBy field in the db.

Oct 13, 2009 at 8:53 PM

There is a line added in the MSSQLUpgradeToNEXT.sql script. This is where latest SQL updates that not a part of 1.5 release.

ALTER TABLE dbo.be_PostComment ADD ModeratedBy nvarchar(100) NULL