struct
cachefile	C:\sites\scidev\hypercache\/87/7C/49/6614E8F92A4446F92BA10477F049C2A4FBF897C178F38EDBEC6C41FA32/FE/6B/8D/05/5C/2D/99/A4/A1/DC/8A/85/02/4B/D4/B9.cache
cfdumpinited	false
exception	struct DataSource scidev_production Detail Parameter index out of range (1 > number of parameters, which is 0). ErrorCode S1009 Message Error Executing Database Query. NativeErrorCode 0 RootCause struct ErrorCode 0 Message Parameter index out of range (1 > number of parameters, which is 0). SQLState S1009 StackTrace java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). 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.setInt(PreparedStatement.java:3258) at com.mysql.jdbc.PreparedStatement.setNumericObject(PreparedStatement.java:3447) at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3680) at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3586) at coldfusion.server.j2ee.sql.JRunPreparedStatement.setObject(JRunPreparedStatement.java:208) at coldfusion.sql.InParameter.setStatement(InParameter.java:58) 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 cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) 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 cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) 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 cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) 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 coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:345) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) 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:157) 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 107 RAW_TRACE at cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) TEMPLATE C:\sites\scidev\app\models\section\SectionDB.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 249 RAW_TRACE at cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) TEMPLATE C:\sites\scidev\app\models\section\SectionManager.cfc TYPE CFML 3 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 280 RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) TEMPLATE C:\sites\scidev\app\controllers\section.cfc TYPE CFML 4 struct COLUMN 0 ID CFINVOKE LINE 291 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML 5 struct COLUMN 0 ID CF_UDFMETHOD LINE 157 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:157) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML Type java.sql.SQLException SQLState S1009 Sql select region_id from sections_regions where section_id = StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) 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 cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) 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 cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) 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 coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:345) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) 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:157) 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 107 RAW_TRACE at cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) TEMPLATE C:\sites\scidev\app\models\section\SectionDB.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 249 RAW_TRACE at cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) TEMPLATE C:\sites\scidev\app\models\section\SectionManager.cfc TYPE CFML 3 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 280 RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) TEMPLATE C:\sites\scidev\app\controllers\section.cfc TYPE CFML 4 struct COLUMN 0 ID CFINVOKE LINE 291 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML 5 struct COLUMN 0 ID CF_UDFMETHOD LINE 157 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:157) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML Type Database queryError Parameter index out of range (1 > number of parameters, which is 0). where (param 1) = [type='IN', class='java.lang.Integer', value='59', sqltype='cf_sql_integer']
nocache	false
params	struct ACTION show APICALL NO CF_REQUEST /section/show/ CONTROLLER section ID 0 LANG en SECTION agriculture-and-environment SUBSECTION water TYPE announcements langID 1 pageNum 1 pageSize 20 pageStart 0
primarykey	877C496614E8F92A4446F92BA10477F049C2A4FBF897C178F38EDBEC6C41FA32
secondarykey	FE6B8D055C2D99A4A1DC8A85024BD4B9
session	component scidev.app.models.session.SessionVO LANGUAGEID 1 CREATEDAT 2008-12-02 22:38:34.0 ISADMIN 0 ISAUTHD 0 LANG en USERID 0 UPDATEDAT 2008-12-02 22:38:34.0 CREATEDBY 0 ID 714EE4EB6005DA5437D8D7EAF527CBDA ISSTICKY 0 UPDATEDBY 0
starttickcount	1228257514593
user	component scidev.app.models.user.UserVO GENDER 0 HASTHIRDPARTYCONTACT 0 LANGUAGEID 1 HASHTMLEMAIL 0 PASSCONFIRM [empty string] COUNTRYNAME [empty string] TOPICID 0 SHOWORGANISATION 0 NAME [empty string] TITLEID 0 CREATEDBY 0 EMAIL [empty string] CREATEDAT {ts '2008-12-02 22:38:34'} ADDRESS1 [empty string] HOWHEARDEMAIL [empty string] UPDATEDAT {ts '2008-12-02 22:38:34'} ADDRESS2 [empty string] CSID 0 EMAILALERTS [empty string] ID 0 HOWHEARDID 0 PASS [empty string] EMAILCONFIRM [empty string] CANCONTACT 0 FIRSTNAME [empty string] POSTCODE [empty string] LASTNAME [empty string] WORKPLACEID 0 COUNTRYID 0 CONTACTNAME [empty string] PHONE [empty string] HASALERTS 0 PHONE2 [empty string] ISDELETED 0 ADDRESS3 [empty string] POSITION [empty string] UPDATEDBY 0 ORGANISATION [empty string] PROFESSIONID 0 REGIONID 0
view	show_announcements

struct
EVENTNAME	[empty string]
EXCEPTION	struct DataSource scidev_production Detail Parameter index out of range (1 > number of parameters, which is 0). ErrorCode S1009 Message Error Executing Database Query. NativeErrorCode 0 RootCause struct ErrorCode 0 Message Parameter index out of range (1 > number of parameters, which is 0). SQLState S1009 StackTrace java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). 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.setInt(PreparedStatement.java:3258) at com.mysql.jdbc.PreparedStatement.setNumericObject(PreparedStatement.java:3447) at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3680) at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3586) at coldfusion.server.j2ee.sql.JRunPreparedStatement.setObject(JRunPreparedStatement.java:208) at coldfusion.sql.InParameter.setStatement(InParameter.java:58) 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 cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) 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 cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) 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 cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) 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 coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:345) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) 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:157) 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 107 RAW_TRACE at cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) TEMPLATE C:\sites\scidev\app\models\section\SectionDB.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 249 RAW_TRACE at cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) TEMPLATE C:\sites\scidev\app\models\section\SectionManager.cfc TYPE CFML 3 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 280 RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) TEMPLATE C:\sites\scidev\app\controllers\section.cfc TYPE CFML 4 struct COLUMN 0 ID CFINVOKE LINE 291 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML 5 struct COLUMN 0 ID CF_UDFMETHOD LINE 157 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:157) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML Type java.sql.SQLException SQLState S1009 Sql select region_id from sections_regions where section_id = StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) 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 cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) 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 cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) 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 coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:345) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916) at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) 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:157) 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 107 RAW_TRACE at cfSectionDB2ecfc545385852$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionDB.cfc:107) TEMPLATE C:\sites\scidev\app\models\section\SectionDB.cfc TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 249 RAW_TRACE at cfSectionManager2ecfc1592199724$funcREAD.runFunction(C:\sites\scidev\app\models\section\SectionManager.cfc:249) TEMPLATE C:\sites\scidev\app\models\section\SectionManager.cfc TYPE CFML 3 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 280 RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:280) TEMPLATE C:\sites\scidev\app\controllers\section.cfc TYPE CFML 4 struct COLUMN 0 ID CFINVOKE LINE 291 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCHDO.runFunction(C:\sites\scidev\framework\dispatch.cfc:291) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML 5 struct COLUMN 0 ID CF_UDFMETHOD LINE 157 RAW_TRACE at cfdispatch2ecfc1525636091$funcDISPATCH.runFunction(C:\sites\scidev\framework\dispatch.cfc:157) TEMPLATE C:\sites\scidev\framework\dispatch.cfc TYPE CFML Type Database queryError Parameter index out of range (1 > number of parameters, which is 0). where (param 1) = [type='IN', class='java.lang.Integer', value='59', sqltype='cf_sql_integer']