An error has occured, please contact the administrator. Thank you

54.225.59.14||cferror||---|54.225.59.14|CCBot/2.0 (https://commoncrawl.org/faq/)||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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1
The error occurred on line 88.|/books/main.cfm|isbn=9781742833460 An error occurred: http://www.toptales.com.au/books/main.cfm?isbn=9781742833460
Time: 9/25/18 1:07 PM
Error - struct
Browser CCBot/2.0 (https://commoncrawl.org/faq/)
DateTime {ts '2018-09-25 13:07:10'}
Diagnostics 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1 <br>The error occurred on line 88.
GeneratedContent <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <HEAD> <title>, , at Top Tales</title> <meta name="description" content="Top Tales has written by , the isbn of this book, CD or DVD is and . Buy online from our Australian bookstore."> <meta name="keywords" content=", , isbn, , , childrens bookstore, educational book shop, reference book Australia, child, kids, book store, bookshop"> <meta name="robots" content="index, follow"> <meta name="googlebot" content="index, follow"> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"> <link rel="stylesheet" type="text/css" href="/inc/stylesheet.css"> <script language="javascript" type="text/javascript"> <!-- Begin function popUp(URL, x, y, srl) { day = new Date(); id = day.getTime(); eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=" + srl + ",location=0,statusbar=0,menubar=0,resizable=1,width=" + x + ",height=" + y + ",left=40,top=40');"); } // End --> </script> </head> <body> <div class="content"> <div id="primary-header-area" style="top:-20px;"> <style> #headerNav{position:absolute;top:0;right:310px;background:#2d2d2d;padding:5px 10px;color:#fff;font:normal 13px "Trebuchet MS",sans-serif;-moz-border-radius-bottomleft:4px;-moz-border-radius-bottomright:4px;-webkit-border-bottom-left-radius:4px;-webkit-border-bottom-right-radius:4px;/* for IE *//*filter:alpha(opacity=60);*//* CSS3 standard *//*opacity:0.6;*/ z-index:500}/*#edf2e1*/ #headerNav li{display:inline;} #headerNav a{padding:0 3px;color:#fff;text-decoration:none;}/*676f73*/ #headerNav a:hover{text-decoration: underline; color: #FFCC00;} #headerNav b a{color:#404040;}/*color:#7fa632;*/ #headerNav .basket{color:#676f73;text-decoration:none;} #headerNav i{color:#fff;font-style:normal;} </style> <div id="headerNav" > <ul> <li><a href="http://www.toptales.com.au/">home</a></li> <li>| <a href="http://www.toptales.com.au/account/acc-login.cfm">login</a></li> <li>| <a href="http://www.toptales.com.au/account/acc-register.cfm">register</a></li> <li>| <a href="http://www.toptales.com.au/contact.cfm">contact</a></li> <li>&nbsp;&nbsp;&nbsp;</li> <li class="basket"><b><a class="basket" href="/checkout/shopping-trolley.cfm?sessionid=111113">shopping trolley</a></b></li> <li><i>$0.00</i></li> </ul> </div> <div id="header-top-nav-area"> <a href="http://www.toptales.com.au" title="Top Tales Book Club"><img src="/images/top-tales-logo.png" alt="Top Tales Book Club" title="Top Tales Book Club" border="0" /></a> </div> <div id="header-top-nav-cs"> <div>Customer Service: 1800 182 096</div> </div> <div id="header-nav-area"> <div id="header-nav-menu"> <div id="navigation"> <ul id="main_navigation"> <li><a href="http://www.toptales.com.au/" id="authors">Home</a></li> <li><a href="http://www.toptales.com.au/books/browse-all-books/" id="books">Book Supply Guidelines</a></li> <li><a href="http://www.toptales.com.au/advisory-service" id="multimedia">Advisory Service</a></li> <li><a href="http://www.toptales.com.au/book-club" id="community">Book Club</a></li> <li><a href="http://www.toptales.com.au/catalogues" id="categories">Current Catalogues</a></li> </ul> <div class="clearFloat"></div> </div></div> </div> <div id="header-search-area"><img src="/images/search_s.png" width="60" height="40" /><div id="quicksearch-area"> <form id="quicksearch" name="quicksearch" method="post" action="/search/search-results.cfm?action=search&searchtype=t"> <input type="hidden" name="action" value="search"><input type="hidden" name="searchtype" value="searchfull"><input type="hidden" name="TitleOperator" value="CONTAINS"> <input type="text" name="TitleCriteria" id="search-box" maxlength="30" onKeyPress="quickSearchStart();" onblur="setTimeout('closeResults()',100);" value="Enter Keyword, title, ISBN" class="inputCell" onFocus="this.value='';" /> <input name="imageField" id="search-button" type="image" src="/images/hnav_search1.gif" align="middle" width="56" height="19" border="0" /> </form> </div><div id="advanced-search-link"><a href="/search/search.cfm">advanced<br /> search</a></div> </div> </div> <div id="front-page-content"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td align="left" valign="top" width="168"> <div id="left-nav-area"> <div id="left-nav-menu"> <ul> <li><a href="/catalogues/?catid=TTX">Centre Xmas Catalogue 2016</a></li> <li><a href="/catalogues/?catid=TTB">Big Books &amp; Storage</a></li> <li><a href="/catalogues/?catid=TC2">Rainbow Book Club Cat</a></li> <li><a href="/catalogues/?catid=XMAS">Christmas Books</a></li> <li><a href="/catalogues/?catid=T11" style="margin-top:15px;">Top Tales Staff Picks</a></li> <li><a href="/catalogues/?catid=T14">Books Ages 0-3</a></li> <li><a href="/catalogues/?catid=T15">Books Ages 3-6</a></li> <li><a href="/catalogues/?catid=T3">Board & Manipulatives</a></li> <li><a href="/catalogues/?catid=T4">Classics</a></li> <li><a href="/catalogues/?catid=T5">Early Readers</a></li> <li><a href="/catalogues/?catid=T6">Educational </a></li> <li><a href="/catalogues/?catid=T7">Family, Friends & Life</a></li> <li><a href="/catalogues/?catid=T8">Picture Story Books</a></li> <li><a href="/catalogues/?catid=T9">Traditional Reading</a></li> </ul> </div> </div> </td> <td bgcolor="#FFFFFF" valign="top"> <div id="copy" style="margin-top:2px;"> <center> <table align="center"> <tr> <td><center><BR><BR><BR><DIV style="font-family:Arial, Helvetica, sans-serif; font-size:20px; font-weight:bold;">The product you are trying to view is not available.... :(</DIV></center></td> </tr> </table> <BR><img src="../images/clearpixel.gif" width="1" height="180"><BR> <table width="95%"> <tr> <td align="center"> <h3>New Releases</h3> <table width="100%"> <tr>
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString isbn=9781742833460
RemoteAddress 54.225.59.14
RootCause
Error - struct
Cause
Error - struct
ErrorCode 1064
Message 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1
SQLState 42000
StackTrace 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1 at sun.reflect.GeneratedConstructorAccessor16050.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:871) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1451) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88) at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
Suppressed
Error - array [empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 88
RAW_TRACE at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_MAIN
LINE 1
RAW_TRACE at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
DataSource booksdirect_stores
Detail 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
message 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1
Message Error Executing Database Query.
NativeErrorCode 1064
RootCause
Error - struct
ErrorCode 1064
Message 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1
SQLState 42000
StackTrace 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1 at sun.reflect.GeneratedConstructorAccessor16050.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:871) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1451) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88) at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
Suppressed
Error - array [empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 88
RAW_TRACE at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_MAIN
LINE 1
RAW_TRACE at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
SQLState 42000
Sql SELECT top 5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM products WHERE type = 'S' AND stkrelmonth > {ts '2018-06-25 00:00:00'} AND stkrelmonth < {ts '2018-09-25 13:07:10'} ORDER BY RND(INT(NOW*id)-NOW*id)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:739) at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88) at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1 at sun.reflect.GeneratedConstructorAccessor16050.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:871) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1451) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) ... 40 more
Suppressed
Error - array [empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 88
RAW_TRACE at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_MAIN
LINE 1
RAW_TRACE at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
Type Database
queryError 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1
where [empty string]
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:739) at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88) at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: 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 '5 isbn,title,cover,newreleases,type,stkrelmonth,priority,DateAdded FROM product' at line 1 at sun.reflect.GeneratedConstructorAccessor16050.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:871) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1451) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) ... 40 more
Suppressed
Error - array [empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 88
RAW_TRACE at cfmain2ecfm758678658._factor8(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:88)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_MAIN
LINE 1
RAW_TRACE at cfmain2ecfm758678658.runPage(C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm:1)
TEMPLATE C:\Inetpub\vhosts\toptales.com.au\httpdocs\books\main.cfm
TYPE CFML
Template /books/main.cfm
Type coldfusion.runtime.CfErrorWrapper
Form - struct [empty]
URL - struct
BOT spider
SESSIONID 111113
isbn 9781742833460