Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Bob Dietrich
Upgrade 6.0.1 to 6.0.3 w/MySQL exceptions
July 17, 2010 1:12 PM
Answer

Bob Dietrich

Rank: Regular Member

Posts: 221

Join Date: May 15, 2005

Recent Posts

Attempting to upgrade LR 6.0.1 to 6.0.3 using MySQL gets the following exceptions (filed as LPS-11341):
  112:38:40,229 INFO  [DialectDetector] Determining dialect for MySQL 5
  212:38:40,414 INFO  [DialectDetector] Using dialect org.hibernate.dialect.MySQLDialect
  312:38:48,110 INFO  [PortalImpl] Global lib directory
  412: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/
  512:39:13,880 INFO  [STDOUT] Starting Liferay Portal Community Edition 6.0.3 CE (Bunyan / Build 6003 / July 15, 2010)
  612:39:17,375 INFO  [BaseDB] Database does not support case sensitive queries
  712:39:32,601 ERROR [JDBCExceptionReporter] Unknown column 'userimpl0_.facebookId' in 'field list'
  812: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}}
  9com.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]
 10    at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:176)
 11    at com.liferay.portal.service.persistence.UserPersistenceImpl.fetchByPrimaryKey(UserPersistenceImpl.java:758)
 12    at com.liferay.portlet.calendar.service.impl.CalEventLocalServiceImpl.checkEvents(CalEventLocalServiceImpl.java:305)
 13    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 14    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 15    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 16    at java.lang.reflect.Method.invoke(Method.java:597)
 17    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 18    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 19    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 20    at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:65)
 21    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 22    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 23    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 24    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 25    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
 26    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 27    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 28    at $Proxy438.checkEvents(Unknown Source)
 29    at com.liferay.portlet.calendar.service.CalEventLocalServiceUtil.checkEvents(CalEventLocalServiceUtil.java:184)
 30    at com.liferay.portlet.calendar.messaging.CheckEventMessageListener.doReceive(CheckEventMessageListener.java:39)
 31    at com.liferay.portlet.calendar.messaging.CheckEventMessageListener.receive(CheckEventMessageListener.java:31)
 32    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 33    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 34    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 35    at java.lang.reflect.Method.invoke(Method.java:597)
 36    at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
 37    at $Proxy468.receive(Unknown Source)
 38    at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:57)
 39    at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
 40    at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
 41    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 42    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 43    at java.lang.Thread.run(Thread.java:619)
 44Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portal.model.impl.UserImpl#10884]
 45    at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
 46    at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:120)
 47    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 48    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 49    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 50    at java.lang.reflect.Method.invoke(Method.java:597)
 51    at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
 52    at $Proxy465.get(Unknown Source)
 53    at com.liferay.portal.service.persistence.UserPersistenceImpl.fetchByPrimaryKey(UserPersistenceImpl.java:755)
 54    ... 32 more
 55Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portal.model.impl.UserImpl#10884]
 56    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
 57    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 58    at org.hibernate.loader.Loader.loadEntity(Loader.java:1937)
 59    at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
 60    at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
 61    at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
 62    at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
 63    at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
 64    at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
 65    at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:269)
 66    at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
 67    at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
 68    at org.hibernate.impl.SessionImpl.get(SessionImpl.java:997)
 69    at org.hibernate.impl.SessionImpl.get(SessionImpl.java:990)
 70    at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:117)
 71    ... 39 more
 72Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'userimpl0_.facebookId' in 'field list'
 73    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
 74    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
 75    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
 76    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
 77    at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
 78    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
 79    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
 80    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
 81    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
 82    at org.hibernate.loader.Loader.getResultSet(Loader.java:1849)
 83    at org.hibernate.loader.Loader.doQuery(Loader.java:718)
 84    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
 85    at org.hibernate.loader.Loader.loadEntity(Loader.java:1933)
 86    ... 51 more
 8712:39:32,861 INFO  [PluginPackageUtil] Reloading repositories
 8812:39:33,290 ERROR [JDBCExceptionReporter] Unknown column 'companyimp0_.maxUsers' in 'field list'
 8912: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}}
 90com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
 91    at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:176)
 92    at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findBySystem(CompanyPersistenceImpl.java:928)
 93    at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findBySystem(CompanyPersistenceImpl.java:872)
 94    at com.liferay.portal.service.impl.CompanyLocalServiceImpl.getCompanies(CompanyLocalServiceImpl.java:406)
 95    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 96    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 97    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 98    at java.lang.reflect.Method.invoke(Method.java:597)
 99    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
