[opencms-dev] Delete files in a subtree of the online project possible through SQL?

Eska sven.kiesow at interone.de
Fri Jan 15 11:54:18 CET 2010

Hi Michael,

Ah, the offline project resources store some info about the publish in the

The reason I ask, is that a customer with an OCEE-Cluster experienced
Exceptions when publishing
and now even the selective replication of folders to single servers of the
cluster might be unsuccessful,
because when trying to delete a folder, the OCEE replication still finds
some files in the online-project
inside of that folder and aborts.

Reason is, that content-editors moved or renamed stuff, but did not publish
those changes
together, but only part of it.

Somehow I managed to fix that stuff, because I could create those still
present folders on the 
Edit-System, publish them and after that delete them again, so that they are
deleted on the
other servers.


Michael Emmerich-2 wrote:
> Eska,
> I can NOT recomment to do so.
> If you delete something from the online tables, the corresponding 
> entries in the offline tables do have an incorrect state.
> So this is a very good way to corrupt your database.
> If you want to delete something online, you should use the api - so 
> delete the resources offline and publish them.
>> Hi Guys,
>> I have a question regarding updating the OpenCms database through usage
>> of
>> SQL-Commands.
>> I have the following file structure:
>>   /sites/abc/def/geh/ij
>>   /sites/abc/def/geh/ij/test1.jpg
>>   /sites/abc/def/geh/ij/test1.xml
>>   /sites/abc/def/geh/kl/
>>   /sites/abc/def/geh/kl/test2.jpg
>>   /sites/abc/def/geh/kl/test2.xml
>> Is it possible to remove all Resources of a certain tree e.g.
>> /sites/abc/def/geh/*
>> in the online project using SQL-Commands?
>> Thanks
>> Eska
> -- 
> Kind Regards,
> Michael.
> -------------------
> Michael Emmerich
> Alkacon Software GmbH  - The OpenCms Experts
> http://www.alkacon.com - http://www.opencms.org
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev

View this message in context: http://old.nabble.com/Delete-files-in-a-subtree-of-the-online-project-possible-through-SQL--tp27165217p27174826.html
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.

More information about the opencms-dev mailing list