• Resolved sprovenza

    (@sprovenza)


    I’ve tried the Force Download and the X-Accel-Redirect/X-Sendfile method, and neither of them work. The purchase goes thru just fine, account gets created, customer gets the email but the download link will not work. We get this error “Unable to insert download log entry in database.”

    I have virtual and downloadable both checked in the product.

    It’s happening for all of the products.

    I’m using the WooCommerce Payments gateway

    Also, the files are .Zip format. Could that be an issue?

    • This topic was modified 3 years ago by sprovenza.
    • This topic was modified 3 years ago by sprovenza.
    • This topic was modified 3 years ago by sprovenza.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Ebbets

    (@ebbets)

    I am having the same issue and it has been going on for multiple weeks.

    Igor H

    (@ihereira)

    Hello @sprovenza

    You can perform a conflict test to check if it solves the issue, please follow these steps below:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

    If the issue is not present after that, it means there was a conflict. You can find a more detailed explanation on how to do a conflict test here.

    Let us know how it goes.

    @ebbets Please create your own thread for your issue – https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0.

    We want to make sure that every user’s issues receive their own thread with proper attention since each site configuration could be different.

    * Frequently Asked Questions

    Thanks.

    Thread Starter sprovenza

    (@sprovenza)

    This issue was fixed by the hosting company! Here are the details:

    We don’t know exactly what went wrong but below are the signs we were seeing:
    >
    > when we click on a download link from an order, we were taken to a WordPress Error Page displaying the error Unable to insert download log entry in database..
    > we then checked the database table that is created by WooCommerce where they store the logs of these downloads. This is necessary if downloads have a download limit or if you simply want to see a detailed history of people downloading their items.
    > we found that this database table was empty which is very unusual.
    > it may seem too simple but disabling then re-enabling a plugin can fix issues like this as these plugins go through a process when being enabled on a site “check if database tables are present, create them if not, update permissions, etc.”
    > from experience, we knew that this issue might simply resolve itself if we delete this database table, disable WooCommerce, and then enable WooCommerce.
    > this did the trick and we started seeing product downloads work + entries being added to this database table.
    > I guess the advice here or what we did to get this resolved was that we followed the clues until we found something that really didn’t look right. Google is also another friend here as there are many other resources and others using WooCommerce day-to-day.`

    Here’s more about the database table:

    Error when trying to download the file from the purchase confirmation email:

    > Unable to insert download log entry in database.
    
    > Most likely there is something slightly off with WooCommerce but we've been able to use the method below in the past to get things re-aligned:
    >
    > backup the site - we just ran a new fresh backup ??
    > drop the db table wp_18fa4jg9ye_wc_download_log
    > disable WooCommerce
    > enable WooCommerce
    > check to see if the table wp_18fa4jg9ye_wc_download_log was re-created
    > test the download file
    Mirko P.

    (@rainfallnixfig)

    Great! Thank you for sharing with us the solution.

    Since this is now resolved I’m going to close the thread. Feel free to open a new topic if you have any other questions.

    Cheers.

    Thread Starter sprovenza

    (@sprovenza)

    Thank you!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Digital download link doesn’t work’ is closed to new replies.