I have problems updating LogicalDoc from version 6.1 to 6.3.5. I installed the new version into the appcontainer and updated the context.properties.
But I cannot login after the update. I'll get a "Acess denied".
Has the DB changed in this version?
The log files gives me following exception:
Code: Select all
07.03.2012 11:36:48,299 WARN (com.logicaldoc.web.service.SecurityServiceImpl: 183) -- User cschnei is not valid
07.03.2012 11:37:31,954 WARN (org.hibernate.util.JDBCExceptionReporter: 100) -- SQL Error: 1054, SQLState: 42S22
07.03.2012 11:37:31,955 ERROR (org.hibernate.util.JDBCExceptionReporter: 101) -- Unknown column 'attributes0_.ld_editor' in 'field list'
07.03.2012 11:37:31,956 ERROR (com.logicaldoc.core.security.dao.HibernateUserDAO: 90) -- could not initialize a collection: [com.logicaldoc.core.security.Group.attributes#6]; SQL [select attributes0_.ld_groupid as ld1_0_, attributes0_.ld_label as ld2_0_, attributes0_.ld_mandatory as ld3_0_, attributes0_.ld_type as ld4_0_, attributes0_.ld_editor as ld5_0_, attributes0_.ld_position as ld6_0_, attributes0_.ld_stringvalue as ld7_0_, attributes0_.ld_intvalue as ld8_0_, attributes0_.ld_doublevalue as ld9_0_, attributes0_.ld_datevalue as ld10_0_, attributes0_.ld_name as ld11_0_ from ld_group_ext attributes0_ where attributes0_.ld_groupid=? order by attributes0_.ld_position asc]; nested exception is org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.logicaldoc.core.security.Group.attributes#6]
org.springframework.dao.InvalidDataAccessResourceUsageException: could not initialize a collection: [com.logicaldoc.core.security.Group.attributes#6]; SQL [select attributes0_.ld_groupid as ld1_0_, attributes0_.ld_label as ld2_0_, attributes0_.ld_mandatory as ld3_0_, attributes0_.ld_type as ld4_0_, attributes0_.ld_editor as ld5_0_, attributes0_.ld_position as ld6_0_, attributes0_.ld_stringvalue as ld7_0_, attributes0_.ld_intvalue as ld8_0_, attributes0_.ld_doublevalue as ld9_0_, attributes0_.ld_datevalue as ld10_0_, attributes0_.ld_name as ld11_0_ from ld_group_ext attributes0_ where attributes0_.ld_groupid=? order by attributes0_.ld_position asc]; nested exception is org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.logicaldoc.core.security.Group.attributes#6]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
......
thanks!