Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume , Price4)
VALUES (8079, 74,
1,
675,
0
, 0
) |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.2 for SQL Server |
| | DriverVersion | | | Datasource | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | Violation of PRIMARY KEY constraint 'PK_PriceLevel_Table'. Cannot insert duplicate key in object 'dbo.PriceLevel_Table'. The duplicate key value is (8079, 74, 1). |
|
| NativeErrorCode | |
| queryError | | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume , Price4)
VALUES (8079, 74,
1,
675,
0
, 0
) |
|
| Sql | | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume , Price4)
VALUES (8079, 74,
1,
675,
0
, 0
) |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: Violation of PRIMARY KEY constraint 'PK_PriceLevel_Table'. Cannot insert duplicate key in object 'dbo.PriceLevel_Table'. The duplicate key value is (8079, 74, 1).
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:620)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:539)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:516)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:328)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at system.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:147)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1057)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
at system.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:109)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1057)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
at __138.__138.organogold_iact495.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../organogold-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:23)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1057)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
at __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:140)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1057)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
at shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:98)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1057)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2479)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2450)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:430)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:1309)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1854)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:829)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 145: <cfif IsDefined("REQUEST.UsePrice_4") and REQUEST.UsePrice_4 eq 1>, <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#PLVQuery.Price_4[plvIndex]#"></cfif><br>
146: )<br>
<b>147: </cfquery></b><br>
148: </cfif><br>
149: <cfset plvIndex = plvIndex + 1><br>
|
| | codePrintPlain | | string | 145: <cfif IsDefined("REQUEST.UsePrice_4") and REQUEST.UsePrice_4 eq 1>, <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#PLVQuery.Price_4[plvIndex]#"></cfif>
146: )
147: </cfquery>
148: </cfif>
149: <cfset plvIndex = plvIndex + 1>
|
| | column | | | id | | | line | | | Raw_Trace | | string | system.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:147) |
| | template | | string | /www/organogold-iact/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 107: <cfinclude template="#CallFile('act_CategoryLevels.cfm')#"><br>
108: <cfinclude template="#CallFile('act_GetAllByCategory.cfm')#"><br>
<b>109: <cfinclude template="#CallFile('act_CheckUpdatePriceLevels.cfm')#"><!---this code will update the price levels for 100 products at a time from the backend---></b><br>
110: <cfinclude template="#CallFile('dsp_GetAllByCategory.cfm')#"><br>
111: </cfif><br>
|
| | codePrintPlain | | string | 107: <cfinclude template="#CallFile('act_CategoryLevels.cfm')#">
108: <cfinclude template="#CallFile('act_GetAllByCategory.cfm')#">
109: <cfinclude template="#CallFile('act_CheckUpdatePriceLevels.cfm')#"><!---this code will update the price levels for 100 products at a time from the backend--->
110: <cfinclude template="#CallFile('dsp_GetAllByCategory.cfm')#">
111: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | system.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:109) |
| | template | | string | /www/organogold-iact/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 21: <cfset FuseSubAction="AllByCategory"><br>
22: <cfset FuseDirectory="Categories"><br>
<b>23: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#"></b><br>
24: </cfif><br>
25: <br>
|
| | codePrintPlain | | string | 21: <cfset FuseSubAction="AllByCategory">
22: <cfset FuseDirectory="Categories">
23: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#">
24: </cfif>
25:
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.__138.organogold_iact495.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../organogold-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:23) |
| | template | | string | /www/organogold-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 138: <!--- WF 95086 ---><br>
139: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679---><br>
<b>140: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#"></b><br>
141: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679---><br>
142: <cfsetting showdebugoutput="yes"><br>
|
| | codePrintPlain | | string | 138: <!--- 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 | | | id | | | line | | | Raw_Trace | | string | __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:140) |
| | template | | string | /www/organogold-iact/system/modules/ShoppingCart/fbx_Switch.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 96: <br>
97: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory---><br>
<b>98: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm"></b><br>
|
| | codePrintPlain | | string | 96:
97: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory--->
98: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:98) |
| | template | | string | /www/organogold-iact/wwwroot/ShoppingCart/index.cfm |
| | type | |
|
|
| type | |
| where | |
