ATENTIE!

Magazinul online NU functioneaza

 

Error

ErrorPreparedStatementCallback; uncategorized SQLException for SQL [SELECT * FROM ( select p.products_id, p.es_code, s.specials_new_products_price, s.specials_id, s.status as special_status, s.expires_date, p.products_quantity,products_model, p.products_image, p.products_price,p.products_date_added, p.products_last_modified, p.products_date_available , p.products_weight, p.products_status, p.products_tax_class_id , p.es_product_availability_id, p.es_images, p.es_documents, epa.es_product_availability_displayable, epa.es_product_availability_can_order, epad.es_product_availability_name, epad.es_product_availability_description, p.manufacturers_id, p.products_ordered, pd.language_id ,pd.products_name , pd.products_description , pd.products_url , pd.products_viewed, c.categories_id ,c.categories_image , c.parent_id , c.sort_order , c.categories_status, concat(pd.products_name,pd.products_description) as products_name_description, pd.products_friendly_url from products p left join (specials s) on (p.products_id = s.products_id and (s.expires_date > now() or s.expires_date is null)), categories as c,products_to_categories as pc, products_description as pd, es_product_availability as epa, es_product_availability_description as epad where c.categories_id=pc.categories_id and pc.products_id = p.products_id and p.products_id = pd.products_id and epa.es_product_availability_id=epad.es_product_availability_id and p.es_product_availability_id = epa.es_product_availability_id and pd.language_id=epad.es_language_id order by p.products_id ) s where categories_id = ? and language_id = ? and products_status = ? order by manufacturers_id asc]; SQL state [HY000]; error code [126]; Incorrect key file for table '/var/tmp/#sql_85d_1.MYI'; try to repair it; nested exception is java.sql.SQLException: Incorrect key file for table '/var/tmp/#sql_85d_1.MYI'; try to repair it
Error Typeorg.springframework.jdbc.UncategorizedSQLException
Stacktraceorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:187)
ro.esolutions.generic.dao.impl.GenericReadOnlyDAOImpl$3.create(GenericReadOnlyDAOImpl.java:123)
ro.esolutions.generic.dao.impl.GenericReadOnlyDAOImpl$3.create(GenericReadOnlyDAOImpl.java:105)
ro.esolutions.util.cache.CacheTemplate.search(CacheTemplate.java:39)
ro.esolutions.util.cache.ListCacheTemplate.search(ListCacheTemplate.java:17)
ro.esolutions.generic.dao.impl.GenericReadOnlyDAOImpl.listByFilter(GenericReadOnlyDAOImpl.java:105)
ro.esolutions.shopportlet.struts.listProductsFromCategory.ListProductsFromCategoryAction.getManufacturers(ListProductsFromCategoryAction.java:95)
ro.esolutions.shopportlet.struts.listProductsFromCategory.ListProductsFromCategoryAction.view(ListProductsFromCategoryAction.java:75)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
ro.esolutions.shopportlet.struts.PageAction.execute(PageAction.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.portals.bridges.struts.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:50)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
com.liferay.portal.apache.bridges.struts.LiferayRequestDispatcher.invoke(LiferayRequestDispatcher.java:170)
com.liferay.portal.apache.bridges.struts.LiferayRequestDispatcher.include(LiferayRequestDispatcher.java:99)
org.apache.portals.bridges.struts.StrutsPortlet.processRequest(StrutsPortlet.java:375)
org.apache.portals.bridges.struts.StrutsPortlet.doView(StrutsPortlet.java:274)
javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:328)
javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:126)
com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:69)
com.liferay.portal.kernel.servlet.PortletServlet.service(PortletServlet.java:100)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:618)
com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:700)
com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:419)
org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1467)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
com.liferay.portal.util.PortalImpl.renderPortlet(PortalImpl.java:2884)
com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:897)
com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:170)
com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:103)
com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:281)
com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:190)
org.apache.jsp.html.portal.layout.view.portlet_jsp._jspService(portlet_jsp.java:831)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
com.liferay.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:294)
com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:471)
com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:195)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:157)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:608)
com.liferay.portal.servlet.MainServlet.service(MainServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:143)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:142)
com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:94)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:140)
com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:282)
com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:94)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:368)
com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154)
com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:257)
com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.esol.MyServletFilter.doFilter(MyServletFilter.java:35)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437)
org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:366)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Thread.java:619)
Cautare rapida