Updating to 8.3.1.7

Updating to 8.3.1.7 - Error

Martin Nielsen

Posted on 20/02/2014 10:53:26

Hi DW,

After updating a solution to 8.3.1.6 i get this error on all productlists with more that one product in them:

System.NullReferenceException: Object reference not set to an instance of an object.
   at Dynamicweb.eCommerce.Prices.Price.LoadPricesOnProducts(ProductCollection Products)
   at Dynamicweb.eCommerce.Products.Product.GetPagedProductsByGroupIds(String groups, String searchValue, String languageId, String orderByClause, Int32 rangeStart, Int32 rangeEnd, String orderByCalculatedFieldName)
   at Dynamicweb.eCommerce.Products.Product.GetPagedProductsByGroupIds(String groups, String orderByClause, Int32 rangeStart, Int32 rangeEnd)
   at Dynamicweb.eCommerce.Frontend.Frontend.List(String groups)
   at Dynamicweb.eCommerce.Frontend.Frontend.EcomRender()
   at Dynamicweb.eCommerce.Frontend.Frontend.GetContent()
   at Dynamicweb.Frontend.Content.getModule(DataRow& ParagraphRow)

I get the error in both Frontend and in Ecom when i click a group.

I have disabled all my custom modules, but it still gives the error.

// Martin

Replies

Morten Snedker

Posted on 20/02/2014 10:54:32

Hey Martin,

Is the site public available? And if so: on which URL?

And I'd suggestion moving to latest 8.3.1(.17). Unless you convince me otherwise, I see no reason not to.

Regards /Snedker

Martin Nielsen

Posted on 20/02/2014 10:57:32

I tried to roll my solution back to 8.3.0.7 and on this build my productlists render correctly.

8.3.1.9 gives error aswell.

Morten Snedker

Posted on 20/02/2014 11:02:53

The error suggests that there's some bad data. You may backup your database and send me a download link (msn@dynamicweb.dk), then I'll find the bugger for you.

If it is hosted at HN you may just give me a URL, then I'll grab it myself.

Regards /Snedker

Martin Nielsen

Posted on 20/02/2014 11:16:41

Hi Morten,

I just sent you a link via email.

// Martin

Morten Snedker

Posted on 20/02/2014 13:26:36

This post has been marked as an answer

Some of the added code doesn't like that you have f!cked up the EcomProducts.ProductAutoID column. It doesn't do that by itself. ;-)

It is supposed to be a running key (auto seeded). If you make it so it will be happy again.

/Snedker

Votes for this answer: 1

Martin Nielsen

Posted on 20/02/2014 13:39:02

Hi Morten,

I will take a look.

Thx.

Just out ouf curiosity, what is the fields used for? I was added between 8.1 and 8.2 right?

//Martin

Nicolai Høeg Pedersen

Posted on 20/02/2014 13:50:54

The ID colum has 2 purposes. It was added in order to make the "Optimized product retrieval" checkbox on paragraph settings and supporting 50.000+ products in product lists in the backend. It is being used when making paged quires in SQL.

In 8.4.1 it will also be the primary index (clustered) for optimizing performance on queries against the table.

BR Nicolai

Martin Nielsen

Posted on 20/02/2014 14:20:04

IT WORKED!!

After i undid my f..!..ckup it works.

Thank you both for your answers :-)

You must be logged in to post in the forum

Developer forum

Updating to 8.3.1.7 - Error

Replies