[opencms-dev] deleting project offline in ocms alpha3

[Hans van der Linden]

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(CmsDriverManager.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:83)
>-----------
>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(DelegatingPreparedStatement.java:92)
>	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.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(CmsDriverManager.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:83)

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(DelegatingPreparedStatement.java:92)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.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(CmsDriverManager.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:83)