an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > DotShoppingCart Suite > Getting "The number of parameters does...
Last Post 2/4/2010 8:45:57 AM By lukezy. 2 replies.
2/1/2010 7:39:35 PM
paulp
Posts: 9
Joined: 11/3/2009
Location:Melb Aus
Getting "The number of parameters does not match number of values for stored procedure. " when adding/editing products?
Suddenly getting an error when I try to add or edit products
Getting "The number of parameters does not match number of values for stored procedure. " when adding/editing products?
 
 
try {
Line 50:                 productId = Product.Add(SiteNavigation.GetHost(), productBasic.ProductName, productBasic.SKU, productBasic.ShortDescription,
Line 51:                     Utils.ConvertNullableFromString<int?>(productBasic.Quantity),
Line 52:                     decimal.Parse(productBasic.Price), null, null, null, productBasic.ManufacturerId, null, 1, (int)ProductTypeEnum.General,
Source File: c:\DotShoppingCartSuiteV4.0.2\Web\Admin\Catalog\AddProductWizard.aspx.cs    Line: 50

Any quick fix?
 
Do I have to reinstall the db?
 
it should be 4.0.2 how to check?
 
Kind REgards
Paul
2/4/2010 4:19:30 AM
paulp
Posts: 9
Joined: 11/3/2009
Location:Melb Aus
Re: Getting &amp;quot;The number of parameters does not match number of values for stored procedure. &amp;quot; when adding/editing products?
Figured this out
 
Had to upgrade to sql server express 2008 with advanced services, and rerun the migration sql script...
 
Works fine now
2/4/2010 8:45:57 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Getting &amp;quot;The number of parameters does not match number of values for stored procedure. &amp;quot; when adding/editing products?
Yes, the v4 is using table variable as the store procedure parameters which are only supported in SQL server 2008.
DotShoppingCart Staff