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


Photo Gallery > Member Galleries
Mr. Lee Pool 7 Pounder!

More Photos

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 '18'.
 
The error occurred in D:/wwwroot/noreastsaltwater/gallery/_listinclude_query.cfm: line 105
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 72
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 1
Called from D:/wwwroot/noreastsaltwater/gallery/_listinclude_query.cfm: line 105
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 72
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 1
 
103 : 		AND dbo.photo_photos.id < #p#
104 : 		ORDER BY photo_datetime DESC, dbo.photo_photos.id DESC
105 : 	<CFELSE>
106 : 		ORDER BY photo_datetime DESC, dbo.photo_photos.id DESC
107 : 	</CFIF>
SQLSTATE   HY000
DATASOURCE   noreastgallery
VENDORERRORCODE   102
SQL    SELECT dbo.photo_photos.ID, catname, cat, photo_username, userid, title, bigimage, views, photo_datetime FROM dbo.photo_photos, dbo.photo_categories WHERE dbo.photo_photos.cat = dbo.photo_categories.id AND userid = 33705 AND photo_forcontest < 2 AND photo_datetime >= 2019-12-02 18:06:20.0 AND dbo.photo_photos.id > 177546 ORDER BY photo_datetime DESC, dbo.photo_photos.id DESC
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   162.158.79.178
Referrer  
Date/Time   05-Dec-19 09:02 PM
Stack Trace
at cf_listinclude_query2ecfm791338603.runPage(D:/wwwroot/noreastsaltwater/gallery/_listinclude_query.cfm:105) at cfview2ecfm1026690586._factor0(D:/wwwroot/noreastsaltwater/gallery/view.cfm:72) at cfview2ecfm1026690586.runPage(D:/wwwroot/noreastsaltwater/gallery/view.cfm:1) at cf_listinclude_query2ecfm791338603.runPage(D:/wwwroot/noreastsaltwater/gallery/_listinclude_query.cfm:105) at cfview2ecfm1026690586._factor0(D:/wwwroot/noreastsaltwater/gallery/view.cfm:72) at cfview2ecfm1026690586.runPage(D:/wwwroot/noreastsaltwater/gallery/view.cfm:1) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '18'.
	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 cf_listinclude_query2ecfm791338603.runPage(D:\wwwroot\noreastsaltwater\gallery\_listinclude_query.cfm:105)
	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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082)
	at cfview2ecfm1026690586._factor0(D:\wwwroot\noreastsaltwater\gallery\view.cfm:72)
	at cfview2ecfm1026690586.runPage(D:\wwwroot\noreastsaltwater\gallery\view.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)