• Resolved Maurice Vieth

    (@mauricevieth89)


    When I go to Dashboard or Reports tab, I got 502 bad gateway error.
    Others are good. Members, Orders, Settings, Add Ons
    What’s the problem?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Andrew Lima

    (@andrewza)

    Hi @mauricevieth89

    Thank you for using Paid Memberships Pro, I’m sorry to hear about the issue you are facing.

    I haven’t been able to replicate this issue on my end. I have tested a handful of sites running Paid Memberships Pro.

    Would you mind enabling debug logging on your site and navigate back to these pages and let me know if there are any errors?

    Here is a guide to debugging WordPress – https://www.paidmembershipspro.com/how-to-enable-debugging-on-you-your-wordpress-site/

    Thread Starter Maurice Vieth

    (@mauricevieth89)

    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT COUNT(DISTINCT mu.user_id) FROM wp_pmpro_memberships_users mu WHERE mu.startdate >= ” made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_memberships_widget, pmpro_getSignups
    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT COUNT(DISTINCT mu.user_id) FROM wp_pmpro_memberships_users mu WHERE mu.startdate >= ” AND mu.membership_id IN(1) made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_memberships_widget, pmpro_getSignups
    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT COUNT(DISTINCT mu.user_id) FROM wp_pmpro_memberships_users mu WHERE mu.startdate >= ” AND mu.membership_id IN(2) made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_memberships_widget, pmpro_getSignups
    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT COUNT(DISTINCT mu.user_id) FROM wp_pmpro_memberships_users mu WHERE mu.startdate >= ” AND mu.membership_id IN(3) made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_memberships_widget, pmpro_getSignups
    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT ROUND(total,8) as rtotal, COUNT(*) as num FROM wp_pmpro_membership_orders WHERE total > 0 AND status NOT IN(‘refunded’, ‘review’, ‘token’, ‘error’) AND timestamp >= ” AND gateway_environment = ‘sandbox’ GROUP BY rtotal ORDER BY num DESC made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_sales_widget, pmpro_get_prices_paid
    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT COUNT(*) FROM wp_pmpro_membership_orders WHERE total > 0 AND status NOT IN(‘refunded’, ‘review’, ‘token’, ‘error’) AND timestamp >= ” AND gateway_environment = ‘sandbox’ made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_sales_widget, pmpro_getSales
    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT SUM(total) FROM wp_pmpro_membership_orders WHERE status NOT IN(‘refunded’, ‘review’, ‘token’, ‘error’) AND timestamp >= ” AND gateway_environment = ‘sandbox’ made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_sales_widget, pmpro_getRevenue
    [09-Jun-2020 05:16:28 UTC] WordPress database error Incorrect DATETIME value: ” for query SELECT ROUND(total,8) as rtotal, COUNT(*) as num FROM wp_pmpro_membership_orders WHERE total > 0 AND status NOT IN(‘refunded’, ‘review’, ‘token’, ‘error’) AND timestamp >= ” AND gateway_environment = ‘sandbox’ GROUP BY rtotal ORDER BY num DESC made by do_action(‘memberships_page_pmpro-reports’), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_reports, require_once(‘/plugins/paid-memberships-pro/adminpages/reports.php’), do_meta_boxes, pmpro_report_sales_widget, pmpro_get_prices_paid

    I got log something like this.

    How can I solve this problem?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘I got a 502 bad gateway error.’ is closed to new replies.