Database error after plugin activation
-
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.