[opencms-dev] deleting project offline in ocms alpha3

[Olli Aro]

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

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005