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

[meng yi]

Thanks ruben.

I actually solved my problem by individually publish the files inside
the problematic folder and then at the folder level did "Undo changes",
then everything is fine.

But your SQL did give me some hint to tackle future problems. Now I'm on
the way into the OpenCMS database :)

-----Original Message-----
From: Ruben Malchow [mailto:ruben at disk0.de] 
Sent: Wednesday, August 05, 2009 12:38 AM
To: The OpenCms mailing list; meng yi
Subject: Re: [opencms-dev] OpenCMS6.2 Help: Error publishing deleted
folder



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
>