Login



You are creating an order with Alternative Health Company
< CONTINUE SHOPPING

Added to Cart!

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume , Price4) VALUES (7958, 6, 1, 34.95, 0 , 0 )
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string13.00.5888
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringORGANOGOLD
DataSource
stringORGANOGOLD
Detail
stringViolation of PRIMARY KEY constraint 'PK_PriceLevel_Table'. Cannot insert duplicate key in object 'dbo.PriceLevel_Table'. The duplicate key value is (7958, 6, 1).
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number2627
queryError
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume , Price4) VALUES (7958, 6, 1, 34.95, 0 , 0 )
Sql
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume , Price4) VALUES (7958, 6, 1, 34.95, 0 , 0 )
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:147) 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:109) 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.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: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:122) 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:98) 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
string145: &lt;cfif IsDefined(&quot;REQUEST.UsePrice_4&quot;) and REQUEST.UsePrice_4 eq 1&gt;, &lt;cfqueryparam cfsqltype=&quot;CF_SQL_DECIMAL&quot; value=&quot;#PLVQuery.Price_4[plvIndex]#&quot;&gt;&lt;/cfif&gt;<br> 146: )<br> <b>147: &lt;/cfquery&gt;</b><br> 148: &lt;/cfif&gt;<br> 149: &lt;cfset plvIndex = plvIndex + 1&gt;<br>
codePrintPlain
string145: <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
number0
id
string??
line
number147
Raw_Trace
stringsystem.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
stringcfml
2
Struct
codePrintHTML
string107: &lt;cfinclude template=&quot;#CallFile('act_CategoryLevels.cfm')#&quot;&gt;<br> 108: &lt;cfinclude template=&quot;#CallFile('act_GetAllByCategory.cfm')#&quot;&gt;<br> <b>109: &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> 110: &lt;cfinclude template=&quot;#CallFile('dsp_GetAllByCategory.cfm')#&quot;&gt;<br> 111: &lt;/cfif&gt;<br>
codePrintPlain
string107: <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
number0
id
string??
line
number109
Raw_Trace
stringsystem.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
stringcfml
3
Struct
codePrintHTML
string21: &lt;cfset FuseSubAction=&quot;AllByCategory&quot;&gt;<br> 22: &lt;cfset FuseDirectory=&quot;Categories&quot;&gt;<br> <b>23: &lt;cfinclude template=&quot;#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#&quot;&gt;</b><br> 24: &lt;/cfif&gt;<br> 25: <br>
codePrintPlain
string21: <cfset FuseSubAction="AllByCategory"> 22: <cfset FuseDirectory="Categories"> 23: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#"> 24: </cfif> 25:
column
number0
id
string??
line
number23
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
stringcfml
4
Struct
codePrintHTML
string120: &lt;!--- WF 95086 ---&gt;<br> 121: &lt;cfinclude template=&quot;Actions/act_Header.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> <b>122: &lt;cfinclude template=&quot;#DisplayShopPath(&quot;dsp_CategoryShop.cfm&quot;)#&quot;&gt;</b><br> 123: &lt;cfinclude template=&quot;Actions/act_Footer.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> 124: &lt;cfsetting showdebugoutput=&quot;yes&quot;&gt;<br>
codePrintPlain
string120: <!--- WF 95086 ---> 121: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679---> 122: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#"> 123: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679---> 124: <cfsetting showdebugoutput="yes">
column
number0
id
string??
line
number122
Raw_Trace
string__138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:122)
template
string/www/organogold-iact/system/modules/ShoppingCart/fbx_Switch.cfm
type
stringcfml
5
Struct
codePrintHTML
string96: <br> 97: &lt;CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir&gt;&lt;!---reset new directory---&gt;<br> <b>98: &lt;CFINCLUDE Template=&quot;../../system/modules/ShoppingCart/fbx_Switch.cfm&quot;&gt;</b><br>
codePrintPlain
string96: 97: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory---> 98: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm">
column
number0
id
string??
line
number98
Raw_Trace
stringshoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:98)
template
string/www/organogold-iact/wwwroot/ShoppingCart/index.cfm
type
stringcfml
type
stringdatabase
where
string