Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Christian Schefer
SQL Syntax error after upgrade to GA2
August 5, 2012 8:09 PM
Answer

Christian Schefer

Rank: New Member

Posts: 19

Join Date: May 27, 2011

Recent Posts

Hello!

I'm having an error after update from GA1 to GA2 when i'm trying to navigate via categories previously defined

  103:03:17,738 ERROR [http-bio-80-exec-9][JDBCExceptionReporter:76] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS ( SELECT 1 FROM AssetEntries_AssetCategories WHERE (AssetEntries_AssetCat' at line 1
  203:03:17,740 ERROR [http-bio-80-exec-9][IncludeTag:253] Current URL /en/group/guest/1er-ano?p_p_id=122_INSTANCE_y88jJx9Zyujc&p_p_lifecycle=0&p_p_state=normal&p_p_mode=view&p_p_col_id=column-1&p_p_col_pos=1&p_p_col_count=3&p_r_p_564233524_resetCur=true&p_r_p_564233524_categoryId=36719 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
  303:03:17,743 ERROR [http-bio-80-exec-9][IncludeTag:154] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
  4        at com.liferay.portlet.asset.service.persistence.AssetEntryFinderImpl.countEntries(AssetEntryFinderImpl.java:77)
  5        at com.liferay.portlet.asset.service.impl.AssetEntryLocalServiceImpl.getEntriesCount(AssetEntryLocalServiceImpl.java:189)
  6        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
  7        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
  8        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
  9        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 10        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 11        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 12        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 13        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 14        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 15        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 16        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 17        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
 18        at com.liferay.portlet.asset.service.impl.AssetEntryServiceImpl.filterEntryQuery(AssetEntryServiceImpl.java:227)
 19        at com.liferay.portlet.asset.service.impl.AssetEntryServiceImpl.getEntriesCount(AssetEntryServiceImpl.java:109)
 20        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
 21        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
 22        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 23        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 24Caused by: com.liferay.portal.kernel.dao.orm.ORMException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
 25        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
 26        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.iterate(SQLQueryImpl.java:83)
 27        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.iterate(SQLQueryImpl.java:74)
 28        at com.liferay.portlet.asset.service.persistence.AssetEntryFinderImpl.countEntries(AssetEntryFinderImpl.java:64)
 29        at com.liferay.portlet.asset.service.impl.AssetEntryLocalServiceImpl.getEntriesCount(AssetEntryLocalServiceImpl.java:189)
 30        at sun.reflect.GeneratedMethodAccessor1068.invoke(Unknown Source)
 31        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 32        at java.lang.reflect.Method.invoke(Method.java:601)
 33        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
 34        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
 35        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 36        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 37        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 38        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 39        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 40        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 41        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 42        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 43        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 44        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
 45        at $Proxy128.getEntriesCount(Unknown Source)
 46        at com.liferay.portlet.asset.service.impl.AssetEntryServiceImpl.filterEntryQuery(AssetEntryServiceImpl.java:227)
 47        at com.liferay.portlet.asset.service.impl.AssetEntryServiceImpl.getEntriesCount(AssetEntryServiceImpl.java:109)
 48        at sun.reflect.GeneratedMethodAccessor1067.invoke(Unknown Source)
 49        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 50        at java.lang.reflect.Method.invoke(Method.java:601)
 51        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
 52        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
 53        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 54        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 55        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 56        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 57        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 58        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 59        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 60        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
 61        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
 62        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
 63        at $Proxy129.getEntriesCount(Unknown Source)
 64        at com.liferay.portlet.asset.service.AssetEntryServiceUtil.getEntriesCount(AssetEntryServiceUtil.java:80)
 65        at org.apache.jsp.html.portlet.asset_005fpublisher.view_jsp._jspService(view_jsp.java:1293)
 66        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 67        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 68        at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:97)
 69        at com.liferay.portal.servlet.PACLRequestDispatcherWrapper.doDispatch(PACLRequestDispatcherWrapper.java:90)
 70        at com.liferay.portal.servlet.PACLRequestDispatcherWrapper.include(PACLRequestDispatcherWrapper.java:54)
 71        at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:345)
 72        at com.liferay.taglib.util.IncludeTag.doInclude(IncludeTag.java:245)
 73        at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:86)
 74        at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:4623)
 75        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 76        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 77        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
 78        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
 79        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
 80        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 81        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
 82        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 83        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
 84        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
 85        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:73)
 86        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
 87        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 88        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
 89        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593)
 90        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530)
 91        at com.liferay.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:323)
 92        at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:120)
 93        at com.liferay.portal.struts.PortletRequestProcessor.doInclude(PortletRequestProcessor.java:357)
 94        at com.liferay.portal.struts.PortletRequestProcessor.doForward(PortletRequestProcessor.java:327)
 95        at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
 96        at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:302)
 97        at com.liferay.portal.struts.PortletRequestProcessor.processForwardConfig(PortletRequestProcessor.java:465)
 98        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
 99        at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:224)
