• Hello,
    When I installed and activated this plugin (Version 2.1.38 ) then I got an error on Add Product page in admin panel:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR p.product_id IN (241) OR g.apply_to = 'all' GROUP BY g.id ORDER BY ' at line 5]
    SELECT g.*, GROUP_CONCAT(DISTINCT c.category_id) as <code>categories</code>, GROUP_CONCAT(DISTINCT p.product_id) as <code>products</code> FROM wp_za_groups as g LEFT JOIN wp_za_categories_to_groups as c ON c.group_id = g.id LEFT JOIN wp_za_products_to_groups as p ON p.group_id = g.id WHERE c.category_id IN () OR p.product_id IN (241) OR g.apply_to = 'all' GROUP BY g.id ORDER BY g.priority ASC

    Following is the WC status report for your reference:
    ======================================================

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://bo.byhomechefs.com
    Site address (URL): https://bo.byhomechefs.com
    WC Version: 5.6.0
    REST API Version: ? 5.6.0
    WC Blocks Version: ? 5.5.1
    Action Scheduler Version: ? 3.2.1
    WC Admin Version: ? 2.5.1
    Log Directory Writable: ? To allow logging
    make /var/www/html/wp-content/uploads/wc-logs/ writable or define a custom WC_LOG_DIR.
    
    WP Version: ? 5.6.5 - There is a newer version of WordPress available (5.9.2)
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ?
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.33 (Unix) LibreSSL/2.6.5
    PHP Version: 7.4.25
    PHP Post Max Size: 8 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.79.1
    OpenSSL/1.1.1l
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.33
    Max Upload Size: 2 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 5.6.0
    WC Database Prefix: wp_
    Total Database Size: 6.27MB
    Database Data Size: 4.58MB
    Database Index Size: 1.69MB
    wp_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.06MB + Index: 0.13MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 2.47MB + Index: 0.08MB + Engine InnoDB
    wp_postmeta: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
    wp_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    wp_sa_captured_wc_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_smsalert_booking_reminder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_smsalert_renewal_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wcfm_daily_analysis: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wcfm_detailed_analysis: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_enquiries_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_enquiries_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_enquiries_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_fbc_chat_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_fbc_chat_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wcfm_fbc_chat_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_fbc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_following_followers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wcfm_marketplace_orders_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_product_multivendor: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wcfm_marketplace_refund_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_refund_request_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_reverse_withdrawal: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_reverse_withdrawal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_reviews_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_reviews_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_review_rating_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_store_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_vendor_ledger: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_withdraw_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_marketplace_withdraw_request_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_membership_subscription: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wcfm_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_messages_modifier: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_messages_stat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_support_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_support_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcfm_support_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_za_categories_to_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_za_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_za_headers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_za_products_to_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_za_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_za_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field-group: 3
    attachment: 42
    customize_changeset: 17
    page: 11
    post: 2
    product: 11
    product_title: 1
    product_variation: 35
    product-title: 107
    revision: 4
    shop_order: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?Error messages should not be shown to visitors.
    
    ### Active Plugins (16) ###
    
    Code Snippets: by Code Snippets Pro – 2.14.3
    Custom Post Type UI: by WebDevStudios – 1.10.0
    JWT Authentication for WP-API: by Enrique Chavez – 1.2.6
    Product Add-Ons for WooCommerce: by BizSwoop a CPF Concepts
    LLC Brand – 2.1.38
    
    SMSAlert - WooCommerce: by Cozy Vision Technologies Pvt. Ltd. – 3.5.3
    WCFM - WooCommerce Frontend Manager - Groups & Staffs: by WC Lovers – 3.4.8
    WCFM - WooCommerce Frontend Manager - Ultimate: by WC Lovers – 6.6.0
    WCFM - WooCommerce Frontend Manager: by WC Lovers – 6.5.10
    WCFM - WooCommerce Multivendor Marketplace: by WC Lovers – 3.4.9
    WCFM - WooCommerce Multivendor Membership: by WC Lovers – 2.9.9
    WC Place Order Without Payment: by Nitin Prakash – 2.1
    WCFM - Category Hierarchy: by WC Lovers – 1.0.4
    WCFM - WooCommerce Multivendor Marketplace - REST API: by WC Lovers – 1.4.5
    WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.13.1
    WooCommerce: by Automattic – 5.6.0 (update to version 5.6.2 is available)
    WP Rest Api V2 Multiple PostTypes: by ElevatiInfotech – 1.0.2
    
    ### Inactive Plugins (17) ###
    
    Akismet Anti-Spam: by Automattic – 4.1.8
    Application Passwords: by George Stephanis – 0.1.3
    Better Search Replace: by Delicious Brains – 1.3.4
    CCAvenue Payment Gateway for WooCommerce: by Nilesh Chourasia – 2.9
    Disable Auto Updates: by Imran Hossain Sagor – 1.3
    Disable frontend website: by Siddharth Sharma – 1.0.0
    Elementor: by Elementor.com – 3.4.4
    Hello Dolly: by Matt Mullenweg – 1.7.2
    Inactive Logout: by Deepen Bajracharya – 2.0.2
    Login LockDown: by Michael VanDeMar – v1.8.1
    Phpinfo WP: by Imran Hossain Sagor – 2.2.3
    Query Monitor: by John Blackbourn – 3.7.1
    Two Factor Authentication: by David Anderson
    original plugin by Oskar Hane and enhanced by Dee Nutbourne – 1.13.0
    
    WCFM - Custom Menus: by WC Lovers – 1.0.0
    WCFM - WooCommerce Multivendor Marketplace - Elementor: by WC Lovers – 1.1.4
    WP Crontrol: by John Blackbourn & crontributors – 1.10.0
    WP Revisions Control: by Erick Hitter – 1.3
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: INR (?)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 0
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: –
    
    ### WC Pages ###
    
    Shop base: #6 - /shop/
    Cart: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: ByHomeChefs
    Version: 1.0.0
    Author URL: 
    Child Theme: ?
    Parent Theme Name: Storefront
    Parent Theme Version: 3.8.1 – 4.0.0 is available
    Parent Theme Author URL: https://woocommerce.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Archive Template: Your theme has a woocommerce.php file
    you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
    
    Overrides: byhomechefs/woocommerce/myaccount/dashboard.php
    
    ### Action Scheduler ###
    
    Pending: 142
    Oldest: -0001-11-30 00:00:00 +0000
    Newest: 2022-03-25 17:17:55 +0000
    
    ### Status report information ###
    
    Generated at: 2022-03-29 20:35:29 +05:30
    
  • The topic ‘Database error after plugin activation’ is closed to new replies.