MySQL upgrade 6.0.1 to 6.0.3 fails

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

  LPS-10406	MySQL upgrade 6.0.1 to 6.0.2 fails
  LPS-11365	Upgrade Liferay 5.2.3 -> 6.0.3 fails for UpgradePermission
  LPS-11099	Database upgrades from 5.2.8 to 6.0.3 failing on document library upgrade
  LPS-30805	Altering Oracle columns fails during upgrade from 6.0.3
  LPS-11363	Upgrade Liferay 5.2.3 -> 6.0.3 fails

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

[Bob]

Still present in 6.0.4

[Pani Gui]

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