BUNDY

Chyba v API

apipath:
"/api/v1/catalog/categories/3806%3A3904%3A3905/products?page=1"
response:

{"code":2000,"message":"Unspecified internal server error","internal_message":"jOOQ; bad SQL grammar [select count(distinct `ssp`.`c_products`.`product_guid`) as `count` from `ssp`.`c_products` join (select `ssp`.`c_prices`.`product_guid` as `product_guid`, `ssp`.`c_prices`.`currency` as `currency`, `ssp`.`c_prices`.`price` as `price`, `ssp`.`c_prices`.`original_price` as `original_price`, `ssp`.`c_prices`.`discount_pc` as `discount_pc`, `ssp`.`c_prices`.`vat` as `vat`, `ssp`.`c_prices`.`with_vat` as `with_vat`, `ssp`.`c_categories_products`.`position` as `position` from `ssp`.`c_categories_products` join `ssp`.`c_prices` on `ssp`.`c_prices`.`product_guid` = `ssp`.`c_categories_products`.`product_guid` join `ssp`.`c_inventory_products` on `ssp`.`c_inventory_products`.`product_guid` = `ssp`.`c_categories_products`.`product_guid` where (`ssp`.`c_prices`.`pricelist` = ? and `ssp`.`c_inventory_products`.`inventory` in (?, ?) and `ssp`.`c_categories_products`.`topmost_id` = ?) group by `ssp`.`c_categories_products`.`product_guid`) as `sub` on `ssp`.`c_products`.`product_guid` = `sub`.`product_guid` join `ssp`.`c_translations` on `ssp`.`c_products`.`product_guid` = `ssp`.`c_translations`.`product_guid` left outer join `ssp`.`c_tags` as `t_size` on (`ssp`.`c_products`.`product_guid` = `t_size`.`product_guid` and `t_size`.`tag` = ?) left outer join `ssp`.`c_tags` as `t_color` on (`ssp`.`c_products`.`product_guid` = `t_color`.`product_guid` and `t_color`.`tag` = ?) left outer join `ssp`.`c_tags` as `t_brand` on (`ssp`.`c_products`.`product_guid` = `t_brand`.`product_guid` and `t_brand`.`tag` = ?) where `ssp`.`c_translations`.`language` = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ssp.c_categories_products.topmost_id' in 'where clause'","stack_trace":"org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)\norg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)\norg.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.translate(JooqExceptionTranslator.java:89)\norg.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.handle(JooqExceptionTranslator.java:78)\norg.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.exception(JooqExceptionTranslator.java:53)\norg.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:246)\norg.jooq.impl.AbstractQuery.execute(AbstractQuery.java:355)\norg.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:341)\norg.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:328)\norg.jooq.impl.AbstractResultQuery.fetchAny(AbstractResultQuery.java:684)\norg.jooq.impl.AbstractResultQuery.fetchAny(AbstractResultQuery.java:652)\norg.jooq.impl.SelectImpl.fetchAny(SelectImpl.java:2887)\ncz.stigma.sombrero.catalog.infrastructure.repository.JooqRepository.findProductsCount(JooqRepository.java:33)\ncz.stigma.sombrero.catalog.domain.CatalogServiceJooqImpl.getProducts(CatalogServiceJooqImpl.java:54)\ncz.stigma.sombrero.catalog.domain.CatalogServiceJooqImpl$$FastClassBySpringCGLIB$$4937e8f.invoke()\norg.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\norg.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:651)\ncz.stigma.sombrero.catalog.domain.CatalogServiceJooqImpl$$EnhancerBySpringCGLIB$$3500162c.getProducts()\ncz.stigma.sombrero.api.catalog.CatalogResourceImpl.internalGetProducts(CatalogResourceImpl.java:114)\ncz.stigma.sombrero.api.catalog.CatalogResourceImpl.getCategoryProducts(CatalogResourceImpl.java:78)\nsun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source)\nsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\njava.lang.reflect.Method.invoke(Method.java:498)\norg.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)\norg.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)\norg.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)\norg.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)\norg.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)\norg.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)\norg.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)\norg.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)\norg.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)\norg.glassfish.jersey.internal.Errors$1.call(Errors.java:271)\norg.glassfish.jersey.internal.Errors$1.call(Errors.java:267)\norg.glassfish.jersey.internal.Errors.process(Errors.java:315)\norg.glassfish.jersey.internal.Errors.process(Errors.java:297)\norg.glassfish.jersey.internal.Errors.process(Errors.java:267)\norg.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)\norg.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)\norg.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)\norg.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)\norg.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)\norg.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)\norg.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)\norg.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.boot.actuate.autoconfigure.EndpointWebMvcAutoConfiguration$ApplicationContextHeaderFilter.doFilterInternal(EndpointWebMvcAutoConfiguration.java:281)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\ncz.stigma.sombrero.application.http.ApiRequestContextFilter.doFilter(ApiRequestContextFilter.java:108)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\ncz.stigma.sombrero.application.http.RequestIdFilter.doFilter(RequestIdFilter.java:43)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:436)\norg.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:177)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:115)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)\norg.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)\norg.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:69)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:176)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:68)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)\norg.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:184)\norg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)\norg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:89)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:103)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)\norg.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\norg.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:176)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)\norg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\norg.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\norg.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)\norg.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)\norg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)\norg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)\norg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)\norg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)\norg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)\norg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)\norg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)\norg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1100)\norg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:687)\norg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)\norg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)\njava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\njava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\norg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\njava.lang.Thread.run(Thread.java:745)\n"}