[opencms-dev] OpenCms 7 RC 1 available

[Stéphane Verger]

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
>
>