Download Space does not list available downloads

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.4.x
-- Browser(s) name and version -- : All

I have my shop setup using the Essential version of HikaShop. I am using Hika to sell digital goods only so I need the download space to work properly.

Right now when a customer purchases a downloadable good they are sent the confirmation email and can download the item using the link in the email. However, when they visit the 'Download Space' on the site they are shown no available downloads. I have tried purchasing the file using a coupon code to receive 100% off and tried creating the order then setting it to confirmed in the admin. I have also tried purchasing using the paypal sandbox and even though it says everything went fine and I get my confirmation emails, I still have nothing listed in the Download Space.

I have read in other places that if it is a "free" download it may not show up in the download area but this does not make sense because people should be able to see any download they have signed up to receive and ordered.

Please let me know what I can do.

Thanks in advance! Loving HikaShop so far

Although I would like to also display downloads that may be free ( either because they are free always or because a user used a coupon ) I am also not seeing downloads that the user paid for. Basically right now no matter how a user obtained the download, free or paid, nothing shows up in the download space.

As I said in the previous two posts the download space does not show all purchased downloads as well. I guess I will have to debug the issue myself and modify the component to make it work the way I expect it to.

So I just did another test by setting a product to $1 and having a friend purchase it. The paypal part went through fine but when I logged in with their account there were no downloads available to them. The status of the order was set to 'none' somehow so I double checked the settings in the paypal configuration and verified that the 'Verified Status' option was set to 'Confirmed'. I think manually set his order to 'Confirmed' but still nothing shows up in the download space for his account. However, when I view his orders from his account on the front end I am presented with the order as confirmed and when I view the order I see the link to download the file. Is there a place I can send some login information to you guys so you may test it out?

So I think I see where the problem is. After breaking down the query that is run to grab downloadable files to this:

SELECT o.order_id,
       o.order_created,
       o.order_user_id,
       f.*,
       p.*,
       Min(o.order_created)                           AS min_order_created,
       Max(o.order_created)                           AS max_order_created,
       Sum(p.order_product_quantity)                  AS file_quantity,
       IF(REPLACE(LEFT(f.file_path, 1), '#', '@') = '@',
       Concat(f.file_id, '@', o.order_id), f.file_id) AS uniq_id
FROM   chjvm_hikashop_order AS o
       INNER JOIN chjvm_hikashop_order_product AS p
               ON p.order_id = o.order_id
       INNER JOIN chjvm_hikashop_file AS f
               ON p.product_id = f.file_ref_id
WHERE  o.order_type = 'sale'
   AND o.order_status IN ( 'shipped', 'confirmed' )
   AND f.file_ref_id > 0
   AND f.file_type = 'file'
   AND o.order_user_id = 5
GROUP  BY uniq_id
ORDER  BY max_order_created DESC