|
Error Executing Database Query.
Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP.
The error occurred in wwwroot\hotline.cfm Line 158
Site Owner: Click to hide extended details.
This error has been recorded in the logs directory for your website.
To display your own content instead of this page, use a file named
cf_custom_error.cfm file in the root directory for iaisnd.com.
(Include <cfdump var="#error#"> to display detailed error information as shown below.)
ColdFusion Documentation (LiveDocs)
| struct |
|---|
| Browser |
CCBot/2.0 |
| DateTime |
{ts '2013-05-25 04:21:50'} |
| Diagnostics |
Error Executing Database Query. Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. <br>The error occurred on line 158. |
| GeneratedContent |
<html>
<head><title>I Am...I Said, A Fan of Neil Diamond</title><style class="text/css">
.PurpleHeadline {font-family : Arial; font-size : 15pt; font-style : normal;font-variant : normal; font-weight : bold; color : 131F6C;}
.BlueHeadline {font-family : verdana, arial; font-size : large; font-style : normal;font-variant : normal; font-weight : bold; color : 131F6C;}
.PurpleMedHeadline {font-family : Arial;font-size : medium;font-style : normal; font-variant : normal;font-weight : bold;color : 131F6C;}
.PurpleSmallHeadline {font-family : Arial; font-size : 12pt; font-style: normal; font-variant : normal; font-weight: bold; color: 131F6C;}
.PurpleMedHeadlinePlain {font-family : Arial;font-size : medium;font-style : normal; font-variant : normal; font-weight : normal; color : 131F6C;}
.BlueMedHeadline {font-family : verdana,arial; font-size : medium;font-style : normal; font-variant : normal;font-weight : bold;color : 131F6C;}
.RedHeadline {font-family : Arial;font-size : large;font-style : normal;font-variant : normal; font-weight : bold; color : 131F6C;}
.BlackHeadline {font-family : Arial;font-size : medium; font-style : normal;font-variant : normal; font-weight : bold; color : black;}
.boldregular { font-size: x-small; font-family: Arial; font-weight: bold }
.regularplus { font-size: x-small; font-family: Arial; font-style: normal }
.regular {font-family : Arial; font-size : 8pt;}
.regularextraextrasmall {font-size: xx-small; font-family: Arial; font-style: normal }
.regularsmaller {font-size: smaller; font-family: Arial; font-style: normal }
.regmain {font-family : verdana,arial;font-size : 8pt;color : efefef;TEXT-DECORATION: none;font-weight : bold;}
.boldfont {font-family : Arial; font-size : small;font-weight : bold;}
.fotgal {border:1px; border-thickness: 1px; border-color: 000000; border-style: solid;}
A:hover {COLOR: 000000; TEXT-DECORATION: underline}
a.leftnav{font-family : verdana,arial;font-size : 10pt; font-weight : bold; color : ffffff; text-decoration : none;}
a.leftnav:hover{font-family : verdana,arial;font-size : 10pt; font-weight : bold; color : ffffff;}
TD.Photo { margin-left: 0%; padding-left: 0;}
.table {font-family: Arial, Helvetica; font-size: 9pt; vertical-align: top; padding-left: 5;}
.tablesmall {font-family: Arial, Helvetica; font-size: 8pt; vertical-align: top; padding-left: 5;}
.tablehead {font-family : Arial; font-size : 12pt; font-style: normal; font-variant : normal; font-weight: bold; color: black; padding-left: 5;}
</style>
<link rel="SHORTCUT ICON" href="http://iaisnd.com/fav.ico"/>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bgcolor="#ffffff" LINK="#131F6C" VLINK="red" ALINK="131F6C">
<table cellspacing=0 cellpadding=0 border=0>
<tr><td cellspan=2 colspan=2>
<a href="http://www.iaisnd.com/indexmain.cfm"><img src="top.jpg" width="752" height="110" alt="" border="0"></a></td></tr>
<tr><td width=150 bgcolor=131F6C valign=top>
<table width=150 cellspacing=0 cellpadding=0 ><tr><td>
<br>
<table>
<tr><td>
<a href="/indexmain.cfm?pageid=1" class="leftnav">Front Page/Home</a><br>
<a href="/about.cfm?pageid=2" class="leftnav">About IAISND.com</a><br>
<a href="/hotline.cfm?id=2009" class="leftnav">Archived News</a><br>
<a href="/biography.cfm?id=40&?pageid=3" class="leftnav">Biography</a><br>
<a href="/concerts.cfm?id=60&?pageid=31" class="leftnav">Concerts</a><br>
<a href="/contact.cfm?pageid=16" class="leftnav">Contact Us</a><br>
<a href="/deely.cfm?id=1&?pageid=43" class="leftnav">Deely's Adventures</a><br>
<a href="/diaries.cfm" class="leftnav">Diamond Diaries</a><br>
<a href="/disc.cfm?id=60&?pageid=4" class="leftnav">Discography</a><br>
<a href="/scans.cfm?id=65&?pageid=1" class="leftnav">Document Scans</a><br>
<a href="/dvdthanks.cfm" class="leftnav">DVD Thanks</a><br>
<a href="/poems.cfm?pageid=37" class="leftnav">Fan Poetry</a><br>
<a href="/interviews70.cfm?id=70" class="leftnav">Interviews</a><br>
<a href="/links.cfm?pageid=6" class="leftnav">Links</a><br>
<a href="/lyrics.cfm?pageid=33" class="leftnav">Lyrics</a><br>
<a href="/board.cfm?pageid=11" class="leftnav">Message Board</a><br>
<a href="/quiz.cfm?pageid=26" class="leftnav">Neil Quiz</a><br>
<a href="/fanphoto.cfm?pageid=22" class="leftnav">Photo Gallery</a><br>
<a href="/registerneil.cfm?pageid=30" class="leftnav">Register Now</a><br>
<a href="/concerts.cfm?id=20&?pageid=41" class="leftnav">Reviews</a><br>
<a href="/book.cfm?pageid=18&type=bang&?pageid=18" class="leftnav">Sheet Music</a><br>
<a href="/Songbooks.cfm?pageid=18&type=1" class="leftnav">Song Books</a><br>
<a href="/songs.cfm?id=stats&?pageid=34" class="leftnav">Songs</a><br>
<a href="/tickets.cfm?pageid=39" class="leftnav">Ticket Exchange</a><br>
<a href="/traders.cfm?pageid=38" class="leftnav">Trader's Corner</a><br>
<a href="/tribute.cfm" class="leftnav">Tributes</a><br>
<a href="/tv.cfm?pageid=32" class="leftnav">TV Appearances</a><br>
<a href="/flash.cfm?pageid=28&min=1&max=299" class="leftnav">Video Clips</a><br>
<a href="/video.cfm?type=full&?pageid=9" class="leftnav">Videography</a><br>
<a href="/going.cfm?pageid=35" class="leftnav">Who's Going Where<br>
<div align="center">(Neil Concerts)</div></a>
<a href="/going2.cfm?pageid=35" class="leftnav">Who's Going Where<br>
<div align="center">(Tribute Artists)</div></a>
<a href="/memberdirectory.cfm?pageid=15" class="leftnav">Who's Who</a><br>
<tr><td>
<hr>
</td></tr>
<tr><td>
<a href="help.cfm" class="leftnav">Site Help</a><br>
<a href="sitemap.cfm" class="leftnav">Site Map</a><br>
<a href="/contact.cfm?pageid=16" class="leftnav">Contact Us</a><br>
<a href="/donations.cfm" class="leftnav">Donations</a><br>
</td></tr>
<tr><td>
<hr>
</td></tr>
<tr><td>
<a href="http://astore.amazon.com/iamisaiafanof-20"class="leftnav">Amazon.com Store</a><br>
<a href="http://www.amazon.com/dp/B00067L6TQ/ref=nosim/?%5Fencoding=UTF8&tag=iamisaiafanof-20&linkCode=ur2&camp=1789&creative=9325" class="leftnav">Gift Certificates</a><img src="http://www.assoc-amazon.com/e/ir?t=iamisaiafanof-20&l=ur2&o=1" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" />
<br><br>
<div align="center">
<font face=arial size=-2 color=white>
Thank you for supporting IAISND.com by using our Amazon.com links!</font></div>
<br>
<div align="center">
<iframe src="http://rcm.amazon.com/e/cm?t=iamisaiafanof-20&o=1&p=20&l=qs1&f=ifr" width="120" height="90" frameborder="0" scrolling="no"></iframe>
<br><br>
<iframe src="http://rcm-ca.amazon.ca/e/cm?t=iamisaiafan0f-20&o=15&p=20&l=qs1&f=ifr" width="120" height="90" frameborder="0" scrolling="no"></iframe>
<br><br>
<iframe src="http://rcm-uk.amazon.co.uk/e/cm?t=iamisaiafanof-21&o=2&p=20&l=qs1&f=ifr" width="120" height="90" frameborder="0" scrolling="no"></iframe>
<div>
</td></tr>
</table>
<br>
<table width=100% border=0 bgcolor=white cellspacing=2><tr><td><font face=arial size=-1><strong><div align="center">Registered User Login</td></tr></table>
<table width="145" bordercolor="black" cellspacing=0 border=0><tr><td>
<form name=Form action="login.cfm" method="post">
<font color=white face="Arial" size=-1>
<b> User Name:</b> <input type="Text" name="Member" size=18>
<p>
<b> Password:<br></b> <input type="Password" name="Password" size=18> <div align="center"><input type="submit" name="Login" value="Login"></div>
<br> <input type="checkbox" name="ExpireCookie"><font size=-2>Save my login info.</form>
<center><table width="140" ><tr><td valign=top>
<div align="center"><a href="forget.cfm"><font face=arial size=-2 color=white>Forget Your Login Info?</a></td></tr></table>
</center></form>
</td></tr></table>
<br>
<!--Site Search-->
<TABLE><INPUT name=Crit1_FieldName type=hidden value=songs.lyrics>
<INPUT name=Crit1_FieldType type=hidden value=CHAR>
<TR>
<TD valign=top></TD>
<TD>
<input name="Crit1_Operator" type="hidden" value="contains">
</TD>
<TD></font>
</TD>
</form></STRONG></FONT></TD></TR>
</table>
<!--From BW-->
<table>
<tr>
<td>
<FORM action="/sitesearch.cfm" method="post" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0">
<INPUT name="Crit1_Value">
<INPUT name=Crit1_Value_required type=hidden value="You must enter something to search for.">
<div align="center"><INPUT type=submit value="Search Site"></div>
</td><td></td></tr></table></form>
<!--End of addition-->
<!--End of Site Search-->
<br>
<!-- Google CSE Search Box Begins -->
<div align="center">
<form id="searchbox_006659550004677981868:lyvjlw9lueg" action="http://www.google.com/cse">
<input type="hidden" name="cx" value="006659550004677981868:lyvjlw9lueg" />
<input name="q" type="text" size="20" />
<div align="center"><input type="submit" name="sa" value="Google Site" /></div>
<input type="hidden" name="cof" value="FORID:0" />
</form>
<script type="text/javascript" src="http://www.google.com/coop/cse/brand?form=searchbox_006659550004677981868%3Alyvjlw9lueg"></script>
</div>
<!-- Google CSE Search Box Ends -->
<p></p>
<div align="center">
</div>
</form>
</td></tr></table></td><td width=590 valign=top>
<script language="javascript">
function popup(){
newwin = window.open('','picture','width=250,height=500,scrollbars=1,resizable=1');}
</script>
<table border=0 width=595 cellpadding=0 cellspacing=0>
<tr><td valign=top>
<table border=0 cellspacing=0 cellpadding=0>
<tr><td width=384 valign=top>
<div align="center">
<div align="center">
<a href="hotline.cfm?id=2009">
<img src="navigation/216.jpg" width="370" height="250" alt="" border="0" vspace=8></a>
<a name="top">
<span class="purplemedheadline">Archived News</span><br>
<!--Site Search-->
<TABLE><INPUT name=Crit1_FieldName type=hidden value=songs.lyrics>
<INPUT name=Crit1_FieldType type=hidden value=CHAR>
<TR>
<TD valign=top></TD>
<TD>
<input name="Crit1_Operator" type="hidden" value="contains">
</TD>
<TD></font>
</TD>
</form></STRONG></FONT></TD></TR>
</table>
<!--From BW-->
<table>
<tr>
<td>
<FORM action="/newssearch.cfm" method="post" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0">
<INPUT name="Crit1_Value" size=35>
<INPUT name=Crit1_Value_required type=hidden value="You must enter something to search for." >
<div align="center"><INPUT type=submit value="Search Front Page Stories" ></div>
</td><td></td></tr></table></form>
<!--End of addition-->
<!--End of Site Search-->
<br>
<!--Year Links-->
<font face=arial size=-1><strong>
<a href="hotline.cfm?id=2010">2010</a> |
<a href="hotline.cfm?id=2009">2009</a> |
<a href="hotline.cfm?id=2008">2008</a> |
<a href="hotline.cfm?id=2007">2007</a> |
<a href="hotline.cfm?id=2006">2006</a> |
<br>
<a href="hotline.cfm?id=2005">2005</a> |
<a href="hotline.cfm?id=2004">2004</a> |
<a href="hotline.cfm?id=2003">2003</a>
<a href="hotline.cfm?id=2002">2002 & earlier</a>
</strong></font>
</div>
<!--Query to retrieve data from database-->
|
| HTTPReferer |
[empty string] |
| Mailto |
[empty string] |
| Message |
Error Executing Database Query. |
| QueryString |
id=2009 |
| RemoteAddress |
54.235.20.17 |
| RootCause |
| struct |
|---|
| DataSource |
neilnew |
| Detail |
Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. |
| ErrorCode |
S1009 |
| Message |
Error Executing Database Query. |
| NativeErrorCode |
0 |
| RootCause |
| struct |
|---|
| ErrorCode |
0 |
| Message |
Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. |
| SQLState |
S1009 |
| StackTrace |
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 7 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:330)
at coldfusion.sql.QueryTable.populate(QueryTable.java:216)
at coldfusion.sql.Executive.getRowSet(Executive.java:314)
at coldfusion.sql.Executive.executeQuery(Executive.java:775)
at coldfusion.sql.Executive.executeQuery(Executive.java:685)
at coldfusion.sql.Executive.executeQuery(Executive.java:646)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cfhotline2ecfm1143740049.runPage(E:\webs\iaisnd.com\wwwroot\hotline.cfm:158)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
158 |
| RAW_TRACE |
at cfhotline2ecfm1143740049.runPage(E:\webs\iaisnd.com\wwwroot\hotline.cfm:158) |
| TEMPLATE |
E:\webs\iaisnd.com\wwwroot\hotline.cfm |
| TYPE |
CFML |
|
|
| Type |
java.sql.SQLException |
|
| SQLState |
S1009 |
| Sql |
select *
from News2
where year = 2009
order by realdate desc
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580)
at cfhotline2ecfm1143740049.runPage(E:\webs\iaisnd.com\wwwroot\hotline.cfm:158)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
158 |
| RAW_TRACE |
at cfhotline2ecfm1143740049.runPage(E:\webs\iaisnd.com\wwwroot\hotline.cfm:158) |
| TEMPLATE |
E:\webs\iaisnd.com\wwwroot\hotline.cfm |
| TYPE |
CFML |
|
|
| Type |
Database |
| queryError |
Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. |
| where |
[empty string] |
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580)
at cfhotline2ecfm1143740049.runPage(E:\webs\iaisnd.com\wwwroot\hotline.cfm:158)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
158 |
| RAW_TRACE |
at cfhotline2ecfm1143740049.runPage(E:\webs\iaisnd.com\wwwroot\hotline.cfm:158) |
| TEMPLATE |
E:\webs\iaisnd.com\wwwroot\hotline.cfm |
| TYPE |
CFML |
|
|
| Template |
/hotline.cfm |
| Type |
coldfusion.runtime.CfErrorWrapper |
|