Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 4.x > Installation and deployment > Database error on site delete View modes: 
User avatar
Member
Member
rdiepenbrock - 9/3/2009 10:46:29 AM
   
Database error on site delete
I am receiving this error when attempting to remove the Community Site:

Error deleting site: [DataConnection.ExecuteQuery]: Query: DELETE FROM CMS_Site WHERE [SiteID] = @ID: caused exception: The DELETE statement conflicted with the REFERENCE constraint "FK_CMS_DocumentAlias_CMS_Site". The conflict occurred in database "GNWeb", table "dbo.CMS_DocumentAlias", column 'AliasSiteID'. The statement has been terminated.
Stack trace: at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) at CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryText, Object[,] parameters, QueryTypeEnum queryType, Boolean transaction) at CMS.DataEngine.GeneralConnection.RunQueryObject(Query query, Object[,] parameters) 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.SiteProvider.SiteInfoProvider.DeleteSiteInternal(SiteInfo si, GeneralConnection conn) at CMS.SiteProvider.SiteInfoProvider.DeleteSite(String siteName) at SiteDeletionManager.DeleteSite(Object parameter) in c:\inetpub\wwwroot\gnweb\CMSSiteManager\Sites\Site_Delete.aspx.cs:line 727

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 9/10/2009 11:37:56 PM
   
RE:Database error on site delete
Hi,

could you please summarize the steps you've made before trying to delete the site? Have you made any changes to the database? Do you have another site(s) within that instance (database)? If yes, are you using document aliases in those sites?

Thank you in advance for information.

Regards,
Zdenek C.