Author: John
Illustrator:
Product Description Lauren St. John grew up surrounded by horses and wild animals on a farm and game reserve in Zimbabwe, the inspiration for her memoir, Rainbow’s End. After studying journalism, she relocated to the UK, where she spent nearly a decade on the European and PGA Tours as golf correspondent to the Sunday Times. She also wrote the acclaimed music biography Hardcore Troubadour: The Life & Near Death of Steve Earle. She is the author of the multi-award-winning The White Giraffe series for children, as well as the Laura Marlin mysteries, the first of which, Dead Man’s Cove, won the 2011 Blue Peter Book of the Year Award. Her bestselling One Dollar Horse series was followed by YA horse romance, The Glory, now optioned for film. Kat Wolfe on Thin Ice is the third mystery in the critically-acclaimed Wolfe and Lamb series published by Macmillan Children's Books.Lauren St. John grew up surrounded by horses and wild animals on a farm and game reserve in Zimbabwe, the inspiration for her memoir, Rainbow’s End. After studying journalism, she relocated to the UK, where she spent nearly a decade on the European and PGA Tours as golf correspondent to the Sunday Times. She also wrote the acclaimed music biography Hardcore Troubadour: The Life & Near Death of Steve Earle. She is the author of the multi-award-winning The White Giraffe series for children, as well as the Laura Marlin mysteries, the first of which, Dead Man’s Cove, won the 2011 Blue Peter Book of the Year Award. Her bestselling One Dollar Horse series was followed by YA horse romance, The Glory, now optioned for film. Kat Wolfe on Thin Ice is the third mystery in the critically-acclaimed Wolfe and Lamb series published by Macmillan Children's Books. Join Kat and Harper as they investigate an icy mystery in this wintry Wolfe and Lamb adventure from the bestselling Lauren St John.
An unexpected error occurred.
Please provide the following information to technical support:
Error Event: onRequest
Error details:
Catch Entries: 18 | additional | Struct (ordered) | SQL | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| DatabaseName | | DatabaseVersion | | DriverName | | DriverVersion | string | mysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c) |
| Datasource | string | booksdirect_stores_57 |
|
| Cause | Struct Entries: 15 | additional | Struct (ordered) | SQL | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| DatabaseName | | DatabaseVersion | | DriverName | | DriverVersion | string | mysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c) |
| Datasource | string | booksdirect_stores_57 |
|
| DataSource | string | booksdirect_stores_57 |
| Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Zero date value prohibited |
| NativeErrorCode | | queryError | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| Sql | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: Zero date value prohibited
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:99)
at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:980)
at lucee.runtime.query.caster.TimestampCast.toCFType(TimestampCast.java:40)
at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:706)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at item_cfm$cf.call(/item.cfm:191)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at application_cfc$cf.udfCall(/application.cfc:256)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at runwar.undertow.SSLClientCertHeaderHandler.handleRequest(SSLClientCertHeaderHandler.java:144)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
at java.base/java.lang.Thread.run(Thread.java:829)
|
| TagContext | Array | 1 | Struct | codePrintHTML | string | 189: WHERE author LIKE <cfqueryparam value="%#getbook.author#%" cfsqltype="cf_sql_varchar"><br>
190: ORDER BY CompanyCode ASC<br>
<b>191: </cfquery><cfset tab_title = "Books by #getbook.author#"><cfset GetSeries.SeriesCode = "1"></CFIF></b><br>
192: <ul id="tabNav"><br>
193: <li id="product-description-tab" class="here"><a id="product-description-link" href="javascript:displayInformationItem('product-description');">Product Details</a></li><br>
|
| codePrintPlain | string | 189: WHERE author LIKE <cfqueryparam value="%#getbook.author#%" cfsqltype="cf_sql_varchar">
190: ORDER BY CompanyCode ASC
191: </cfquery><cfset tab_title = "Books by #getbook.author#"><cfset GetSeries.SeriesCode = "1"></CFIF>
192: <ul id="tabNav">
193: <li id="product-description-tab" class="here"><a id="product-description-link" href="javascript:displayInformationItem('product-description');">Product Details</a></li>
|
| column | | id | | line | | Raw_Trace | string | item_cfm$cf.call(/item.cfm:191) |
| template | string | /var/www/www.betabooks.com.au/item.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 254: <br>
255: <!--- Include the requested page. ---><br>
<b>256: <cfinclude template="#ARGUMENTS.TargetPage#" /></b><br>
257: <br>
258: <!--- Return out. ---><br>
|
| codePrintPlain | string | 254:
255: <!--- Include the requested page. --->
256: <cfinclude template="#ARGUMENTS.TargetPage#" />
257:
258: <!--- Return out. --->
|
| column | | id | | line | | Raw_Trace | string | application_cfc$cf.udfCall(/application.cfc:256) |
| template | string | /var/www/www.betabooks.com.au/application.cfc |
| type | |
|
| type | | where | |
| DataSource | string | booksdirect_stores_57 |
| Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Zero date value prohibited |
| name | | NativeErrorCode | | queryError | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| rootCause | Struct Entries: 15 | additional | Struct (ordered) | SQL | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| DatabaseName | | DatabaseVersion | | DriverName | | DriverVersion | string | mysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c) |
| Datasource | string | booksdirect_stores_57 |
|
| DataSource | string | booksdirect_stores_57 |
| Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Zero date value prohibited |
| NativeErrorCode | | queryError | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| Sql | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: Zero date value prohibited
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:99)
at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:980)
at lucee.runtime.query.caster.TimestampCast.toCFType(TimestampCast.java:40)
at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:706)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at item_cfm$cf.call(/item.cfm:191)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at application_cfc$cf.udfCall(/application.cfc:256)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at runwar.undertow.SSLClientCertHeaderHandler.handleRequest(SSLClientCertHeaderHandler.java:144)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
at java.base/java.lang.Thread.run(Thread.java:829)
|
| TagContext | Array | 1 | Struct | codePrintHTML | string | 189: WHERE author LIKE <cfqueryparam value="%#getbook.author#%" cfsqltype="cf_sql_varchar"><br>
190: ORDER BY CompanyCode ASC<br>
<b>191: </cfquery><cfset tab_title = "Books by #getbook.author#"><cfset GetSeries.SeriesCode = "1"></CFIF></b><br>
192: <ul id="tabNav"><br>
193: <li id="product-description-tab" class="here"><a id="product-description-link" href="javascript:displayInformationItem('product-description');">Product Details</a></li><br>
|
| codePrintPlain | string | 189: WHERE author LIKE <cfqueryparam value="%#getbook.author#%" cfsqltype="cf_sql_varchar">
190: ORDER BY CompanyCode ASC
191: </cfquery><cfset tab_title = "Books by #getbook.author#"><cfset GetSeries.SeriesCode = "1"></CFIF>
192: <ul id="tabNav">
193: <li id="product-description-tab" class="here"><a id="product-description-link" href="javascript:displayInformationItem('product-description');">Product Details</a></li>
|
| column | | id | | line | | Raw_Trace | string | item_cfm$cf.call(/item.cfm:191) |
| template | string | /var/www/www.betabooks.com.au/item.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 254: <br>
255: <!--- Include the requested page. ---><br>
<b>256: <cfinclude template="#ARGUMENTS.TargetPage#" /></b><br>
257: <br>
258: <!--- Return out. ---><br>
|
| codePrintPlain | string | 254:
255: <!--- Include the requested page. --->
256: <cfinclude template="#ARGUMENTS.TargetPage#" />
257:
258: <!--- Return out. --->
|
| column | | id | | line | | Raw_Trace | string | application_cfc$cf.udfCall(/application.cfc:256) |
| template | string | /var/www/www.betabooks.com.au/application.cfc |
| type | |
|
| type | | where | |
| Sql | string | SELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode
FROM products
WHERE author LIKE '%John%'
ORDER BY CompanyCode ASC |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: Zero date value prohibited
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:99)
at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:980)
at lucee.runtime.query.caster.TimestampCast.toCFType(TimestampCast.java:40)
at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:706)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at item_cfm$cf.call(/item.cfm:191)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at application_cfc$cf.udfCall(/application.cfc:256)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at runwar.undertow.SSLClientCertHeaderHandler.handleRequest(SSLClientCertHeaderHandler.java:144)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
at java.base/java.lang.Thread.run(Thread.java:829)
|
| TagContext | Array | 1 | Struct | codePrintHTML | string | 189: WHERE author LIKE <cfqueryparam value="%#getbook.author#%" cfsqltype="cf_sql_varchar"><br>
190: ORDER BY CompanyCode ASC<br>
<b>191: </cfquery><cfset tab_title = "Books by #getbook.author#"><cfset GetSeries.SeriesCode = "1"></CFIF></b><br>
192: <ul id="tabNav"><br>
193: <li id="product-description-tab" class="here"><a id="product-description-link" href="javascript:displayInformationItem('product-description');">Product Details</a></li><br>
|
| codePrintPlain | string | 189: WHERE author LIKE <cfqueryparam value="%#getbook.author#%" cfsqltype="cf_sql_varchar">
190: ORDER BY CompanyCode ASC
191: </cfquery><cfset tab_title = "Books by #getbook.author#"><cfset GetSeries.SeriesCode = "1"></CFIF>
192: <ul id="tabNav">
193: <li id="product-description-tab" class="here"><a id="product-description-link" href="javascript:displayInformationItem('product-description');">Product Details</a></li>
|
| column | | id | | line | | Raw_Trace | string | item_cfm$cf.call(/item.cfm:191) |
| template | string | /var/www/www.betabooks.com.au/item.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 254: <br>
255: <!--- Include the requested page. ---><br>
<b>256: <cfinclude template="#ARGUMENTS.TargetPage#" /></b><br>
257: <br>
258: <!--- Return out. ---><br>
|
| codePrintPlain | string | 254:
255: <!--- Include the requested page. --->
256: <cfinclude template="#ARGUMENTS.TargetPage#" />
257:
258: <!--- Return out. --->
|
| column | | id | | line | | Raw_Trace | string | application_cfc$cf.udfCall(/application.cfc:256) |
| template | string | /var/www/www.betabooks.com.au/application.cfc |
| type | |
|
| type | | where | |
|
|