Đã hoàn thành

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.

Kĩ năng: HTML, MySQL, PHP, WordPress

Xem nhiều hơn: 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

Về Bên Thuê:
( 10 nhận xét ) Hotchkiss, United States

ID dự án: #18174921

Được trao cho:

prakharkumar610

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 Thêm

$20 USD trong 1 ngày
(39 Đánh Giá)
5.8

9 freelancer đang chào giá trung bình $27 cho công việc này

AltiuseCreaton

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

$30 USD trong 1 ngày
(96 Nhận xét)
7.3
struggler1

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

$20 USD trong 1 ngày
(504 Nhận xét)
7.2
brianconey

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

$20 USD trong 1 ngày
(152 Nhận xét)
6.8
radimosve

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] Thêm

$30 USD trong 5 ngày
(59 Nhận xét)
5.7
sahildeveloper01

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, Thêm

$41 USD trong 1 ngày
(34 Nhận xét)
4.9
Coder026

Sir- I check the error and it seems some issue with update method - Is it working fine on your development server ? I have 15+ years of exp on wordpress and I'm sure I can fix it within a matter of few hours :) Thêm

$40 USD trong 1 ngày
(3 Nhận xét)
3.0
cagdasdag

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 Thêm

$15 USD trong 1 ngày
(3 Nhận xét)
2.5
hasssyy

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 Thêm

$25 USD trong 1 ngày
(1 Nhận xét)
0.0