struct
cachefile C:\sites\scidev\hypercache\/A9/B2/74/C29F9639F373ED2AA000FA3391AD060B3F11D16BF2F4856F732C80EB4D/B8/1D/54/CA/6B/64/1A/38/20/02/6F/C8/A8/D5/1A/81.cache
cfdumpinited false
exception
struct
DataSource scidev_production
Detail Parameter index out of range (2 > number of parameters, which is 1).
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Parameter index out of range (2 > number of parameters, which is 1).
SQLState S1009
StackTrace java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3288) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3272) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3314) at com.mysql.jdbc.PreparedStatement.setBigDecimal(PreparedStatement.java:2729) at com.mysql.jdbc.PreparedStatement.setNumericObject(PreparedStatement.java:3491) at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3680) at coldfusion.server.j2ee.sql.JRunPreparedStatement.setObject(JRunPreparedStatement.java:213) at coldfusion.sql.InParameter.setStatement(InParameter.java:62) at coldfusion.sql.ParameterList.setStatement(ParameterList.java:107) at coldfusion.sql.Executive.executeQuery(Executive.java:755) at coldfusion.sql.Executive.executeQuery(Executive.java:675) at coldfusion.sql.Executive.executeQuery(Executive.java:636) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500) at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:158) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:219) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:106) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:157) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 695
RAW_TRACE at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695)
TEMPLATE C:\sites\scidev\app\models\topic\TopicDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 167
RAW_TRACE at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167)
TEMPLATE C:\sites\scidev\app\models\topic\TopicManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 9
RAW_TRACE at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9)
TEMPLATE C:\sites\scidev\app\views\layouts\_nav.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 12
RAW_TRACE at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12)
TEMPLATE C:\sites\scidev\app\views\layouts\main.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 99
RAW_TRACE at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 25
RAW_TRACE at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 353
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 147
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
Type java.sql.SQLException
SQLState S1009
Sql (param 1) select st.topic_id, st.section_id, s.parent_id, tt.name as topic_title, str.title as section_title, str.slug as slug, replace(str.slug,'-','_') as export_slug, pstr.title as parent_title from section_topics st inner join sections s on s.id = st.section_id inner join section_translations str on str.section_id = st.section_id and str.language_id = inner join topic_translations tt on tt.topic_id = st.topic_id and tt.language_id = inner join section_translations pstr on pstr.section_id = s.parent_id and pstr.language_id = where s.parent_id NOT IN () and s.status_id = order by pstr.title asc, tt.name asc
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:158) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:219) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:106) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:157) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 695
RAW_TRACE at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695)
TEMPLATE C:\sites\scidev\app\models\topic\TopicDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 167
RAW_TRACE at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167)
TEMPLATE C:\sites\scidev\app\models\topic\TopicManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 9
RAW_TRACE at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9)
TEMPLATE C:\sites\scidev\app\views\layouts\_nav.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 12
RAW_TRACE at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12)
TEMPLATE C:\sites\scidev\app\views\layouts\main.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 99
RAW_TRACE at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 25
RAW_TRACE at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 353
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 147
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
Type Database
queryError Parameter index out of range (2 > number of parameters, which is 1).
where (param 1) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 2) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 3) = [type='IN', class='java.lang.String', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 4) = [type='IN', class='java.lang.String', value='1', sqltype='cf_sql_varchar'] , (param 5) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 6) = [type='IN', class='java.lang.String', value='4', sqltype='cf_sql_varchar'] , (param 7) = [type='IN', class='java.lang.String', value='3', sqltype='cf_sql_numeric', scale='0']
layout main
nocache false
params
struct
ACTION definitions
ALL true
APICALL NO
BODY_CLASS topic_page content_green
CATEGORY agri-biotech-
CF_REQUEST /section/definitions/
CONTROLLER section
ID 0
LANG en
SECTION agriculture-and-environment
TYPE definitions
archive false
breadcrumb [empty string]
indexonly 0
langID 1
letter [empty string]
pageNum 1
pageSize 20
pageStart 0
subsection [empty string]
primarykey A9B274C29F9639F373ED2AA000FA3391AD060B3F11D16BF2F4856F732C80EB4D
secondarykey B81D54CA6B641A3820026FC8A8D51A81
sectioncontext topic
session
component scidev.app.models.session.SessionVO
ISADMIN 0
LANG en
CREATEDAT 2008-11-21 11:42:28.0
ISSTICKY 0
UPDATEDAT 2008-11-21 11:42:28.0
ID 614EE4EB6005DA5437B065EF23B04547
USERID 0
UPDATEDBY 0
ISAUTHD 0
LANGUAGEID 1
CREATEDBY 0
starttickcount 1227267748046
top_box <div id="energy_policy_feature" class="title_box cf"> <h2> <a href="/en/agriculture-and-environment/" > <strong>Agriculture &amp; Environment</strong></a> </h2> <ul class="cf"> <li> <a href="/en/agriculture-and-environment/news/" > News</a></li> <li> <a href="/en/agriculture-and-environment/features/" > Features</a></li> <li> <a href="/en/agriculture-and-environment/opinions/" > Opinions</a></li> <li> <a href="/en/agriculture-and-environment/editorials/" > Editorials</a></li> <li> <a href="/en/agriculture-and-environment/policy-briefs/" > Policy Briefs</a></li> <li> <a href="/en/agriculture-and-environment/editor-letters/" > Letters to the Editor</a></li> <li class="last"> <a href="/en/agriculture-and-environment/book-reviews/" > Book Reviews</a></li> </ul> <ul class="cf"> <li> <a href="/en/agriculture-and-environment/practical-guides/" > Practical Guides</a></li> <li> <a href="/en/agriculture-and-environment/key-documents/" > Key Documents</a></li> <li> <a href="/en/agriculture-and-environment/links/" > Links</a></li> <li class="active"> <a href="/en/agriculture-and-environment/definitions/" > Definitions</a></li> <li> <a href="/en/agriculture-and-environment/events/" > Events</a></li> <li> <a href="/en/agriculture-and-environment/jobs/" > Jobs</a></li> <li> <a href="/en/agriculture-and-environment/grants/" > Grants</a></li> <li class="last"> <a href="/en/agriculture-and-environment/announcements/" > Announcements</a></li> </ul> </div>
user
component scidev.app.models.user.UserVO
GENDER 0
ADDRESS3 [empty string]
FIRSTNAME [empty string]
COUNTRYNAME [empty string]
HASHTMLEMAIL 0
REGIONID 0
HASTHIRDPARTYCONTACT 0
TOPICID 0
NAME [empty string]
PASS [empty string]
PHONE2 [empty string]
ADDRESS2 [empty string]
HOWHEARDID 0
EMAILALERTS [empty string]
SHOWORGANISATION 0
CONTACTNAME [empty string]
CANCONTACT 0
LANGUAGEID 1
LASTNAME [empty string]
ID 0
POSITION [empty string]
TITLEID 0
ADDRESS1 [empty string]
PHONE [empty string]
EMAILCONFIRM [empty string]
WORKPLACEID 0
UPDATEDAT {ts '2008-11-21 11:42:28'}
ORGANISATION [empty string]
CREATEDAT {ts '2008-11-21 11:42:28'}
COUNTRYID 0
ISDELETED 0
POSTCODE [empty string]
HASALERTS 0
UPDATEDBY 0
CREATEDBY 0
PASSCONFIRM [empty string]
CSID 0
EMAIL [empty string]
PROFESSIONID 0
view definitions
struct
EVENTNAME [empty string]
EXCEPTION
struct
DataSource scidev_production
Detail Parameter index out of range (2 > number of parameters, which is 1).
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Parameter index out of range (2 > number of parameters, which is 1).
SQLState S1009
StackTrace java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3288) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3272) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3314) at com.mysql.jdbc.PreparedStatement.setBigDecimal(PreparedStatement.java:2729) at com.mysql.jdbc.PreparedStatement.setNumericObject(PreparedStatement.java:3491) at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3680) at coldfusion.server.j2ee.sql.JRunPreparedStatement.setObject(JRunPreparedStatement.java:213) at coldfusion.sql.InParameter.setStatement(InParameter.java:62) at coldfusion.sql.ParameterList.setStatement(ParameterList.java:107) at coldfusion.sql.Executive.executeQuery(Executive.java:755) at coldfusion.sql.Executive.executeQuery(Executive.java:675) at coldfusion.sql.Executive.executeQuery(Executive.java:636) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500) at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:158) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:219) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:106) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:157) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 695
RAW_TRACE at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695)
TEMPLATE C:\sites\scidev\app\models\topic\TopicDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 167
RAW_TRACE at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167)
TEMPLATE C:\sites\scidev\app\models\topic\TopicManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 9
RAW_TRACE at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9)
TEMPLATE C:\sites\scidev\app\views\layouts\_nav.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 12
RAW_TRACE at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12)
TEMPLATE C:\sites\scidev\app\views\layouts\main.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 99
RAW_TRACE at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 25
RAW_TRACE at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 353
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 147
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
Type java.sql.SQLException
SQLState S1009
Sql (param 1) select st.topic_id, st.section_id, s.parent_id, tt.name as topic_title, str.title as section_title, str.slug as slug, replace(str.slug,'-','_') as export_slug, pstr.title as parent_title from section_topics st inner join sections s on s.id = st.section_id inner join section_translations str on str.section_id = st.section_id and str.language_id = inner join topic_translations tt on tt.topic_id = st.topic_id and tt.language_id = inner join section_translations pstr on pstr.section_id = s.parent_id and pstr.language_id = where s.parent_id NOT IN () and s.status_id = order by pstr.title asc, tt.name asc
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:158) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:219) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:106) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:157) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 695
RAW_TRACE at cfTopicDB2ecfc1211774728$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicDB.cfc:695)
TEMPLATE C:\sites\scidev\app\models\topic\TopicDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 167
RAW_TRACE at cfTopicManager2ecfc1996846983$funcGETSUBTOPICS.runFunction(C:\sites\scidev\app\models\topic\TopicManager.cfc:167)
TEMPLATE C:\sites\scidev\app\models\topic\TopicManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 9
RAW_TRACE at cf_nav2ecfm1527219254.runPage(C:\sites\scidev\app\views\layouts\_nav.cfm:9)
TEMPLATE C:\sites\scidev\app\views\layouts\_nav.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 12
RAW_TRACE at cfmain2ecfm1727535597.runPage(C:\sites\scidev\app\views\layouts\main.cfm:12)
TEMPLATE C:\sites\scidev\app\views\layouts\main.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 99
RAW_TRACE at cfview2ecfc1603091630$funcRENDERLAYOUT.runFunction(C:\sites\scidev\framework\view.cfc:99)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 25
RAW_TRACE at cfview2ecfc1603091630$funcRENDER.runFunction(C:\sites\scidev\framework\view.cfc:25)
TEMPLATE C:\sites\scidev\framework\view.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 353
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:353)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 147
RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:147)
TEMPLATE C:\sites\scidev\framework\dispatch.cfc
TYPE CFML
Type Database
queryError Parameter index out of range (2 > number of parameters, which is 1).
where (param 1) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 2) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 3) = [type='IN', class='java.lang.String', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 4) = [type='IN', class='java.lang.String', value='1', sqltype='cf_sql_varchar'] , (param 5) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 6) = [type='IN', class='java.lang.String', value='4', sqltype='cf_sql_varchar'] , (param 7) = [type='IN', class='java.lang.String', value='3', sqltype='cf_sql_numeric', scale='0']