Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogError when upgrading to v4.01.00Error when upgrading to v4.01.00
Previous
 
Next
New Post
2/28/2011 6:17 PM
 
  • DotNetNuke Version: 5.5.1 (community edition)
I today upgraded my DNN Blog module from v4.0.1 to the (just released) v04.01.00. The following error emerged during the install of the v4.1 blog module. It seems to relate to the Active Forums module ("activeforums_Security_ModLock") which is also installed in my portal. I note that, despite this error, the installation ended with the words "installation successful". I also note that already existing blog entries created with the blog module are being built correctly after this istallation. 

Is this a problem of the blog module or the Active Forums module? SHoudl I roll back to v4.0.0?

Info Start Sql execution: 04.01.00.SqlDataProvider file
Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Constraint 'DF_activeforums_Security_ModLock' does not belong to table '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) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*************** TABLES ************************/ 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.Blog_Blogs DROP CONSTRAINT ' + @defname EXEC(@cmd) System.Data.SqlClient.SqlException (0x80131904): The object 'DF_Blog_Blogs_EnableTwitterIntegration' is dependent on column 'EnableTwitterIntegration'. ALTER TABLE DROP COLUMN EnableTwitterIntegration failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Blog_Blogs DROP COLUMN [EnableTwitterIntegration]
Info End Sql execution: 04.01.00.SqlDataProvider file
 
New Post
3/1/2011 1:51 PM
 
Yes, the same here. Exactly the same error. Although after installation it says the install was successful....?!?
 
New Post
3/1/2011 2:26 PM
 
Sorry, I've just looked at my error which I saved but couldn't find earlier.

Here is my error:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Constraint 'DF_intranetdigitalmagiccouk_Forum_Posts_ParseInfo' does not belong to table 'intranetdigitalmagiccouk_Blog_Blogs'. Could not drop constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*************** TABLES ************************/ 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.intranetdigitalmagiccouk_Blog_Blogs DROP CONSTRAINT ' + @defname EXEC(@cmd) System.Data.SqlClient.SqlException: The object 'DF_intranetdigitalmagiccouk_Blog_Blogs_EnableTwitterIntegration' is dependent on column 'EnableTwitterIntegration'. ALTER TABLE DROP COLUMN EnableTwitterIntegration failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.intranetdigitalmagiccouk_Blog_Blogs DROP COLUMN [EnableTwitterIntegration]

 
New Post
3/2/2011 5:46 AM
 
This is the same error I allready posted on this thread http://www.dotnetnuke.com/Resources/F...



The issue didn't block the install of the Module.  At time I didn't clearing if the proberties for the Blogmodule are deleted well or if the sql process running correct for the blog module. 

The problem is that the proberty to delete the coloumn "EnableTwitterIntegration" is not detailed specified for the Blog module only!   The script is into the 04.01.00.SqlDataProvider locaded.

 
New Post
10/30/2011 1:01 AM
 
any update on this? I just ran into the same issue, upgrading a site's Blog module. Do I need to roll back the upgrade or is there a fix?

Thanks,
William
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogError when upgrading to v4.01.00Error when upgrading to v4.01.00


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out