struct
Cause
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'marketingDate'.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1436) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:366) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 39
RAW_TRACE at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39)
TEMPLATE D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm
TYPE CFML
Type java.sql.SQLException
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'marketingDate'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1436) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:366) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 39
RAW_TRACE at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39)
TEMPLATE D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource cicerone
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'marketingDate'.
ErrorCode 42S22
Message Error Executing Database Query.
NativeErrorCode 207
RootCause
struct
ErrorCode 207
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'marketingDate'.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1436) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:366) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 39
RAW_TRACE at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39)
TEMPLATE D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm
TYPE CFML
Type java.sql.SQLException
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'marketingDate'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1436) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:366) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 39
RAW_TRACE at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39)
TEMPLATE D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
Sql SELECT p.id, t.aiTitle, p.title, p.subTitle, t.aiContents, t.bookBiography, p.price_pounds, t.marketingPrice, p.ISBN, p.previousISBN, p.EAN, p.publishedDate, t.marketingDate, p.height_cm, p.width_cm, p.pages, t.formatDesc, t.marketingPoints, p.editionNo FROM tbl_Product p LEFT JOIN tbl_ProductTitle t ON p.id = t.id WHERE p.EAN = (param 1)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:366) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'marketingDate'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1436) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 31 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 39
RAW_TRACE at cfinformationSheet2ecfm376777658.runPage(D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm:39)
TEMPLATE D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'marketingDate'.
where (param 1) = [type='IN', class='java.lang.String', value='9781852843366', sqltype='cf_sql_varchar']

struct
cfid 187523
cftoken 16394456
obasket
component components.Basket
METHODS
ADDFORMATITEM
function addFormatItem
Arguments:
Name Required Type Default
FormatId Required Any 0
quantity Optional Any 1
referrer Optional Any [empty string]
ProductFormat Optional Any [runtime expression]
PurchaseSource Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Add product format (e.g. eBook) item to the basket
Description:  
ADDITEM
function addItem
Arguments:
Name Required Type Default
productId Required Any 0
quantity Optional Any 1
referrer Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Add an item to the basket
Description:  
APPLYDISCOUNT
function applyDiscount
Arguments:none
ReturnType: Any
Roles:  
Access: private
Output: false
DisplayName:  
Hint: I check for discounts in the basket
Description:  
DBGETTOTAL
function dbGetTotal
Arguments:none
ReturnType: Any
Roles:  
Access: private
Output: false
DisplayName:  
Hint: I get the totals from the DB
Description:  
GETCONTENTS
function getContents
Arguments:none
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Get all items in the basket
Description:  
GETINGRAMDOWNLOADURL
function getIngramDownloadURL
Arguments:
Name Required Type Default
orderId Required Any 0
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I get the download URL from Ingram for Adobe eBooks format
Description:  
GETITEMID
function getItemId
Arguments:
Name Required Type Default
productId Required Any 0
ReturnType: Any
Roles:  
Access: private
Output: false
DisplayName:  
Hint: I check if an item is already in basket
Description:  
GETPRODUCTFORMAT
function getProductFormat
Arguments:
Name Required Type Default
ParentBookID Required Any 0
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Get other product formats not in basket
Description:  
GETTOTAL
function getTotal
Arguments:none
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Get basket total
Description:  
INIT
function init
Arguments:
Name Required Type Default
sessionId Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Setup the basket
Description:  
REFRESH
function refresh
Arguments:none
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Reset basket totals with db values
Description:  
REMOVEITEM
function removeItem
Arguments:
Name Required Type Default
orderItemId Required Any 0
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: Remove an item from the basket
Description:  
UPDATEQUANTITY
function updateQuantity
Arguments:
Name Required Type Default
orderItemId Required Any 0
quantity Optional Any 1
referrer Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I set a new quantity for an item
Description:  
XXGETDOWNLOADURL
function xxgetDownloadURL
Arguments:
Name Required Type Default
orderId Required Any 0
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I get the download URLs from VCI for Adobe eBooks format
Description:  
sessionid CICERONE2014_187523_16394456
urltoken CFID=187523&CFTOKEN=16394456

struct
USESTANDARDPRICE true
isbn 9781852843366

struct [empty]

struct
AUTH_PASSWORD [empty string]
AUTH_TYPE [empty string]
AUTH_USER [empty string]
CERT_COOKIE [empty string]
CERT_FLAGS [empty string]
CERT_ISSUER [empty string]
CERT_KEYSIZE 256
CERT_SECRETKEYSIZE 2048
CERT_SERIALNUMBER [empty string]
CERT_SERVER_ISSUER C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
CERT_SERVER_SUBJECT CN=bookmanager.cicerone.co.uk
CERT_SUBJECT [empty string]
CF_TEMPLATE_PATH D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm
CONTENT_LENGTH [empty string]
CONTENT_TYPE [empty string]
CONTEXT_PATH [empty string]
GATEWAY_INTERFACE CGI/1.1
HTTPS on
HTTPS_KEYSIZE 256
HTTPS_SECRETKEYSIZE 2048
HTTPS_SERVER_ISSUER C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
HTTPS_SERVER_SUBJECT CN=bookmanager.cicerone.co.uk
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING gzip
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE [empty string]
HTTP_HOST assets.cicerone.co.uk
HTTP_REFERER [empty string]
HTTP_USER_AGENT CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO /product/informationSheet.cfm
PATH_TRANSLATED D:\WebRoot\cicerone.co.uk\httpdocs\product\informationSheet.cfm
QUERY_STRING isbn=9781852843366
REMOTE_ADDR 18.212.239.56
REMOTE_HOST 18.212.239.56
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /product/informationSheet.cfm
SERVER_NAME assets.cicerone.co.uk
SERVER_PORT 443
SERVER_PORT_SECURE 1
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/7.5
WEB_SERVER_API [empty string]