|
Last Post 2/4/2010 2:58:23 PM By Bahram.
2 replies.
| 2/4/2010 2:47:11 PM |
|
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
|
Problem with Adding Volume Quantities to a Product
|
Server Error in '/' Application.
The number of parameters does not match number of values for stored procedure.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The number of parameters does not match number of values for stored procedure.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
<span class="Apple-style-span" style="font-family: monospace; white-space: pre; ">[InvalidOperationException: The number of parameters does not match number of values for stored procedure.]</span>
Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues) +191
DotShoppingCart.Commercial.Core.Product.Update(String host, Int32 productId, String productName, String sku, String shortDescription, Nullable`1 quantity, Decimal price, Nullable`1 retailPrice, Nullable`1 salePrice, Nullable`1 cost, Int32 manufacturerId, String manufacturerSKU, Int32 statusId, Int32 productTypeId, Int32 shipTypeId, Int32 shipEstimateId, Int32 taxTypeId, Nullable`1 weight, Nullable`1 weightMeasureId, Nullable`1 length, Nullable`1 height, Nullable`1 width, Nullable`1 dimensionMeasureId, Int32 sortOrder, Nullable`1 timeCreated, Nullable`1 showIfOutofStock, CategoryInformationCollection categories, ProductImageCollection images, ProductDescriptorCollection descriptors, ProductAttributeCollection attributes, Nullable`1 billingCycleId, Nullable`1 recurringCount, ProductCrossSellCollection crossSellProducts, ProductDownloadCollection productDownloads, String title, String keywords, String extraHeadData, List`1 customFields, Boolean disableDiscountGroupPricing, Nullable`1 restockLevel, RateUnit volumePricingRateUnit, ProductVolumePriceRateCollection volumePricing) +1271
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +261
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +488
System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method) +39
System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +1030
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +92
System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation) +835
System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +509
System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) +113
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
|
| 2/4/2010 2:51:20 PM |
|
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
|
Re: Problem with Adding Volume Quantities to a Product
|
|
Are you using SQL server 2008?
DotShoppingCart Staff
|
| 2/4/2010 2:58:23 PM |
|
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
|
Re: Problem with Adding Volume Quantities to a Product
|
|
No I am using 2005.
I had no problem on 2008 , but this is a copy of live database and it is 2005,
|
| |