struct
cachefile C:\sites\scidev\hypercache\/87/7C/49/6614E8F92A4446F92BA10477F049C2A4FBF897C178F38EDBEC6C41FA32/65/E9/67/89/A1/AA/8B/0F/47/C8/6C/7C/03/9C/AB/38.cache
cfdumpinited false
exception
struct
DataSource scidev_production
Detail Parameter index out of range (6 > number of parameters, which is 5).
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Parameter index out of range (6 > number of parameters, which is 5).
SQLState S1009
StackTrace java.sql.SQLException: Parameter index out of range (6 > number of parameters, which is 5). 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 cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701) 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 cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151) 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:206) 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 701
RAW_TRACE at cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701)
TEMPLATE C:\sites\scidev\app\models\article\ArticleDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 151
RAW_TRACE at cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151)
TEMPLATE C:\sites\scidev\app\models\article\ArticleManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 206
RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:206)
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 ) s and a.type_id NOT IN (nct a.id) as count from articles a inner join article_translations atr on atr.article_id = a.id and atr.language_id = (param 1) and atr.status_id = 2 inner join article_types at on a.type_id = at.id inner join article_statuses ast on ast.id = a.status_id inner join users u on u.id = a.created_by left outer join article_links ali on ali.article_id = a.id left outer join article_files af on af.article_id = a.id left outer join key_documents kd on kd.article_id = a.id left outer join notices n on n.article_id = a.id left outer join notice_translations nt on nt.article_id = n.article_id and nt.language_id = (param 2) inner join article_translation_slugs ats on ats.article_id = a.id where 1=1 and a.status_id = (param 3) and a.type_id IN ( (param 4) ) and a.is_deleted = (param 5) and ( a.expire_at > now() or a.expire_at is null or a.expire_at = '0000-00-00 00:00:00' ) and a.publish_at <= now() order by a.publish_at desc
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701) 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 cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151) 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:206) 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 701
RAW_TRACE at cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701)
TEMPLATE C:\sites\scidev\app\models\article\ArticleDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 151
RAW_TRACE at cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151)
TEMPLATE C:\sites\scidev\app\models\article\ArticleManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 206
RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:206)
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 (6 > number of parameters, which is 5).
where (param 1) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 4) = [type='IN', class='java.lang.Integer', value='13', sqltype='cf_sql_integer'] , (param 5) = [type='IN', class='java.lang.Integer', value='17', sqltype='cf_sql_integer'] , (param 6) = [type='IN', class='java.lang.Integer', value='0', sqltype='cf_sql_integer']
nocache false
params
struct
ACTION show
APICALL NO
CF_REQUEST /section/show/
CONTROLLER section
ID 0
LANG po
SECTION [empty string]
TYPE jobs
langID 3
pageNum 1
pageSize 20
pageStart 0
primarykey 877C496614E8F92A4446F92BA10477F049C2A4FBF897C178F38EDBEC6C41FA32
secondarykey 65E96789A1AA8B0F47C86C7C039CAB38
session
component scidev.app.models.session.SessionVO
CREATEDBY 0
CREATEDAT 2008-12-02 20:40:54.0
UPDATEDAT 2008-12-02 20:40:54.0
LANGUAGEID 3
ISSTICKY 0
ISAUTHD 0
LANG po
ISADMIN 0
ID 114EE4EB6005DEB4E493567DA784DAF8
USERID 0
UPDATEDBY 0
starttickcount 1228250454421
user
component scidev.app.models.user.UserVO
PASS [empty string]
ORGANISATION [empty string]
LASTNAME [empty string]
ADDRESS1 [empty string]
GENDER 0
SHOWORGANISATION 0
POSTCODE [empty string]
HOWHEARDEMAIL [empty string]
COUNTRYID 0
HOWHEARDID 0
LANGUAGEID 1
PROFESSIONID 0
PHONE2 [empty string]
UPDATEDAT {ts '2008-12-02 20:40:54'}
HASHTMLEMAIL 0
COUNTRYNAME [empty string]
NAME [empty string]
WORKPLACEID 0
EMAIL [empty string]
FIRSTNAME [empty string]
CONTACTNAME [empty string]
ID 0
EMAILALERTS [empty string]
HASTHIRDPARTYCONTACT 0
UPDATEDBY 0
PASSCONFIRM [empty string]
CSID 0
EMAILCONFIRM [empty string]
HASALERTS 0
TITLEID 0
ADDRESS3 [empty string]
CREATEDBY 0
POSITION [empty string]
CANCONTACT 0
ADDRESS2 [empty string]
REGIONID 0
CREATEDAT {ts '2008-12-02 20:40:54'}
TOPICID 0
ISDELETED 0
PHONE [empty string]
view show_jobs
struct
EVENTNAME [empty string]
EXCEPTION
struct
DataSource scidev_production
Detail Parameter index out of range (6 > number of parameters, which is 5).
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Parameter index out of range (6 > number of parameters, which is 5).
SQLState S1009
StackTrace java.sql.SQLException: Parameter index out of range (6 > number of parameters, which is 5). 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 cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701) 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 cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151) 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:206) 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 701
RAW_TRACE at cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701)
TEMPLATE C:\sites\scidev\app\models\article\ArticleDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 151
RAW_TRACE at cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151)
TEMPLATE C:\sites\scidev\app\models\article\ArticleManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 206
RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:206)
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 ) s and a.type_id NOT IN (nct a.id) as count from articles a inner join article_translations atr on atr.article_id = a.id and atr.language_id = (param 1) and atr.status_id = 2 inner join article_types at on a.type_id = at.id inner join article_statuses ast on ast.id = a.status_id inner join users u on u.id = a.created_by left outer join article_links ali on ali.article_id = a.id left outer join article_files af on af.article_id = a.id left outer join key_documents kd on kd.article_id = a.id left outer join notices n on n.article_id = a.id left outer join notice_translations nt on nt.article_id = n.article_id and nt.language_id = (param 2) inner join article_translation_slugs ats on ats.article_id = a.id where 1=1 and a.status_id = (param 3) and a.type_id IN ( (param 4) ) and a.is_deleted = (param 5) and ( a.expire_at > now() or a.expire_at is null or a.expire_at = '0000-00-00 00:00:00' ) and a.publish_at <= now() order by a.publish_at desc
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701) 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 cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151) 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:206) 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 701
RAW_TRACE at cfArticleDB2ecfc1172654810$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleDB.cfc:701)
TEMPLATE C:\sites\scidev\app\models\article\ArticleDB.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 151
RAW_TRACE at cfArticleManager2ecfc389033674$funcSEARCH.runFunction(C:\sites\scidev\app\models\article\ArticleManager.cfc:151)
TEMPLATE C:\sites\scidev\app\models\article\ArticleManager.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 206
RAW_TRACE at cfsection2ecfc498715138$funcSHOW.runFunction(C:\sites\scidev\app\controllers\section.cfc:206)
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 (6 > number of parameters, which is 5).
where (param 1) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 4) = [type='IN', class='java.lang.Integer', value='13', sqltype='cf_sql_integer'] , (param 5) = [type='IN', class='java.lang.Integer', value='17', sqltype='cf_sql_integer'] , (param 6) = [type='IN', class='java.lang.Integer', value='0', sqltype='cf_sql_integer']