Oops! Exception Encountered

Application Execution Exception

Error Type: Database : 22018
Error Messages: Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value '0)' to data type int.
Tag Context:
ID: CFQUERY
LINE: 3481
Template: C:\home\irauctions.com\global\framework\muon\external\dataMgr\_DataMgr.cfc
ID: CF_TEMPLATEPROXY
LINE: 1
Template:
ID: CF_CFPAGE
LINE: 83
Template: C:\home\irauctions.com\global\framework\muon\DataAccessObject.cfc
ID: CF_TEMPLATEPROXY
LINE: 1104
Template: C:\home\irauctions.com\htdocs\models\Site.cfc
ID: CF_TEMPLATEPROXY
LINE: 9
Template: C:\home\irauctions.com\htdocs\views\auction\listing.cfm
ID: CFINCLUDE
LINE: 139
Template: C:\home\irauctions.com\global\framework\coldbox\2.6.4\system\plugins\renderer.cfc
ID: CF_UDFMETHOD
LINE: 211
Template: C:\home\irauctions.com\htdocs\layouts\Layout.Auction.cfm
ID: CFINCLUDE
LINE: 233
Template: C:\home\irauctions.com\global\framework\coldbox\2.6.4\system\plugins\renderer.cfc
ID: CF_TEMPLATEPROXY
LINE: 172
Template: C:\home\irauctions.com\global\framework\coldbox\2.6.4\system\coldbox.cfc
ID: CF_TEMPLATEPROXY
LINE: 74
Template: C:\home\irauctions.com\htdocs\Application.cfc
ID: ??
LINE: 1055
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 980
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 1124
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 193
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 1153
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 4126
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 4275
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 2035
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 632
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 2699
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 2508
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 1358
Template: |SQLServer|6.0.0.1282|
ID: CF_|SQLSERVER|6.0.0
LINE: 4478
Template: |SQLServer|6.0.0.1282|
Framework Snapshot
Current Event: auction.listing
Current Layout: Layout.auction.cfm
Current View: auction/listing
Bug Date: 11/328/2024 05:32:36 PM
Coldfusion ID: CFID=31449017 ; CFToken=71c8225316f7b433-8F8D7705-BB67-58C4-3414BF1DCCA58807 ; JSessionID=DE846FE03F0D8A774BB305E9C3FDA644_31449017_71c8225316f7b433-8F8D7705-BB67-58C4-3414BF1DCCA58807
Template Path : C:\home\irauctions.com\htdocs\index.cfm
Path Info : /listing/0)
Host & Server: sea4ihm.irauctions.com VPS-503-VA1
Query String:
Browser: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Database Exception Information:
NativeErrorCode & SQL State:
245 : 22018
SQL Sent:
SELECT ac.id, ac.siteID, ac.categoryName, ac.image, ac.orderBy, ac.isDeleted, ac.createdAt, (select count(1) from jnCategoryAuctions join auctions on jnCategoryAuctions.auctionID = auctions.id and auctions.isDeleted = 0 and auctions.isActive = 1 and auctions.isReady = 1 and auctions.serverStartsAt <= getDate() and auctions.serverEndsAt > getDate() where ac.id = jnCategoryAuctions.categoryID ) as auctionCount FROM auctionCategories ac WHERE ac.siteID = 997 AND (ac.isDeleted = 0 or ac.isDeleted is null) AND ac.categoryName != '' AND ac.id = '0)' ORDER BY ac.orderby;
Database Driver Error Message:
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value '0)' to data type int.
Name-Value Pairs:
Stack Trace: 
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cf_DataMgr2ecfc1094351835$funcRUNSQL.runFunction(C:\home\irauctions.com\global\framework\muon\external\dataMgr\_DataMgr.cfc:3481)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4053)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4017)
	at Statement24.evaluate(:1)
	at coldfusion.compiler.ExprClassLoader.evaluate(ExprClassLoader.java:149)
	at coldfusion.runtime.CFPage.evaluateExpr(CFPage.java:4478)
	at coldfusion.runtime.CFPage.Evaluate(CFPage.java:4464)
	at cfDataAccessObject2ecfc119944859$funcONMISSINGMETHOD.runFunction(C:\home\irauctions.com\global\framework\muon\DataAccessObject.cfc:83)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:423)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:996)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4142)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4105)
	at cfSite2ecfc1623844864$funcLISTAUCTIONCATEGORIES.runFunction(C:\home\irauctions.com\htdocs\models\Site.cfc:1104)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4053)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4017)
	at cflisting2ecfm1033308717.runPage(C:\home\irauctions.com\htdocs\views\auction\listing.cfm:9)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfrenderer2ecfc1885007936$funcRENDERVIEW.runFunction(C:\home\irauctions.com\global\framework\coldbox\2.6.4\system\plugins\renderer.cfc:139)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4899)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4879)
	at cfLayout2eAuction2ecfm1492010917.runPage(C:\home\irauctions.com\htdocs\layouts\Layout.Auction.cfm:211)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfrenderer2ecfc1885007936$funcRENDERLAYOUT.runFunction(C:\home\irauctions.com\global\framework\coldbox\2.6.4\system\plugins\renderer.cfc:233)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4142)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4105)
	at cfcoldbox2ecfc1718830957$funcPROCESSCOLDBOXREQUEST.runFunction(C:\home\irauctions.com\global\framework\coldbox\2.6.4\system\coldbox.cfc:172)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4142)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4105)
	at cfApplication2ecfc256835755$funcONREQUESTSTART.runFunction(C:\home\irauctions.com\htdocs\Application.cfc:74)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
	at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:562)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at jdk.internal.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at jdk.internal.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at jdk.internal.reflect.GeneratedMethodAccessor115.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value '0)' to data type int.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
	at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
	at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
	at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
	at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
	at macromedia.jdbc.sqlserver.base.gr.$fr$execute(|SQLServer|6.0.0.1282|:4478)
	at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:865)
	... 162 more
Extra Information Dump
[N/A]