An error occurred within the web site, the details are as follows:
struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DataSource | HubbleHomes | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Detail | [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'awards'. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ErrorCode | 42S22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Exceptions |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Message | Error Executing Database Query. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NativeErrorCode | 207 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RootCause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLState | 42S22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sql | SELECT DISTINCT A.ID, A.Title, A.Date, A.ShortDescription, A.PDF, A.PDFTitle, A.HomePage, A.Display, A.ParentID, a.MetaTitle, a.Metadescription, SmallImage, SmallImageAltTag,BlogRows,HideCommenting, SmallImageTitleTag ,detail1 ,image1 ,imageAltTag1 ,Video1 ,ImageLocation1 ,imageTitleTag1 ,detail2 ,image2 ,imageAltTag2 ,Video2 ,ImageLocation2 ,imageTitleTag2 ,detail3 ,image3 ,imageAltTag3 ,Video3 ,ImageLocation3 ,imageTitleTag3 ,detail4 ,image4 ,imageAltTag4 ,Video4 ,ImageLocation4 ,imageTitleTag4 ,detail5 ,image5 ,imageAltTag5 ,Video5 ,ImageLocation5 ,imageTitleTag5 ,detail6 ,image6 ,imageAltTag6 ,Video6 ,ImageLocation6 ,imageTitleTag6 ,detail7 ,image7 ,imageAltTag7 ,Video7 ,ImageLocation7 ,imageTitleTag7 ,detail8 ,image8 ,imageAltTag8 ,Video8 ,ImageLocation8 ,imageTitleTag8 ,detail9 ,image9 ,imageAltTag9 ,Video9 ,ImageLocation9 ,imageTitleTag9 ,detail10 ,image10 ,imageAltTag10 ,Video10 ,ImageLocation10 ,imageTitleTag10 FROM Blog AS A INNER JOIN BlogCategory AS B ON (',' + a.ParentID + ',' LIKE '%,' + CAST(awards AS nvarchar) + ',%') WHERE (A.Display = 1) ORDER BY A.Date DESC, title | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfqry_getAllArticles2ecfm376078570.runPage(D:\CustomDomains\HubbleHomes\htdocs\sNews\qry_getAllArticles.cfm:40) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfindex2ecfm1470606587.runPage(D:\CustomDomains\HubbleHomes\htdocs\sNews\index.cfm:32) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfindex2ecfm544930682._factor7(D:\CustomDomains\HubbleHomes\htdocs\index.cfm:9) at cfindex2ecfm544930682.runPage(D:\CustomDomains\HubbleHomes\htdocs\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:332) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cf4042ecfm1531918848._factor22(D:\CustomDomains\HubbleHomes\htdocs\404.cfm:642) at cf4042ecfm1531918848._factor30(D:\CustomDomains\HubbleHomes\htdocs\404.cfm:505) at cf4042ecfm1531918848._factor32(D:\CustomDomains\HubbleHomes\htdocs\404.cfm:37) at cf4042ecfm1531918848.runPage(D:\CustomDomains\HubbleHomes\htdocs\404.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:474) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121) 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:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) 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(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) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'awards'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 64 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Suppressed |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
queryError | [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'awards'. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
where | [empty string] |
struct [empty] |
---|
struct | |
---|---|
404;https://hubblehomes.bluetangtest.com:443/news/news-article-list/awards-?start | 11 |
start | 11 |
struct | |||
---|---|---|---|
cfid | 6427642 | ||
cftoken | 39c2c3af92f13b49-10327518-006A-F49E-EDC1B1B0634B8D60 | ||
favorites |
|
||
loggedin | [empty string] | ||
sessionid | HUBBLEHOMES_6427642_39c2c3af92f13b49-10327518-006A-F49E-EDC1B1B0634B8D60 | ||
urltoken | CFID=6427642&CFTOKEN=39c2c3af92f13b49-10327518-006A-F49E-EDC1B1B0634B8D60 | ||
userid | [empty string] |
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 | 2048 |
CERT_SERIALNUMBER | [empty string] |
CERT_SERVER_ISSUER | C=US, O=DigiCert Inc, OU=www.digicert.com, CN=RapidSSL TLS RSA CA G1 |
CERT_SERVER_SUBJECT | CN=*.BlueTangTest.com |
CERT_SUBJECT | [empty string] |
CF_TEMPLATE_PATH | D:\CustomDomains\HubbleHomes\htdocs\404.cfm |
CONTENT_LENGTH | 0 |
CONTENT_TYPE | [empty string] |
CONTEXT_PATH | [empty string] |
GATEWAY_INTERFACE | CGI/1.1 |
HTTPS | on |
HTTPS_KEYSIZE | 256 |
HTTPS_SECRETKEYSIZE | 2048 |
HTTPS_SERVER_ISSUER | C=US, O=DigiCert Inc, OU=www.digicert.com, CN=RapidSSL TLS RSA CA G1 |
HTTPS_SERVER_SUBJECT | CN=*.BlueTangTest.com |
HTTP_ACCEPT | */* |
HTTP_ACCEPT_ENCODING | [empty string] |
HTTP_ACCEPT_LANGUAGE | [empty string] |
HTTP_CONNECTION | [empty string] |
HTTP_COOKIE | CFTOKEN=39c2c3af92f13b49-10327518-006A-F49E-EDC1B1B0634B8D60; JSESSIONID=C0B092ED6A88797A93CE2562703F4E21.cfusion; CFID=6427642 |
HTTP_HOST | hubblehomes.bluetangtest.com |
HTTP_REFERER | [empty string] |
HTTP_URL | [empty string] |
HTTP_USER_AGENT | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
LOCAL_ADDR | 192.168.10.86 |
PATH_INFO | [empty string] |
PATH_TRANSLATED | D:\CustomDomains\HubbleHomes\htdocs\404.cfm |
QUERY_STRING | 404;https://hubblehomes.bluetangtest.com:443/news/news-article-list/awards-?start=11 |
REMOTE_ADDR | 192.168.10.246 |
REMOTE_HOST | 192.168.10.246 |
REMOTE_USER | [empty string] |
REQUEST_METHOD | GET |
SCRIPT_NAME | /404.cfm |
SERVER_NAME | hubblehomes.bluetangtest.com |
SERVER_PORT | 443 |
SERVER_PORT_SECURE | 1 |
SERVER_PROTOCOL | HTTP/1.1 |
SERVER_SOFTWARE | Microsoft-IIS/10.0 |
WEB_SERVER_API | [empty string] |