Skip to Primary Content Skip to Footer Navigation

Canyon Country Blog

This is your stop for the latest news, insider information, and details on events and happenings in Canyon Country.

From To

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.

Unknown column 'category' in 'where clause'
 
The error occurred in D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm: line 619
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/s.cfm: line 80
Called from D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/modules/search.cfm: line 85
Called from D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/redesign/templates/heber_valley_2015_sidebar_page.template.cfm: line 165
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 167
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 105
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 53
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 357
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 847
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm: line 619
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm: line 1
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/s.cfm: line 80
Called from D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/modules/search.cfm: line 85
Called from D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/redesign/templates/heber_valley_2015_sidebar_page.template.cfm: line 165
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 167
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 105
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc: line 53
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 357
Called from D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc: line 847
617 : 		</cfif>
618 : 
619 :         order by <cfif structKeyExists( dirs, 'sortBy' ) and trim( dirs.sortBy ) neq "">#Replace(replace( dirs.sortBy, "|", " ", "all" ), "name", "replace(b.name, 'The ', '')", "all")#<cfelse>#variables.ord#</cfif>
620 : 
621 :     </cfquery>

VENDORERRORCODE   1054
SQLSTATE   42S22
SQL    select b.display, b.title as name, b.teaser as teaser, b.keywords , media.image as ri , post_date , group_concat( distinct cast( post_categories.name as char ) order by post_categories.name separator ', ' ) as `category` from posts b left outer join posts__media__link ri on b.id_posts = ri.id_posts left outer join media on ri.id_media = media.id_media left outer join posts__category on b.id_posts = posts__category.id_posts left outer join post_categories on ( posts__category.id_post_categories = post_categories.id_post_categories ) left outer join posts__category posts__category_filter on b.id_posts = posts__category_filter.id_posts where 1 = 1 and ids_posts = 1 and post_date <= now() and posts__category_filter.id_post_categories in ( category ) group by b.id_posts order by post_date desc
DATASOURCE   canyoncountry
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   162.158.79.152
Referrer  
Date/Time   19-Nov-18 02:02 AM
Stack Trace
at cfq2ecfm2088999719._factor81(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm:619) at cfq2ecfm2088999719._factor82(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm:1) at cfq2ecfm2088999719.runPage(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm:1) at cfs2ecfm2087176741.runPage(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/s.cfm:80) at cfsearch2ecfm2143886451.runPage(D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/modules/search.cfm:85) at cfheber_valley_2015_sidebar_page2etemplate2ecfm553879341.runPage(D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/redesign/templates/heber_valley_2015_sidebar_page.template.cfm:165) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor6(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:167) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor8(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:105) at cfcontent2ecfc812926230$funcRENDERCONTENT.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:53) at cfapp2ecfc1996423358$funcEXECUTELAYERTRIGGERS.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:357) at cfapp2ecfc1996423358$funcONREQUESTEND.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:847) at cfq2ecfm2088999719._factor81(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm:619) at cfq2ecfm2088999719._factor82(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm:1) at cfq2ecfm2088999719.runPage(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/q.cfm:1) at cfs2ecfm2087176741.runPage(D:/Dropbox/gts/webroot/platform/prototype/shared/modules/search/default/s.cfm:80) at cfsearch2ecfm2143886451.runPage(D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/modules/search.cfm:85) at cfheber_valley_2015_sidebar_page2etemplate2ecfm553879341.runPage(D:/Dropbox/gts/webroot/platform/instances/dmo/canyoncountry/redesign/templates/heber_valley_2015_sidebar_page.template.cfm:165) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor6(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:167) at cfcontent2ecfc812926230$funcRENDERCONTENT._factor8(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:105) at cfcontent2ecfc812926230$funcRENDERCONTENT.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/layers/content.cfc:53) at cfapp2ecfc1996423358$funcEXECUTELAYERTRIGGERS.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:357) at cfapp2ecfc1996423358$funcONREQUESTEND.runFunction(D:/Dropbox/gts/webroot/platform/prototype/shared/engine/app.cfc:847)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'category' in 'where clause'
	at sun.reflect.GeneratedConstructorAccessor867.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:928)
	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 cfq2ecfm2088999719._factor81(D:\Dropbox\gts\webroot\platform\prototype\shared\modules\search\default\q.cfm:619)
	at cfq2ecfm2088999719._factor82(D:\Dropbox\gts\webroot\platform\prototype\shared\modules\search\default\q.cfm:1)
	at cfq2ecfm2088999719.runPage(D:\Dropbox\gts\webroot\platform\prototype\shared\modules\search\default\q.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 cfs2ecfm2087176741.runPage(D:\Dropbox\gts\webroot\platform\prototype\shared\modules\search\default\s.cfm:80)
	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 cfsearch2ecfm2143886451.runPage(D:\Dropbox\gts\webroot\platform\instances\dmo\canyoncountry\modules\search.cfm:85)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
	at cfheber_valley_2015_sidebar_page2etemplate2ecfm553879341.runPage(D:\Dropbox\gts\webroot\platform\instances\dmo\canyoncountry\redesign\templates\heber_valley_2015_sidebar_page.template.cfm:165)
	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 cfcontent2ecfc812926230$funcRENDERCONTENT._factor6(D:\Dropbox\gts\webroot\platform\prototype\shared\layers\content.cfc:167)
	at cfcontent2ecfc812926230$funcRENDERCONTENT._factor8(D:\Dropbox\gts\webroot\platform\prototype\shared\layers\content.cfc:105)
	at cfcontent2ecfc812926230$funcRENDERCONTENT.runFunction(D:\Dropbox\gts\webroot\platform\prototype\shared\layers\content.cfc:53)
	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:518)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:402)
	at cfapp2ecfc1996423358$funcEXECUTELAYERTRIGGERS.runFunction(D:\Dropbox\gts\webroot\platform\prototype\shared\engine\app.cfc:357)
	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.CfJspPage._invokeUDF(CfJspPage.java:2655)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2451)
	at cfapp2ecfc1996423358$funcONREQUESTEND.runFunction(D:\Dropbox\gts\webroot\platform\prototype\shared\engine\app.cfc:847)
	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.AppEventInvoker.invoke(AppEventInvoker.java:108)
	at coldfusion.runtime.AppEventInvoker.onRequestEnd(AppEventInvoker.java:343)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:447)
	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.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(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)