Support » Plugin: WooCommerce » Database error for smart coupons

  • Resolved Vidish

    (@vidishp)


    Hello,

    I am having issue with Smart coupon plugin. I have active subscription, of that plugin.

    Here is the database error that is logged for that plugin. Can you help me understand how can I fix it?

    2020/04/27 17:39:41 [error] 10541#10541: *2163156 access forbidden by rule, client: 185.70.40.71, server: xyz.com, request: "HEAD /.well-known/openpgpkey/policy HTTP/1.0", host: "xyz.com"
    2020/04/27 17:41:56 [error] 10541#10541: *2163626 FastCGI sent in stderr: "PHP message: WordPress database error Duplicate entry 'sc_display_custom_credit_19522_1' for key 'option_name' for query INSERT INTO wpms_options (option_name, option_value, autoload)
    SELECT 'sc_display_custom_credit_19522_1',
    GROUP_CONCAT(id SEPARATOR ','),
    'no'
    FROM wpms_posts
    WHERE post_type = 'shop_coupon'
    AND post_status = 'publish' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action('wc_ajax_update_order_review'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::update_order_review, apply_filters('woocommerce_update_order_review_fragments'), WP_Hook->apply_filters, WC_SC_Display_Coupons->woocommerce_update_order_review_fragments, WC_SC_Display_Coupons->show_available_coupons_before_checkout_form, WC_SC_Display_Coupons->show_available_coupons, WC_SC_Display_Coupons->sc_get_available_coupons_list" while reading response header from upstream, client: 66.42.75.92, server: xyz.com, request: "POST /?wc-ajax=update_order_review HTTP/1.0", upstream: "fastcgi://unix:/var/run/php/php7.3-fpm.sock:", host: "www.xyz.com", referrer: "https://www.xyz.com/checkout/"

    Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database error for smart coupons’ is closed to new replies.