Details

    • Type: Bug Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.0.3 GA
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      JBoss 6.0.3 download, Win7x64, MySQL 5.0.67
    • Similar Issues:
      Show 5 results 

      Description

      Attempting to upgrade from LR 6.0.1 to 6.0.3 using MySQL gets the following exceptions:
      12:38:40,229 INFO [DialectDetector] Determining dialect for MySQL 5
      12:38:40,414 INFO [DialectDetector] Using dialect org.hibernate.dialect.MySQLDialect
      12:38:48,110 INFO [PortalImpl] Global lib directory
      12:38:48,113 INFO [PortalImpl] Portal lib directory /C:/Build/Liferay6.0.3/jboss/jboss-5.1.0/server/default/deploy/ROOT.war/WEB-INF/lib/
      12:39:13,880 INFO [STDOUT] Starting Liferay Portal Community Edition 6.0.3 CE (Bunyan / Build 6003 / July 15, 2010)
      12:39:17,375 INFO [BaseDB] Database does not support case sensitive queries
      12:39:32,601 ERROR [JDBCExceptionReporter] Unknown column 'userimpl0_.facebookId' in 'field list'
      12:39:32,643 ERROR [CheckEventMessageListener] Unable to process message {destinationName=liferay/scheduler_dispatch, responseDestinationName=null, responseId=null, payload=null, values={receiver_key=com.liferay.portlet.calendar.messaging.CheckEventMessageListener:com.liferay.portlet.calendar.messaging.CheckEventMessageListener, scheduledFireTime=Sat Jul 17 12:39:31 PDT 2010}}
      com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: com.liferay.portal.model.impl.UserImpl#10884
      at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:176)
      at com.liferay.portal.service.persistence.UserPersistenceImpl.fetchByPrimaryKey(UserPersistenceImpl.java:758)
      at com.liferay.portlet.calendar.service.impl.CalEventLocalServiceImpl.checkEvents(CalEventLocalServiceImpl.java:305)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:65)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy438.checkEvents(Unknown Source)
      at com.liferay.portlet.calendar.service.CalEventLocalServiceUtil.checkEvents(CalEventLocalServiceUtil.java:184)
      at com.liferay.portlet.calendar.messaging.CheckEventMessageListener.doReceive(CheckEventMessageListener.java:39)
      at com.liferay.portlet.calendar.messaging.CheckEventMessageListener.receive(CheckEventMessageListener.java:31)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
      at $Proxy468.receive(Unknown Source)
      at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:57)
      at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
      at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: com.liferay.portal.model.impl.UserImpl#10884
      at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
      at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:120)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
      at $Proxy465.get(Unknown Source)
      at com.liferay.portal.service.persistence.UserPersistenceImpl.fetchByPrimaryKey(UserPersistenceImpl.java:755)
      ... 32 more
      Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: com.liferay.portal.model.impl.UserImpl#10884
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.loader.Loader.loadEntity(Loader.java:1937)
      at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
      at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
      at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
      at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
      at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
      at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
      at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:269)
      at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
      at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:997)
      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:990)
      at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:117)
      ... 39 more
      Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'userimpl0_.facebookId' in 'field list'
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
      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:1849)
      at org.hibernate.loader.Loader.doQuery(Loader.java:718)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
      at org.hibernate.loader.Loader.loadEntity(Loader.java:1933)
      ... 51 more
      12:39:32,861 INFO [PluginPackageUtil] Reloading repositories
      12:39:33,290 ERROR [JDBCExceptionReporter] Unknown column 'companyimp0_.maxUsers' in 'field list'
      12:39:33,297 ERROR [LDAPImportMessageListener] Unable to process message {destinationName=liferay/scheduler_dispatch, responseDestinationName=null, responseId=null, payload=null, values={receiver_key=com.liferay.portlet.admin.messaging.LDAPImportMessageListener:com.liferay.portlet.admin.messaging.LDAPImportMessageListener, scheduledFireTime=Sat Jul 17 12:39:32 PDT 2010}}
      com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:176)
      at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findBySystem(CompanyPersistenceImpl.java:928)
      at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findBySystem(CompanyPersistenceImpl.java:872)
      at com.liferay.portal.service.impl.CompanyLocalServiceImpl.getCompanies(CompanyLocalServiceImpl.java:406)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:65)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy251.getCompanies(Unknown Source)
      at com.liferay.portal.service.CompanyLocalServiceUtil.getCompanies(CompanyLocalServiceUtil.java:158)
      at com.liferay.portal.security.ldap.PortalLDAPImporterImpl.importFromLDAP(PortalLDAPImporterImpl.java:81)
      at com.liferay.portal.security.ldap.PortalLDAPImporterUtil.importFromLDAP(PortalLDAPImporterUtil.java:30)
      at com.liferay.portlet.admin.messaging.LDAPImportMessageListener.doReceive(LDAPImportMessageListener.java:38)
      at com.liferay.portlet.admin.messaging.LDAPImportMessageListener.receive(LDAPImportMessageListener.java:30)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
      at $Proxy468.receive(Unknown Source)
      at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:57)
      at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
      at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
      at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:78)
      at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:60)
      at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
      at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findBySystem(CompanyPersistenceImpl.java:925)
      ... 35 more
      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:2297)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
      at org.hibernate.loader.Loader.list(Loader.java:2167)
      at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:936)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:68)
      ... 38 more
      Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'companyimp0_.maxUsers' in 'field list'
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
      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:1849)
      at org.hibernate.loader.Loader.doQuery(Loader.java:718)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
      at org.hibernate.loader.Loader.doList(Loader.java:2294)
      ... 45 more
      12:39:47,553 INFO [HotDeployUtil] Initializing hot deploy manager 504648333
      12:39:47,579 INFO [ServerDetector] Detected server jboss
      12:39:47,596 ERROR [CheckEquityLogMessageListener] Unable to process message {destinationName=liferay/scheduler_dispatch, responseDestinationName=null, responseId=null, payload=null, values={receiver_key=com.liferay.portlet.social.messaging.CheckEquityLogMessageListener:com.liferay.portlet.social.messaging.CheckEquityLogMessageListener, scheduledFireTime=Sat Jul 17 12:39:47 PDT 2010}}
      com.liferay.portal.kernel.exception.SystemException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ UPDATE SocialEquityAssetEntry SET informationK = informationK - ( SELECT SUM(value / (expiration - actionDate)) FROM SocialEquityLog WHERE (SocialEquityLog.assetEntryId = SocialEquityAssetEntry.assetEntryId) AND (expiration <= 197) AND (active_ = 1) ), informationB = informationB - ( SELECT SUM((-value / (expiration - actionDate)) * expiration) FROM SocialEquityLog WHERE (SocialEquityLog.assetEntryId = SocialEquityAssetEntry.assetEntryId) AND (expiration <= 197) AND (active_ = 1) ) WHERE assetEntryId IN ( SELECT assetEntryId FROM SocialEquityLog WHERE (type_ = 1) AND (expiration <= 197) AND (active_ = 1) ) ]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal3.socialequityassetentry' doesn't exist
      at com.liferay.portlet.social.service.base.SocialEquityLogLocalServiceBaseImpl.runSQL(SocialEquityLogLocalServiceBaseImpl.java:422)
      at com.liferay.portlet.social.service.impl.SocialEquityLogLocalServiceImpl.runCheckSQL(SocialEquityLogLocalServiceImpl.java:610)
      at com.liferay.portlet.social.service.impl.SocialEquityLogLocalServiceImpl.checkEquityLogs(SocialEquityLogLocalServiceImpl.java:118)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:65)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy392.checkEquityLogs(Unknown Source)
      at com.liferay.portlet.social.service.SocialEquityLogLocalServiceUtil.checkEquityLogs(SocialEquityLogLocalServiceUtil.java:133)
      at com.liferay.portlet.social.messaging.CheckEquityLogMessageListener.doReceive(CheckEquityLogMessageListener.java:39)
      at com.liferay.portlet.social.messaging.CheckEquityLogMessageListener.receive(CheckEquityLogMessageListener.java:31)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
      at $Proxy468.receive(Unknown Source)
      at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:57)
      at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
      at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ UPDATE SocialEquityAssetEntry SET informationK = informationK - ( SELECT SUM(value / (expiration - actionDate)) FROM SocialEquityLog WHERE (SocialEquityLog.assetEntryId = SocialEquityAssetEntry.assetEntryId) AND (expiration <= 197) AND (active_ = 1) ), informationB = informationB - ( SELECT SUM((-value / (expiration - actionDate)) * expiration) FROM SocialEquityLog WHERE (SocialEquityLog.assetEntryId = SocialEquityAssetEntry.assetEntryId) AND (expiration <= 197) AND (active_ = 1) ) WHERE assetEntryId IN ( SELECT assetEntryId FROM SocialEquityLog WHERE (type_ = 1) AND (expiration <= 197) AND (active_ = 1) ) ]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal3.socialequityassetentry' doesn't exist
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:833)
      at org.springframework.jdbc.object.SqlUpdate.update(SqlUpdate.java:167)
      at com.liferay.portlet.social.service.base.SocialEquityLogLocalServiceBaseImpl.runSQL(SocialEquityLogLocalServiceBaseImpl.java:419)
      ... 33 more
      Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal3.socialequityassetentry' doesn't exist
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:817)
      at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
      ... 37 more

        Activity

        Hide
        Bob added a comment -

        Still present in 6.0.4

        Show
        Bob added a comment - Still present in 6.0.4
        Hide
        Pani Gui (Inactive) added a comment -

        I did upgrading from 6.0.1 to 6.0.4, did not show error messages. Working fine.

        Show
        Pani Gui (Inactive) added a comment - I did upgrading from 6.0.1 to 6.0.4, did not show error messages. Working fine.

          People

          • Assignee:
            SE Support
            Reporter:
            Bob
            Recent user:
            Esther Sanz
            Participants of an Issue:
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Days since last comment:
              4 years, 44 weeks, 3 days ago

              Development

                Structure Helper Panel