Hi Matthew,



Damned, it's a bug! Fortunately it can be corrected easily. connect to your website as host and go to Host > SQL. Copy and paste the following code to the text box, check 'Run as script' and click on 'Execute'.



ALTER Procedure {databaseOwner}{objectQualifier}Store_Orders_GetDownloads

 @PortalID int,

 @UserID int

 AS

 SET NOCOUNT ON

 SELECT d.OrderDetailID, d.OrderID, d.ProductID, p.ModelNumber, p.ModelName, p.VirtualFileID, p.AllowedDownloads, d.Quantity, d.Downloads

 FROM {databaseOwner}{objectQualifier}Store_Orders o INNER JOIN

  {databaseOwner}{objectQualifier}Store_OrderDetails d ON o.OrderID = d.OrderID INNER JOIN

  {databaseOwner}{objectQualifier}Store_Products p ON d.ProductID = p.ProductID

 WHERE (o.PortalID = @PortalID) AND (o.UserID = @UserID) AND o.OrderStatusID NOT IN (1, 2, 6) AND (p.Virtual = 1)

GO



This will be corrected in the next version.



Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.

Hi,



Congrats to Mavericks! :-)



Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.