dognzb.cr - just another php/ColdFusion noob :D

         _____ _____ _ _____ _____         _____ _____ _____ _____
     ___|     | __  |_|  _  |_   _|___ ___|_   _|   __|  _  |     |
    |_ -|   --|    -| |   __| | | |- _|___| | | |   __|     | | | |
    |___|_____|__|__|_|__|    |_| |___|     |_| |_____|__|__|_|_|_|
    |s C R i P T z - T E A M . i N F O|████████████████████████████

                             - iNfO -

    dognzb.cr.com - just another php/ColdFusion noob :D

    YO, DOGGY, WANNA PLAY ?

    YEAH WE ARE HERE AGAiN :P

    YOU GiVE US YOUR REAL PATH, NiCE ONE.

                             - NOtIcE -

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND r.passwordstatus = 0 AND c.status = 1 AND size > 0 AND postdate >=' at line 10

The error occurred in D:/domains/dognzb.cr/htdocs/browse.cfm: line 62
Called from D:/domains/dognzb.cr/htdocs/browse.cfm: line 39
Called from D:/domains/dognzb.cr/htdocs/browse.cfm: line 1
Called from D:/domains/dognzb.cr/htdocs/main.cfm: line 4
Called from D:/domains/dognzb.cr/htdocs/browse.cfm: line 62
Called from D:/domains/dognzb.cr/htdocs/browse.cfm: line 39
Called from D:/domains/dognzb.cr/htdocs/browse.cfm: line 1
Called from D:/domains/dognzb.cr/htdocs/main.cfm: line 4

60 : 		<cfif user.role LTE 1>AND postdate >= <CFQUERYPARAM Value="#DateAdd('d',-30,now())#" cfsqltype="CF_SQL_TIMESTAMP"></cfif>
61 : 		ORDER BY #sort#
62 : 		LIMIT #startrow#,#session.max_rows+1#
63 : 	</cfquery>
64 :

VENDORERRORCODE 	  1064
SQLSTATE 	  42000
SQL 	   SELECT r.id, r.name, adddate, postdate, size, guid, imdbID, rageID, consoleinfoID, musicinfoID, episodeinfoID, categoryID, tvairdate, r.grabs, uncompress(nfo) AS nfo, rn.ID as nfoID, cp.title AS category_parent, c.title as category_name, cp.ID as parent, (SELECT count(*) FROM releasesubs where releaseID = r.id) AS subs, (SELECT count(*) FROM releasetracks where releaseID = r.id) AS tracks, (SELECT timestamp FROM userdownloads WHERE releaseID = r.id AND userID = (param 1) LIMIT 1) AS timestamp FROM releases r FORCE INDEX (ix_releases_rageID) JOIN category c on c.ID = r.categoryID JOIN category cp on cp.ID = c.parentID LEFT JOIN releasenfo rn on rn.releaseID = r.ID and rn.nfo IS NOT null WHERE () AND r.passwordstatus = 0 AND c.status = 1 AND size > 0 AND postdate >= (param 2) ORDER BY postdate DESC LIMIT 0,101
DATASOURCE 	  dognzb
Resources:

    Check the ColdFusion documentation to verify that you are using the correct syntax.
    Search the Knowledge Base to find a solution to your problem.

Browser   	xxYYzz
Remote Address   	xx.xx.xx.xx
Referrer   	http://dognzb.cr/
Date/Time   	16-Apr-12 xx:xx AM
Stack Trace
at cfbrowse2ecfm701712769._factor1(D:/domains/dognzb.cr/htdocs/browse.cfm:62) at cfbrowse2ecfm701712769._factor13(D:/domains/dognzb.cr/htdocs/browse.cfm:39) at cfbrowse2ecfm701712769.runPage(D:/domains/dognzb.cr/htdocs/browse.cfm:1) at cfmain2ecfm89353295.runPage(D:/domains/dognzb.cr/htdocs/main.cfm:4) at cfbrowse2ecfm701712769._factor1(D:/domains/dognzb.cr/htdocs/browse.cfm:62) at cfbrowse2ecfm701712769._factor13(D:/domains/dognzb.cr/htdocs/browse.cfm:39) at cfbrowse2ecfm701712769.runPage(D:/domains/dognzb.cr/htdocs/browse.cfm:1) at cfmain2ecfm89353295.runPage(D:/domains/dognzb.cr/htdocs/main.cfm:4)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
		AND r.passwordstatus = 0
		AND c.status = 1
		AND size > 0
		AND postdate >=' at line 10
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1436)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	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 cfbrowse2ecfm701712769._factor1(D:\domains\dognzb.cr\htdocs\browse.cfm:62)
	at cfbrowse2ecfm701712769._factor13(D:\domains\dognzb.cr\htdocs\browse.cfm:39)
	at cfbrowse2ecfm701712769.runPage(D:\domains\dognzb.cr\htdocs\browse.cfm:1)
	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 cfmain2ecfm89353295.runPage(D:\domains\dognzb.cr\htdocs\main.cfm:4)
	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.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)