The error description hints at the problem Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'personnelb0_.site_preference' in 'field list'
1. upgrade didnt work OR 2. upgrade didnt include patch to do with 'site_preference' column Jakub/Udai should know for sure. Keith. On Tue, Apr 3, 2012 at 1:52 PM, <[email protected]> wrote: > Hi, > > > > Have you run the attached password update script which is shipped along with > the Mifos download package ? I think that should resolve the error. > > > > Thanks > > Chetan > > > > > > From: Intrasoft Technologies [mailto:[email protected]] > Sent: Tuesday, April 03, 2012 6:19 PM > To: [email protected]; mifos software development > Subject: [Mifos-users] Mifos v.2.3.0 upgrade issue > > > > Community, > > > > We tried upgrading Mifos version 2.1.6 to 2.3.0, the database seemed to have > changed successfully but when logging in to Mifos it gives a stack trace > below: > > > > org.mifos.core.MifosRuntimeException: > org.hibernate.exception.SQLGrammarException: could not execute query > at > org.mifos.accounts.savings.persistence.GenericDaoHibernate.executeUniqueResultNamedQuery(GenericDaoHibernate.java:107) > at > org.mifos.customers.personnel.persistence.PersonnelDaoHibernate.findPersonnelByUsername(PersonnelDaoHibernate.java:96) > at > org.mifos.application.servicefacade.LoginServiceFacadeWebTier.login(LoginServiceFacadeWebTier.java:63) > at > org.mifos.security.authentication.MifosLegacyUsernamePasswordAuthenticationFilter.unsuccessfulAuthentication(MifosLegacyUsernamePasswordAuthenticationFilter.java:131) > at > org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:203) > at > org.mifos.security.authentication.MifosLegacyUsernamePasswordAuthenticationFilter.doFilter(MifosLegacyUsernamePasswordAuthenticationFilter.java:115) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) > at > org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) > at > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) > at > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) > at > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) > at > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) > at > org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) > at > org.mifos.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) > at > org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:474) > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) > at > org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:480) > at > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) > at > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:934) > at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:404) > at > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) > at > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:869) > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) > at > org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) > at > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:151) > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) > at org.eclipse.jetty.server.Server.handle(Server.java:346) > at > org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581) > at > org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1057) > at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:807) > at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:220) > at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411) > at > org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:526) > at > org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:41) > at > org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:528) > at java.lang.Thread.run(Unknown Source) > Caused by: org.hibernate.exception.SQLGrammarException: could not execute > query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > at org.hibernate.loader.Loader.doList(Loader.java:2545) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) > at org.hibernate.loader.Loader.list(Loader.java:2271) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459) > at > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365) > at > org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) > at > org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) > at > org.mifos.accounts.savings.persistence.GenericDaoHibernate.executeUniqueResultNamedQuery(GenericDaoHibernate.java:105) > ... 38 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Unknown column 'personnelb0_.site_preference' in 'field list' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) > at java.lang.reflect.Constructor.newInstance(Unknown Source) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) > at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) > at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > at org.hibernate.loader.Loader.doQuery(Loader.java:802) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) > at org.hibernate.loader.Loader.doList(Loader.java:2542) > ... 47 more > > Kindly advise on how we can resolve the errors. > > > > Thanks. > -- > ****** > INTRASOFT TECHNOLOGIES | B8, KIGLESS HSE MOI AVENUE > P.O. BOX 82298 - 80100 Mombasa Kenya. > Tel: +254 20 267 0011 / Cell: +254 734 138478 > Email: [email protected] > > > ------------------------------------------------------------------------------ > Better than sec? Nothing is better than sec when it comes to > monitoring Big Data applications. Try Boundary one-second > resolution app monitoring today. Free. > http://p.sf.net/sfu/Boundary-dev2dev > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
