[opencms-dev] OpenCMS6.2 Help: Error publishing deleted folder

[Ruben Malchow]

hi,

if you have direct access to the database, i would suggest that you look 
for the file and its parent using sql:

SELECT
	STRUCTURE_ID, PARENT_ID, RESOURCE_PATH
FROM
	cms_offline_structure
WHERE
	RESOURCE_PATH LIKE '/sites/your/path/ %' ;


in my experience, what can happen is that while moving, resource_path 
and parent_id might not be updated in one transaction. for the explorer, 
files are selected by PARENT_ID, while for publishing and deleting, 
files are selected using their RESOURCE_PATH.

this can lead to inconsistent behaviour when the path is updated, but 
the id is not (or the other way round)

when you execute the statement above, you should see the folder and the 
files in it. the files in the folder should have the folder's 
STRUCTURE_ID as their PARENT_ID ... if that is not the case:

	- do a backup of the db
	- change the PARENT_ID values to the correct ones
	- restart the opencms
	- see if it fixes it

.rm


meng yi schrieb:
> Dear All,
> 
> We are using OpenCMS 6.2 with Oracle 10g.
> 
> I got the error below when I'm publishing the entire Offline project. I
> don't know what my client had done to the system. But basically,
> /sites/path/to/my/folder/ is NOT to be deleted and there is no such file
> under the folder as ~index.html.
> How should I clear this error?
> 
> Best Regards,
> Meng YI
> 
> 
> 
> ( 1 / 2 ) Deleting folder /sites/path/to/my/folder / ... Error
> publishing deleted folder "/sites/path/to/my/folder/". 
> Exception org.opencms.file.CmsVfsException: Unable to remove the folder
> "/sites/caas/html/business-partners/commercial/offices-and-warehouse-lea
> sing/". The folder contains the files "[~index.html]". 
> at
> org.opencms.db.generic.CmsVfsDriver.removeFolder(CmsVfsDriver.java:1864)
> at
> org.opencms.db.generic.CmsProjectDriver.publishDeletedFolder(CmsProjectD
> river.java:701)
> at
> org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.
> java:1712)
> at
> org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:449
> 3)
> at
> org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java
> :2893)
> at org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)
> at
> org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java
> :122)
> Statistics: published files: 0, published folders: 0, deleted folders:
> 1, duration: 00:00:00
> Exception org.opencms.file.CmsVfsException: Error publishing deleted
> folder "/sites/path/to/my/folder /". 
> at
> org.opencms.file.CmsVfsException.createException(CmsVfsException.java:79
> )
> at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
> at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
> at
> org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.
> java:1727)
> at
> org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:449
> 3)
> at
> org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java
> :2893)
> at org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)
> at
> org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java
> :122)
> Caused by: org.opencms.file.CmsVfsException: Unable to remove the folder
> "/sites/path/to/my/folder /". The folder contains the files
> "[~index.html]". 
> at
> org.opencms.db.generic.CmsVfsDriver.removeFolder(CmsVfsDriver.java:1864)
> at
> org.opencms.db.generic.CmsProjectDriver.publishDeletedFolder(CmsProjectD
> river.java:701)
> at
> org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.
> java:1712)
> ... 4 more
> 
> 
> When I click on the "Details" button, I get 
> 
> 
> Deleting folders ...
> ??? report.error ???Error publishing deleted folder
> "/sites/path/to/my/folder /". ??? report.error.details ???
> 
> _______________________________________________
> 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
>