Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

eStore download links database overload

by

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, 8 months ago by clearscopedesign.
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • July 31, 2014 at 6:43 am #11261
    clearscopedesign
    Participant

    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 #64695
    wzp
    Moderator

    What 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 #64696
    clearscopedesign
    Participant

    Yes, 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 #64697
    wzp
    Moderator

    …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 #64698
    clearscopedesign
    Participant

    Yes, 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 #64699
    wzp
    Moderator

    Yes, 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 #64700
    clearscopedesign
    Participant

    Regarding 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…

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