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

[Eska]

Hi Michael,

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

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.

Eska


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.