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...Administration ...Administration ...Exception deleting portalsException deleting portals
Previous
 
Next
New Post
5/3/2014 7:23 AM
 

I'm trying to delete a couple of test portal from Host > Site Management but I receive the following exception (and no portal is deleted). Also I noticed the use of PetaPoco! Is PetaPoco already integrated in DNN? this would be a great news for module development (I love it)

Errore: Site Management non è attualmente disponibile. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dbo.mcl_Workflows'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.mcl_Workflows'. in System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) in System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) in System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in PetaPoco.Database.Execute(String sql, Object[] args) in DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args) in DotNetNuke.Data.DataProvider.DeletePortalInfo(Int32 PortalId) in DotNetNuke.Entities.Portals.PortalController.DeletePortalInfo(Int32 portalId) in DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) in DotNetNuke.Modules.Admin.Portals.Portals.OnGridDeleteCommand(Object source, GridCommandEventArgs e) --- Fine della traccia dello stack dell'eccezione interna ---

 
New Post
5/3/2014 8:11 AM
 
it looks like delete portal tries to remove records from a table, which doesn't exist (any more) in your DNN.
Yes, DNN is using Petapoco since version 7.0, you may get some details from http://www.dnnsoftware.com/wiki/page/...

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2014 9:09 AM
 
But the table dbo.mcl_Workflows is still there. I did no mangling in the db (except for your scripts could be those to "lock" things up?).

EDIT: I have to correct myself! The table mcl_Workflow is there but mcl_Workflows (with "s" at the end) doesn't seem to exist... how is it possible?!

I checked another DNN clean install and there is no Workflows table only Workflow... may this be a DNN bug?

I created a fake mcl_Workflows table copied from the Workflow one. This seemed to work but:



Errore: Site Management non è attualmente disponibile. DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_mcl_FolderPermission_mcl_Roles". The conflict occurred in database "sitilocalimcl", table "dbo.mcl_FolderPermission", column 'RoleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_mcl_FolderPermission_mcl_Roles". The conflict occurred in database "sitilocalimcl", table "dbo.mcl_FolderPermission", column 'RoleID'. The statement has been terminated. in System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) in System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) in System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in PetaPoco.Database.Execute(String sql, Object[] args) in DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args) in DotNetNuke.Data.DataProvider.DeletePortalInfo(Int32 PortalId) in DotNetNuke.Entities.Portals.PortalController.DeletePortalInfo(Int32 portalId) in DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) in DotNetNuke.Modules.Admin.Portals.Portals.OnGridDeleteCommand(Object source, GridCommandEventArgs e) --- Fine della traccia dello stack dell'eccezione interna ---


It seems something wiked is going on here. The delete on a full portal should take care of FK/PK relationship I guess.

 
New Post
5/3/2014 10:47 AM
 
Max, the first issue is a typo in my turbo script (I added some cleanup statements, because DNN simply keeps the orphaned records).



The other issue is caused by a missing or misconfigured foreign key constraint from Folders to FolderPermission table, which should cascade on delete. I checked a new install of DNN 7.2.2, and it was properly installed while on another site, which was upgraded to 7.2.2, this FK was missing



I will upload an updated version of my script later today or tomorrow, which should handle both issues.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2014 11:00 AM
 
Well at least I'm happy that after bugging you so much in the forums I came up with something useful for you ;)

Anyway mine is a fresh 7.2.2 install.

And thanks of course for your INVALUABLE work with the scripts!
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Exception deleting portalsException deleting portals


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.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out