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!