Lucee 5.3.10.120 Error (database) | |
Message | Unknown column 'product_sizes.auto' in 'field list' |
SQL | select product_sizes.id_size as recorduid, CASE WHEN product_sizes.sizegroup = 'bra' THEN product_sizes.sizegroup WHEN product_sizes.sizegroup = 'stocking' THEN product_sizes.sizegroup WHEN product_sizes.sizegroup = 'sextoys' THEN product_sizes.sizegroup WHEN product_sizes.sizegroup = 'shoes' THEN product_sizes.sizegroup WHEN product_sizes.sizegroup = 'accessories' THEN product_sizes.sizegroup ELSE 'default' END as sizegroup, product_sizes.gender, product_sizes.intlsize as value, if(product_sizes.auto <> '',product_sizes.auto,product_sizes.eusize) as size, if(product_sizes.auto <> '','auto','eusize') as sizetype, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.bust, product_sizes.underbust, product_sizes.waist, product_sizes.hip, CASE WHEN product_sizes.sizegroup = 'bra' THEN if(auto <> '', cast(auto as SIGNED ), cast(eusize as SIGNED )) WHEN product_sizes.sizegroup = 'stocking' THEN SUBSTRING_INDEX(intlsize,'-',1) WHEN product_sizes.sizegroup = 'sextoys' THEN intlsize WHEN product_sizes.sizegroup = 'shoes' THEN cast(auto as SIGNED ) WHEN product_sizes.sizegroup = 'accessories' THEN intlsize ELSE SUBSTRING_INDEX(auto,'-',1) END as param1, CASE WHEN product_sizes.sizegroup = 'bra' THEN if(auto <> '', MID(auto,length(cast(auto as SIGNED ))+1,length(auto)), MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))) WHEN product_sizes.sizegroup = 'stocking' THEN SUBSTRING_INDEX(intlsize,'-',-1) WHEN product_sizes.sizegroup = 'sextoys' THEN intlsize WHEN product_sizes.sizegroup = 'shoes' THEN cast(auto as SIGNED ) WHEN product_sizes.sizegroup = 'accessories' THEN intlsize ELSE SUBSTRING_INDEX(auto,'-',-1) END as param2, if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_variations.warehouse)+sum(product_variations.packaging)-sum(product_variations.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_variations.warehouse)+sum(product_variations.packaging)-sum(product_variations.reserved), 0 ) )) as available, IF((sum(product_variations.warehouse)+sum(product_variations.packaging)-sum(product_variations.reserved))>=0,sum(product_variations.warehouse)+sum(product_variations.packaging)-sum(product_variations.reserved),0) as stock from products left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1 left outer join product_sizes on product_variations.size = product_sizes.suppliersize and FIND_IN_SET(product_sizes.id_size,products.sizes) left outer join product_colors on product_variations.color = product_colors.color left outer join product_categorymap on products.productuid = product_categorymap.productuid left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key) left outer join brands on products.brand = brands.brand where product_variations.size is not null and product_sizes.id_size > 0 and product_sizes.id_size <> 471 and products.isactive = 1 and products.isdeleted = 0 and brands.isactive = 1 and brands.isdeleted = 0 and product_categories.isactive = 1 and brands.branding IN ('all','divasboudoir') and FIND_IN_SET('divasboudoir',products.branding) and product_categories.branding IN ('all','divasboudoir') and product_categorymap.branding IN ('all','divasboudoir') and FIND_IN_SET(product_sizes.sizerange,"all,plus") and products.language in ('all','fr') and product_categories.language in ('all','fr') and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null) and (products.displayTo >= DATE(NOW()) or products.displayTo IS null) and products.isoutletprice = 0 and product_categorymap.section = 'glamour' and product_categorymap.category = 'sexylingerie' and product_categorymap.key = 'bustier' group by product_sizes.gender,product_sizes.sizegroup,product_sizes.intlsize having 1=1 order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, cast(size as SIGNED ), size |
DatabaseName | MySQL |
DatabaseVersion | 5.5.68-MariaDB |
DriverName | MySQL Connector/J |
DriverVersion | mysql-connector-java-8.0.30 (Revision: 1de2fe873fe26189564c030a343885011412976a) |
Datasource | divasboudoir_sitedatas |
Stacktrace | The Error Occurred in /var/webdatas/websites/divasboudoir.com/www/system/api/product/sizes.cfc: line 256 254: </cfswitch>called from /var/webdatas/websites/divasboudoir.com/www/products/view.init.cfm: line 164 162: <cfset request.lists.flavors = application.api.product.colors.filter(type = 'flavor', mode = request.mode, section = request.section, category = request.category, subcategory = request.subcategory, filters = request.filters)>called from /var/webdatas/websites/divasboudoir.com/www/Application.cfm: line 87 85: |
Java Stacktrace | lucee.runtime.exp.DatabaseException: Unknown column 'product_sizes.auto' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:328) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at system.api.product.sizes_cfc$cf$cxl.udfCall(/system/api/product/sizes.cfc:256) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:584) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1950) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1794) at products.view_init_cfm230$cf.call(/products/view.init.cfm:164) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfm$cf.call(/Application.cfm:87) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:56) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:836) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1839) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) |
Timestamp | 29/03/2024 09:10:58 CET |