Catch Entries: 15 |
additional | Struct (ordered) | SQL | string | SELECT 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 | | DatabaseVersion | | DriverName | | DriverVersion | string | mysql-connector-java-8.0.28 (Revision: 7ff2161da3899f379fb3171b6538b191b1c5c7e2) |
| Datasource | |
|
DataSource | |
Detail | |
ErrorCode | |
Extended_Info | |
ExtendedInfo | |
Message | string | 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 |
|
NativeErrorCode | |
queryError | string | SELECT 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 | string | SELECT 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 | |
StackTrace | string | lucee.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 | string | 273: GROUP BY t.loginid<br>
274: ORDER BY #variables.orderBy#<br>
<b>275: </cfquery></b><br>
276: <!---<cfif StructKeyExists(COOKIE, 'USERID') AND cookie.USERID EQ 155><br>
277: <cfdump var="#getData#"/><br>
|
| codePrintPlain | string | 273: 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 | | id | | line | | Raw_Trace | string | talent.index_cfm$cf$2.call(/talent/index.cfm:275) |
| template | string | /var/efs/www/omnia/talent/index.cfm |
| type | |
|
|
type | |
where | |