[opencms-dev] deleting project offline in ocms alpha3

[Sven Bonorden]

In OpenCms 5.0.1 deleting the offline project was possible.
We did that in a script using the CmsShell deleteProject method.
Same reason as Hans, we must not have an offline project with access for 
every user but several projects for each user group.

Never tested with current versions.

Regards,
Sven


Olli Aro wrote:

>The offine project is one of the default OpenCMS projects so I think it is
>not possible to delete it or if you do it will mess up your system.
>
>Regards,
>
>Olli
>
>-----Original Message-----
>From: opencms-dev-bounces at opencms.org
>[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Hans van der Linden
>Sent: 19 January 2005 14:34
>To: The OpenCms mailing list
>Subject: RE: [opencms-dev] deleting project offline in ocms alpha3
>
>Hi
>
>Someone ever tried to delete project offline ?
>
>Hans
>
>
>-----Oorspronkelijk bericht-----
>Van: opencms-dev-bounces at opencms.org
>[mailto:opencms-dev-bounces at opencms.org]Namens Hans van der Linden
>Verzonden: dinsdag 18 januari 2005 9:35
>Aan: The OpenCms mailing list
>Onderwerp: [opencms-dev] deleting project offline in ocms alpha3
>
>
>Hi
>
>When I try to delete the offline project I get the error below (I use mysql
>4.1). I now hesitate if it's possible to delete the
>offline project. The reason why I want to do this is because of a multi site
>implementation. Every user gets is own offline project
>i.e. "Offline - siteA" So I don't want them to be able to see or select the
>Offline project.
>
>Any suggestions?
>
>regards,
>
>Hans
>
>org.opencms.main.CmsException: [org.opencms.db.mysql.CmsVfsDriver] where:
>org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1554)
>, why: java.sql.SQLException: Syntax error or access
>violation message from server: "You have an error in your SQL syntax; check
>the manual that corresponds to your MySQL server version
>for the right syntax to use near 'BY CMS_OFFLINE_STRUCTURE.RESOURCE_PATH' at
>line 1" [Code 4 - Sql exception]
>Root cause was: java.sql.SQLException: Syntax error or access violation
>message from server: "You have an error in your SQL syntax;
>check the manual that corresponds to your MySQL server version for the right
>syntax to use near 'BY
>CMS_OFFLINE_STRUCTURE.RESOURCE_PATH' at line 1"
>	at
>org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:295)
>	at
>org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1561)
>	at
>org.opencms.db.CmsDriverManager.readResources(CmsDriverManager.java:5763)
>	at
>org.opencms.db.CmsDriverManager.readChangedResourcesInsideProject(CmsDriverM
>anager.java:4812)
>	at
>org.opencms.db.CmsDriverManager.deleteProject(CmsDriverManager.java:2394)
>	at
>org.opencms.db.CmsSecurityManager.deleteProject(CmsSecurityManager.java:1276
>)
>	at org.opencms.file.CmsObject.deleteProject(CmsObject.java:760)
>	at
>org.opencms.threads.CmsProjectDeleteThread.run(CmsProjectDeleteThread.java:8
>3)
>  
>
>>-----------
>>Root cause:
>>java.sql.SQLException: Syntax error or access violation message from
>>    
>>
>server: "You have an error in your SQL syntax; check the
>manual that corresponds to your MySQL server version for the right syntax to
>use near 'BY CMS_OFFLINE_STRUCTURE.RESOURCE_PATH' at
>line 1"
>  
>
>>	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
>>	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
>>	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
>>	at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
>>	at
>>    
>>
>com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)
>  
>
>>	at
>>    
>>
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
>reparedStatement.java:92)
>  
>
>>	at
>>    
>>
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
>reparedStatement.java:92)
>  
>
>>	at
>>    
>>
>org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1554)
>  
>
>>	at
>>    
>>
>org.opencms.db.CmsDriverManager.readResources(CmsDriverManager.java:5763)
>  
>
>>	at
>>    
>>
>org.opencms.db.CmsDriverManager.readChangedResourcesInsideProject(CmsDriverM
>anager.java:4812)
>  
>
>>	at
>>    
>>
>org.opencms.db.CmsDriverManager.deleteProject(CmsDriverManager.java:2394)
>  
>
>>	at
>>    
>>
>org.opencms.db.CmsSecurityManager.deleteProject(CmsSecurityManager.java:1276
>)
>  
>
>>	at org.opencms.file.CmsObject.deleteProject(CmsObject.java:760)
>>	at
>>    
>>
>org.opencms.threads.CmsProjectDeleteThread.run(CmsProjectDeleteThread.java:8
>3)
>
>java.sql.SQLException: Syntax error or access violation message from server:
>"You have an error in your SQL syntax; check the manual
>that corresponds to your MySQL server version for the right syntax to use
>near 'BY CMS_OFFLINE_STRUCTURE.RESOURCE_PATH' at line 1"
>	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
>	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
>	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
>	at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
>	at
>com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)
>	at
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
>reparedStatement.java:92)
>	at
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
>reparedStatement.java:92)
>	at
>org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1554)
>	at
>org.opencms.db.CmsDriverManager.readResources(CmsDriverManager.java:5763)
>	at
>org.opencms.db.CmsDriverManager.readChangedResourcesInsideProject(CmsDriverM
>anager.java:4812)
>	at
>org.opencms.db.CmsDriverManager.deleteProject(CmsDriverManager.java:2394)
>	at
>org.opencms.db.CmsSecurityManager.deleteProject(CmsSecurityManager.java:1276
>)
>	at org.opencms.file.CmsObject.deleteProject(CmsObject.java:760)
>	at
>org.opencms.threads.CmsProjectDeleteThread.run(CmsProjectDeleteThread.java:8
>3)
>
>
>
>_______________________________________________
>This mail is send to you from the opencms-dev mailing list
>To change your list options, or to unsubscribe from the list, please visit
>http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
>
>_______________________________________________
>This mail is send to you from the opencms-dev mailing list
>To change your list options, or to unsubscribe from the list, please visit
>http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>  
>


-- 
Sven Bonorden
Softwareentwicklung und Beratung, GETIT   mailto:bonorden at getit.de

-----
GETIT - Gesellschaft für Technologie- und Informationstransfer mbH

                                             Fon: +49.231.9742.339
                                             Fax: +49.231.9742.356

Emil-Figge-Straße 76-80                        http://www.getit.de
44227 Dortmund                                mailto:info at getit.de