[opencms-dev] (6b3) SQL exception on publish

[Jorge Gonzalez]

Hi list:

I'm getting this exception while publishing any content...

My config:

opencms b3
mysql  Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i686)
Linux 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 19 01:53:23 GMT 2005 i686 i686 i386
GNU/Linux
CentOS release 3.3 (final)
jboss-3.2.7


Thanks

----
ERROR [org.opencms.db.CmsSqlException] [org.opencms.db.mysql.CmsVfsDriver]
where:
org.opencms.db.generic.CmsVfsDriver.readResourcesWithProperty(CmsVfsDriver.j
ava:1500), why: java.sql.SQLException: Syntax error or access violation
message from server: "You have an error in your SQL syntax near '(SELECT
DISTINCT CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE' at
line 1"query: com.mysql.jdbc.PreparedStatement at 1542094: (SELECT DISTINCT
CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_ID,CMS_ONLIN
E_STRUCTURE.RESOURCE_PATH,CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,CMS_ONLINE_ST
RUCTURE.DATE_RELEASED,CMS_ONLINE_STRUCTURE.DATE_EXPIRED,CMS_ONLINE_RESOURCES
.RESOURCE_ID,CMS_ONLINE_RESOURCES.RESOURCE_TYPE,CMS_ONLINE_RESOURCES.RESOURC
E_FLAGS,CMS_ONLINE_RESOURCES.RESOURCE_STATE,CMS_ONLINE_RESOURCES.DATE_CREATE
D,CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED,CMS_ONLINE_RESOURCES.USER_CREATED,C
MS_ONLINE_RESOURCES.USER_LASTMODIFIED,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIF
IED
LOCKED_IN_PROJECT,CMS_ONLINE_RESOURCES.RESOURCE_SIZE,CMS_ONLINE_RESOURCES.SI
BLING_COUNT,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED FROM
CMS_ONLINE_PROPERTIES, CMS_ONLINE_RESOURCES, CMS_ONLINE_STRUCTURE WHERE
CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID =
'bcb971be-c17e-11d9-817d-618b99d6fcab' AND
CMS_ONLINE_PROPERTIES.PROPERTY_MAPPING_ID = CMS_ONLINE_RESOURCES.RESOURCE_ID
AND CMS_ONLINE_STRUCTURE.RESOURCE_ID = CMS_ONLINE_RESOURCES.RESOURCE_ID AND
CMS_ONLINE_STRUCTURE.RESOURCE_PATH LIKE '/%') UNION (SELECT DISTINCT
CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_ID,CMS_ONLIN
E_STRUCTURE.RESOURCE_PATH,CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,CMS_ONLINE_ST
RUCTURE.DATE_RELEASED,CMS_ONLINE_STRUCTURE.DATE_EXPIRED,CMS_ONLINE_RESOURCES
.RESOURCE_ID,CMS_ONLINE_RESOURCES.RESOURCE_TYPE,CMS_ONLINE_RESOURCES.RESOURC
E_FLAGS,CMS_ONLINE_RESOURCES.RESOURCE_STATE,CMS_ONLINE_RESOURCES.DATE_CREATE
D,CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED,CMS_ONLINE_RESOURCES.USER_CREATED,C
MS_ONLINE_RESOURCES.USER_LASTMODIFIED,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIF
IED
LOCKED_IN_PROJECT,CMS_ONLINE_RESOURCES.RESOURCE_SIZE,CMS_ONLINE_RESOURCES.SI
BLING_COUNT,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED FROM
CMS_ONLINE_PROPERTIES, CMS_ONLINE_STRUCTURE, CMS_ONLINE_RESOURCES WHERE
CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID =
'bcb971be-c17e-11d9-817d-618b99d6fcab' AND
CMS_ONLINE_PROPERTIES.PROPERTY_MAPPING_ID =
CMS_ONLINE_STRUCTURE.STRUCTURE_ID AND CMS_ONLINE_STRUCTURE.RESOURCE_ID =
CMS_ONLINE_RESOURCES.RESOURCE_ID AND CMS_ONLINE_STRUCTURE.RESOURCE_PATH LIKE
'/%') ORDER BY RESOURCE_PATH DESC SQL Exception
java.sql.SQLException: Syntax error or access violation message from server:
"You have an error in your SQL syntax near '(SELECT DISTINCT
CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE' 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.readResourcesWithProperty(CmsVfsDriver.j
ava:1500)
        at
org.opencms.db.CmsDriverManager.readResourcesWithProperty(CmsDriverManager.j
ava:5587)
        at
org.opencms.db.CmsSecurityManager.readResourcesWithProperty(CmsSecurityManag
er.java:3577)
        at
org.opencms.file.CmsObject.readResourcesWithProperty(CmsObject.java:2593)
        at
org.opencms.staticexport.CmsStaticExportManager.setExportnames(CmsStaticExpo
rtManager.java:1974)
        at
org.opencms.staticexport.CmsStaticExportManager.clearCaches(CmsStaticExportM
anager.java:1634)
        at
org.opencms.staticexport.CmsStaticExportManager.cmsEvent(CmsStaticExportMana
ger.java:269)
        at
org.opencms.main.OpenCmsCore.fireCmsEventHandler(OpenCmsCore.java:1763)
        at org.opencms.main.OpenCmsCore.fireCmsEvent(OpenCmsCore.java:353)
        at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:125)
        at
org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4376)
        at
org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:260
2)
        at org.opencms.file.CmsObject.publishProject(CmsObject.java:1862)
        at
org.opencms.threads.CmsPublishThread.run(CmsPublishThread.java:116)
----