uCommerce installed on a current v6 installation gives XSLT errors when the host name is set so i've had to set up a clean version of Umbraco to get it working. Kind of defeats the object!
uCommerce wont allow English-United Kingdom to be set, only US. So i cant apply display names
uCommerce gives an XSLT error: Error parsing XSLT file: \xslt\RootCategories[XSLT].xslt
when I try to change the hostname then change it back again.
And no the @displayName, @shortDescription and @longDescription won't display!
This is driving me insane! :-(
I'm happy to supply login information is someone would be kind enough to help me.
Hi Søren, In relation to last nights conversation. I set up uCommerce on a junior developers umbraco dev site. umbracodev.co.uk I set up the hostname for uCommerce as umbracodev.co.uk/shop
2013-03-07 09:18:08,653 [68] INFO NHibernate.Loader.Loader - select TOP (@p0) productcat0_.ProductCatalogGroupId as ProductC1_58_, productcat0_.Name as Name58_, productcat0_.Description as Descript3_58_, productcat0_.DomainId as DomainId58_, productcat0_.Deleted as Deleted58_, productcat0_.CreateCustomersAsUmbracoMembers as CreateCu6_58_, productcat0_.ProductReviewsRequireApproval as ProductR7_58_, productcat0_.MemberGroupId as MemberGr8_58_, productcat0_.MemberTypeId as MemberTy9_58_, productcat0_.OrderNumberId as OrderNu10_58_, productcat0_.CurrencyId as CurrencyId58_, productcat0_.EmailProfileId as EmailPr12_58_ from uCommerce_ProductCatalogGroup productcat0_ where (productcat0_.DomainId=@p1 or productcat0_.DomainId is null) and not (productcat0_.Deleted=1) 2013-03-07 09:18:08,832 [68] INFO umbraco.BusinessLogic.Log - [Thread 84] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: The uCommerce license file is either empty or missing. Void LoadLicense() at UCommerce.Licensing.LicensingService.LoadLicense() 2013-03-07 09:18:10,315 [68] WARN umbraco.macro - <log4net.Error>Exception during StringFormat: Input string was not in a correct format. <format>[Thread 83] Error parsing XSLT file. Exception: System.Xml.Xsl.XslTransformException: An error occurred during a call to extension function 'GetAllCatalogs'. See InnerException for a complete description of the error. ---> System.InvalidOperationException: No product catalog group supporting the url "http://test.umbracodev.co.uk:80/shop" found. at UCommerce.Runtime.CatalogContext.FindProductCatalogGroupForDomain() at UCommerce.Runtime.CatalogContext.get_CurrentCatalogGroup() at UCommerce.Xslt.ClientContext.get_CurrentProductCatalogGroup() at UCommerce.Extensions.ClientContextExtensions.AssertInProductCatalogGroupContext(IClientContext clientContext) at UCommerce.Catalog.CatalogLibraryInternal.GetCatalogs() at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalogs_callback() at Castle.Proxies.Invocations.CatalogLibraryInternal_GetCatalogs.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at UCommerce.Infrastructure.Interceptor.ExceptionLoggingInterceptor.Intercept(IInvocation invocation) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalogs() at UCommerce.Xslt.LibraryImpl.GetAllCatalogs() at UCommerce.Xslt.Library.GetAllCatalogs() --- End of inner exception stack trace --- at System.Xml.Xsl.Runtime.XmlExtensionFunction.Invoke(Object extObj, Object[] args) at System.Xml.Xsl.Runtime.XmlQueryContext.InvokeXsltLateBoundFunction(String name, String namespaceUri, IList`1[] args) at <xsl:template match="/">(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime) at Root(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime) at Execute(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime) at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlSequenceWriter results) at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter writer) at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, XmlWriter results, XmlResolver documentResolver) at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, TextWriter results) at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters) at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)</format><args>{}</args></log4net.Error> 2013-03-07 09:18:10,319 [68] INFO NHibernate.Loader.Loader - select purchaseor0_.OrderId as OrderId74_, purchaseor0_.BasketId as BasketId74_, purchaseor0_.OrderNumber as OrderNum3_74_, purchaseor0_.CultureCode as CultureC4_74_, purchaseor0_.CreatedDate as CreatedD5_74_, purchaseor0_.ModifiedOn as ModifiedOn74_, purchaseor0_.CompletedDate as Complete7_74_, purchaseor0_.Note as Note74_, purchaseor0_.VAT as VAT74_, purchaseor0_.OrderTotal as OrderTotal74_, purchaseor0_.Discount as Discount74_, purchaseor0_.DiscountTotal as Discoun12_74_, purchaseor0_.ShippingTotal as Shippin13_74_, purchaseor0_.PaymentTotal as Payment14_74_, purchaseor0_.TaxTotal as TaxTotal74_, purchaseor0_.SubTotal as SubTotal74_, purchaseor0_.OrderGuid as OrderGuid74_, purchaseor0_.CustomerId as CustomerId74_, purchaseor0_.OrderStatusId as OrderSt19_74_, purchaseor0_.CurrencyId as CurrencyId74_, purchaseor0_.ProductCatalogGroupId as Product21_74_, purchaseor0_.BillingAddressId as Billing22_74_ from uCommerce_PurchaseOrder purchaseor0_ where purchaseor0_.BasketId=@p0 2013-03-07 09:18:10,562 [68] INFO NHibernate.Loader.Loader - SELECT orderstatu0_.OrderStatusId as OrderSta1_46_0_, orderstatu0_.Name as Name46_0_, orderstatu0_.Sort as Sort46_0_, orderstatu0_.RenderChildren as RenderCh4_46_0_, orderstatu0_.RenderInMenu as RenderIn5_46_0_, orderstatu0_.ExternalId as ExternalId46_0_, orderstatu0_.IncludeInAuditTrail as IncludeI7_46_0_, orderstatu0_.[Order] as column8_46_0_, orderstatu0_.AllowUpdate as AllowUpd9_46_0_, orderstatu0_.AlwaysAvailable as AlwaysA10_46_0_, orderstatu0_.Pipeline as Pipeline46_0_, orderstatu0_.AllowOrderEdit as AllowOr12_46_0_, orderstatu0_.NextOrderStatusId as NextOrd13_46_0_ FROM uCommerce_OrderStatus orderstatu0_ WHERE orderstatu0_.OrderStatusId=@p0 2013-03-07 09:18:10,849 [68] INFO NHibernate.Loader.Loader - SELECT orderlines0_.OrderId as OrderId1_, orderlines0_.OrderLineId as OrderLin1_1_, orderlines0_.OrderLineId as OrderLin1_42_0_, orderlines0_.Sku as Sku42_0_, orderlines0_.ProductName as ProductN3_42_0_, orderlines0_.Price as Price42_0_, orderlines0_.Quantity as Quantity42_0_, orderlines0_.CreatedOn as CreatedOn42_0_, orderlines0_.Discount as Discount42_0_, orderlines0_.UnitDiscount as UnitDisc8_42_0_, orderlines0_.VAT as VAT42_0_, orderlines0_.Total as Total42_0_, orderlines0_.VATRate as VATRate42_0_, orderlines0_.VariantSku as VariantSku42_0_, orderlines0_.ShipmentId as ShipmentId42_0_, orderlines0_.OrderId as OrderId42_0_ FROM uCommerce_OrderLine orderlines0_ WHERE orderlines0_.OrderId=@p0 2013-03-07 09:18:10,874 [68] INFO NHibernate.Loader.Loader - SELECT currency0_.CurrencyId as CurrencyId21_0_, currency0_.ISOCode as ISOCode21_0_, currency0_.ExchangeRate as Exchange3_21_0_, currency0_.Deleted as Deleted21_0_ FROM uCommerce_Currency currency0_ WHERE currency0_.CurrencyId=@p0 2013-03-07 09:18:10,885 [68] INFO NHibernate.Loader.Loader - SELECT orderprope0_.OrderId as OrderId1_, orderprope0_.OrderPropertyId as OrderPro1_1_, orderprope0_.OrderPropertyId as OrderPro1_44_0_, orderprope0_.[key] as column2_44_0_, orderprope0_.Value as Value44_0_, orderprope0_.OrderId as OrderId44_0_, orderprope0_.OrderLineId as OrderLin5_44_0_ FROM uCommerce_OrderProperty orderprope0_ WHERE (orderprope0_.OrderLineId is null) and orderprope0_.OrderId=@p0 2013-03-07 09:18:10,926 [68] INFO NHibernate.Loader.Loader - SELECT orderprope0_.OrderLineId as OrderLin5_1_, orderprope0_.OrderPropertyId as OrderPro1_1_, orderprope0_.OrderPropertyId as OrderPro1_44_0_, orderprope0_.[key] as column2_44_0_, orderprope0_.Value as Value44_0_, orderprope0_.OrderId as OrderId44_0_, orderprope0_.OrderLineId as OrderLin5_44_0_ FROM uCommerce_OrderProperty orderprope0_ WHERE (orderprope0_.OrderId is not null) and orderprope0_.OrderLineId=@p0 2013-03-07 09:18:10,930 [68] INFO NHibernate.Loader.Loader - select orderline0_.OrderLineId as OrderLin1_42_, orderline0_.Sku as Sku42_, orderline0_.ProductName as ProductN3_42_, orderline0_.Price as Price42_, orderline0_.Quantity as Quantity42_, orderline0_.CreatedOn as CreatedOn42_, orderline0_.Discount as Discount42_, orderline0_.UnitDiscount as UnitDisc8_42_, orderline0_.VAT as VAT42_, orderline0_.Total as Total42_, orderline0_.VATRate as VATRate42_, orderline0_.VariantSku as VariantSku42_, orderline0_.ShipmentId as ShipmentId42_, orderline0_.OrderId as OrderId42_ from uCommerce_OrderLine orderline0_ where orderline0_.OrderLineId=@p0 2013-03-07 09:18:10,932 [68] INFO NHibernate.Loader.Loader - SELECT discounts0_.OrderLineId as OrderLin2_1_, discounts0_.DiscountId as DiscountId1_, discount1_.DiscountId as DiscountId31_0_, discount1_.CampaignName as Campaign2_31_0_, discount1_.CampaignItemName as Campaign3_31_0_, discount1_.Description as Descript4_31_0_, discount1_.AmountOffTotal as AmountOf5_31_0_, discount1_.CreatedOn as CreatedOn31_0_, discount1_.ModifiedOn as ModifiedOn31_0_, discount1_.CreatedBy as CreatedBy31_0_, discount1_.ModifiedBy as ModifiedBy31_0_, discount1_.OrderId as OrderId31_0_ FROM uCommerce_OrderLineDiscountRelation discounts0_ left outer join uCommerce_Discount discount1_ on discounts0_.DiscountId=discount1_.DiscountId WHERE discounts0_.OrderLineId=@p0 2013-03-07 09:18:10,983 [68] INFO NHibernate.Loader.Loader - select purchaseor0_.OrderId as OrderId74_, purchaseor0_.BasketId as BasketId74_, purchaseor0_.OrderNumber as OrderNum3_74_, purchaseor0_.CultureCode as CultureC4_74_, purchaseor0_.CreatedDate as CreatedD5_74_, purchaseor0_.ModifiedOn as ModifiedOn74_, purchaseor0_.CompletedDate as Complete7_74_, purchaseor0_.Note as Note74_, purchaseor0_.VAT as VAT74_, purchaseor0_.OrderTotal as OrderTotal74_, purchaseor0_.Discount as Discount74_, purchaseor0_.DiscountTotal as Discoun12_74_, purchaseor0_.ShippingTotal as Shippin13_74_, purchaseor0_.PaymentTotal as Payment14_74_, purchaseor0_.TaxTotal as TaxTotal74_, purchaseor0_.SubTotal as SubTotal74_, purchaseor0_.OrderGuid as OrderGuid74_, purchaseor0_.CustomerId as CustomerId74_, purchaseor0_.OrderStatusId as OrderSt19_74_, purchaseor0_.CurrencyId as CurrencyId74_, purchaseor0_.ProductCatalogGroupId as Product21_74_, purchaseor0_.BillingAddressId as Billing22_74_ from uCommerce_PurchaseOrder purchaseor0_ where purchaseor0_.OrderId=@p0 2013-03-07 09:18:11,005 [68] INFO NHibernate.Loader.Loader - SELECT discounts0_.OrderId as OrderId1_, discounts0_.DiscountId as DiscountId1_, discounts0_.DiscountId as DiscountId31_0_, discounts0_.CampaignName as Campaign2_31_0_, discounts0_.CampaignItemName as Campaign3_31_0_, discounts0_.Description as Descript4_31_0_, discounts0_.AmountOffTotal as AmountOf5_31_0_, discounts0_.CreatedOn as CreatedOn31_0_, discounts0_.ModifiedOn as ModifiedOn31_0_, discounts0_.CreatedBy as CreatedBy31_0_, discounts0_.ModifiedBy as ModifiedBy31_0_, discounts0_.OrderId as OrderId31_0_ FROM uCommerce_Discount discounts0_ WHERE discounts0_.OrderId=@p0 2013-03-07 09:18:11,007 [68] INFO NHibernate.Loader.Loader - SELECT orderlines0_.DiscountId as DiscountId1_, orderlines0_.OrderLineId as OrderLin2_1_, orderline1_.OrderLineId as OrderLin1_42_0_, orderline1_.Sku as Sku42_0_, orderline1_.ProductName as ProductN3_42_0_, orderline1_.Price as Price42_0_, orderline1_.Quantity as Quantity42_0_, orderline1_.CreatedOn as CreatedOn42_0_, orderline1_.Discount as Discount42_0_, orderline1_.UnitDiscount as UnitDisc8_42_0_, orderline1_.VAT as VAT42_0_, orderline1_.Total as Total42_0_, orderline1_.VATRate as VATRate42_0_, orderline1_.VariantSku as VariantSku42_0_, orderline1_.ShipmentId as ShipmentId42_0_, orderline1_.OrderId as OrderId42_0_ FROM uCommerce_OrderLineDiscountRelation orderlines0_ left outer join uCommerce_OrderLine orderline1_ on orderlines0_.OrderLineId=orderline1_.OrderLineId WHERE orderlines0_.DiscountId in (@p0, @p1) 2013-03-07 09:18:11,014 [68] INFO NHibernate.Loader.Loader - SELECT shipments0_.OrderId as OrderId1_, shipments0_.ShipmentId as ShipmentId1_, shipments0_.ShipmentId as ShipmentId77_0_, shipments0_.ShipmentName as Shipment2_77_0_, shipments0_.CreatedOn as CreatedOn77_0_, shipments0_.CreatedBy as CreatedBy77_0_, shipments0_.ShipmentPrice as Shipment5_77_0_, shipments0_.DeliveryNote as Delivery6_77_0_, shipments0_.TrackAndTrace as TrackAnd7_77_0_, shipments0_.Tax as Tax77_0_, shipments0_.TaxRate as TaxRate77_0_, shipments0_.ShipmentTotal as Shipmen10_77_0_, shipments0_.ShipmentDiscount as Shipmen11_77_0_, shipments0_.ShipmentAddressId as Shipmen12_77_0_, shipments0_.ShippingMethodId as Shippin13_77_0_, shipments0_.OrderId as OrderId77_0_ FROM uCommerce_Shipment shipments0_ WHERE shipments0_.OrderId=@p0 2013-03-07 09:18:11,306 [68] INFO NHibernate.Loader.Loader - SELECT payments0_.OrderId as OrderId1_, payments0_.PaymentId as PaymentId1_, payments0_.PaymentId as PaymentId47_0_, payments0_.TransactionId as Transact2_47_0_, payments0_.PaymentMethodName as PaymentM3_47_0_, payments0_.Created as Created47_0_, payments0_.Fee as Fee47_0_, payments0_.FeeTotal as FeeTotal47_0_, payments0_.FeePercentage as FeePerce7_47_0_, payments0_.Amount as Amount47_0_, payments0_.ReferenceId as Referenc9_47_0_, payments0_.PaymentMethodId as Payment10_47_0_, payments0_.PaymentStatusId as Payment11_47_0_, payments0_.OrderId as OrderId47_0_ FROM uCommerce_Payment payments0_ WHERE payments0_.OrderId=@p0 2013-03-07 09:18:11,352 [68] INFO NHibernate.Loader.Loader - select TOP (@p0) productcat0_.ProductCatalogGroupId as ProductC1_58_, productcat0_.Name as Name58_, productcat0_.Description as Descript3_58_, productcat0_.DomainId as DomainId58_, productcat0_.Deleted as Deleted58_, productcat0_.CreateCustomersAsUmbracoMembers as CreateCu6_58_, productcat0_.ProductReviewsRequireApproval as ProductR7_58_, productcat0_.MemberGroupId as MemberGr8_58_, productcat0_.MemberTypeId as MemberTy9_58_, productcat0_.OrderNumberId as OrderNu10_58_, productcat0_.CurrencyId as CurrencyId58_, productcat0_.EmailProfileId as EmailPr12_58_ from uCommerce_ProductCatalogGroup productcat0_ where (productcat0_.DomainId=@p1 or productcat0_.DomainId is null) and not (productcat0_.Deleted=1) 2013-03-07 09:18:11,375 [68] WARN umbraco.macro - <log4net.Error>Exception during StringFormat: Input string was not in a correct format. <format>[Thread 83] Error parsing XSLT file. Exception: System.Xml.Xsl.XslTransformException: An error occurred during a call to extension function 'GetRootCategories'. See InnerException for a complete description of the error. ---> System.InvalidOperationException: No product catalog group supporting the url "http://test.umbracodev.co.uk:80/shop" found. at UCommerce.Runtime.CatalogContext.FindProductCatalogGroupForDomain() at UCommerce.Runtime.CatalogContext.get_CurrentCatalogGroup() at UCommerce.Xslt.ClientContext.get_CurrentProductCatalogGroup() at UCommerce.Extensions.ClientContextExtensions.AssertInProductCatalogGroupContext(IClientContext clientContext) at UCommerce.Catalog.CatalogLibraryInternal.GetCatalog(String catalogName) at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalog_callback_1(String catalogName) at Castle.Proxies.Invocations.CatalogLibraryInternal_GetCatalog_1.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at UCommerce.Infrastructure.Interceptor.ExceptionLoggingInterceptor.Intercept(IInvocation invocation) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalog(String catalogName) at Castle.Proxies.CatalogLibraryInternalProxy.GetRootCategories_callback_1(String catalogName) at Castle.Proxies.Invocations.CatalogLibraryInternal_GetRootCategories_1.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at UCommerce.Infrastructure.Interceptor.ExceptionLoggingInterceptor.Intercept(IInvocation invocation) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.CatalogLibraryInternalProxy.GetRootCategories(String catalogName) at UCommerce.Xslt.LibraryImpl.GetRootCategories(String catalogName, Boolean includeFullCategoryStructure) at UCommerce.Xslt.LibraryImpl.GetRootCategories(String catalogName) at UCommerce.Xslt.Library.GetRootCategories(String catalogName) --- End of inner exception stack trace --- at System.Xml.Xsl.Runtime.XmlExtensionFunction.Invoke(Object extObj, Object[] args) at System.Xml.Xsl.Runtime.XmlQueryContext.InvokeXsltLateBoundFunction(String name, String namespaceUri, IList`1[] args) at <xsl:template match="/">(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime) at Root(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime) at Execute(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime) at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlSequenceWriter results) at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter writer) at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, XmlWriter results, XmlResolver documentResolver) at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, TextWriter results) at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters) at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)</format><args>{}</args></log4net.Error>
All sorts of problems!
Can anyone help here please.
uCommerce installed on a current v6 installation gives XSLT errors when the host name is set so i've had to set up a clean version of Umbraco to get it working. Kind of defeats the object!
uCommerce wont allow English-United Kingdom to be set, only US. So i cant apply display names
uCommerce gives an XSLT error: Error parsing XSLT file: \xslt\RootCategories[XSLT].xslt
when I try to change the hostname then change it back again.
Hi Roger,
uCommerce will log info to the Umbraco log file. Could you take a look at that and let me if there's any useful hints in there?
Log file is in /app_data/logs/UmbracoTraceLog.txt
Thanks.
Hi Søren,
In relation to last nights conversation. I set up uCommerce on a junior developers umbraco dev site. umbracodev.co.uk
I set up the hostname for uCommerce as umbracodev.co.uk/shop
I have 2 errors on the main shop page:
Error parsing XSLT file: \xslt\AllCatalogs[XSLT].xslt
The shop is set up as the standard demo shop that comes with uCommerce. The UrlRewriting entries are listed below
<add name="DefaultCategoryProductRewrite" virtualUrl="(.*)/c-([0-9]+)/c-([0-9]+)/p-([0-9]+)" rewriteUrlParameter="ExcludeFromClientQueryString" destinationUrl="~/shop/product.aspx?catalog=$2&category=$3&product=$4" ignoreCase="true" xmlns="" />
<add name="DefaultProductRewrite" virtualUrl="(.*)/c-([0-9]+)/p-([0-9]+)" rewriteUrlParameter="ExcludeFromClientQueryString" destinationUrl="~/shop/product.aspx?catalog=$2&product=$3" ignoreCase="true" xmlns="" />
<add name="DefaultCategoryRewrite" virtualUrl="(.*)/c-([0-9]+)/c-([0-9]+)" rewriteUrlParameter="ExcludeFromClientQueryString" destinationUrl="~/shop/catalog.aspx?catalog=$2&category=$3" ignoreCase="true" xmlns="" />
<add name="DefaultCatalogRewrite" virtualUrl="(.*)/c-([0-9]+)" rewriteUrlParameter="ExcludeFromClientQueryString" destinationUrl="~/shop/catalog.aspx?catalog=$2" ignoreCase="true" xmlns="" />
Here is the trace log:
2013-03-07 09:18:08,653 [68] INFO NHibernate.Loader.Loader - select TOP (@p0) productcat0_.ProductCatalogGroupId as ProductC1_58_, productcat0_.Name as Name58_, productcat0_.Description as Descript3_58_, productcat0_.DomainId as DomainId58_, productcat0_.Deleted as Deleted58_, productcat0_.CreateCustomersAsUmbracoMembers as CreateCu6_58_, productcat0_.ProductReviewsRequireApproval as ProductR7_58_, productcat0_.MemberGroupId as MemberGr8_58_, productcat0_.MemberTypeId as MemberTy9_58_, productcat0_.OrderNumberId as OrderNu10_58_, productcat0_.CurrencyId as CurrencyId58_, productcat0_.EmailProfileId as EmailPr12_58_ from uCommerce_ProductCatalogGroup productcat0_ where (productcat0_.DomainId=@p1 or productcat0_.DomainId is null) and not (productcat0_.Deleted=1)
2013-03-07 09:18:08,832 [68] INFO umbraco.BusinessLogic.Log - [Thread 84] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: The uCommerce license file is either empty or missing.
Void LoadLicense()
at UCommerce.Licensing.LicensingService.LoadLicense()
2013-03-07 09:18:10,315 [68] WARN umbraco.macro - <log4net.Error>Exception during StringFormat: Input string was not in a correct format. <format>[Thread 83] Error parsing XSLT file. Exception: System.Xml.Xsl.XslTransformException: An error occurred during a call to extension function 'GetAllCatalogs'. See InnerException for a complete description of the error. ---> System.InvalidOperationException: No product catalog group supporting the url "http://test.umbracodev.co.uk:80/shop" found.
at UCommerce.Runtime.CatalogContext.FindProductCatalogGroupForDomain()
at UCommerce.Runtime.CatalogContext.get_CurrentCatalogGroup()
at UCommerce.Xslt.ClientContext.get_CurrentProductCatalogGroup()
at UCommerce.Extensions.ClientContextExtensions.AssertInProductCatalogGroupContext(IClientContext clientContext)
at UCommerce.Catalog.CatalogLibraryInternal.GetCatalogs()
at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalogs_callback()
at Castle.Proxies.Invocations.CatalogLibraryInternal_GetCatalogs.InvokeMethodOnTarget()
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at UCommerce.Infrastructure.Interceptor.ExceptionLoggingInterceptor.Intercept(IInvocation invocation)
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalogs()
at UCommerce.Xslt.LibraryImpl.GetAllCatalogs()
at UCommerce.Xslt.Library.GetAllCatalogs()
--- End of inner exception stack trace ---
at System.Xml.Xsl.Runtime.XmlExtensionFunction.Invoke(Object extObj, Object[] args)
at System.Xml.Xsl.Runtime.XmlQueryContext.InvokeXsltLateBoundFunction(String name, String namespaceUri, IList`1[] args)
at <xsl:template match="/">(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime)
at Root(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime)
at Execute(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime)
at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlSequenceWriter results)
at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter writer)
at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, XmlWriter results, XmlResolver documentResolver)
at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, TextWriter results)
at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters)
at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)</format><args>{}</args></log4net.Error>
2013-03-07 09:18:10,319 [68] INFO NHibernate.Loader.Loader - select purchaseor0_.OrderId as OrderId74_, purchaseor0_.BasketId as BasketId74_, purchaseor0_.OrderNumber as OrderNum3_74_, purchaseor0_.CultureCode as CultureC4_74_, purchaseor0_.CreatedDate as CreatedD5_74_, purchaseor0_.ModifiedOn as ModifiedOn74_, purchaseor0_.CompletedDate as Complete7_74_, purchaseor0_.Note as Note74_, purchaseor0_.VAT as VAT74_, purchaseor0_.OrderTotal as OrderTotal74_, purchaseor0_.Discount as Discount74_, purchaseor0_.DiscountTotal as Discoun12_74_, purchaseor0_.ShippingTotal as Shippin13_74_, purchaseor0_.PaymentTotal as Payment14_74_, purchaseor0_.TaxTotal as TaxTotal74_, purchaseor0_.SubTotal as SubTotal74_, purchaseor0_.OrderGuid as OrderGuid74_, purchaseor0_.CustomerId as CustomerId74_, purchaseor0_.OrderStatusId as OrderSt19_74_, purchaseor0_.CurrencyId as CurrencyId74_, purchaseor0_.ProductCatalogGroupId as Product21_74_, purchaseor0_.BillingAddressId as Billing22_74_ from uCommerce_PurchaseOrder purchaseor0_ where purchaseor0_.BasketId=@p0
2013-03-07 09:18:10,562 [68] INFO NHibernate.Loader.Loader - SELECT orderstatu0_.OrderStatusId as OrderSta1_46_0_, orderstatu0_.Name as Name46_0_, orderstatu0_.Sort as Sort46_0_, orderstatu0_.RenderChildren as RenderCh4_46_0_, orderstatu0_.RenderInMenu as RenderIn5_46_0_, orderstatu0_.ExternalId as ExternalId46_0_, orderstatu0_.IncludeInAuditTrail as IncludeI7_46_0_, orderstatu0_.[Order] as column8_46_0_, orderstatu0_.AllowUpdate as AllowUpd9_46_0_, orderstatu0_.AlwaysAvailable as AlwaysA10_46_0_, orderstatu0_.Pipeline as Pipeline46_0_, orderstatu0_.AllowOrderEdit as AllowOr12_46_0_, orderstatu0_.NextOrderStatusId as NextOrd13_46_0_ FROM uCommerce_OrderStatus orderstatu0_ WHERE orderstatu0_.OrderStatusId=@p0
2013-03-07 09:18:10,849 [68] INFO NHibernate.Loader.Loader - SELECT orderlines0_.OrderId as OrderId1_, orderlines0_.OrderLineId as OrderLin1_1_, orderlines0_.OrderLineId as OrderLin1_42_0_, orderlines0_.Sku as Sku42_0_, orderlines0_.ProductName as ProductN3_42_0_, orderlines0_.Price as Price42_0_, orderlines0_.Quantity as Quantity42_0_, orderlines0_.CreatedOn as CreatedOn42_0_, orderlines0_.Discount as Discount42_0_, orderlines0_.UnitDiscount as UnitDisc8_42_0_, orderlines0_.VAT as VAT42_0_, orderlines0_.Total as Total42_0_, orderlines0_.VATRate as VATRate42_0_, orderlines0_.VariantSku as VariantSku42_0_, orderlines0_.ShipmentId as ShipmentId42_0_, orderlines0_.OrderId as OrderId42_0_ FROM uCommerce_OrderLine orderlines0_ WHERE orderlines0_.OrderId=@p0
2013-03-07 09:18:10,874 [68] INFO NHibernate.Loader.Loader - SELECT currency0_.CurrencyId as CurrencyId21_0_, currency0_.ISOCode as ISOCode21_0_, currency0_.ExchangeRate as Exchange3_21_0_, currency0_.Deleted as Deleted21_0_ FROM uCommerce_Currency currency0_ WHERE currency0_.CurrencyId=@p0
2013-03-07 09:18:10,885 [68] INFO NHibernate.Loader.Loader - SELECT orderprope0_.OrderId as OrderId1_, orderprope0_.OrderPropertyId as OrderPro1_1_, orderprope0_.OrderPropertyId as OrderPro1_44_0_, orderprope0_.[key] as column2_44_0_, orderprope0_.Value as Value44_0_, orderprope0_.OrderId as OrderId44_0_, orderprope0_.OrderLineId as OrderLin5_44_0_ FROM uCommerce_OrderProperty orderprope0_ WHERE (orderprope0_.OrderLineId is null) and orderprope0_.OrderId=@p0
2013-03-07 09:18:10,926 [68] INFO NHibernate.Loader.Loader - SELECT orderprope0_.OrderLineId as OrderLin5_1_, orderprope0_.OrderPropertyId as OrderPro1_1_, orderprope0_.OrderPropertyId as OrderPro1_44_0_, orderprope0_.[key] as column2_44_0_, orderprope0_.Value as Value44_0_, orderprope0_.OrderId as OrderId44_0_, orderprope0_.OrderLineId as OrderLin5_44_0_ FROM uCommerce_OrderProperty orderprope0_ WHERE (orderprope0_.OrderId is not null) and orderprope0_.OrderLineId=@p0
2013-03-07 09:18:10,930 [68] INFO NHibernate.Loader.Loader - select orderline0_.OrderLineId as OrderLin1_42_, orderline0_.Sku as Sku42_, orderline0_.ProductName as ProductN3_42_, orderline0_.Price as Price42_, orderline0_.Quantity as Quantity42_, orderline0_.CreatedOn as CreatedOn42_, orderline0_.Discount as Discount42_, orderline0_.UnitDiscount as UnitDisc8_42_, orderline0_.VAT as VAT42_, orderline0_.Total as Total42_, orderline0_.VATRate as VATRate42_, orderline0_.VariantSku as VariantSku42_, orderline0_.ShipmentId as ShipmentId42_, orderline0_.OrderId as OrderId42_ from uCommerce_OrderLine orderline0_ where orderline0_.OrderLineId=@p0
2013-03-07 09:18:10,932 [68] INFO NHibernate.Loader.Loader - SELECT discounts0_.OrderLineId as OrderLin2_1_, discounts0_.DiscountId as DiscountId1_, discount1_.DiscountId as DiscountId31_0_, discount1_.CampaignName as Campaign2_31_0_, discount1_.CampaignItemName as Campaign3_31_0_, discount1_.Description as Descript4_31_0_, discount1_.AmountOffTotal as AmountOf5_31_0_, discount1_.CreatedOn as CreatedOn31_0_, discount1_.ModifiedOn as ModifiedOn31_0_, discount1_.CreatedBy as CreatedBy31_0_, discount1_.ModifiedBy as ModifiedBy31_0_, discount1_.OrderId as OrderId31_0_ FROM uCommerce_OrderLineDiscountRelation discounts0_ left outer join uCommerce_Discount discount1_ on discounts0_.DiscountId=discount1_.DiscountId WHERE discounts0_.OrderLineId=@p0
2013-03-07 09:18:10,983 [68] INFO NHibernate.Loader.Loader - select purchaseor0_.OrderId as OrderId74_, purchaseor0_.BasketId as BasketId74_, purchaseor0_.OrderNumber as OrderNum3_74_, purchaseor0_.CultureCode as CultureC4_74_, purchaseor0_.CreatedDate as CreatedD5_74_, purchaseor0_.ModifiedOn as ModifiedOn74_, purchaseor0_.CompletedDate as Complete7_74_, purchaseor0_.Note as Note74_, purchaseor0_.VAT as VAT74_, purchaseor0_.OrderTotal as OrderTotal74_, purchaseor0_.Discount as Discount74_, purchaseor0_.DiscountTotal as Discoun12_74_, purchaseor0_.ShippingTotal as Shippin13_74_, purchaseor0_.PaymentTotal as Payment14_74_, purchaseor0_.TaxTotal as TaxTotal74_, purchaseor0_.SubTotal as SubTotal74_, purchaseor0_.OrderGuid as OrderGuid74_, purchaseor0_.CustomerId as CustomerId74_, purchaseor0_.OrderStatusId as OrderSt19_74_, purchaseor0_.CurrencyId as CurrencyId74_, purchaseor0_.ProductCatalogGroupId as Product21_74_, purchaseor0_.BillingAddressId as Billing22_74_ from uCommerce_PurchaseOrder purchaseor0_ where purchaseor0_.OrderId=@p0
2013-03-07 09:18:11,005 [68] INFO NHibernate.Loader.Loader - SELECT discounts0_.OrderId as OrderId1_, discounts0_.DiscountId as DiscountId1_, discounts0_.DiscountId as DiscountId31_0_, discounts0_.CampaignName as Campaign2_31_0_, discounts0_.CampaignItemName as Campaign3_31_0_, discounts0_.Description as Descript4_31_0_, discounts0_.AmountOffTotal as AmountOf5_31_0_, discounts0_.CreatedOn as CreatedOn31_0_, discounts0_.ModifiedOn as ModifiedOn31_0_, discounts0_.CreatedBy as CreatedBy31_0_, discounts0_.ModifiedBy as ModifiedBy31_0_, discounts0_.OrderId as OrderId31_0_ FROM uCommerce_Discount discounts0_ WHERE discounts0_.OrderId=@p0
2013-03-07 09:18:11,007 [68] INFO NHibernate.Loader.Loader - SELECT orderlines0_.DiscountId as DiscountId1_, orderlines0_.OrderLineId as OrderLin2_1_, orderline1_.OrderLineId as OrderLin1_42_0_, orderline1_.Sku as Sku42_0_, orderline1_.ProductName as ProductN3_42_0_, orderline1_.Price as Price42_0_, orderline1_.Quantity as Quantity42_0_, orderline1_.CreatedOn as CreatedOn42_0_, orderline1_.Discount as Discount42_0_, orderline1_.UnitDiscount as UnitDisc8_42_0_, orderline1_.VAT as VAT42_0_, orderline1_.Total as Total42_0_, orderline1_.VATRate as VATRate42_0_, orderline1_.VariantSku as VariantSku42_0_, orderline1_.ShipmentId as ShipmentId42_0_, orderline1_.OrderId as OrderId42_0_ FROM uCommerce_OrderLineDiscountRelation orderlines0_ left outer join uCommerce_OrderLine orderline1_ on orderlines0_.OrderLineId=orderline1_.OrderLineId WHERE orderlines0_.DiscountId in (@p0, @p1)
2013-03-07 09:18:11,014 [68] INFO NHibernate.Loader.Loader - SELECT shipments0_.OrderId as OrderId1_, shipments0_.ShipmentId as ShipmentId1_, shipments0_.ShipmentId as ShipmentId77_0_, shipments0_.ShipmentName as Shipment2_77_0_, shipments0_.CreatedOn as CreatedOn77_0_, shipments0_.CreatedBy as CreatedBy77_0_, shipments0_.ShipmentPrice as Shipment5_77_0_, shipments0_.DeliveryNote as Delivery6_77_0_, shipments0_.TrackAndTrace as TrackAnd7_77_0_, shipments0_.Tax as Tax77_0_, shipments0_.TaxRate as TaxRate77_0_, shipments0_.ShipmentTotal as Shipmen10_77_0_, shipments0_.ShipmentDiscount as Shipmen11_77_0_, shipments0_.ShipmentAddressId as Shipmen12_77_0_, shipments0_.ShippingMethodId as Shippin13_77_0_, shipments0_.OrderId as OrderId77_0_ FROM uCommerce_Shipment shipments0_ WHERE shipments0_.OrderId=@p0
2013-03-07 09:18:11,306 [68] INFO NHibernate.Loader.Loader - SELECT payments0_.OrderId as OrderId1_, payments0_.PaymentId as PaymentId1_, payments0_.PaymentId as PaymentId47_0_, payments0_.TransactionId as Transact2_47_0_, payments0_.PaymentMethodName as PaymentM3_47_0_, payments0_.Created as Created47_0_, payments0_.Fee as Fee47_0_, payments0_.FeeTotal as FeeTotal47_0_, payments0_.FeePercentage as FeePerce7_47_0_, payments0_.Amount as Amount47_0_, payments0_.ReferenceId as Referenc9_47_0_, payments0_.PaymentMethodId as Payment10_47_0_, payments0_.PaymentStatusId as Payment11_47_0_, payments0_.OrderId as OrderId47_0_ FROM uCommerce_Payment payments0_ WHERE payments0_.OrderId=@p0
2013-03-07 09:18:11,352 [68] INFO NHibernate.Loader.Loader - select TOP (@p0) productcat0_.ProductCatalogGroupId as ProductC1_58_, productcat0_.Name as Name58_, productcat0_.Description as Descript3_58_, productcat0_.DomainId as DomainId58_, productcat0_.Deleted as Deleted58_, productcat0_.CreateCustomersAsUmbracoMembers as CreateCu6_58_, productcat0_.ProductReviewsRequireApproval as ProductR7_58_, productcat0_.MemberGroupId as MemberGr8_58_, productcat0_.MemberTypeId as MemberTy9_58_, productcat0_.OrderNumberId as OrderNu10_58_, productcat0_.CurrencyId as CurrencyId58_, productcat0_.EmailProfileId as EmailPr12_58_ from uCommerce_ProductCatalogGroup productcat0_ where (productcat0_.DomainId=@p1 or productcat0_.DomainId is null) and not (productcat0_.Deleted=1)
2013-03-07 09:18:11,375 [68] WARN umbraco.macro - <log4net.Error>Exception during StringFormat: Input string was not in a correct format. <format>[Thread 83] Error parsing XSLT file. Exception: System.Xml.Xsl.XslTransformException: An error occurred during a call to extension function 'GetRootCategories'. See InnerException for a complete description of the error. ---> System.InvalidOperationException: No product catalog group supporting the url "http://test.umbracodev.co.uk:80/shop" found.
at UCommerce.Runtime.CatalogContext.FindProductCatalogGroupForDomain()
at UCommerce.Runtime.CatalogContext.get_CurrentCatalogGroup()
at UCommerce.Xslt.ClientContext.get_CurrentProductCatalogGroup()
at UCommerce.Extensions.ClientContextExtensions.AssertInProductCatalogGroupContext(IClientContext clientContext)
at UCommerce.Catalog.CatalogLibraryInternal.GetCatalog(String catalogName)
at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalog_callback_1(String catalogName)
at Castle.Proxies.Invocations.CatalogLibraryInternal_GetCatalog_1.InvokeMethodOnTarget()
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at UCommerce.Infrastructure.Interceptor.ExceptionLoggingInterceptor.Intercept(IInvocation invocation)
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at Castle.Proxies.CatalogLibraryInternalProxy.GetCatalog(String catalogName)
at Castle.Proxies.CatalogLibraryInternalProxy.GetRootCategories_callback_1(String catalogName)
at Castle.Proxies.Invocations.CatalogLibraryInternal_GetRootCategories_1.InvokeMethodOnTarget()
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at UCommerce.Infrastructure.Interceptor.ExceptionLoggingInterceptor.Intercept(IInvocation invocation)
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at Castle.Proxies.CatalogLibraryInternalProxy.GetRootCategories(String catalogName)
at UCommerce.Xslt.LibraryImpl.GetRootCategories(String catalogName, Boolean includeFullCategoryStructure)
at UCommerce.Xslt.LibraryImpl.GetRootCategories(String catalogName)
at UCommerce.Xslt.Library.GetRootCategories(String catalogName)
--- End of inner exception stack trace ---
at System.Xml.Xsl.Runtime.XmlExtensionFunction.Invoke(Object extObj, Object[] args)
at System.Xml.Xsl.Runtime.XmlQueryContext.InvokeXsltLateBoundFunction(String name, String namespaceUri, IList`1[] args)
at <xsl:template match="/">(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime)
at Root(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime)
at Execute(XmlQueryRuntime {urn:schemas-microsoft-com:xslt-debug}runtime)
at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlSequenceWriter results)
at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter writer)
at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, XmlWriter results, XmlResolver documentResolver)
at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, TextWriter results)
at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters)
at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)</format><args>{}</args></log4net.Error>
However, the basket XSLT on the right isn't showing an error this time but it was when I first installed it.
Thanks
Roger
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.