While installing the DNN BLog 4.1 today, I ran across this Sql Error:















System.Data.SqlClient.SqlException: Constraint 'DF_dnn_Forum_Posts_ParseInfo' does not belong to table 'dnn_Blog_Blogs'. Could not drop constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)







...







DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SELECT @defname = sc.name FROM sys.columns st JOIN sys.default_constraints sc ON st.column_id = sc.parent_column_id WHERE st.name = 'EnableTwitterIntegration' SET @cmd = 'ALTER TABLE dbo.dnn_Blog_Blogs DROP CONSTRAINT ' + @defname EXEC(@cmd)















This error occurs because of a bad join in the start of the 4.1 sql script, which joins up random columns and constraints in the database, and tries to drop constraints that aren't on the dnn_Blog_Blogs table.















After a bit of examination, I worked out the fix.















1. If you have installed the module and received this error - the module will still be installed, so you need to fix the script manually.







2. Find the 04.01.00.SqlDataProvider file from the blog install package.  YOu will need to unzip the install package to get this file







3. Open up this file in notepad or other text editor







4. Go to your host->sql page







5. Fix up the script, by finding this section:















SELECT @defname = sc.name







FROM sys.columns st JOIN sys.default_constraints sc







ON st.column_id = sc.parent_column_id







WHERE st.name = 'EnableTwitterIntegration'















and replace it with this Sql instead (copy paste and overwrite above section only)















SELECT @defName = sc.name







FROM sys.columns st JOIN sys.default_constraints sc







ON st.column_id = sc.parent_column_id







inner join sys.objects so







 on sc.parent_object_Id = so.object_id







WHERE so.Name = '{objectQualifier}Blog_BLogs'







 and st.Name = 'EnableTwitterIntegration'















6. Copy/Paste the entire contents on the 04.01.00.SqlDataProvider (including your fix) into the host->sql window







7. Check the 'execute as script' box







8. Click the execute link.















If all has gone well, your script will run without issue.