saunier francois
Forum Replies Created
-
Hello,
Forgive me, I must have been absent.
Yes the problem was solved.
For information, if it could be useful to someone, it was an Ajax request conflict caused by another plugin.
Good end of the day to you and good continuation.I have something new!
rapport in error_log[12-Jul-2020 20:00:45 UTC] Erreur de la base de données WordPress Unknown column ‘mt3.post_id’ in ‘where clause’ pour la requête SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_give_donationmeta ON ( wp_posts.ID = wp_give_donationmeta.donation_id ) LEFT JOIN wp_give_donationmeta AS mt1 ON ( wp_posts.ID = mt1.donation_id ) LEFT JOIN wp_give_donationmeta AS mt2 ON ( wp_posts.ID = mt2.donation_id ) LEFT JOIN wp_give_donationmeta AS mt3 ON (wp_posts.ID = mt3.donation_id AND mt3.meta_key = ‘rms_rm_uniq_meta_post_id’ ) LEFT JOIN wp_give_donationmeta AS mt4 ON (wp_posts.ID = mt4.donation_id AND mt4.meta_key = ‘rms_remote_featured_image’ ) WHERE 1=1 AND (
( wp_posts.post_date >= ‘2020-07-05 00:00:00’ AND wp_posts.post_date <= ‘2020-07-06 23:59:59’ )
) AND wp_posts.post_parent = 0 AND (
( wp_give_donationmeta.meta_key = ‘_give_payment_currency’ AND wp_give_donationmeta.meta_value = ‘EUR’ )
AND
( mt1.meta_key = ‘_give_payment_mode’ AND mt1.meta_value = ‘live’ )
AND
( mt2.meta_key = ‘_give_payment_gateway’ AND mt2.meta_value IN (‘paypal’,’offline’,’stripe’,’stripe_checkout’,’stripe_sepa’,’stripe_becs’) )
AND
mt3.post_id IS NULL
AND
mt4.post_id IS NULL
) AND wp_posts.post_type = ‘give_payment’ AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘refunded’ OR wp_posts.post_status = ‘failed’ OR wp_posts.post_status = ‘revoked’ OR wp_posts.post_status = ‘abandoned’ OR wp_posts.post_status = ‘processing’ OR wp_posts.post_status = ‘cancelled’ OR wp_posts.post_status = ‘preapproval’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC faite par require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Give\API\Endpoints\Reports\Endpoint->handle_request, Give\API\Endpoints\Reports\AverageDonation->get_report, Give\API\Endpoints\Reports\AverageDonation->get_data, Give\API\Endpoints\Reports\AverageDonation->get_average_donation, Give\API\Endpoints\Reports\Endpoint->get_payments, Give_Payments_Query->get_payments, WP_Query->__construct, WP_Query->query, WP_Query->get_posts