Lucee 5.3.10.120 Error (database) | |
Message | Unknown column 'auto' in 'field list' |
SQL | select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, 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, if(auto <> '',auto,product_sizes.intlsize) as size, if(auto <> '','auto','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_variations.warehouse, product_variations.ontour, product_variations.packaging, product_variations.supplier, product_variations.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (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, IF((warehouse+packaging-reserved)>=0,warehouse+packaging-reserved,0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size and b.supplier < 0) > 0, -1, (select sum(distinct if(b.supplier >= 0,b.supplier,0)) + if((sum(b.warehouse)+sum(b.packaging)-sum(b.reserved))>=0,sum(b.warehouse)+sum(b.packaging)-sum(b.reserved),0) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size) )) as availablepersize, (select if((sum(c.warehouse)+sum(c.packaging)-sum(c.reserved))>=0,sum(c.warehouse)+sum(c.packaging)-sum(c.reserved),0) from product_variations c where c.isactive = 1 and c.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and c.size = product_variations.size) as stockpersize, (if( (select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color and d.supplier < 0) > 0, -1, (select sum(distinct if(d.supplier >= 0,d.supplier,0)) + if((sum(d.warehouse)+sum(d.packaging)-sum(d.reserved))>=0,sum(d.warehouse)+sum(d.packaging)-sum(d.reserved),0) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color) )) as availablepercolor, (select if((sum(e.warehouse)+sum(e.packaging)-sum(e.reserved))>=0,sum(e.warehouse)+sum(e.packaging)-sum(e.reserved),0) from product_variations e where e.isactive = 1 and e.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and e.color = product_variations.color) as stockpercolor, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice, product_variations.comments from product_variations left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_variations.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and product_variations.isactive = 1 and product_sizes.id_size = 227 and FIND_IN_SET(product_sizes.sizerange,"all,plus") group by product_variations.variationuid UNION select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, 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, if(auto <> '',auto,product_sizes.intlsize) as size, if(auto <> '','auto','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_variations.warehouse, product_variations.ontour, product_variations.packaging, product_variations.supplier, product_variations.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (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, IF((warehouse+packaging-reserved)>=0,warehouse+packaging-reserved,0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size and b.supplier < 0) > 0, -1, (select sum(distinct if(b.supplier >= 0,b.supplier,0)) + if((sum(b.warehouse)+sum(b.packaging)-sum(b.reserved))>=0,sum(b.warehouse)+sum(b.packaging)-sum(b.reserved),0) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size) )) as availablepersize, (select if((sum(c.warehouse)+sum(c.packaging)-sum(c.reserved))>=0,sum(c.warehouse)+sum(c.packaging)-sum(c.reserved),0) from product_variations c where c.isactive = 1 and c.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and c.size = product_variations.size) as stockpersize, (if( (select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color and d.supplier < 0) > 0, -1, (select sum(distinct if(d.supplier >= 0,d.supplier,0)) + if((sum(d.warehouse)+sum(d.packaging)-sum(d.reserved))>=0,sum(d.warehouse)+sum(d.packaging)-sum(d.reserved),0) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color) )) as availablepercolor, (select if((sum(e.warehouse)+sum(e.packaging)-sum(e.reserved))>=0,sum(e.warehouse)+sum(e.packaging)-sum(e.reserved),0) from product_variations e where e.isactive = 1 and e.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and e.color = product_variations.color) as stockpercolor, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice, product_variations.comments from product_variations left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_variations.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and product_variations.isactive = 1 and product_sizes.id_size = 229 and FIND_IN_SET(product_sizes.sizerange,"all,plus") group by product_variations.variationuid UNION select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, 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, if(auto <> '',auto,product_sizes.intlsize) as size, if(auto <> '','auto','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_variations.warehouse, product_variations.ontour, product_variations.packaging, product_variations.supplier, product_variations.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (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, IF((warehouse+packaging-reserved)>=0,warehouse+packaging-reserved,0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size and b.supplier < 0) > 0, -1, (select sum(distinct if(b.supplier >= 0,b.supplier,0)) + if((sum(b.warehouse)+sum(b.packaging)-sum(b.reserved))>=0,sum(b.warehouse)+sum(b.packaging)-sum(b.reserved),0) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size) )) as availablepersize, (select if((sum(c.warehouse)+sum(c.packaging)-sum(c.reserved))>=0,sum(c.warehouse)+sum(c.packaging)-sum(c.reserved),0) from product_variations c where c.isactive = 1 and c.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and c.size = product_variations.size) as stockpersize, (if( (select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color and d.supplier < 0) > 0, -1, (select sum(distinct if(d.supplier >= 0,d.supplier,0)) + if((sum(d.warehouse)+sum(d.packaging)-sum(d.reserved))>=0,sum(d.warehouse)+sum(d.packaging)-sum(d.reserved),0) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color) )) as availablepercolor, (select if((sum(e.warehouse)+sum(e.packaging)-sum(e.reserved))>=0,sum(e.warehouse)+sum(e.packaging)-sum(e.reserved),0) from product_variations e where e.isactive = 1 and e.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and e.color = product_variations.color) as stockpercolor, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice, product_variations.comments from product_variations left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_variations.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and product_variations.isactive = 1 and product_sizes.id_size = 1275 and FIND_IN_SET(product_sizes.sizerange,"all,plus") group by product_variations.variationuid UNION select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, 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, if(auto <> '',auto,product_sizes.intlsize) as size, if(auto <> '','auto','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_variations.warehouse, product_variations.ontour, product_variations.packaging, product_variations.supplier, product_variations.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (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, IF((warehouse+packaging-reserved)>=0,warehouse+packaging-reserved,0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size and b.supplier < 0) > 0, -1, (select sum(distinct if(b.supplier >= 0,b.supplier,0)) + if((sum(b.warehouse)+sum(b.packaging)-sum(b.reserved))>=0,sum(b.warehouse)+sum(b.packaging)-sum(b.reserved),0) from product_variations b where b.isactive = 1 and b.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and b.size = product_variations.size) )) as availablepersize, (select if((sum(c.warehouse)+sum(c.packaging)-sum(c.reserved))>=0,sum(c.warehouse)+sum(c.packaging)-sum(c.reserved),0) from product_variations c where c.isactive = 1 and c.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and c.size = product_variations.size) as stockpersize, (if( (select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color and d.supplier < 0) > 0, -1, (select sum(distinct if(d.supplier >= 0,d.supplier,0)) + if((sum(d.warehouse)+sum(d.packaging)-sum(d.reserved))>=0,sum(d.warehouse)+sum(d.packaging)-sum(d.reserved),0) from product_variations d where d.isactive = 1 and d.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and d.color = product_variations.color) )) as availablepercolor, (select if((sum(e.warehouse)+sum(e.packaging)-sum(e.reserved))>=0,sum(e.warehouse)+sum(e.packaging)-sum(e.reserved),0) from product_variations e where e.isactive = 1 and e.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and e.color = product_variations.color) as stockpercolor, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo, if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice, product_variations.comments from product_variations left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_variations.productuid = 'B50B630C-A8E0-4DC9-90E8680576D67171' and product_variations.isactive = 1 and product_sizes.id_size = 230 and FIND_IN_SET(product_sizes.sizerange,"all,plus") group by product_variations.variationuid order by cast(eusize as SIGNED ), color |
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/variations.cfc: line 229 227: </cfloop>called from /var/webdatas/websites/divasboudoir.com/www/system/api/products.cfc: line 212 210: </cfif>called from /var/webdatas/websites/divasboudoir.com/www/products/view.init.cfm: line 8 6: country = session.country,called from /var/webdatas/websites/divasboudoir.com/www/Application.cfm: line 87 85: |
Java Stacktrace | lucee.runtime.exp.DatabaseException: Unknown column '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.variations_cfc$cf$cgf.udfCall(/system/api/product/variations.cfc:229) 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 system.api.products_cfc$cf$aiv.udfCall1(/system/api/products.cfc:212) at system.api.products_cfc$cf$aiv.udfCall(/system/api/products.cfc) 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:8) 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 02:00:01 CET |