Candle and Crafts Directory

Candles and Candle Making Links


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.

Cannot convert value '0000-00-00 00:00:00' from column 8 to TIMESTAMP.
 
The error occurred in D:\Inetpub\northwestcandlesupply\links\links.cfm: line 3
Called from D:\Inetpub\northwestcandlesupply\links\home-garden.cfm: line 8
Called from D:\Inetpub\northwestcandlesupply\links\links.cfm: line 3
Called from D:\Inetpub\northwestcandlesupply\links\home-garden.cfm: line 8
 
1 : <cfquery datasource="#caller.dsn#" name="getLinks">
2 : 	SELECT * FROM #caller.dbprefix#links
3 : 	WHERE link_category_id=#attributes.type#
4 : 	ORDER BY link_title
5 : </cfquery>
SQLSTATE   S1009
SQL    SELECT * FROM nwcs_links WHERE link_category_id=3 ORDER BY link_title
DATASOURCE   mysql_nwcs
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.103.63.16
Referrer  
Date/Time   09-May-08 07:28 PM
Stack Trace
at cflinks2ecfm720661948.runPage(D:\Inetpub\northwestcandlesupply\links\links.cfm:3) at cfhome2dgarden2ecfm1361352249.runPage(D:\Inetpub\northwestcandlesupply\links\home-garden.cfm:8) at cflinks2ecfm720661948.runPage(D:\Inetpub\northwestcandlesupply\links\links.cfm:3) at cfhome2dgarden2ecfm1361352249.runPage(D:\Inetpub\northwestcandlesupply\links\home-garden.cfm:8) 

java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 8 to TIMESTAMP.
	at com.mysql.jdbc.ResultSet.getTimestampFromBytes(ResultSet.java:6886)
	at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6921)
	at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:6245)
	at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:5035)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:331)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:217)
	at coldfusion.sql.Executive.getRowSet(Executive.java:466)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
	at cflinks2ecfm720661948.runPage(D:\Inetpub\northwestcandlesupply\links\links.cfm:3)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:280)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2650)
	at cfhome2dgarden2ecfm1361352249.runPage(D:\Inetpub\northwestcandlesupply\links\home-garden.cfm:8)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	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.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.A(Unknown Source)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at com.seefusion.Filter.doFilter(Filter.java:40)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1160)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	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:284)
	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)