uCommerce migration 1.2 to 1.3 / Product Catalog Node empty
umbraco : 4.6
Hi, I'm trying to migrate from uCommerce 1.2 to 1.3. After migration, when I try to browse 'Product Catalog' in the back-end, the folder (Product Catalog) doesn't shows any children nodes (nothing)
Note : The existing product catalog (in the DB) is not 'linked' to a specific domain name.
I can see the following error in the 'umbracoLog' table each time I try to browse "Product Catalog" Node Thanks for your help
Could not execute query[SQL: SQL not available] Void List(NHibernate.IQueryExpression, NHibernate.Engine.QueryParameters, System.Collections.IList) at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results) at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters) at NHibernate.Impl.ExpressionQueryImpl.List() at NHibernate.Linq.NhQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery) at NHibernate.Linq.NhQueryProvider.Execute(Expression expression) at NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression expression) at Remotion.Data.Linq.QueryableBase`1.GetEnumerator() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at UCommerce.EntitiesV2.ProductCatalogGroup.Find(Expression`1 expression) at UCommerce.Umbraco.Menu.LoadCatalog.RenderProductCatalogGroups(XmlTree& tree) at UCommerce.Umbraco.Menu.LoadCatalog.Render(XmlTree& tree)
Unable to cast object of type 'System.Boolean' to type 'System.String'. System.String ToString(System.Object) at NHibernate.Type.AbstractStringType.ToString(Object val) at NHibernate.Type.NullableType.ToLoggableString(Object value, ISessionFactoryImplementor factory) at NHibernate.Impl.Printer.ToString(IDictionary`2 namedTypedValues) at NHibernate.Engine.QueryParameters.LogParameters(ISessionFactoryImplementor factory) at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results) at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results)
I reran our migration from 1.2 => 1.3 to see if it would produce the behavior you're seeing, but I didn't see the behavior. I'm guessing that the issue might be related with your particular data. Could you get in touch with me at [email protected] so we can arrange a closer look at the issue?
I rare circumstances the underlying repositories will fail to parse LINQ queries properly. I've added a small fix to the existing uCommerce 1.3.0.1 to address the issue.
uCommerce migration 1.2 to 1.3 / Product Catalog Node empty
umbraco : 4.6
Hi,
I'm trying to migrate from uCommerce 1.2 to 1.3.
After migration, when I try to browse 'Product Catalog' in the back-end, the folder (Product Catalog) doesn't shows any children nodes (nothing)
Note : The existing product catalog (in the DB) is not 'linked' to a specific domain name.
I can see the following error in the 'umbracoLog' table each time I try to browse "Product Catalog" Node
Thanks for your help
Hi Blaise,
I reran our migration from 1.2 => 1.3 to see if it would produce the behavior you're seeing, but I didn't see the behavior. I'm guessing that the issue might be related with your particular data. Could you get in touch with me at [email protected] so we can arrange a closer look at the issue?
Thanks.
I rare circumstances the underlying repositories will fail to parse LINQ queries properly. I've added a small fix to the existing uCommerce 1.3.0.1 to address the issue.
is working on a reply...