I m using umbraco v 4.5.2 (Assembly version: 1.0.3891.20719). I m using umbraco in dev , qa and production. I need to delete items in recycle bin.
Used below query for deleting from DEV and QA
delete from cmsPreviewXml where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 ) delete from cmsContentVersion where contentId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 ) delete from cmsDocument where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 ) delete from cmsContentXML where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 ) delete from cmsContent where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 ) delete from cmsPropertyData where contentNodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 ) delete from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20
Please give your comments on this query execution for prod Umbraco??
In the administration part of Umbraco you have the possibility to empty the recycle bin by right clicking and select "Empty recycle bin". Have you tried that?
Delete items in Recylce Bin
I m using umbraco v 4.5.2 (Assembly version: 1.0.3891.20719). I m using umbraco in dev , qa and production. I need to delete items in recycle bin.
Used below query for deleting from DEV and QA
delete from cmsPreviewXml where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 )
delete from cmsContentVersion where contentId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 )
delete from cmsDocument where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 )
delete from cmsContentXML where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 )
delete from cmsContent where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 )
delete from cmsPropertyData where contentNodeId in (select id from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20 )
delete from umbracoNode where path like '%-20%' and id!=-20 and parentID=-20
Please give your comments on this query execution for prod Umbraco??
Hi can anyone help me on this?
Why don't you delete the items from the backend ? Are you having trouble with that function ?
Dave
Thanks Dave.
I have used this query from backend.
I found few pages in my web site were down once i executed this?
Any idea for this root cause?
If i can validate it , i can execute this in LIVE site.
Please help
In the administration part of Umbraco you have the possibility to empty the recycle bin by right clicking and select "Empty recycle bin". Have you tried that?
is working on a reply...