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 = 'hoisery'
and product_categorymap.key = 'tights'












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>
255:
256: </cfquery>
257: <!--- if(#sizetype# <> '', cast(#sizetype# as SIGNED ), cast(eusize as SIGNED )), if(#sizetype# <> '', #sizetype#, eusize) --->
258:

called from /var/webdatas/websites/divasboudoir.com/www/products/view.init.cfm: line 164
called from /var/webdatas/websites/divasboudoir.com/www/Application.cfm: line 87
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 08:58:30 CET