Fix A Wordpress Database Error for Woo-commerce Downloads

$10-30 USD

Imekamilika

Imechapishwa

over 5 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

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.

Kitambulisho cha mradi: 18174921

Kuhusu mradi

7 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@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 check out the tables, check the foreign key constraint, and see that it matches with your code and your development server. I can get started ASAP

$20 USD ndani ya siku 1

5.0

(44 hakiki)

5.8

7 wafanyakazi huru wana zabuni kwa wastani $27 USD kwa kazi hii

@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 ndani ya siku 1

4.9

(235 hakiki)

7.2

@struggler1

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

$20 USD ndani ya siku 1

4.8

(624 hakiki)

7.4

@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 ndani ya siku 1

5.0

(104 hakiki)

7.3

@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, MySQL, JQuery, JS, HTML5, Bootstrap and many more. I can intergrate and customize APIs, Plugins, update themes and plugins, PSD to HTML/Wordpress, Integrate payment gateways. We can discuss further details over chat. Looking forward to talk to you.

$41 USD ndani ya siku 1

4.9

(35 hakiki)

4.9

@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. Wishing to hear from you. Hassy

$25 USD ndani ya siku 1