Bug reports Found a bug? Post it here please.
Version 4.x > Bug reports > Error during site deletion View modes: 
User avatar
Member
Member
jakubsloup-jakubsloup - 3/18/2009 3:47:59 PM
   
Error during site deletion
During the deletion of site in CMS Site Manager it show this error in version 4.0:



[GeneralConnection.RunQuery]: Query 'cms.blogpost.removedependencies' not found.
Stack trace: at CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns) at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters) at CMS.WorkflowEngine.DocumentHelper.RemoveBlogPostDependencies(Int32 documentId, GeneralConnection conn) at CMS.WorkflowEngine.DocumentHelper.DeleteDocument(TreeNode node, TreeProvider tree, Boolean deleteAllCultures, Boolean destroyHistory, Boolean deleteProduct, String webRootFullPath, ArrayList deletedNodeIDs) at CMS.WorkflowEngine.DocumentHelper.DeleteSiteTree(String siteName, TreeProvider tree, OnAfterDocumentDeletedEventHandler deleteCallback, String webRootFullPath) at SiteDeletionManager.DeleteSite(Object parameter)

User avatar
Kentico Developer
Kentico Developer
kentico_ondrejv - 3/18/2009 6:34:50 PM
   
RE:Error during site deletion
Hello,

There may be missing appropriate query within Blogpost document type. Could you please check if you have the 'removedependencies' query in: 'Site Manager -> Development -> Document types -> Edit (Blog post) -> Queries tab'?

If not please make new by clicking on 'New query'. Please name it removedependencies, choose 'Stored procedure', please check 'automatic updates' and fill following text into 'Query text' area: Proc_CMS_Document_RemoveBlogPostDependencies.

Best regards
Ondrej Vasil