Database Error

[thiemann.k]

Hey Community,

I’m tidying up our database and have been notified by the “Querry Montior” plugin that a table in the database is corrupted.

Querry:
SELECT SUM( commission.item_total ) AS item_total, commission.vendor_id AS vendor_id
FROM wp_wcfm_marketplace_orders AS commission
WHERE 1=1
AND commission.order_status IN (‘pending’, ‘processing’, ‘completed’)
AND is_refunded != 1
AND is_trashed != 1
GROUP BY vendor_id
ORDER BY item_total DESC LIMIT

Caller:
WCFMmp_Vendor->wcfmmp_best_selling_vendors() +

wp-content/plugins/wc-multivendor-marketplace/core/class-wcfmmp-vendor.php:2955
–
WCFMmp_Store_Best_Selling_Vendors->widget()
wp-content/plugins/wc-multivendor-marketplace/includes/store-widgets/class-wcfmmp-widget-store-best-selling-vendors.php:36
WP_Widget->display_callback()
wp-includes/class-wp-widget.php:378
Mega_Menu_Widget_Manager->show_widget()
wp-content/plugins/megamenu/classes/widget-manager.class.php:846
Mega_Menu->add_widgets_to_menu()
wp-content/plugins/megamenu/megamenu.php:655
apply_filters(‘wp_nav_menu_objects’)
wp-includes/plugin.php:208
wp_nav_menu()
wp-includes/nav-menu-template.php:211
load_template(‘wp-content/themes/storefront-child-theme-master/header.php’)
wp-includes/template.php:722
locate_template()
wp-includes/template.php:671
get_header()
wp-includes/general-template.php:41

Component
Plugin: wc-multivendor-marketplace

Error Message
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 ” at line 1

https://ibb.co/F5tpx0w
https://ibb.co/FzGWXsv

Can anyone help me?

Ciao, Karsten

[WCFM Forum]

Hi,

What is your WCFM and WCFM Marketplace plugins version?

Thank You

[thiemann.k]

WCFM = Version 6.3.2

WCFM = Version 3.2.4

[WCFM Forum]

HI,

Well, there is nothing wrong in this query.

Kindly share your site access with us, we have to debug this in your site – https://wclovers.com/woocommerce-multivendor-customization/

Thank you

[Author]

Posts