Fix A Wordpress Database Error for Woo-commerce Downloads

We just moved a site from development to live and now get the following error when trying to download a product:

Unable to insert download log entry in database.

The WordPress error log shows the following entry:

16-Nov-2018 05:20:54 UTC] WordPress database error Cannot add or update a child row: a foreign key constraint fails (`livesite_wp522`.`wplive_wc_download_log`, CONSTRAINT `fk_wc_download_log_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `wpdev_woocommerce_downloadable_product_permissions` (`permission_id) for query INSERT INTO `wp01_wc_download_log` (`timestamp`, `permission_id`, `user_id`, `user_ip_address`) VALUES ('2018-11-16 05:20:54', '37', NULL, '[login to view URL]') made by require('[login to view URL]'), require_once('[login to view URL]'), require_once('[login to view URL]'), require_once('[login to view URL]'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Download_Handler::download_product, WC_Customer_Download->track_download, WC_Data->save, WC_Data_Store->create, WC_Customer_Download_Log_Data_Store->create, QM_DB->query

To see the issue you can go here: [login to view URL] and checkout one of the "By Donation" downloads with a payment of $0.

We need to fix this to get the downloads to work again.

Beceriler: HTML, MySQL, PHP, WordPress

Daha fazlasını gör: wordpress download, repair wordpress database, wordpress error establishing a database connection, woocommerce repair database, wordpress repair plugin, http error 500 wordpress, wordpress database repair plugin, wordpress check database, fix wordpress database corrupt, wordpress database error got error 127, wordpress database error got error 127 storage engine, database error fix, wordpress database error connect storage engine, wordpress database error sort aborted, wordpress database error database selected, fix broken wordpress database, fix corrupted wordpress database, wordpress database error, fix a small error on my wordpress website, fix a very small error in wordpress

İşveren Hakkında:
( 14 değerlendirme ) Hotchkiss, United States

Proje NO: #18174921



Hey there I understand this error and can fix this ASAP. It seems like your tables are setup using InnoDB (which is a good practice) and use a foreign key constraint (WordPress is not very good with this) I'll ch Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(42 Değerlendirme)

Bu iş için 8 freelancer ortalamada $25 teklif veriyor


Hello, I can fix your issue on download on your wordpress site as per your given brief on project post. Let me know when you available to discuss more in detailed. Regards Rina

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(97 Değerlendirme)

Hello How are you My name is Xu I can fix it in 5 min i have full time and I can start to work immediately Please contact me and do let us discuss about your project Thanks for your posting

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(235 Değerlendirme)

will fix site issue now,ready to start now. thanks..........................................................................................

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(582 Değerlendirme)

Hello how are you? I always deliver on time and on budget feel free to check my feedbacks and portfolio. I am available right now and I am interested in your project and would like to discuss the project with [login to view URL] Daha Fazla

$30 USD in 5 gün içinde
(60 Değerlendirme)

Hello, First of all for your information; I'm not an indian robot :) I read your proposal and write quick answer for your job. I'm pretty excited to work together. I'm waiting for your message :) Quick Answer Fo Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(49 Değerlendirme)

Hi There, I can start immediately and fix up the issue. Lets discuss further over chat. I have 5+ years of experience working with Wordpress, Codeigniter, Laravel, Shopify, Bigcommerce, Woocommerce, Opencart, PHP, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(35 Değerlendirme)

Greetings!! We have work experience over 6 years in WordPress, Custom Plug-in, Themes, Widgets, Woocommerce, PHP and Yii2 etc. I can fix your issue. Please open private message board to initiate the discussion. Wis Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)