Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter sprovenza

    (@sprovenza)

    Thank you!

    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
Viewing 2 replies - 1 through 2 (of 2 total)