Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

How to remove a large number of pages.


Reply


4 Posts   674 Views

Avatar
bekkevos

Community Member, 2 Posts

7 July 2011 at 6:57am

Edited: 07/07/2011 6:59am

Is it possible to remove a large number of published pages in one go? Either in Silverstripe or in PHPadmin. Also, is it possible to remove all the different versions of a page except the live one?

Avatar
martimiz

Forum Moderator, 1106 Posts

7 July 2011 at 7:23am

Edited: 07/07/2011 7:24am

There are tho two batch actions 'Delete from draft site' and 'Delete from published site'. Check out the 'Batch actions' button, top left of the CMS, and select the pages you want to remove.

There is no batch action to delete a bunch of previous page versions. If you want to remove all previous versions, you can empty the database tables directly: tables with name-extension _versions (like SiteTree_versions) contain previous versions, emptying them won't affect the live pages, but I'd recommend making a backup of the database in advance.

Also there is a SanitizeTask tool here that might help you, but I haven't tried it yet:

https://github.com/silverstripe-labs/silverstripe-recipes/blob/master/model/tools/

Avatar
bekkevos

Community Member, 2 Posts

7 July 2011 at 11:18pm

Thanks martimiz,

that's exactly what i was looking for!

Avatar
Jellygnite

Community Member, 11 Posts

19 June 2013 at 1:37pm

I didn't have much success with martimiz's suggestion but did find this.

https://github.com/axllent/silverstripe-version-truncator

It is doubly useful as you can limit the number of versions in the database and avoid db bloat.