Lucee 5.2.9.31 Error (database) | |
Message | |
Detail | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cmsContent.status = 3 LIMIT 1' at line 13 |
SQL | SELECT cmsContent.*, ProdHead.*, prodSku.* FROM prodMenuIndex INNER JOIN cmsContent ON prodMenuIndex.productPageID = cmsContent.pageID INNER JOIN prodHead ON prodMenuIndex.prodCode = prodHead.prodCode LEFT JOIN prodSku ON prodHead.prodCode = prodSku.prodCode WHERE prodMenuIndex.pmID = AND cmsContent.status = 3 LIMIT 1 |
DatabaseName | MySQL |
DatabaseVersion | 5.7.24-0ubuntu0.18.04.1 |
DriverName | MySQL Connector/J |
DriverVersion | mysql-connector-java-8.0.11 (Revision: 6d4eaa273bc181b4cf1c8ad0821a2227f116fedf) |
Datasource | milliemiles |
Stacktrace | The Error Occurred in /var/www/milliemiles.co.uk/html/bwa-assets/plugins/Webshop-Categories/productDetail.cfm: line 68 66: AND cmsContent.status = 3called from /var/www/milliemiles.co.uk/html/bwa-assets/themes/default/include/template.cfm: line 84 82: </cfcase>called from /var/www/milliemiles.co.uk/html/bwa-include/buildTemplate.cfm: line 135 133:called from /var/www/milliemiles.co.uk/html/index.cfm: line 3 1: <cfoutput>called from /var/www/milliemiles.co.uk/html/application.cfc: line 525 523: <cfinclude template="#script#" /> |
Java Stacktrace | lucee.runtime.exp.DatabaseException: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:790) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:675) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:293) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273) at lucee.runtime.type.QueryImpl. at lucee.runtime.tag.Query.executeDatasoure(Query.java:951) at lucee.runtime.tag.Query.doEndTag(Query.java:700) at bwa_assets180.plugins.webshop_categories360.productdetail_cfm$cf.call(/localMapping/bwa-assets/plugins/Webshop-Categories/productDetail.cfm:68) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at bwa_assets180.themes._default.include.template_cfm$cf.call(/localMapping/bwa-assets/themes/default/include/template.cfm:84) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at bwa_include180.buildtemplate_cfm$cf.call(/localMapping/bwa-include/buildTemplate.cfm:135) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at index_cfm$cf.call(/index.cfm:3) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:901) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at application_cfc$cf.udfCall(/application.cfc:525) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:657) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:438) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427) at lucee.runtime.engine.Request.exe(Request.java:44) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1090) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1038) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) 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:52) 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:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) |
Timestamp | 29/03/24 11:25:51 GMT |