Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Badzi 7 posts 27 karma points
    Jan 20, 2011 @ 10:37
    Badzi
    0

    uCommerce migration 1.2 to 1.3 / Product Catalog Node empty

    uCommerce Support

    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)
    Copy Link
  • Søren Spelling Lund 1797 posts 2786 karma points
    Jan 20, 2011 @ 11:15
    Søren Spelling Lund
    0

    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.

    Copy Link
  • Søren Spelling Lund 1797 posts 2786 karma points
    Jan 25, 2011 @ 13:10
    Søren Spelling Lund
    0

    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.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft