ERROR

struct
Browser CCBot/2.0 (https://commoncrawl.org/faq/)
DateTime {ts '2024-10-04 16:54:37'}
Diagnostics Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. <br>The error occurred on line 37.
GeneratedContent [empty string]
HTTPReferer [empty string]
Mailto [empty string]
Message Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
QueryString coursekey=7772
RemoteAddress 3.236.86.184
RootCause
struct
Detail [empty string]
ErrorCode n/a
Message Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
NativeErrorCode 0
SQLState n/a
StackTrace coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. at coldfusion.sql.Parameter.getMappingValue(Parameter.java:112) at coldfusion.sql.Parameter.getMappingValues(Parameter.java:62) at coldfusion.sql.InParameter.setStatement(InParameter.java:72) at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109) at coldfusion.sql.Executive.executeQuery(Executive.java:1466) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) at cfsyllabus2ecfm1572785042._factor12(F:\Web Properties\dentallearning.org\website\syllabus.cfm:37) at cfsyllabus2ecfm1572785042.runPage(F:\Web Properties\dentallearning.org\website\syllabus.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfcache2einc2ecfm1872787899$funcGETPAGE.runFunction(F:\Web Properties\dentallearning.org\website\core\includes\post-processors\cache.inc.cfm:60) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655) at cfpost2dprocess2einc2ecfm73297109.runPage(F:\Web Properties\dentallearning.org\website\core\includes\post-process.inc.cfm:16) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfApplication2ecfm332189700.runPage(F:\Web Properties\dentallearning.org\website\Application.cfm:85) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:352) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 37
RAW_TRACE at cfsyllabus2ecfm1572785042._factor12(F:\Web Properties\dentallearning.org\website\syllabus.cfm:37)
TEMPLATE F:\Web Properties\dentallearning.org\website\syllabus.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_SYLLABUS
LINE 1
RAW_TRACE at cfsyllabus2ecfm1572785042.runPage(F:\Web Properties\dentallearning.org\website\syllabus.cfm:1)
TEMPLATE F:\Web Properties\dentallearning.org\website\syllabus.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 60
RAW_TRACE at cfcache2einc2ecfm1872787899$funcGETPAGE.runFunction(F:\Web Properties\dentallearning.org\website\core\includes\post-processors\cache.inc.cfm:60)
TEMPLATE F:\Web Properties\dentallearning.org\website\core\includes\post-processors\cache.inc.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 16
RAW_TRACE at cfpost2dprocess2einc2ecfm73297109.runPage(F:\Web Properties\dentallearning.org\website\core\includes\post-process.inc.cfm:16)
TEMPLATE F:\Web Properties\dentallearning.org\website\core\includes\post-process.inc.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 85
RAW_TRACE at cfApplication2ecfm332189700.runPage(F:\Web Properties\dentallearning.org\website\Application.cfm:85)
TEMPLATE F:\Web Properties\dentallearning.org\website\Application.cfm
TYPE CFML
Type Database
sql_type CF_SQL_INTEGER
value [empty string]
StackTrace coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. at coldfusion.sql.Parameter.getMappingValue(Parameter.java:112) at coldfusion.sql.Parameter.getMappingValues(Parameter.java:62) at coldfusion.sql.InParameter.setStatement(InParameter.java:72) at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109) at coldfusion.sql.Executive.executeQuery(Executive.java:1466) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) at cfsyllabus2ecfm1572785042._factor12(F:\Web Properties\dentallearning.org\website\syllabus.cfm:37) at cfsyllabus2ecfm1572785042.runPage(F:\Web Properties\dentallearning.org\website\syllabus.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfcache2einc2ecfm1872787899$funcGETPAGE.runFunction(F:\Web Properties\dentallearning.org\website\core\includes\post-processors\cache.inc.cfm:60) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655) at cfpost2dprocess2einc2ecfm73297109.runPage(F:\Web Properties\dentallearning.org\website\core\includes\post-process.inc.cfm:16) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfApplication2ecfm332189700.runPage(F:\Web Properties\dentallearning.org\website\Application.cfm:85) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:352) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 37
RAW_TRACE at cfsyllabus2ecfm1572785042._factor12(F:\Web Properties\dentallearning.org\website\syllabus.cfm:37)
TEMPLATE F:\Web Properties\dentallearning.org\website\syllabus.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_SYLLABUS
LINE 1
RAW_TRACE at cfsyllabus2ecfm1572785042.runPage(F:\Web Properties\dentallearning.org\website\syllabus.cfm:1)
TEMPLATE F:\Web Properties\dentallearning.org\website\syllabus.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 60
RAW_TRACE at cfcache2einc2ecfm1872787899$funcGETPAGE.runFunction(F:\Web Properties\dentallearning.org\website\core\includes\post-processors\cache.inc.cfm:60)
TEMPLATE F:\Web Properties\dentallearning.org\website\core\includes\post-processors\cache.inc.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 16
RAW_TRACE at cfpost2dprocess2einc2ecfm73297109.runPage(F:\Web Properties\dentallearning.org\website\core\includes\post-process.inc.cfm:16)
TEMPLATE F:\Web Properties\dentallearning.org\website\core\includes\post-process.inc.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 85
RAW_TRACE at cfApplication2ecfm332189700.runPage(F:\Web Properties\dentallearning.org\website\Application.cfm:85)
TEMPLATE F:\Web Properties\dentallearning.org\website\Application.cfm
TYPE CFML
Template /syllabus.cfm
Type coldfusion.runtime.CfErrorWrapper

CGI

struct
AUTH_PASSWORD [empty string]
AUTH_TYPE [empty string]
AUTH_USER [empty string]
CERT_COOKIE [empty string]
CERT_FLAGS [empty string]
CERT_ISSUER [empty string]
CERT_KEYSIZE 256
CERT_SECRETKEYSIZE 3072
CERT_SERIALNUMBER [empty string]
CERT_SERVER_ISSUER C=US, O=Let's Encrypt, CN=R11
CERT_SERVER_SUBJECT CN=dentallearning.org
CERT_SUBJECT [empty string]
CF_TEMPLATE_PATH F:\Web Properties\dentallearning.org\website\syllabus.cfm
CONTENT_LENGTH 0
CONTENT_TYPE [empty string]
CONTEXT_PATH [empty string]
GATEWAY_INTERFACE CGI/1.1
HTTPS on
HTTPS_KEYSIZE 256
HTTPS_SECRETKEYSIZE 3072
HTTPS_SERVER_ISSUER C=US, O=Let's Encrypt, CN=R11
HTTPS_SERVER_SUBJECT CN=dentallearning.org
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING br,gzip
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE [empty string]
HTTP_HOST dentallearning.org
HTTP_REFERER [empty string]
HTTP_URL /syllabus.cfm?coursekey=7772
HTTP_USER_AGENT CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR 209.177.102.105
PATH_INFO [empty string]
PATH_TRANSLATED F:\Web Properties\dentallearning.org\website\syllabus.cfm
QUERY_STRING coursekey=7772
REMOTE_ADDR 3.236.86.184
REMOTE_HOST 3.236.86.184
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /syllabus.cfm
SERVER_NAME dentallearning.org
SERVER_PORT 443
SERVER_PORT_SECURE 1
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/8.5
WEB_SERVER_API [empty string]

URL

struct
coursekey 7772

FORM

struct [empty]

SESSION

struct
cfid 107581391
cftoken 1ccee8a9670a55ee-8A014406-F8DA-8DCD-160B832135127F2D
language english
location
struct
CITY_ID 0
CITY_OBJ
struct
city_id 0
coordinate_id 0
created [empty string]
created_by 0
long_name [empty string]
modified [empty string]
modified_by 0
province_id 0
short_name [empty string]
status Active
validation_checksum
struct [empty]
COORDINATE_ID 0
COORDINATE_OBJ
struct
coordinate_id 0
created [empty string]
created_by 0
lat 0
long 0
modified [empty string]
modified_by 0
validation_checksum
struct [empty]
COUNTRY_ID 0
COUNTRY_OBJ
struct
coordinate_id 0
country_id 0
created [empty string]
created_by 0
long_name [empty string]
modified [empty string]
modified_by 0
short_name [empty string]
status Active
validation_checksum
struct [empty]
POSTAL_CODE_ID 0
POSTAL_CODE_OBJ
struct
city_id 0
coordinate_id 0
created [empty string]
created_by 0
modified [empty string]
modified_by 0
postal_code [empty string]
postal_code_id 0
province_id 0
status Active
validation_checksum
struct [empty]
PROVINCE_ID 0
PROVINCE_OBJ
struct
coordinate_id 0
country_id 0
created [empty string]
created_by 0
long_name [empty string]
modified [empty string]
modified_by 0
province_id 0
short_name [empty string]
status Active
validation_checksum
struct [empty]
sessionid 140CE46030064E24021CB2FDAE437D38_107581391_1ccee8a9670a55ee-8A014406-F8DA-8DCD-160B832135127F2D
tstmde false
urltoken CFID=107581391&CFTOKEN=1ccee8a9670a55ee-8A014406-F8DA-8DCD-160B832135127F2D

COOKIE

struct
CFID 107581391
CFTOKEN 1ccee8a9670a55ee-8A014406-F8DA-8DCD-160B832135127F2D