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 SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
DatabaseName
stringMySQL
DatabaseVersion
string8.0.28
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 SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
DatabaseName
stringMySQL
DatabaseVersion
string8.0.28
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
stringColumn 'isbn' in field list is ambiguous
NativeErrorCode
number1052
queryError
stringSELECT SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
Sql
stringSELECT SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
SQLState
string23000
StackTrace
stringlucee.runtime.exp.DatabaseException: Column 'isbn' in field list is ambiguous at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) 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 books.best_sellers225.index_cfm$cf$2y.call(/books/best-sellers/index.cfm:35) 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:232) 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
string33: ORDER BY total_sales DESC<br> 34: LIMIT #start_limit# , 48<br> <b>35: &lt;/cfquery&gt;</b><br> 36: <br> 37: &lt;cfquery name=&quot;articlecount&quot; datasource=&quot;#ds#&quot;&gt;<br>
codePrintPlain
string33: ORDER BY total_sales DESC 34: LIMIT #start_limit# , 48 35: </cfquery> 36: 37: <cfquery name="articlecount" datasource="#ds#">
column
number0
id
string??
line
number35
Raw_Trace
stringbooks.best_sellers225.index_cfm$cf$2y.call(/books/best-sellers/index.cfm:35)
template
string/var/www/www.bookwarehouse.com.au/books/best-sellers/index.cfm
type
stringcfml
2
Struct
codePrintHTML
string230: <br> 231: &lt;!--- Include the requested page. ---&gt;<br> <b>232: &lt;cfinclude template=&quot;#ARGUMENTS.TargetPage#&quot; /&gt;</b><br> 233: <br> 234: &lt;!--- Return out. ---&gt;<br>
codePrintPlain
string230: 231: <!--- Include the requested page. ---> 232: <cfinclude template="#ARGUMENTS.TargetPage#" /> 233: 234: <!--- Return out. --->
column
number0
id
string??
line
number232
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:232)
template
string/var/www/www.bookwarehouse.com.au/application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringbooksdirect_stores_57
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringColumn 'isbn' in field list is ambiguous
name
stringonRequest
NativeErrorCode
number1052
queryError
stringSELECT SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
DatabaseName
stringMySQL
DatabaseVersion
string8.0.28
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
stringColumn 'isbn' in field list is ambiguous
NativeErrorCode
number1052
queryError
stringSELECT SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
Sql
stringSELECT SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
SQLState
string23000
StackTrace
stringlucee.runtime.exp.DatabaseException: Column 'isbn' in field list is ambiguous at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) 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 books.best_sellers225.index_cfm$cf$2y.call(/books/best-sellers/index.cfm:35) 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:232) 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
string33: ORDER BY total_sales DESC<br> 34: LIMIT #start_limit# , 48<br> <b>35: &lt;/cfquery&gt;</b><br> 36: <br> 37: &lt;cfquery name=&quot;articlecount&quot; datasource=&quot;#ds#&quot;&gt;<br>
codePrintPlain
string33: ORDER BY total_sales DESC 34: LIMIT #start_limit# , 48 35: </cfquery> 36: 37: <cfquery name="articlecount" datasource="#ds#">
column
number0
id
string??
line
number35
Raw_Trace
stringbooks.best_sellers225.index_cfm$cf$2y.call(/books/best-sellers/index.cfm:35)
template
string/var/www/www.bookwarehouse.com.au/books/best-sellers/index.cfm
type
stringcfml
2
Struct
codePrintHTML
string230: <br> 231: &lt;!--- Include the requested page. ---&gt;<br> <b>232: &lt;cfinclude template=&quot;#ARGUMENTS.TargetPage#&quot; /&gt;</b><br> 233: <br> 234: &lt;!--- Return out. ---&gt;<br>
codePrintPlain
string230: 231: <!--- Include the requested page. ---> 232: <cfinclude template="#ARGUMENTS.TargetPage#" /> 233: 234: <!--- Return out. --->
column
number0
id
string??
line
number232
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:232)
template
string/var/www/www.bookwarehouse.com.au/application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringSELECT SQL_CALC_FOUND_ROWS `sol_date_stamp`,`pronto_stock_master`.`stock_code` as code,`pronto_stock_master`.`stk_description` AS description,stk_apn_number,stk_sort_analysis_code,stk_shelf_life_days,title,subtitle,isbn,cover,readingage,price,readingage,format,companycode,author,`condition`,available,author,size,pages,stkrelmonth,illustrator,publisher,promocode,shortdescription,curriculum_ref,seriescode,`prc_retail_inc_tax` AS priceinc,SUM(`pronto_sales_order_lines`.`sol_ordered_qty`) AS total_sales FROM `pronto_sales_order_lines` INNER JOIN `pronto_stock_master` ON `pronto_sales_order_lines`.`stock_code` = `pronto_stock_master`.`stock_code` INNER JOIN `pronto_stock_price` ON `pronto_stock_price`.`stock_code` = `pronto_stock_master`.`stock_code` LEFT OUTER JOIN products ON `products`.`companycode` = `pronto_stock_master`.`stock_code` WHERE `so_bo_suffix` = "" AND (`sol_date_stamp` < '2023-11-29') AND (`sol_date_stamp` > '2023-08-29') AND left(`stk_sort_analysis_code`,1) NOT IN ("P","F") GROUP BY `pronto_sales_order_lines`.`stock_code` ORDER BY total_sales DESC LIMIT 0 , 48
SQLState
string23000
StackTrace
stringlucee.runtime.exp.DatabaseException: Column 'isbn' in field list is ambiguous at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) 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 books.best_sellers225.index_cfm$cf$2y.call(/books/best-sellers/index.cfm:35) 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:232) 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
string33: ORDER BY total_sales DESC<br> 34: LIMIT #start_limit# , 48<br> <b>35: &lt;/cfquery&gt;</b><br> 36: <br> 37: &lt;cfquery name=&quot;articlecount&quot; datasource=&quot;#ds#&quot;&gt;<br>
codePrintPlain
string33: ORDER BY total_sales DESC 34: LIMIT #start_limit# , 48 35: </cfquery> 36: 37: <cfquery name="articlecount" datasource="#ds#">
column
number0
id
string??
line
number35
Raw_Trace
stringbooks.best_sellers225.index_cfm$cf$2y.call(/books/best-sellers/index.cfm:35)
template
string/var/www/www.bookwarehouse.com.au/books/best-sellers/index.cfm
type
stringcfml
2
Struct
codePrintHTML
string230: <br> 231: &lt;!--- Include the requested page. ---&gt;<br> <b>232: &lt;cfinclude template=&quot;#ARGUMENTS.TargetPage#&quot; /&gt;</b><br> 233: <br> 234: &lt;!--- Return out. ---&gt;<br>
codePrintPlain
string230: 231: <!--- Include the requested page. ---> 232: <cfinclude template="#ARGUMENTS.TargetPage#" /> 233: 234: <!--- Return out. --->
column
number0
id
string??
line
number232
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:232)
template
string/var/www/www.bookwarehouse.com.au/application.cfc
type
stringcfml
type
stringdatabase
where
string