[opencms-dev] OpenCms 7 RC 1 available
Marco
mailings at weeswel.com
Thu May 10 17:33:42 CEST 2007
It seems like it,
Caused by: java.sql.SQLException: Column not found message from server:
"Unknown column 'CMS_ONLINE_STRUCTURE.STRUCTURE_VERSION' in 'field list'"
Same as with me, the Postgresl dump doesn't contain the
STRUCTURE_VERSION field list for the CMS_ONLINE_STRUCTURE table. And
atleast one of the many Mysql dumps does contain a dump which presumably
is correct.
Stéphane Verger schreef:
> Hi !
>
> I had an unexpected error trying to install OpenCms 7 RC1 with the
> java 1.4 package.
> It seems to have a problem with the sql schemas, is it the same
> problem as yours, marco ?
>
> Has anybody already had the same probleme, and got a solution ?
>
> Ty,
>
> R.
>
>
>
> 47: Shutdown completed, total uptime was 00:00:29.
> 46: Shutting down OpenCms, version 7 RC 1 (6.9.1) in web
> application "opencms7beta"
> 45: 44: 43: at
> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:209)
>
> 42: at
> org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:118)
>
> 41: at org.opencms.main.CmsShell.exit(CmsShell.java:557)
> 40: java.lang.NullPointerException
> 39: at
> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:194)
>
> 38: at org.opencms.main.CmsShell.start(CmsShell.java:646)
> 37: at
> org.opencms.main.CmsShell.executeCommands(CmsShell.java:818)
> 36: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:743)
> 35: ${user}@${project}>java.lang.NullPointerException
> 34: ${user}@${project}># Turn echo on
> 33: ... 9 more
> 32: at
> org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1653)
> 31: at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
>
> 30: at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
>
> 29: at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634)
>
> 28: at com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
> 27: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> 26: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
> 25: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
> 24: Caused by: java.sql.SQLException: Column not found message from
> server: "Unknown column 'CMS_ONLINE_STRUCTURE.STRUCTURE_VERSION' in
> 'field list'"
> 23: ... 5 more
> 22: at
> org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2579)
> 21: at
> org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4034)
> 20: at
> org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:577)
>
> 19: at
> org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:471)
> 18: at
> org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1666)
> 17: Caused by: org.opencms.db.CmsDbSqlException: An SQL error
> occurred when executing the following query:
> com.mysql.jdbc.PreparedStatement at 12ce574: SELECT
> CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_PATH,CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,CMS_ONLINE_STRUCTURE.DATE_RELEASED,CMS_ONLINE_STRUCTURE.DATE_EXPIRED,CMS_ONLINE_STRUCTURE.STRUCTURE_VERSION,CMS_ONLINE_RESOURCES.RESOURCE_ID,CMS_ONLINE_RESOURCES.RESOURCE_TYPE,CMS_ONLINE_RESOURCES.RESOURCE_FLAGS,CMS_ONLINE_RESOURCES.RESOURCE_STATE,CMS_ONLINE_RESOURCES.DATE_CREATED,CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED,CMS_ONLINE_RESOURCES.USER_CREATED,CMS_ONLINE_RESOURCES.USER_LASTMODIFIED,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED
> LOCKED_IN_PROJECT,CMS_ONLINE_RESOURCES.RESOURCE_SIZE,CMS_ONLINE_RESOURCES.DATE_CONTENT,CMS_ONLINE_RESOURCES.SIBLING_COUNT,CMS_ONLINE_RESOURCES.RESOURCE_VERSION,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED
> FROM CMS_ONLINE_STRUCTURE,CMS_ONLINE_RESOURCES WHERE
> CMS_ONLINE_STRUCTURE.RESOURCE_PATH='/' AND
> CMS_ONLINE_STRUCTURE.RESOURCE_ID=CMS_ONLINE_RESOURCES.RESOURCE_ID
> ORDER BY CMS_ONLINE_STRUCTURE.STRUCTURE_STATE ASC.
> 16: at
> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:155)
>
> 15: at org.opencms.main.CmsShell.<init>(CmsShell.java:450)
> 14: at
> org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1684)
> 13: at
> org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1111)
> 12: at
> org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:168)
>
> 11: at
> org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2588)
> 10: org.opencms.main.CmsInitException: Critical error while loading
> driver manager.
> 9: --------------------
> 8: Giving up, unable to start OpenCms.
> 7: Critical error while loading driver manager.
> 6: The following critical error occured:
> 5: --------------------
> 4: 3: 2: OpenCms property file:
> "C:\dev\java\jakarta-tomcat-5.0.30\webapps\opencms7beta\WEB-INF\config\opencms.properties".
>
> 1: OpenCms WEB-INF path:
> "C:\dev\java\jakarta-tomcat-5.0.30\webapps\opencms7beta\WEB-INF\".
>
> Marco a écrit :
>> I just tried to install this release candidat but couldn't get it to
>> work.
>> The OpenCms logging mentioned problems with a query, this had to do
>> with the absence of the group_ou column in the cms_groups tables.
>>
>> This field could not be found on the database server and in the
>> setup/database/postgresql/create_tables file.
>> When comparing the oracle, mysql en Postgresql dump I suspect that
>> the Postgresql dump is horribly out of date.
>>
>> Hope this helps the RC phase a bit further.
>>
>> Cheers,
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> _______________________________________________
> 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
More information about the opencms-dev
mailing list