Download Links for files removed from purchase receipt

Anyone?

This is happening with WordPress 4.6.1 and 4.7

I also checked the Database line: wp_p859x8jayr_woocommerce_downloadable_product_permissions

And can confirm that product entries are being entered:

https://pasteboard.co/b2Pt8V9CG.png

Though, not sure if I need to make that database line shorter or need to adjust the name of the database via this article? https://docs.woocommerce.com/document/completed-order-email-doesnt-contain-download-links/

WooCommerce Status Report

### WordPress Environment ###

Home URL: https://patcosta.com
Site URL: https://patcosta.com
WC Version: 2.6.9
Log Directory Writable: ?
WP Version: 4.6.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US

### Server Environment ###

Server Info: Apache
PHP Version: ? 5.4.45 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
PHP Post Max Size: 65 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.45.0
OpenSSL/1.0.1e

SUHOSIN Installed: –
MySQL Version: 5.6.32
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 2.6.9
: 
woocommerce_sessions: ?
woocommerce_api_keys: ?
woocommerce_attribute_taxonomies: ?
woocommerce_downloadable_product_permissions: ?
woocommerce_order_items: ?
woocommerce_order_itemmeta: ?
woocommerce_tax_rates: ?
woocommerce_tax_rate_locations: ?
woocommerce_shipping_zones: ?
woocommerce_shipping_zone_locations: ?
woocommerce_shipping_zone_methods: ?
woocommerce_payment_tokens: ?
woocommerce_payment_tokenmeta: ?

### Active Plugins (29) ###

Akismet: by Automattic – 3.2
AMP: by Automattic – 0.4.2
Autoptimize: by Frank Goossens (futtta) – 2.1.0
Cloudflare: by John Wineman
Furkan Yilmaz
Junade Ali (Cloudflare Team) – 3.1.1

Custom Field Finder: by Joost de Valk – 0.1
EWWW Image Optimizer: by Shane Bishop – 3.1.3
Google Analytics by MonsterInsights eCommerce tracking addon: by The MonsterInsights Team – 5.5.3
Glue for Yoast SEO & AMP: by Joost de Valk – 0.3.3
Google Analytics by MonsterInsights: by MonsterInsights – 5.5.4
Google Authenticator: by Henrik Schack – 0.48
Google AdSense: by Google – 1.2.1
Homepage Control: by WooThemes – 2.0.2
Jetpack by WordPress.com: by Automattic – 4.4.2
Go Daddy Quick Setup: by GoDaddy.com
LLC – 1.06

Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 2.2.6
Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri
Inc – 1.8.3

Theme Customisations: by WooThemes – 1.0.0
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.12.29

Vanilla PDF Embed: by Mike Doherty  – 0.0.8
WangGuard: by WangGuard – 1.7.2
WooCommerce Checkout Manager: by Visser Labs – 4.0.9
WooCommerce Customizer: by SkyVerge – 2.3.1
WooCommerce: by WooThemes – 2.6.9
Yoast SEO Premium: by Team Yoast – 4.0.1
Yoast SEO: Local for WooCommerce: by Team Yoast and Arjan Snaterse – 3.7.0
WordPress SEO News: by Team Yoast – 3.1
Yoast SEO: Video: by Team Yoast – 4.0
Yoast SEO: WooCommerce: by Team Yoast – 3.5
YouTube: by EmbedPlus Team – 11.5

### Settings ###

Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2

### API ###

API Enabled: ?

### WC Pages ###

Shop Base: #1723 - /
Cart: #1725 - /cart/
Checkout: #1727 - /checkout/
My Account: #1729 - /my-account/

### Taxonomies ###

Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

### Theme ###

Name: Storefront
Version: 2.1.6
Author URL: https://woocommerce.com/
Child Theme: ? – If you're modifying WooCommerce on a parent theme you didn't build personally
then we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ?

### Templates ###

Overrides: –

Well…I am going to change the way I do downloads. Currently is is

https://pasteboard.co/b3CfBflCl.png

I am going to unclick “Grant access to downloadable products after payment” to see if that changes anything.

I also deactivated and then reactivated the plugin. Either that or changing the way I do downloads may have resolved it.

Nope, still happening.

https://pasteboard.co/hon6iki2e.png

The code that prints out the links in the emails is function display_item_downloads() in:
plugins/woocommerce/includes/abstracts/abstract-wc-order/php lines 2227 onwards (v2.6.11)
Consider debugging that by temporarily inserting code at each step to find out why its not working. So, insert: var_dump($product) on line 3 of the function and so on.

So the issue was that the WordPress Database had too long a string

wp_p859x8jayr_woocommerce_downloadable_product_permissions

I used this plugin here https://www.ads-software.com/plugins/change-table-prefix/ (it worked with WP 4.7.1) and changed the above string to something shorter like wp_woocomm_downloads. There were several of these strings that I had to change. This appeared to have done the trick.