When reviewing subscriptions I am seeing that each subscription is being squared. I made another subscription to test some things and found that under the my registration I showed 4 subscriptions, only two different transaction ID's. Then I added another one to test the theory and now I show 9 of them. Each transaction ID shows with the dates from each other transaction. I have a screenshot showing the issue that I can send if you like.

I'm using DNN Version 7.00.05
SmithRegPro version 4.56

Hi,
The sproc Smith_ListSubscriptionsByUserName is not a cartesian product. The join fields for the sproc in my database look good as follows:

select c.*, ph.TransID, ph.InvoiceNo, s.*
from dnn_Smith_Subscription s
inner join dnn_Smith_RegPayHist ph
on s.PayHistID = ph.PayHistID
inner join dnn_Smith_RegCustomer c
on s.CustomerID = c.CustomerID
where c.DNNLogin=@dnnLogin
order by ph.paydate desc

Please confirm the sproc in your database is the same.

---

Scott Kelly
Project Manager