100        at com.liferay.portlet.StrutsPortlet.include(StrutsPortlet.java:274)
101        at com.liferay.portlet.StrutsPortlet.doView(StrutsPortlet.java:153)
102        at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:218)
103        at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
104        at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:100)
105        at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:64)
106        at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:548)
107        at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:607)
108        at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:359)
109        at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1207)
110        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
111        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
112        at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:97)
113        at com.liferay.portal.servlet.PACLRequestDispatcherWrapper.doDispatch(PACLRequestDispatcherWrapper.java:90)
114        at com.liferay.portal.servlet.PACLRequestDispatcherWrapper.include(PACLRequestDispatcherWrapper.java:54)
115        at com.liferay.portal.util.PortalImpl.renderPortlet(PortalImpl.java:5158)
116        at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:1569)
117        at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:165)
118        at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processPortlet(RuntimePortletImpl.java:97)
119        at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.doProcessTemplate(RuntimePortletImpl.java:531)
120        at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.doDispatch(RuntimePortletImpl.java:394)
121        at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processTemplate(RuntimePortletImpl.java:228)
122        at com.liferay.portlet.layoutconfiguration.util.RuntimePortletImpl.processTemplate(RuntimePortletImpl.java:216)
123        at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:113)
124        at org.apache.jsp.html.portal.layout.view.portlet_jsp._jspService(portlet_jsp.java:507)
125        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
126        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
127        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
128        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
129        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
130        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
131        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
132        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
133        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
134        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
135        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:73)
136        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
137        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
138        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
139        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593)
140        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530)
141        at com.liferay.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:468)
142        at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:735)
143        at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:249)
144        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
145        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
146        at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:176)
147        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
148        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
149        at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
150        at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:560)
151        at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:537)
152        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
153        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
154        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
155        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
156        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
157        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
158        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
159        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
160        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
161        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
162        at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:294)
163        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
164        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
165        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
166        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:73)
167        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
168        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
169        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
170        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
171        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
172        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
173        at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:138)
174        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
175        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
176        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
177        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
178        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
179        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
180        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
181        at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:335)
182        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
183        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
184        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
185        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
186        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
187        at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:123)
188        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
189        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
190        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
191        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
192        at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:294)
193        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
194        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
195        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
196        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
197        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
198        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
199        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
200        at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:56)
201        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
202        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
203        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
204        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
205        at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:246)
206        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
207        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
208        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
209        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:73)
210        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
211        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
212        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
213        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
214        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
215        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
216        at com.liferay.portal.servlet.I18nServlet.service(I18nServlet.java:102)
217        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
218        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
219        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
220        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72)
221        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
222        at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:83)
223        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
224        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
225        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
226        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
227        at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:80)
228        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
229        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
230        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
231        at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:163)
232        at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:216)
233        at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:57)
234        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
235        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
236        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:187)
237        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:95)
238        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
239        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
240        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
241        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
242        at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
243        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:206)
244        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:108)
245        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:167)
246        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:95)
247        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
248        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:167)
249        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:95)
250        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
251        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:187)
252        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:95)
253        at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:73)
254        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
255        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
256        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
257        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
258        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
259        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
260        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
261        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
262        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
263        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
264        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
265        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
266        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
267        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
268        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
269        at java.lang.Thread.run(Thread.java:722)
270Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
271        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
272        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:111)
273        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:92)
274        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.iterate(SQLQueryImpl.java:80)
275        ... 243 more
276Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
277        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
278        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
279        at org.hibernate.loader.Loader.doList(Loader.java:2545)
280        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
281        at org.hibernate.loader.Loader.list(Loader.java:2271)
282        at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
283        at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
284        at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
285        at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
286        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:99)
287        ... 245 more
288Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS ( SELECT 1 FROM AssetEntries_AssetCategories WHERE (AssetEntries_AssetCat' at line 1
289        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
290        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
291        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
292        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
293        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
294        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
295        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
296        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
297        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
298        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
299        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
300        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
301        at org.hibernate.loader.Loader.doList(Loader.java:2542)
302        ... 252 more



Could you help me to undestand this error?

Thanks!
Pravin Pawar
RE: SQL Syntax error after upgrade to GA2
February 26, 2013 4:32 AM
Answer

Pravin Pawar

Rank: Junior Member

Posts: 62

Join Date: November 17, 2009

Recent Posts

Hi,

I am also facing the same issue.

Kindly check the log here. http://issues.liferay.com/secure/attachment/51542/MultiLevelCatError_in_AssetPublisher.txt

I am also trying to implement the multiple categories filtering on Asset publisher
Refer http://www.liferay.com/community/forums/-/message_boards/view_message/12400782#_19_message_9843469


Hoping for positive response :-)
Juan Gonzalez
RE: SQL Syntax error after upgrade to GA2
February 26, 2013 5:32 AM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1930

Join Date: October 28, 2008

Recent Posts

Will try to patch in few days.

Watch lcepatchers web page in next days...
Pravin Pawar
RE: SQL Syntax error after upgrade to GA2
March 1, 2013 5:08 AM
Answer

Pravin Pawar

Rank: Junior Member

Posts: 62

Join Date: November 17, 2009

Recent Posts

Hi Juan,

Any updates on the patch.

I haven't seen any patch related to above fix on lcepatchers.
Juan Gonzalez
RE: SQL Syntax error after upgrade to GA2
March 2, 2013 8:26 AM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1930

Join Date: October 28, 2008

Recent Posts

Just commited.

Check after few minutes when automatic build is available.
Pravin Pawar
RE: SQL Syntax error after upgrade to GA2
March 4, 2013 5:50 AM
Answer

Pravin Pawar

Rank: Junior Member

Posts: 62

Join Date: November 17, 2009

Recent Posts

Hey Juan,

Thanks for the patch.
I will try that and let you know if any issue emoticon