Home Page Coming Soon

Gymnastics School

Author:
Illustrator:
Retail Price: $24.95
Betabooks Price $19.96
ISBN: 9781405308533
Format: Hardback
Published: August 2005
Published By: Dorling Kindersley
Stock Availability
Titles that are READY TO SHIP will be sent from our warehouse within 2 business days while stocks last. Click here for more details.

SAVE $4.99  (20.0%) 

 This item is No Longer Available.
 

Product Description

Gymnastics School is a fabulous introduction to the world of gymnastics for beginners or those with some training. Clear illustrations show you how to perform essential basic gymnastic moves such as handstands, backflips, rolls and balances. Learn how to properly use equipment such as the vault, beam, bars and pommel horse. Beautiful photographs and lively instructions make Gymnastics School an essential guide for every child interested in the magical world of gymnastics.

An unexpected error occurred.

Please provide the following information to technical support:

Error Event: onRequest

Error details:

Catch
Entries: 18
additional
Struct (ordered)
SQL
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
DatabaseName
stringMySQL
DatabaseVersion
string8.0.32
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c)
Datasource
stringbooksdirect_stores_57
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
DatabaseName
stringMySQL
DatabaseVersion
string8.0.32
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c)
Datasource
stringbooksdirect_stores_57
DataSource
stringbooksdirect_stores_57
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringZero date value prohibited
NativeErrorCode
number0
queryError
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
Sql
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
SQLState
stringS1009
StackTrace
stringlucee.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
string189: WHERE author LIKE &lt;cfqueryparam value=&quot;%#getbook.author#%&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt;<br> 190: ORDER BY CompanyCode ASC<br> <b>191: &lt;/cfquery&gt;&lt;cfset tab_title = &quot;Books by #getbook.author#&quot;&gt;&lt;cfset GetSeries.SeriesCode = &quot;1&quot;&gt;&lt;/CFIF&gt;</b><br> 192: &lt;ul id=&quot;tabNav&quot;&gt;<br> 193: &lt;li id=&quot;product-description-tab&quot; class=&quot;here&quot;&gt;&lt;a id=&quot;product-description-link&quot; href=&quot;javascript:displayInformationItem('product-description');&quot;&gt;Product Details&lt;/a&gt;&lt;/li&gt;<br>
codePrintPlain
string189: 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
number0
id
string??
line
number191
Raw_Trace
stringitem_cfm$cf.call(/item.cfm:191)
template
string/var/www/www.betabooks.com.au/item.cfm
type
stringcfml
2
Struct
codePrintHTML
string254: <br> 255: &lt;!--- Include the requested page. ---&gt;<br> <b>256: &lt;cfinclude template=&quot;#ARGUMENTS.TargetPage#&quot; /&gt;</b><br> 257: <br> 258: &lt;!--- Return out. ---&gt;<br>
codePrintPlain
string254: 255: <!--- Include the requested page. ---> 256: <cfinclude template="#ARGUMENTS.TargetPage#" /> 257: 258: <!--- Return out. --->
column
number0
id
string??
line
number256
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:256)
template
string/var/www/www.betabooks.com.au/application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringbooksdirect_stores_57
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringZero date value prohibited
name
stringonRequest
NativeErrorCode
number0
queryError
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
DatabaseName
stringMySQL
DatabaseVersion
string8.0.32
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c)
Datasource
stringbooksdirect_stores_57
DataSource
stringbooksdirect_stores_57
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringZero date value prohibited
NativeErrorCode
number0
queryError
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
Sql
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
SQLState
stringS1009
StackTrace
stringlucee.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
string189: WHERE author LIKE &lt;cfqueryparam value=&quot;%#getbook.author#%&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt;<br> 190: ORDER BY CompanyCode ASC<br> <b>191: &lt;/cfquery&gt;&lt;cfset tab_title = &quot;Books by #getbook.author#&quot;&gt;&lt;cfset GetSeries.SeriesCode = &quot;1&quot;&gt;&lt;/CFIF&gt;</b><br> 192: &lt;ul id=&quot;tabNav&quot;&gt;<br> 193: &lt;li id=&quot;product-description-tab&quot; class=&quot;here&quot;&gt;&lt;a id=&quot;product-description-link&quot; href=&quot;javascript:displayInformationItem('product-description');&quot;&gt;Product Details&lt;/a&gt;&lt;/li&gt;<br>
codePrintPlain
string189: 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
number0
id
string??
line
number191
Raw_Trace
stringitem_cfm$cf.call(/item.cfm:191)
template
string/var/www/www.betabooks.com.au/item.cfm
type
stringcfml
2
Struct
codePrintHTML
string254: <br> 255: &lt;!--- Include the requested page. ---&gt;<br> <b>256: &lt;cfinclude template=&quot;#ARGUMENTS.TargetPage#&quot; /&gt;</b><br> 257: <br> 258: &lt;!--- Return out. ---&gt;<br>
codePrintPlain
string254: 255: <!--- Include the requested page. ---> 256: <cfinclude template="#ARGUMENTS.TargetPage#" /> 257: 258: <!--- Return out. --->
column
number0
id
string??
line
number256
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:256)
template
string/var/www/www.betabooks.com.au/application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringSELECT id,companycode,isbn,title,price,specialpriceBD,seriescode,author,`condition`,available,pubmonth,pubyear,type,stkrelmonth,cover,promocode FROM products WHERE author LIKE '% %' ORDER BY CompanyCode ASC
SQLState
stringS1009
StackTrace
stringlucee.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
string189: WHERE author LIKE &lt;cfqueryparam value=&quot;%#getbook.author#%&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt;<br> 190: ORDER BY CompanyCode ASC<br> <b>191: &lt;/cfquery&gt;&lt;cfset tab_title = &quot;Books by #getbook.author#&quot;&gt;&lt;cfset GetSeries.SeriesCode = &quot;1&quot;&gt;&lt;/CFIF&gt;</b><br> 192: &lt;ul id=&quot;tabNav&quot;&gt;<br> 193: &lt;li id=&quot;product-description-tab&quot; class=&quot;here&quot;&gt;&lt;a id=&quot;product-description-link&quot; href=&quot;javascript:displayInformationItem('product-description');&quot;&gt;Product Details&lt;/a&gt;&lt;/li&gt;<br>
codePrintPlain
string189: 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
number0
id
string??
line
number191
Raw_Trace
stringitem_cfm$cf.call(/item.cfm:191)
template
string/var/www/www.betabooks.com.au/item.cfm
type
stringcfml
2
Struct
codePrintHTML
string254: <br> 255: &lt;!--- Include the requested page. ---&gt;<br> <b>256: &lt;cfinclude template=&quot;#ARGUMENTS.TargetPage#&quot; /&gt;</b><br> 257: <br> 258: &lt;!--- Return out. ---&gt;<br>
codePrintPlain
string254: 255: <!--- Include the requested page. ---> 256: <cfinclude template="#ARGUMENTS.TargetPage#" /> 257: 258: <!--- Return out. --->
column
number0
id
string??
line
number256
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:256)
template
string/var/www/www.betabooks.com.au/application.cfc
type
stringcfml
type
stringdatabase
where
string