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.

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 tbl_nav.used = 1 and tbl_documents.used = 1 and (tbl_documents.tdate_star' at line 5
 
The error occurred in C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/vk.cfm: line 34
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/index.cfm: line 3
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/system/lib_content.cfm: line 629
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 61
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 23
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 5
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 1
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/vk.cfm: line 34
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/index.cfm: line 3
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/system/lib_content.cfm: line 629
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 61
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 23
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 5
Called from C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm: line 1
32 : 		where tbl_documents.id = tbl_navelements.element
33 : 		and tbl_navelements.nav = tbl_nav.id
34 : 		and tbl_nav.contact = #get_berater.id#
35 : 		and tbl_nav.used = 1 and tbl_documents.used = 1
36 : 		and (tbl_documents.tdate_start <= Now() or tbl_documents.tdate_start is NULL)

VENDORERRORCODE   1064
SQLSTATE   42000
SQL    select tbl_documents.*,tbl_nav.id as tnav from tbl_documents,tbl_navelements,tbl_nav where tbl_documents.id = tbl_navelements.element and tbl_navelements.nav = tbl_nav.id and tbl_nav.contact = and tbl_nav.used = 1 and tbl_documents.used = 1 and (tbl_documents.tdate_start <= Now() or tbl_documents.tdate_start is NULL) and (tbl_documents.tdate_expire >= Now() or tbl_documents.tdate_expire is NULL) order by tbl_documents.torder,tbl_documents.title
DATASOURCE   su_internet_2009
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.107.179.220
Referrer  
Date/Time   04-Feb-12 01:13 PM
Stack Trace
at cfvk2ecfm2053979820.runPage(C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/vk.cfm:34) at cfindex2ecfm1894048012.runPage(C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/index.cfm:3) at cflib_content2ecfm2000009292$funcSETACTIONCONTENT.runFunction(C:/inetpub/wwwroot/saaten-union.internet.2009/system/lib_content.cfm:629) at cfindex2ecfm129157006._factor3(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:61) at cfindex2ecfm129157006._factor8(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:23) at cfindex2ecfm129157006._factor11(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:5) at cfindex2ecfm129157006.runPage(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:1) at cfvk2ecfm2053979820.runPage(C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/vk.cfm:34) at cfindex2ecfm1894048012.runPage(C:/inetpub/wwwroot/saaten-union.internet.2009/modules/berater/index.cfm:3) at cflib_content2ecfm2000009292$funcSETACTIONCONTENT.runFunction(C:/inetpub/wwwroot/saaten-union.internet.2009/system/lib_content.cfm:629) at cfindex2ecfm129157006._factor3(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:61) at cfindex2ecfm129157006._factor8(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:23) at cfindex2ecfm129157006._factor11(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:5) at cfindex2ecfm129157006.runPage(C:/inetpub/wwwroot/saaten-union.internet.2009/index.cfm:1)

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 tbl_nav.used = 1 and tbl_documents.used = 1
		and (tbl_documents.tdate_star' at line 5
	at sun.reflect.GeneratedConstructorAccessor1208.newInstance(Unknown Source)
	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:2687)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:879)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	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 cfvk2ecfm2053979820.runPage(C:\inetpub\wwwroot\saaten-union.internet.2009\modules\berater\vk.cfm:34)
	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 cfindex2ecfm1894048012.runPage(C:\inetpub\wwwroot\saaten-union.internet.2009\modules\berater\index.cfm:3)
	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 cflib_content2ecfm2000009292$funcSETACTIONCONTENT.runFunction(C:\inetpub\wwwroot\saaten-union.internet.2009\system\lib_content.cfm:629)
	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:2582)
	at cfindex2ecfm129157006._factor3(C:\inetpub\wwwroot\saaten-union.internet.2009\index.cfm:61)
	at cfindex2ecfm129157006._factor8(C:\inetpub\wwwroot\saaten-union.internet.2009\index.cfm:23)
	at cfindex2ecfm129157006._factor11(C:\inetpub\wwwroot\saaten-union.internet.2009\index.cfm:5)
	at cfindex2ecfm129157006.runPage(C:\inetpub\wwwroot\saaten-union.internet.2009\index.cfm:1)
	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)