100    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
101    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
102    at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:65)
103    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
104    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
105    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
106    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
107    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
108    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
109    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
110    at $Proxy251.getCompanies(Unknown Source)
111    at com.liferay.portal.service.CompanyLocalServiceUtil.getCompanies(CompanyLocalServiceUtil.java:158)
112    at com.liferay.portal.security.ldap.PortalLDAPImporterImpl.importFromLDAP(PortalLDAPImporterImpl.java:81)
113    at com.liferay.portal.security.ldap.PortalLDAPImporterUtil.importFromLDAP(PortalLDAPImporterUtil.java:30)
114    at com.liferay.portlet.admin.messaging.LDAPImportMessageListener.doReceive(LDAPImportMessageListener.java:38)
115    at com.liferay.portlet.admin.messaging.LDAPImportMessageListener.receive(LDAPImportMessageListener.java:30)
116    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
117    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
118    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
119    at java.lang.reflect.Method.invoke(Method.java:597)
120    at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
121    at $Proxy468.receive(Unknown Source)
122    at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:57)
123    at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
124    at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
125    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
126    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
127    at java.lang.Thread.run(Thread.java:619)
128Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
129    at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
130    at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:78)
131    at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:60)
132    at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
133    at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findBySystem(CompanyPersistenceImpl.java:925)
134    ... 35 more
135Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
136    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
137    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
138    at org.hibernate.loader.Loader.doList(Loader.java:2297)
139    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
140    at org.hibernate.loader.Loader.list(Loader.java:2167)
141    at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:936)
142    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
143    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
144    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
145    at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:68)
146    ... 38 more
147Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'companyimp0_.maxUsers' in 'field list'
148    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
149    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
150    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
151    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
152    at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
153    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
154    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
155    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
156    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
157    at org.hibernate.loader.Loader.getResultSet(Loader.java:1849)
158    at org.hibernate.loader.Loader.doQuery(Loader.java:718)
159    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
160    at org.hibernate.loader.Loader.doList(Loader.java:2294)
161    ... 45 more
16212:39:47,553 INFO  [HotDeployUtil] Initializing hot deploy manager 504648333
16312:39:47,579 INFO  [ServerDetector] Detected server jboss
16412: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}}
165com.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
166    at com.liferay.portlet.social.service.base.SocialEquityLogLocalServiceBaseImpl.runSQL(SocialEquityLogLocalServiceBaseImpl.java:422)
167    at com.liferay.portlet.social.service.impl.SocialEquityLogLocalServiceImpl.runCheckSQL(SocialEquityLogLocalServiceImpl.java:610)
168    at com.liferay.portlet.social.service.impl.SocialEquityLogLocalServiceImpl.checkEquityLogs(SocialEquityLogLocalServiceImpl.java:118)
169    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
170    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
171    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
172    at java.lang.reflect.Method.invoke(Method.java:597)
173    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
174    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
175    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
176    at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:65)
177    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
178    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
179    at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
180    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
181    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
182    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
183    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
184    at $Proxy392.checkEquityLogs(Unknown Source)
185    at com.liferay.portlet.social.service.SocialEquityLogLocalServiceUtil.checkEquityLogs(SocialEquityLogLocalServiceUtil.java:133)
186    at com.liferay.portlet.social.messaging.CheckEquityLogMessageListener.doReceive(CheckEquityLogMessageListener.java:39)
187    at com.liferay.portlet.social.messaging.CheckEquityLogMessageListener.receive(CheckEquityLogMessageListener.java:31)
188    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
189    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
190    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
191    at java.lang.reflect.Method.invoke(Method.java:597)
192    at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
193    at $Proxy468.receive(Unknown Source)
194    at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:57)
195    at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
196    at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
197    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
198    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
199    at java.lang.Thread.run(Thread.java:619)
200Caused 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
201    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
202    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
203    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
204    at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811)
205    at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:833)
206    at org.springframework.jdbc.object.SqlUpdate.update(SqlUpdate.java:167)
207    at com.liferay.portlet.social.service.base.SocialEquityLogLocalServiceBaseImpl.runSQL(SocialEquityLogLocalServiceBaseImpl.java:419)
208    ... 33 more
209Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal3.socialequityassetentry' doesn't exist
210    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
211    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
212    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
213    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
214    at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
215    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
216    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
217    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
218    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
219    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
220    at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:817)
221    at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
222    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
223    ... 37 more
Shivam Sharma
RE: Upgrade 6.0.1 to 6.0.3 w/MySQL exceptions
August 27, 2010 3:07 AM
Answer

Shivam Sharma

Rank: New Member

Posts: 21

Join Date: August 12, 2010

Recent Posts

hey am also trying to upgrade my lr from 6.0.0 to 6.0.5... I am also getting similar errors... were u able 2 fix urs?
Bob Dietrich
RE: Upgrade 6.0.1 to 6.0.3 w/MySQL exceptions
August 27, 2010 9:13 AM
Answer

Bob Dietrich

Rank: Regular Member

Posts: 221

Join Date: May 15, 2005

Recent Posts

At the time, we didn't have much invested in our 6.0.1 db, so we abandoned it. I did successfully update from 6.0.4 to .5 the other night.

I do plan on trying to update our 4.4.2 db, but not certain how soon.

Also, if you copy your portal-ext.properties file around, make sure the upgrade processes in that file are updated.