Username:
Password:
Get Account    
Login
         Home  |  Magazine  |  Reports  |  Discussion  |  Photos  |  Tides  |  Weather  |  Community  |  Updates  |  Fishing Info  |  Contact

HomeSearchTop PostersToday's Active Topics



Trout Tactics



  Discussion Boards > Freshwater Forum
Author Message

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]Incorrect syntax near the keyword 'AND'.
 
The error occurred in D:/CF_CustomTags/CF_CustomTags/ClubTag.cfm: line 17
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 600
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 591
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 463
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 69
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 1
Called from D:/CF_CustomTags/CF_CustomTags/ClubTag.cfm: line 17
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 600
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 591
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 463
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 69
Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 1
15 : 			WHERE users_ID = #attributes.clubtag_userID#
16 : 			  AND startdate <= #now()#
17 : 			  AND enddate >= #now()#
18 : 			  AND paid = 1
19 : 			ORDER BY EndDate DESC

SQLSTATE   HY000
DATASOURCE   noreastusermanager
VENDORERRORCODE   156
SQL    SELECT users_ID FROM dbo.PremiumMemberships WHERE users_ID = AND startdate <= {ts '2019-12-15 11:59:11'} AND enddate >= {ts '2019-12-15 11:59:11'} AND paid = 1 ORDER BY EndDate DESC
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   162.158.107.66
Referrer  
Date/Time   15-Dec-19 11:59 AM
Stack Trace
at cfClubTag2ecfm121910079.runPage(D:/CF_CustomTags/CF_CustomTags/ClubTag.cfm:17) at cfViewTopic2ecfm1569125251._factor11(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:600) at cfViewTopic2ecfm1569125251._factor28(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:591) at cfViewTopic2ecfm1569125251._factor38(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:463) at cfViewTopic2ecfm1569125251._factor40(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:69) at cfViewTopic2ecfm1569125251.runPage(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:1) at cfClubTag2ecfm121910079.runPage(D:/CF_CustomTags/CF_CustomTags/ClubTag.cfm:17) at cfViewTopic2ecfm1569125251._factor11(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:600) at cfViewTopic2ecfm1569125251._factor28(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:591) at cfViewTopic2ecfm1569125251._factor38(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:463) at cfViewTopic2ecfm1569125251._factor40(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:69) at cfViewTopic2ecfm1569125251.runPage(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
	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:1561)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1311)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1241)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1208)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cfClubTag2ecfm121910079.runPage(D:\CF_CustomTags\CF_CustomTags\ClubTag.cfm:17)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfViewTopic2ecfm1569125251._factor11(D:\wwwroot\noreastsaltwater\discussion\ViewTopic.cfm:600)
	at cfViewTopic2ecfm1569125251._factor28(D:\wwwroot\noreastsaltwater\discussion\ViewTopic.cfm:591)
	at cfViewTopic2ecfm1569125251._factor38(D:\wwwroot\noreastsaltwater\discussion\ViewTopic.cfm:463)
	at cfViewTopic2ecfm1569125251._factor40(D:\wwwroot\noreastsaltwater\discussion\ViewTopic.cfm:69)
	at cfViewTopic2ecfm1569125251.runPage(D:\wwwroot\noreastsaltwater\discussion\ViewTopic.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:544)
	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:96)
	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:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:426)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:844)