Lucee 5.3.7.47 Error (database)
Message You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND customfieldvalues.deletedAt IS NULL
AND customfieldvalues.moduleChar...' at line 4
SQL SELECT GROUP_CONCAT(columnName) As columnName, group_concat(customValue SEPARATOR'~') AS value FROM
(SELECT GROUP_CONCAT(customFields.dictionaryKey) AS columnName, GROUP_CONCAT(customfieldvalues.value SEPARATOR'~') AS customValue
FROM customFields
INNER JOIN customfieldvalues ON customfieldvalues.customFieldId =customFields.id AND customfieldvalues.variationId= AND customfieldvalues.deletedAt IS NULL
AND customfieldvalues.moduleCharId='articles'
WHERE customFields.moduleCharId='articles' AND customFields.deletedAt IS NULL
UNION
SELECT GROUP_CONCAT(customFields.dictionaryKey) AS columnName,GROUP_CONCAT(customFieldOptions.value SEPARATOR'~') AS customValue
FROM customFieldOptions
INNER JOIN customFields ON customFields.id=customFieldOptions.customFieldId AND customFields.deletedAt IS NULL
INNER JOIN customFieldOptionValues ON customFieldOptionValues.customFieldOptionId=customFieldOptions.id AND customFieldOptionValues.deletedAt IS NULL
AND customFieldOptionValues.variationId=
WHERE customFields.moduleCharId='articles' AND customFieldOptionValues.deletedAt IS NULL) AS a
DatabaseName MySQL
DatabaseVersion 5.5.5-10.5.20-MariaDB
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.19 (Revision: a0ca826f5cdf51a98356fdfb1bf251eb042f80bf)
Datasource vestingstedenroute
Stacktrace The Error Occurred in
S:\Plesk\vestingstedenroute.nl\GPI\controllers\gfCustomFields.cfc: line 21
19: AND customFieldOptionValues.variationId=#arguments.variationId#
20: WHERE customFields.moduleCharId='#arguments.moduleCharId#' AND customFieldOptionValues.deletedAt IS NULL) AS a
21: </cfquery>
22:
23: <!--- Get information without value in column name --->

called from S:\Plesk\vestingstedenroute.nl\GPI\controllers\Articles.cfc: line 47
called from S:\Plesk\vestingstedenroute.nl\GPI\wheels\global\cfml.cfm: line 160
called from S:\Plesk\vestingstedenroute.nl\GPI\wheels\controller\processing.cfm: line 125
called from S:\Plesk\vestingstedenroute.nl\GPI\wheels\controller\processing.cfm: line 92
called from S:\Plesk\vestingstedenroute.nl\GPI\wheels\dispatch\functions.cfm: line 199
called from S:\Plesk\vestingstedenroute.nl\GPI\wheels\index.cfm: line 6
called from S:\Plesk\vestingstedenroute.nl\GPI\rewrite.cfm: line 2
called from S:\Plesk\vestingstedenroute.nl\GPI\wheels\events\onrequest.cfm: line 4
Java Stacktrace lucee.runtime.exp.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND customfieldvalues.deletedAt IS NULL
  AND customfieldvalues.moduleChar...' at line 4
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
  at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:319)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:227)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1112)
  at lucee.runtime.tag.Query._doEndTag(Query.java:686)
  at lucee.runtime.tag.Query.doEndTag(Query.java:553)
  at controllers.gfcustomfields_cfc$cf.udfCall(/controllers/gfCustomFields.cfc:21)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
  at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:792)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729)
  at controllers.articles_cfc$cf.udfCall(/controllers/Articles.cfc:47)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:202)
  at lucee.runtime.tag.Invoke.doFunction(Invoke.java:222)
  at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)
  at global.cfml_cfm$cf.udfCall2(/wheels/global/cfml.cfm:160)
  at global.cfml_cfm$cf.udfCall(/wheels/global/cfml.cfm)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
  at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:792)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729)
  at controller.processing_cfm$cf.udfCall(/wheels/controller/processing.cfm:125)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
  at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:792)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729)
  at controller.processing_cfm$cf.udfCall(/wheels/controller/processing.cfm:92)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710)
  at wheels.dispatch.functions_cfm$cf.udfCall1(/wheels/dispatch/functions.cfm:199)
  at wheels.dispatch.functions_cfm$cf.udfCall(/wheels/dispatch/functions.cfm)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1710)
  at wheels.index_cfm$cf$12i.call(/wheels/index.cfm:6)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
  at rewrite_cfm$cf$12h.call(/rewrite.cfm:2)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
  at wheels.events.onrequest_cfm$cf.udfCall(/wheels/events/onrequest.cfm:4)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
  at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:436)
  at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:215)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
  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:202)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  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:432)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
  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 28-03-24 12:47:27 CET