I'm experimenting a very frustrating problem and can't seem to figure out the cause...
I sell downloads only and some downloads in my customers account are duplicated or missing.
This issue only happens in the customer download page.
If I look at the customer's order, every downloadable product appears correctly.
Any help would be very appreciated!
Wallimann, I too sell a lot of downloads and have a lot of experience with them. I just need some more information to be able to help... without knowing a thing, I'd have to guess the customers are having a caching issue with their browsers. This is not just an OpenCart downloads issue, anybody who deals with downloads will have to occasionally tell a customer how to clear their cache.Wallimann wrote:I'm experimenting a very frustrating problem and can't seem to figure out the cause...
I sell downloads only and some downloads in my customers account are duplicated or missing.
This issue only happens in the customer download page.
If I look at the customer's order, every downloadable product appears correctly.
Any help would be very appreciated!
You might also try asking the customers who have problems what browser, OS etc. that they are on... try to see if there is a pattern. Again I doubt that this is an OpenCart issue.
Good Luck,
Merry
Most answers are from my OpenCart 1.5 User Manual CURRENT TO 1.5.5.1 and includes free updates.
FREE HELP! 60-page user guide with OpenCart Admin Menu Cheatsheet, Install Guide & 30 Minute QuickStart Guide: http://showmeguides.com/
Thanks for the quick response...
I don't think it's a cache issue as I logged in to some of the customers accounts to try myself and can verify the issue...
This seems to happen with items that have multiple downloads associated with them...
Here are a few strange things that are probably all related:
The order of appearance of the downloads for a same product change each time a customer logs out and back in..
The duplicate and missing downloads don't happen for all customers...
Very strange!
I don't think it's a cache issue as I logged in to some of the customers accounts to try myself and can verify the issue...
This seems to happen with items that have multiple downloads associated with them...
Here are a few strange things that are probably all related:
The order of appearance of the downloads for a same product change each time a customer logs out and back in..
The duplicate and missing downloads don't happen for all customers...
Very strange!
Guitar Backing Tracks and Video Lessons at http://www.guitarplayback.com
Hmmm not much feedback in the forum lately, so in the meantime I've discovered a very simple, partial solution.
Go into Admin > System > Settings > Option > Default Items Per Page (Catalog). Change the number to a high enough number that all downloads show on the same page.
What seems to be happening is, on each page load the downloads re-sort randomly and so the order keeps changing from page to page - making it seem like there are missing downloads. So if you force everything to load on the same page you'll see that they are all there. But each time you reload the page they will re-shuffle (sort) again, but as long as they are on the same page you'll find them all there. At least that's how it works on my site.
I've simply upped the number to 200 and it seems to load fine without slowdown. However this also effects the product thumbnail listings on the front end - but it does not seem to slow my page load.
Maybe someone else has a solution to the random resorting ?
Go into Admin > System > Settings > Option > Default Items Per Page (Catalog). Change the number to a high enough number that all downloads show on the same page.
What seems to be happening is, on each page load the downloads re-sort randomly and so the order keeps changing from page to page - making it seem like there are missing downloads. So if you force everything to load on the same page you'll see that they are all there. But each time you reload the page they will re-shuffle (sort) again, but as long as they are on the same page you'll find them all there. At least that's how it works on my site.
I've simply upped the number to 200 and it seems to load fine without slowdown. However this also effects the product thumbnail listings on the front end - but it does not seem to slow my page load.
Maybe someone else has a solution to the random resorting ?
Having the same issue, many years later in 2.3
Customer with many downloads (45) are getting randomly resorted each time. Some repeat across the pages.
Alber99's solution doesn't appear to work, the only option here: Admin > System > Settings > Option > Default Items Per Page (Catalog) is for Admin items.
Customer with many downloads (45) are getting randomly resorted each time. Some repeat across the pages.
Alber99's solution doesn't appear to work, the only option here: Admin > System > Settings > Option > Default Items Per Page (Catalog) is for Admin items.
Try Editing catalog/model/account/download.php
Find
Remove DISTINCT and update the code like this
Hope this helps.
Find
Code: Select all
$query = $this->db->query("SELECT DISTINCT op.order_product_id, d.download_id, o.order_id, o.date_added, dd.name, d.filename FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (o.order_id = op.order_id) LEFT JOIN " . DB_PREFIX . "product_to_download p2d ON (op.product_id = p2d.product_id) LEFT JOIN " . DB_PREFIX . "download d ON (p2d.download_id = d.download_id) LEFT JOIN " . DB_PREFIX . "download_description dd ON (d.download_id = dd.download_id) WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND (" . implode(" OR ", $implode) . ") ORDER BY o.date_added DESC LIMIT " . (int)$start . "," . (int)$limit);Code: Select all
$query = $this->db->query("SELECT op.order_product_id, d.download_id, o.order_id, o.date_added, dd.name, d.filename FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (o.order_id = op.order_id) LEFT JOIN " . DB_PREFIX . "product_to_download p2d ON (op.product_id = p2d.product_id) LEFT JOIN " . DB_PREFIX . "download d ON (p2d.download_id = d.download_id) LEFT JOIN " . DB_PREFIX . "download_description dd ON (d.download_id = dd.download_id) WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND (" . implode(" OR ", $implode) . ") ORDER BY o.date_added DESC LIMIT " . (int)$start . "," . (int)$limit);HuntBee OpenCart Services
https://www.huntbee.com
@Priya didn't you pickup little too late on this XD
Got an urgent question that’s keeping you up at night? There might just be a magical inbox ready to help: khnaz35@gmail.com
Enjoy nature 
Today, I learned about this issue from one of my clients. While checking if others have encountered the same problem, I came across this thread.
HuntBee OpenCart Services
https://www.huntbee.com
Nice, so this seems to be a real bug in 2.0.3.0? And the code here fixes it?
If so, shall we mark it [SOLVED]?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
This bug is continued in newer opencart versions (3.0.4.0) as well. With this code update, the issue with download duplication in the paginations seems to have been fixed (tested for orders with one product and multiple downloads assigned to the product). I have not thoroughly tested it for other scenarios like when an order contains multiple products with multiple downloads.
paulfeakins wrote: ↑Tue Nov 12, 2024 8:38 pmNice, so this seems to be a real bug in 2.0.3.0? And the code here fixes it?
If so, shall we mark it [SOLVED]?
HuntBee OpenCart Services
https://www.huntbee.com
Is there a github issue for it?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Who is online
Users browsing this forum: No registered users and 80 guests
