Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT t.loginid FROM talent t INNER JOIN customlogins l ON t.loginid = l.loginid LEFT JOIN talent_category c ON t.loginid = c.loginid LEFT JOIN talent_ethnicity e ON t.loginid = e.loginid LEFT JOIN talent_affiliation g ON t.loginid = g.loginid LEFT JOIN talent_workhistory w ON t.loginid = w.loginid LEFT JOIN talent_skills s ON t.loginid = s.loginid WHERE l.siteid = 45 AND t.loginid NOT IN( SELECT loginid FROM talent_category tc WHERE tc.category = "Voiceover" AND tc.loginid NOT IN( SELECT loginid FROM talent_category WHERE category IN ('On-Camera','Print','Promotional') ) ) AND l.role = 'talent' AND t.published = 1 AND (IFNULL(t.age_min,0) BETWEEN 1 AND 100 OR IFNULL(t.age_max,100) BETWEEN 1 AND 100 OR (IFNULL(t.age_min,year(now())-year(t.DOB)) <= 1 AND IFNULL(t.age_max,year(now())-year(t.DOB)) >= 100) ) --AND (t.height >= 0 AND t.height <= 100) AND t.height BETWEEN 0 AND 100 AND (t.DOB <= '2005-01-27 00:00:00' OR t.DOB IS NULL OR t.DOB = '') GROUP BY t.loginid ORDER BY t.lastname ASC, t.firstname ASC
DatabaseName
stringMySQL
DatabaseVersion
string5.7.12
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-java-8.0.28 (Revision: 7ff2161da3899f379fb3171b6538b191b1c5c7e2)
Datasource
stringoneoffs
DataSource
stringoneoffs
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringYou 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 (t.height >= 0 AND t.height <= 100) AND t.height BETWEEN 0 AND ' at line 37
NativeErrorCode
number1064
queryError
stringSELECT t.loginid FROM talent t INNER JOIN customlogins l ON t.loginid = l.loginid LEFT JOIN talent_category c ON t.loginid = c.loginid LEFT JOIN talent_ethnicity e ON t.loginid = e.loginid LEFT JOIN talent_affiliation g ON t.loginid = g.loginid LEFT JOIN talent_workhistory w ON t.loginid = w.loginid LEFT JOIN talent_skills s ON t.loginid = s.loginid WHERE l.siteid = 45 AND t.loginid NOT IN( SELECT loginid FROM talent_category tc WHERE tc.category = "Voiceover" AND tc.loginid NOT IN( SELECT loginid FROM talent_category WHERE category IN ('On-Camera','Print','Promotional') ) ) AND l.role = 'talent' AND t.published = 1 AND (IFNULL(t.age_min,0) BETWEEN 1 AND 100 OR IFNULL(t.age_max,100) BETWEEN 1 AND 100 OR (IFNULL(t.age_min,year(now())-year(t.DOB)) <= 1 AND IFNULL(t.age_max,year(now())-year(t.DOB)) >= 100) ) --AND (t.height >= 0 AND t.height <= 100) AND t.height BETWEEN 0 AND 100 AND (t.DOB <= '2005-01-27 00:00:00' OR t.DOB IS NULL OR t.DOB = '') GROUP BY t.loginid ORDER BY t.lastname ASC, t.firstname ASC
Sql
stringSELECT t.loginid FROM talent t INNER JOIN customlogins l ON t.loginid = l.loginid LEFT JOIN talent_category c ON t.loginid = c.loginid LEFT JOIN talent_ethnicity e ON t.loginid = e.loginid LEFT JOIN talent_affiliation g ON t.loginid = g.loginid LEFT JOIN talent_workhistory w ON t.loginid = w.loginid LEFT JOIN talent_skills s ON t.loginid = s.loginid WHERE l.siteid = 45 AND t.loginid NOT IN( SELECT loginid FROM talent_category tc WHERE tc.category = "Voiceover" AND tc.loginid NOT IN( SELECT loginid FROM talent_category WHERE category IN ('On-Camera','Print','Promotional') ) ) AND l.role = 'talent' AND t.published = 1 AND (IFNULL(t.age_min,0) BETWEEN 1 AND 100 OR IFNULL(t.age_max,100) BETWEEN 1 AND 100 OR (IFNULL(t.age_min,year(now())-year(t.DOB)) <= 1 AND IFNULL(t.age_max,year(now())-year(t.DOB)) >= 100) ) --AND (t.height >= 0 AND t.height <= 100) AND t.height BETWEEN 0 AND 100 AND (t.DOB <= '2005-01-27 00:00:00' OR t.DOB IS NULL OR t.DOB = '') GROUP BY t.loginid ORDER BY t.lastname ASC, t.firstname ASC
SQLState
string42000
StackTrace
stringlucee.runtime.exp.DatabaseException: 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 (t.height >= 0 AND t.height <= 100) AND t.height BETWEEN 0 AND ' at line 37 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:953) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371) 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:1134) at lucee.runtime.tag.Query._doEndTag(Query.java:699) at lucee.runtime.tag.Query.doEndTag(Query.java:565) at talent.index_cfm$cf$2.call(/talent/index.cfm:275) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1043) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:935) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2475) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2465) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2436) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1198) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1144) 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:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) 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:800) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) 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)
TagContext
Array
1
Struct
codePrintHTML
string273: GROUP BY t.loginid<br> 274: ORDER BY #variables.orderBy#<br> <b>275: &lt;/cfquery&gt;</b><br> 276: &lt;!---&lt;cfif StructKeyExists(COOKIE, 'USERID') AND cookie.USERID EQ 155&gt;<br> 277: &lt;cfdump var=&quot;#getData#&quot;/&gt;<br>
codePrintPlain
string273: GROUP BY t.loginid 274: ORDER BY #variables.orderBy# 275: </cfquery> 276: <!---<cfif StructKeyExists(COOKIE, 'USERID') AND cookie.USERID EQ 155> 277: <cfdump var="#getData#"/>
column
number0
id
string??
line
number275
Raw_Trace
stringtalent.index_cfm$cf$2.call(/talent/index.cfm:275)
template
string/var/efs/www/omnia/talent/index.cfm
type
stringcfml
type
stringdatabase
where
string