.

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.

ERROR: syntax error at or near "and"
 
The error occurred in /var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/page.cfm: line 7
Called from /var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/index.cfm: line 602
Called from /var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/page.cfm: line 7
Called from /var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/index.cfm: line 602
5 : <!--- get other pages on same level/category --->
6 : <cfquery name="catpages" datasource="#ds#">
7 : select id,html,uuid,title,linkname,friendlyurl from page_table where category_id=#catme.category_id# and mother=0 and inmenu='yes'
8 : order by seq,linkname
9 : </cfquery>

SQLSTATE   42601
SQL    select id,html,uuid,title,linkname,friendlyurl from page_table where category_id= and mother=0 and inmenu='yes' order by seq,linkname
DATASOURCE   selfhelp
Resources:

Browser   claudebot
Remote Address   216.211.191.75
Referrer  
Date/Time   18-Mar-24 08:05 PM
Stack Trace
at cfpage2ecfm12880164.runPage(/var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/page.cfm:7) at cfindex2ecfm1210074122.runPage(/var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/index.cfm:602) at cfpage2ecfm12880164.runPage(/var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/page.cfm:7) at cfindex2ecfm1210074122.runPage(/var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/index.cfm:602)

org.postgresql.util.PSQLException: ERROR: syntax error at or near "and"
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:254)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1374)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfpage2ecfm12880164.runPage(/var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/page.cfm:7)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfindex2ecfm1210074122.runPage(/var/www/sites/arnold/montanasky.net/subdomains/selfhelp/html/index.cfm:602)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	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:46)
	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:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)