Forum OpenACS CMS: Re: content repository physical folders keeps growing

Collapse
2: Re: content repository physical folders keeps growing (response to 1)
Posted by Antonio Pisano on 12/19/13 08:49 PM
I managed to identify every folder containing cr files. The query is this:

select split(content, '/', 2)
from cr_revisions
where revision_id in
(select live_revision
from fs_files)
group by split(content, '/', 2);

I then removed folders not in content-repository-content-files not belonging that set.

What could have caused this behaviour?

Collapse
3: Re: content repository physical folders keeps growing (response to 2)
Posted by Antonio Pisano on 12/19/13 08:50 PM
*I then removed folders in content-repository-content-files not belonging that set.