Database error in every order

We're shifting our Forum based support to a more dedicated support system!

We'll be closing our Forum support from 10th June, 2020 and move to Email Support assistance.

  • If you are a WCFM premium add-ons user, contact us- here
  • Want to know more before buying our add-ons? Send Pre sale queries- here
  • If you are a WCFM free user, please open a support ticket at WordPress.org
  • For WCFM App related queries, reach us- here
From now the forum will be read-only!

Multi Vendor Marketplace Plugin | WCFM Marketplace › Forums › WCFM – Ultimate › Database error in every order

Viewing 1 reply thread
  • Author
    Posts
    • June 17, 2019 at 2:12 pm #68079
      CommunityCorals
      Participant

      Hello,

      could you please check the error message below. It is shown in every order. Thanks.

      WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘AND is_refunded != 1′ at line 11]
      SELECT SUM(commission_amount) as line_total, SUM(item_total) as item_total, SUM(item_sub_total) as item_sub_total, SUM(shipping) as shipping, SUM(tax) as tax, SUM( shipping_tax_amount) as shipping_tax_amount, SUM( refunded_amount) as refunded_amount FROM gxRTKcRxwcfm_marketplace_orders WHERE order_id = 55474 AND vendor_id = AND is_refunded != 1

    • June 18, 2019 at 2:33 pm #68381
      WCFM Forum
      Member

      Hi,

      Do you have edited this database table manually?

      Thank You

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.