Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › eStore download links database overload
- This topic has 6 replies, 2 voices, and was last updated 10 years, 2 months ago by clearscopedesign.
-
AuthorPosts
-
July 31, 2014 at 6:43 am #11261clearscopedesignParticipant
Our eStore is creating tons of erroneous links in the eStore_download_links_tbl table of the database. We know how to clear the links through the eStore Admin functions, but it’s adding about 1MB of links per day.
Can you please tell us how we can prevent this from happening?
Thank you!
July 31, 2014 at 2:00 pm #64695wzpModeratorWhat do you mean by an “erroneous link?”
Links do not get generated for no good reason. Do you offer free downloads on your site?
August 28, 2014 at 1:16 am #64696clearscopedesignParticipantYes, we have many free downloads for members. But as we have reported previously, the ‘sales count’ for each item is incredibly high (into the 10’s of thousands for some items), way higher than it could possibly be if it were accurate. Which suggests that many of the links that are being created in the database are actually being generated for no good reason. There are far more links being built up in the database than actual downloads.
Right now there are 18.7 MiB of links in the eStore_download_links_tbl table alone, and I emptied it just a couple weeks ago!
Thank you…
August 28, 2014 at 1:12 pm #64697wzpModerator…we have many free downloads for members.
- Do the members first have to log into your site, in order to access the free downloads?
- Are the free downloads accessed via “Download Now” or “Squeeze Form” buttons?
September 9, 2014 at 3:43 am #64698clearscopedesignParticipantYes, members must be logged-in in order to download. I don’t believe we are using ‘Squeeze Form’. The buttons all just say ‘Download’.
Thank you…
September 9, 2014 at 3:15 pm #64699wzpModeratorYes, members must be logged-in in order to download.
So, you are using eStore “Download Now” buttons on eMember protected pages, that first require a member to log in; in order to access the buttons? If that is the case, you may have members that are simply downloading the same files all the time. Is that a possibility?
Are you sure the page is properly protected? Perhaps you can enhance the “sure” part, by using the “Members Only” download button addon:
https://www.tipsandtricks-hq.com/ecommerce/wp-estore-members-only-download-button-addon-1718
September 10, 2014 at 2:11 am #64700clearscopedesignParticipantRegarding the first question: Yes, exactly. All of these pages are protected pages that are only accessible to our members (and memberships are not available to the public).
There is no reason for our members to download materials more than once, but even if they are doing so, it would not add up. The download count for the most recent item that we added, just a week or two ago, is showing as 10,137. I just cleaned about 30MB of links from the database, all from just the past month.
As far as the pages go, all of these pages are protected by eMember and only accessible to those with a membership, so unless there is something else we should be doing, I believe the pages are properly protected.
Thank you…
-
AuthorPosts
- You must be logged in to reply to this topic.