Free Shipping on Orders over $149

0

Home > Accessories > Sunglasses

Sunglasses

Filter Products

You've Selected

Narrow Your Selection

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 'Pricelist'.
 
The error occurred in C:/websites/Skicountry/functions/category.cfc: line 576
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 45
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 297
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/category.cfm: line 139
Called from |SQLServer|6.0.0.1282|: line 1085
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from |SQLServer|6.0.0.1282|: line 1085
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from C:/websites/Skicountry/functions/category.cfc: line 576
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 45
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 297
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/category.cfm: line 139
 
574 : 		<!--- ***** START - LOOP THROUGH ACTIVE URL VARS AND PROCESS THEM FOR DB **** --->
575 : 		<Cfif isDefined("application.filterList") and ListLen(application.filterList) gt 0>
576 : 			<cfloop list="#application.filterList#" index="listItem">
577 : 				<cfif len(url[listItem])  and listItem neq "Keyword">
578 : 					<cfif listItem eq "Team">
SQLSTATE   42S22
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   celerantSQL
VENDORERRORCODE   207
SQL   SELECT distinct dept, count(*) as itemCount FROM web_all_products WHERE dept<>'EMPTY' and upper(Sizelist) like '%5,%' and upper(Pricelist) like '%,%' GROUP BY dept
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.188.212.54
Referrer   https://skicountrysports.com/sunglasses/browse/size/5/color/azalea
Date/Time   14-Nov-24 11:59 AM
Stack Trace
at cfcategory2ecfc1744178712$funcGETDEPARTMENTFILTER.runFunction(C:/websites/Skicountry/functions/category.cfc:576) at cfdepartments2ecfm888053368._factor15(C:/websites/Skicountry/includes/views/departments.cfm:45) at cfdepartments2ecfm888053368._factor16(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfdepartments2ecfm888053368.runPage(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfsidenav2ecfm995677278._factor13(C:/websites/Skicountry/includes/sidenav.cfm:297) at cfsidenav2ecfm995677278._factor15(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfsidenav2ecfm995677278.runPage(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:139) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at cfcategory2ecfc1744178712$funcGETDEPARTMENTFILTER.runFunction(C:/websites/Skicountry/functions/category.cfc:576) at cfdepartments2ecfm888053368._factor15(C:/websites/Skicountry/includes/views/departments.cfm:45) at cfdepartments2ecfm888053368._factor16(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfdepartments2ecfm888053368.runPage(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfsidenav2ecfm995677278._factor13(C:/websites/Skicountry/includes/sidenav.cfm:297) at cfsidenav2ecfm995677278._factor15(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfsidenav2ecfm995677278.runPage(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:139) 

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Pricelist'.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
	at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
	at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
	at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
	at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
	at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1613)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1355)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1285)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
	at cfcategory2ecfc1744178712$funcGETDEPARTMENTFILTER.runFunction(C:\websites\Skicountry\functions\category.cfc:576)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227)
	at cfdepartments2ecfm888053368._factor15(C:\websites\Skicountry\includes\views\departments.cfm:45)
	at cfdepartments2ecfm888053368._factor16(C:\websites\Skicountry\includes\views\departments.cfm:1)
	at cfdepartments2ecfm888053368.runPage(C:\websites\Skicountry\includes\views\departments.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211)
	at cfsidenav2ecfm995677278._factor13(C:\websites\Skicountry\includes\sidenav.cfm:297)
	at cfsidenav2ecfm995677278._factor15(C:\websites\Skicountry\includes\sidenav.cfm:1)
	at cfsidenav2ecfm995677278.runPage(C:\websites\Skicountry\includes\sidenav.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211)
	at cfcategory2ecfm1749867363.runPage(C:\websites\Skicountry\category.cfm:139)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	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:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)