Login

You are creating an order with Sara Hammel (Leave)
< CONTINUE SHOPPING

Added to Cart!

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (59, 1, 1, 20, 20 )
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string13.00.5888
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringREDASPEN
DataSource
stringREDASPEN
Detail
stringViolation of PRIMARY KEY constraint 'PK_PriceLevel_Table'. Cannot insert duplicate key in object 'dbo.PriceLevel_Table'. The duplicate key value is (59, 1, 1).
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number2627
queryError
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (59, 1, 1, 20, 20 )
Sql
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (59, 1, 1, 20, 20 )
SQLState
string23000
StackTrace
stringlucee.runtime.exp.DatabaseException: at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:393) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:280) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:224) at lucee.runtime.tag.Query.executeDatasoure(Query.java:951) at lucee.runtime.tag.Query.doEndTag(Query.java:700) at system.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:146) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at system.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:77) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at __138.__138.redaspen_iact405.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../redaspen-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:15) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:140) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:89) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:225) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427) at lucee.runtime.engine.Request.exe(Request.java:44) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1091) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1039) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:486) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
TagContext
Array
1
Struct
codePrintHTML
string144: &lt;cfif IsDefined(&quot;REQUEST.SHOPPINGCART_TaxableType&quot;) and REQUEST.SHOPPINGCART_TaxableType eq 1&gt;, &lt;cfqueryparam cfsqltype=&quot;CF_SQL_DECIMAL&quot; value=&quot;#PLVQuery.Price_3[plvIndex]#&quot;&gt;&lt;/cfif&gt;<br> 145: )<br> <b>146: &lt;/cfquery&gt;</b><br> 147: &lt;/cfif&gt;<br> 148: &lt;cfset plvIndex = plvIndex + 1&gt;<br>
codePrintPlain
string144: <cfif IsDefined("REQUEST.SHOPPINGCART_TaxableType") and REQUEST.SHOPPINGCART_TaxableType eq 1>, <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#PLVQuery.Price_3[plvIndex]#"></cfif> 145: ) 146: </cfquery> 147: </cfif> 148: <cfset plvIndex = plvIndex + 1>
column
number0
id
string??
line
number146
Raw_Trace
stringsystem.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:146)
template
string/www/redaspen-iact/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm
type
stringcfml
2
Struct
codePrintHTML
string75: &lt;cfinclude template=&quot;#CallFile('act_CategoryLevels.cfm')#&quot;&gt;<br> 76: &lt;cfinclude template=&quot;#CallFile('act_GetAllByCategory.cfm')#&quot;&gt;<br> <b>77: &lt;cfinclude template=&quot;#CallFile('act_CheckUpdatePriceLevels.cfm')#&quot;&gt;&lt;!---this code will update the price levels for 100 products at a time from the backend---&gt;</b><br> 78: &lt;cfinclude template=&quot;#CallFile('dsp_GetAllByCategory.cfm')#&quot;&gt;<br> 79: &lt;/cfif&gt;<br>
codePrintPlain
string75: <cfinclude template="#CallFile('act_CategoryLevels.cfm')#"> 76: <cfinclude template="#CallFile('act_GetAllByCategory.cfm')#"> 77: <cfinclude template="#CallFile('act_CheckUpdatePriceLevels.cfm')#"><!---this code will update the price levels for 100 products at a time from the backend---> 78: <cfinclude template="#CallFile('dsp_GetAllByCategory.cfm')#"> 79: </cfif>
column
number0
id
string??
line
number77
Raw_Trace
stringsystem.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:77)
template
string/www/redaspen-iact/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm
type
stringcfml
3
Struct
codePrintHTML
string13: &lt;cfset FuseSubAction=&quot;AllByCategory&quot;&gt;<br> 14: &lt;cfset FuseDirectory=&quot;Categories&quot;&gt;<br> <b>15: &lt;cfinclude template=&quot;#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#&quot;&gt; </b><br> 16: &lt;/cfif&gt;<br> 17: <br>
codePrintPlain
string13: <cfset FuseSubAction="AllByCategory"> 14: <cfset FuseDirectory="Categories"> 15: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#"> 16: </cfif> 17:
column
number0
id
string??
line
number15
Raw_Trace
string__138.__138.redaspen_iact405.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../redaspen-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:15)
template
string/www/redaspen-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm
type
stringcfml
4
Struct
codePrintHTML
string138: &lt;!--- WF 95086 ---&gt;<br> 139: &lt;cfinclude template=&quot;Actions/act_Header.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> <b>140: &lt;cfinclude template=&quot;#DisplayShopPath(&quot;dsp_CategoryShop.cfm&quot;)#&quot;&gt;</b><br> 141: &lt;cfinclude template=&quot;Actions/act_Footer.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> 142: &lt;cfsetting showdebugoutput=&quot;yes&quot;&gt;<br>
codePrintPlain
string138: <!--- WF 95086 ---> 139: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679---> 140: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#"> 141: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679---> 142: <cfsetting showdebugoutput="yes">
column
number0
id
string??
line
number140
Raw_Trace
string__138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:140)
template
string/www/redaspen-iact/system/modules/ShoppingCart/fbx_Switch.cfm
type
stringcfml
5
Struct
codePrintHTML
string87: <br> 88: &lt;CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir&gt;&lt;!---reset new directory---&gt;<br> <b>89: &lt;CFINCLUDE Template=&quot;../../system/modules/ShoppingCart/fbx_Switch.cfm&quot;&gt;</b><br>
codePrintPlain
string87: 88: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory---> 89: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm">
column
number0
id
string??
line
number89
Raw_Trace
stringshoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:89)
template
string/www/redaspen-iact/wwwroot/ShoppingCart/index.cfm
type
stringcfml
type
stringdatabase
where
string