Need Help? Got a Question? Call Us Anytime! 888.665NoSkype.0636

Home > Essential Gear > Snorkels

Refine Your Results:

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Size'.
 
The error occurred in C:/websites/functions/category.cfc: line 574
Called from C:/websites/includes/views/departments.cfm: line 46
Called from C:/websites/includes/views/departments.cfm: line 1
Called from C:/websites/includes/views/departments.cfm: line 1
Called from C:/websites/includes/sidenav.cfm: line 136
Called from C:/websites/includes/sidenav.cfm: line 1
Called from C:/websites/includes/sidenav.cfm: line 1
Called from C:/websites/defaultWebsite/category.cfm: line 90
Called from C:/websites/functions/category.cfc: line 574
Called from C:/websites/includes/views/departments.cfm: line 46
Called from C:/websites/includes/views/departments.cfm: line 1
Called from C:/websites/includes/views/departments.cfm: line 1
Called from C:/websites/includes/sidenav.cfm: line 136
Called from C:/websites/includes/sidenav.cfm: line 1
Called from C:/websites/includes/sidenav.cfm: line 1
Called from C:/websites/defaultWebsite/category.cfm: line 90
572 : 		<!--- ***** START - LOOP THROUGH ACTIVE URL VARS AND PROCESS THEM FOR DB **** --->
573 : 		<Cfif isDefined("application.filterList") and ListLen(application.filterList) gt 0>
574 : 			<cfloop list="#application.filterList#" index="listItem">
575 : 				<cfif len(url[listItem])  and listItem neq "Keyword">
576 : 					<cfif listItem eq "Team">

SQLSTATE   42S22
DATASOURCE   celerantSQL
VENDORERRORCODE   207
SQL    SELECT distinct dept, count(*) as itemCount FROM web_all_products WHERE dept<>'EMPTY' and upper(Size)='' GROUP BY dept
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.198.132.162
Referrer  
Date/Time   28-May-17 02:41 AM
Stack Trace
at cfcategory2ecfc1249146366$funcGETDEPARTMENTFILTER.runFunction(C:/websites/functions/category.cfc:574) at cfdepartments2ecfm2076284044._factor35(C:/websites/includes/views/departments.cfm:46) at cfdepartments2ecfm2076284044._factor36(C:/websites/includes/views/departments.cfm:1) at cfdepartments2ecfm2076284044.runPage(C:/websites/includes/views/departments.cfm:1) at cfsidenav2ecfm1251937799._factor8(C:/websites/includes/sidenav.cfm:136) at cfsidenav2ecfm1251937799._factor9(C:/websites/includes/sidenav.cfm:1) at cfsidenav2ecfm1251937799.runPage(C:/websites/includes/sidenav.cfm:1) at cfcategory2ecfm824199980.runPage(C:/websites/defaultWebsite/category.cfm:90) at cfcategory2ecfc1249146366$funcGETDEPARTMENTFILTER.runFunction(C:/websites/functions/category.cfc:574) at cfdepartments2ecfm2076284044._factor35(C:/websites/includes/views/departments.cfm:46) at cfdepartments2ecfm2076284044._factor36(C:/websites/includes/views/departments.cfm:1) at cfdepartments2ecfm2076284044.runPage(C:/websites/includes/views/departments.cfm:1) at cfsidenav2ecfm1251937799._factor8(C:/websites/includes/sidenav.cfm:136) at cfsidenav2ecfm1251937799._factor9(C:/websites/includes/sidenav.cfm:1) at cfsidenav2ecfm1251937799.runPage(C:/websites/includes/sidenav.cfm:1) at cfcategory2ecfm824199980.runPage(C:/websites/defaultWebsite/category.cfm:90)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Size'.
	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:1451)
	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.setupCachedQuery(QueryTag.java:993)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:680)
	at cfcategory2ecfc1249146366$funcGETDEPARTMENTFILTER.runFunction(C:\websites\functions\category.cfc:574)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	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.TemplateProxy.invoke(TemplateProxy.java:655)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
	at cfdepartments2ecfm2076284044._factor35(C:\websites\includes\views\departments.cfm:46)
	at cfdepartments2ecfm2076284044._factor36(C:\websites\includes\views\departments.cfm:1)
	at cfdepartments2ecfm2076284044.runPage(C:\websites\includes\views\departments.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 cfsidenav2ecfm1251937799._factor8(C:\websites\includes\sidenav.cfm:136)
	at cfsidenav2ecfm1251937799._factor9(C:\websites\includes\sidenav.cfm:1)
	at cfsidenav2ecfm1251937799.runPage(C:\websites\includes\sidenav.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 cfcategory2ecfm824199980.runPage(C:\websites\defaultWebsite\category.cfm:90)
	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.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	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:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	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:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)