Bρίσκεστε εδω
 Επιστροφή στο Μενού

PANCACES 344
Σφάλμα: System.Exception: SQL Error [GetMenuItemSizes]
Error=Incorrect syntax near 'S'. Unclosed quotation mark after the character string ', ') ProductName, p.BriefDescription, p.[Description], p.PromotionPaneId, p.ReadMoreLinkTitle, p.ReadMoreLinkURL, p.KeyWord, p.URL, p.IsActive, pbe.IsPrimary, pbe.IsOffer, pbe.OfferPrice, pbe.Featured, pbe.ReleaseDate, pbe.SaleStart, pbe.SaleEnd, pbe.CreatedDate, pbe.FreightCost1, pbe.FreightType1, pbe.FreightCost2, pbe.FreightType2, pbe.FreightCost3, pbe.FreightType3, pbe.Download, pbe.ArchivePassword, pbe.DownloadFile, pbe.UnitCost, pbe.UnitCost1, pbe.UnitCost2, pbe.UnitCost3, pbe.UnitCost4, pbe.UnitCost5, IsNULL(pbe.NotForSale,0) NotForSale, IsNULL(pbe.NotShownInList,0) NotShownInList, IsNULL(pbe.IsColorSelection,0) IsColorSelection, IsNULL(pbe.IsSizeSelection,0) IsSizeSelection, IsNULL(pbe.ParentProductId,-1) ParentProductId, pbe.BulkPriceLimit1, pbe.BulkPriceLimit2, pbe.BulkPriceLimit3, pbe.BulkPriceLimit4, pbe.BulkPriceLimit5, pbe.IsSuggested, pbe.IsPopular, pbe.Subscription, VatRate.Amount VatAmount, TotalVatAmount=pb.RetailPrice * VatRate.Amount/100, TotalPriceWithTax=pb.RetailPrice * VatRate.Amount/100 + pb.RetailPrice, isNULL(Manufacturer.Logo,') BrandLogo FROM ProductBase pb INNER JOIN Product p ON pb.ProductId = p.ProductId INNER JOIN Category ON pb.CategoryId = Category.CategoryId INNER JOIN ProductBaseExtension pbe ON pb.ProductId = pbe.ProductId LEFT OUTER JOIN Manufacturer ON pb.ManufacturerId = Manufacturer.ManufacturerId INNER JOIN VatRate ON pb.VatRateId=VatRate.VatRateId WHERE pbe.ParentProductId = @ProductId AND p.LangId = @LangId AND Category.LangId = @LangId AND pb.NotActive=0 AND p.IsActive=1 AND pbe.IsColorSelection = 1'.
at WebEdit.Modules.Product.WebDelivery.MenuItemList.ItemList_ItemDataBound(Object sender, RepeaterItemEventArgs e) at System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e) at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) at System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) at System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.Repeater.DataBind() at WebEdit.Modules.Product.WebDelivery.MenuItemList.MenuCategoriesList_ItemDataBound(Object sender, RepeaterItemEventArgs e) at System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e) at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) at System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) at System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.Repeater.DataBind() at WebEdit.Modules.Product.WebDelivery.MenuItemList.GetCategories() at WebEdit.Modules.Product.WebDelivery.MenuItemList.Page_Load(Object sender, EventArgs e)

Η παραγγελεία σας

Το καλάθι σας είναι άδειο