| Issue 39: | PATCH Wrong number of orders by country | |
| 1 person starred this issue and may be notified of changes. | Back to list |
What steps will reproduce the problem? 1. Pick one user and make several orders and let the billing and shipping addresses the same. What is the expected output? What do you see instead? The result in administration view is the sum of (number_of_orders_of_an_user_to_a_country * number_of_total_orders_of_this_user). It should be only the sum of orders sent to a country by any user. What version of the product are you using? On what operating system? trunk. Ubuntu 7.04 Please provide any additional information below. The way it is it only works when you test with just one order per user. Create one more and it will give wrong results. The SQL is wrong, you dont need to join orders with users and then to addresses, the order already have a foreign key to a shipping address where you can discover the country. Follows a patch.
Apr 8, 2008
Project Member
#1
subim...@gmail.com
Status:
Fixed
|