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

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Could not drop object 'dbo.Blog_Entries' because it is referenced by a FOREIGN KEYCould not drop object 'dbo.Blog_Entries' because it is referenced by a FOREIGN KEY
Previous
 
Next
New Post
11/18/2012 9:59 AM
 

I recently upgraded a DNN 5 site to DNN 6.2.4.

I tried to upgrade the blog module but there was an error (I don't remember the error unfortunately), but I had this in my clipboard history from when I tried to uninstall the blog module.

(I ultimately reverted the site to a backup so I still have the old blog module (3.4.1) on the new DNN site (6.2.4).

If I encounter this error again, should I just delete the Blog_Entries table from the database?  I'm not sure the blog module was ever even in use or added to a page in the past on this site.

Thanks!

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.Blog_Entries' because it is referenced by a FOREIGN KEY constraint. 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) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.Blog_Entries') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table dbo.Blog_Entries






Info Reading Component Manifest - Script
Info Reading Component Manifest - Cleanup
Info Reading Component Manifest - Module
Info Module Manifest read successfully
Info Reading Component Manifest - Assembly
Info Reading Component Manifest - File
Info Reading Component Manifest - ResourceFile
StartJob Starting Package Uninstall
Info Starting Package Uninstall - DotNetNuke.Blog
Info Starting Component Uninstall - Script
Info Begin Sql UnInstall
Info Deleted - 01.00.00.SqlDataProvider
Info Deleted - 01.00.01.SqlDataProvider
Info Deleted - 01.00.02.SqlDataProvider
Info Deleted - 01.00.03.SqlDataProvider
Info Deleted - 03.00.00.SqlDataProvider
Info Deleted - 03.00.01.SqlDataProvider
Info Deleted - 03.01.04.SqlDataProvider
Info Deleted - 03.01.07.SqlDataProvider
Info Deleted - 03.01.12.SqlDataProvider
Info Deleted - 03.01.15.SqlDataProvider
Info Deleted - 03.01.20.SqlDataProvider
Info Deleted - 03.01.21.SqlDataProvider
Info Deleted - 03.03.00.SqlDataProvider
Info Deleted - 03.03.01.SqlDataProvider
Info Deleted - 03.04.00.SqlDataProvider
Info Deleted - 03.05.00.SqlDataProvider
Info Deleted - 03.05.01.SqlDataProvider
Info Executing Uninstall.SqlDataProvider
Info Start Sql execution: Uninstall.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.Blog_Entries' because it is referenced by a FOREIGN KEY constraint. 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) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.Blog_Entries') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table dbo.Blog_Entries
Info End Sql execution: Uninstall.SqlDataProvider file
Info Deleted - Uninstall.SqlDataProvider
Info End Sql UnInstall
Info Component uninstalled successfully - Script
Warning Component Uninstalled with Warnings - Script
Info Starting Component Uninstall - Cleanup
Info Component uninstalled successfully - Cleanup
Info Component Uninstall Successful - Cleanup
Info Starting Component Uninstall - Module
Info Module un-registered successfully - Blog
Info Component uninstalled successfully - Module
Info Component Uninstall Successful - Module
Info Starting Component Uninstall - Assembly
Info Assembly unregistered - bin\DotNetNuke.Modules.Blog.dll
Info Deleted - bin\DotNetNuke.Modules.Blog.dll
Info Assembly unregistered - bin\DotNetNuke.Modules.Blog.SqlDataProvider.dll
Info Deleted - bin\DotNetNuke.Modules.Blog.SqlDataProvider.dll
Info Assembly unregistered - bin\CookComputing.XmlRpc.dll
Info Deleted - bin\CookComputing.XmlRpc.dll
Info Component uninstalled successfully - Assembly
Info Component Uninstall Successful - Assembly
Info Starting Component Uninstall - File
Info Deleted - MainView.ascx
Info Deleted - BlogList.ascx
Info Deleted - BlogFeed.ascx
Info Deleted - Blog.ascx
Info Deleted - ViewBlog.ascx
Info Deleted - EditBlog.ascx
Info Deleted - EditEntry.ascx
Info Deleted - ViewEntry.ascx
Info Deleted - Archive.ascx
Info Deleted - Search.ascx
Info Deleted - trackback.aspx
Info Deleted - ModuleOptions.ascx
Info Deleted - module.css
Info Component uninstalled successfully - File
Info Component Uninstall Successful - File
Info Starting Component Uninstall - ResourceFile
Info Deleted - App_LocalResources/Archive.ascx.resx
Info Deleted - App_LocalResources/Blog.ascx.resx
Info Deleted - App_LocalResources/BlogList.ascx.resx
Info Deleted - App_LocalResources/blogpost.ascx.resx
Info Deleted - App_LocalResources/EditBlog.ascx.resx
Info Deleted - App_LocalResources/EditEntry.ascx.resx
Info Deleted - App_LocalResources/ModuleOptions.ascx.resx
Info Deleted - App_LocalResources/Search.ascx.resx
Info Deleted - App_LocalResources/Trackback.aspx.resx
Info Deleted - App_LocalResources/ViewBlog.ascx.resx
Info Deleted - App_LocalResources/ViewEntry.ascx.resx
Info Folder Deleted - App_LocalResources
Info Deleted - Images/bookmarks/i_ask.gif
Info Deleted - Images/bookmarks/i_backflip.gif
Info Deleted - Images/bookmarks/i_bl.gif
Info Deleted - Images/bookmarks/i_blogbuzz.jpg
Info Deleted - Images/bookmarks/i_bluedot.gif
Info Deleted - Images/bookmarks/i_bm.gif
Info Deleted - Images/bookmarks/i_co_mments.gif
Info Deleted - Images/bookmarks/i_delicious.gif
Info Deleted - Images/bookmarks/i_delirious.gif
Info Deleted - Images/bookmarks/i_digg.gif
Info Deleted - Images/bookmarks/i_fark.gif
Info Deleted - Images/bookmarks/i_fav_ie.gif
Info Deleted - Images/bookmarks/i_feedmelinks.gif
Info Deleted - Images/bookmarks/i_furl.gif
Info Deleted - Images/bookmarks/i_google.gif
Info Deleted - Images/bookmarks/i_linkagogo.gif
Info Deleted - Images/bookmarks/i_magnolia.gif
Info Deleted - Images/bookmarks/i_msn.gif
Info Deleted - Images/bookmarks/i_netvouz.gif
Info Deleted - Images/bookmarks/i_ns.gif
Info Deleted - Images/bookmarks/i_nv.gif
Info Deleted - Images/bookmarks/i_pluck.gif
Info Deleted - Images/bookmarks/i_rawsugar.gif
Info Deleted - Images/bookmarks/i_reddit.gif
Info Deleted - Images/bookmarks/i_rojo.gif
Info Deleted - Images/bookmarks/i_shadows.gif
Info Deleted - Images/bookmarks/i_simpy.gif
Info Deleted - Images/bookmarks/i_spurl.gif
Info Deleted - Images/bookmarks/i_stumble.gif
Info Deleted - Images/bookmarks/i_technorati.gif
Info Deleted - Images/bookmarks/i_tr.gif
Info Deleted - Images/bookmarks/i_wink.gif
Info Deleted - Images/bookmarks/i_yahoo.gif
Info Deleted - Images/bookmarks/required.gif
Info Folder Deleted - bookmarks
Info Deleted - Images/approve.gif
Info Deleted - Images/blog_accept.png
Info Deleted - Images/blog_comments.png
Info Deleted - Images/blog_comment_tip.gif
Info Deleted - Images/blog_comment_tip_owner.gif
Info Deleted - Images/blog_edit_link.png
Info Deleted - Images/blog_print.png
Info Deleted - Images/blog_tag_blue.png
Info Deleted - Images/blog_topic.png
Info Deleted - Images/blog_trackback.png
Info Deleted - Images/clip-bottom.png
Info Deleted - Images/clip-top.png
Info Deleted - Images/Delete_File.gif
Info Deleted - Images/feed-icon-12x12.gif
Info Deleted - Images/feed-icon-24x24.gif
Info Deleted - Images/folder_closed.gif
Info Deleted - Images/folder_item.gif
Info Deleted - Images/folder_opened.gif
Info Deleted - Images/grayman.png
Info Deleted - Images/identicon.png
Info Deleted - Images/indicator.white.gif
Info Deleted - Images/monsterid.png
Info Deleted - Images/not_approved.gif
Info Deleted - Images/tree_item.gif
Info Deleted - Images/wavatar.png
Info Deleted - Images/xml.gif
Info Deleted - Images/xml_small.gif
Info Deleted - Images/xml_small_warning.gif
Info Deleted - Images/xml_warning.gif
Info Deleted - Images/yourimagehere.png
Info Folder Deleted - Images
Info Deleted - js/bookmarks.js
Info Deleted - js/bookmarks.xml
Info Deleted - js/md5.js
Info Folder Deleted - js
Info Deleted - ShareBadge/css/ShareBadge.css
Info Folder Deleted - css
Info Deleted - ShareBadge/images/i_ask.png
Info Deleted - ShareBadge/images/i_backflip.png
Info Deleted - ShareBadge/images/i_blinklist.gif
Info Deleted - ShareBadge/images/i_blogbuzz.jpg
Info Deleted - ShareBadge/images/i_bluedot.png
Info Deleted - ShareBadge/images/i_bm.gif
Info Deleted - ShareBadge/images/i_co_mments.gif
Info Deleted - ShareBadge/images/i_delicious.gif
Info Deleted - ShareBadge/images/i_delirious.png
Info Deleted - ShareBadge/images/i_digg.gif
Info Deleted - ShareBadge/images/i_dotnetkicks.gif
Info Deleted - ShareBadge/images/i_facebook.gif
Info Deleted - ShareBadge/images/i_fark.png
Info Deleted - ShareBadge/images/i_feedmelinks.png
Info Deleted - ShareBadge/images/i_furl.gif
Info Deleted - ShareBadge/images/i_google.gif
Info Deleted - ShareBadge/images/i_linkagogo.png
Info Deleted - ShareBadge/images/i_live.gif
Info Deleted - ShareBadge/images/i_magnolia.gif
Info Deleted - ShareBadge/images/i_netscape.gif
Info Deleted - ShareBadge/images/i_netvouz.png
Info Deleted - ShareBadge/images/i_newsvine.gif
Info Deleted - ShareBadge/images/i_pluck.gif
Info Deleted - ShareBadge/images/i_rawsugar.png
Info Deleted - ShareBadge/images/i_reddit.gif
Info Deleted - ShareBadge/images/i_rojo.gif
Info Deleted - ShareBadge/images/i_shadows.png
Info Deleted - ShareBadge/images/i_simpy.png
Info Deleted - ShareBadge/images/i_spurl.png
Info Deleted - ShareBadge/images/i_stumble.gif
Info Deleted - ShareBadge/images/i_tailrank.gif
Info Deleted - ShareBadge/images/i_technorati.gif
Info Deleted - ShareBadge/images/i_wink.png
Info Deleted - ShareBadge/images/i_yahoo.gif
Info Folder Deleted - images
Info Deleted - ShareBadge/js/ShareBadgeChicklets.js
Info Deleted - ShareBadge/js/ShareBadgePro.js
Info Folder Deleted - js
Info Deleted - ShareBadge/ShareBadgePro.html
Info Folder Deleted - ShareBadge
Info Deleted - blogpost.ashx
Info Deleted - blogpostredirect.aspx
Info Deleted - wlwblog.xml
Info Deleted - DNN_Blog_Resources.zip.manifest
Info Component uninstalled successfully - ResourceFile
Info Component Uninstall Successful - ResourceFile
Warning Uninstalled with Warnings - DotNetNuke.Blog
EndJob Uninstalled with Warnings


 
New Post
11/18/2012 1:31 PM
 
did you install any addon relying on DNN blog (some kind of content aggregator or sth like this)?

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/18/2012 4:51 PM
 

No I didn't.  There were no 3rd party modules.

 
New Post
11/18/2012 5:43 PM
 

Well, I uninstalled it successfully.

I reverted back to 6.2.4 before I tried to upgrade the Blog Module.

Then I just uninstalled it without issues.

Perhaps it was because I first tried to upgrade the blog module... and when that failed, I couldn't uninstall it.


 
New Post
11/19/2012 12:41 PM
 
With Microsoft SQL Management studio you must to connect to your database and delete all blogs table and blogs stored procedure.
After this, you can install the blog module
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Could not drop object 'dbo.Blog_Entries' because it is referenced by a FOREIGN KEYCould not drop object 'dbo.Blog_Entries' because it is referenced by a FOREIGN KEY


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