November Happy Hour will be moved to Thursday December 5th.

How to Delete Recycle Bin with SQL Query

Vote:
 

Hi!

Since there is an issue with the Recycle Bin for us, after applying a bunch of patches in order to get CMS6R2 to work as it should, we cant delete pages from it in edit mode without getting time out. Weve set the time out in the config without any luck so we hope we can do it with an SQL query. However EPiServer removed the script for deleting pages only in the recycle bin in this version and since we arent EPiServer engineers we dont know how to specify to only delete the pages in the recycle bin. The only script ive found is the editdeletepage which are close to what we need but im guessing its for a given page and not all pages in the recycle bin.

Is there a kind soul which could help us with this issue?

#59956
Jul 06, 2012 11:23
Vote:
 

There is a store procedure called "editDeleteChilds" which take a page id. Call that with the pageid of the recycle bin. Be sure to backup the database before doing this, if something should fail... :)

#59958
Jul 06, 2012 12:08
Vote:
 

Hi,


You can set the timeout on siteSettings with databaseQueryTimeout http://sdk.episerver.com/library/cms5/html/P_EPiServer_Configuration_Settings_DatabaseQueryTimeout.htm.

And if you set debug to true in web.config you will not receive a timeout from asp.net.

#59960
Jul 06, 2012 13:12
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.