Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » GetActiveProducts gives SQL exception

GetActiveProducts gives SQL exception

Tobias Belling
Reply

Hi.

I have upgraded a solution to DW 9.6.9 and it's able to compile. The issue is, that when I try to call:

var products = Dynamicweb.Ecommerce.Services.Products.GetActiveProducts(cart.LanguageId, true).ToList();

I get following error:

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '.'. Incorrect syntax near ')'.

This happens after a user has logged in, and we are trying to get the cart. This is done in a custom basket provider (which will create a product if it exists in the cart, but doesn't exist in the current active products).


Replies

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Reply

Hi Tobias,

This seems to be a bug. I will have the developer team post back a bug number.

/Snedker

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Reply

Hi Tobias,

This has been reported as bug #65629, and will be fixed in the next release. Thank you for your feedback.

Best regards
Morten Snedker | Helpdesk

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Reply

Hi Tobias

This problem has been resolved in Dynamicweb Hotfix version 9.6.10

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum