Dionisis Bolanis
Forum Replies Created
Viewing 12 replies - 1 through 12 (of 12 total)
-
Forum: Plugins
In reply to: [WooCommerce] ErrorsHello Again i have changed the PHP Version to php 8 just in case but the errors keep on coming.
Here is the new status:
WordPress environment WordPress address (URL): https://MyDomain Site address (URL): https://MyDomain WooCommerce version: 7.0.0 WooCommerce REST API package: 7.0.0 /home/MyDomain/public_html/wp-content/plugins/woocommerce/includes WooCommerce Blocks package: 8.5.1 /home/MyDomain/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/ Action Scheduler package: 3.5.2 /home/MyDomain/public_html/wp-content/plugins/wp-rocket/inc/Dependencies/ActionScheduler Log directory writable: /home/MyDomain/public_html/wp-content/uploads/wc-logs/ WordPress version: 6.0.3 WordPress multisite: – WordPress memory limit: 2 GB WordPress debug mode: WordPress cron: Language: en_US External object cache: – Server environment Server info: Apache PHP version: 8.0.24 PHP post max size: 50 MB PHP time limit: 1000 PHP max input vars: 10000 cURL version: 7.85.0, OpenSSL/1.1.1q SUHOSIN installed: – MySQL version: 10.3.36-MariaDB Max upload size: 50 MB Default timezone is UTC: fsockopen/cURL: SoapClient: DOMDocument: GZip: Multibyte string: Remote post: Remote get: Database WooCommerce database version: 6.7.0 Database prefix wp_ Total Database Size 2348.80MB Database Data Size 1313.07MB Database Index Size 1035.73MB wp_woocommerce_sessions Data: 73.11MB + Index: 5.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.52MB + Index: 0.14MB + Engine InnoDB wp_woocommerce_order_itemmeta Data: 3.52MB + Index: 3.00MB + 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: 1.52MB + Index: 1.88MB + 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: 364.39MB + Index: 519.95MB + Engine InnoDB wp_actionscheduler_claims Data: 0.11MB + Index: 0.08MB + Engine InnoDB wp_actionscheduler_groups Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs Data: 119.16MB + Index: 70.16MB + Engine InnoDB wp_adtribes_my_conversions Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_aiowps_debug_log Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_events Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_failed_logins Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_aiowps_global_meta Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_activity Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_lockdown Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_permanent_block Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aws_cache Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aws_index Data: 226.09MB + Index: 195.69MB + Engine InnoDB wp_commentmeta Data: 0.11MB + Index: 0.14MB + Engine InnoDB wp_comments Data: 2.52MB + Index: 1.36MB + Engine InnoDB wp_eurobank_transactions Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_links Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts Data: 4.20MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_options Data: 18.02MB + Index: 4.05MB + Engine InnoDB wp_pimwick_gift_card Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_pimwick_gift_card_activity Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_postmeta Data: 253.48MB + Index: 152.55MB + Engine InnoDB wp_posts Data: 109.16MB + Index: 15.02MB + Engine InnoDB wp_redirection_404 Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_redirection_groups Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_redirection_items Data: 0.31MB + Index: 0.34MB + Engine InnoDB wp_redirection_logs Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_termmeta Data: 1.48MB + Index: 0.72MB + Engine InnoDB wp_terms Data: 3.47MB + Index: 2.95MB + Engine InnoDB wp_term_relationships Data: 18.09MB + Index: 7.14MB + Engine InnoDB wp_term_taxonomy Data: 5.47MB + Index: 3.98MB + Engine InnoDB wp_usermeta Data: 16.06MB + Index: 5.11MB + Engine InnoDB wp_users Data: 0.41MB + Index: 0.36MB + Engine InnoDB wp_userway Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_vxcf_mailchimp Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_admin_notes Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup Data: 0.25MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup Data: 0.25MB + Index: 0.22MB + 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.41MB + Index: 0.36MB + Engine InnoDB wp_wc_order_stats Data: 0.23MB + Index: 0.22MB + Engine InnoDB wp_wc_order_tax_lookup Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup Data: 3.34MB + Index: 2.20MB + Engine InnoDB wp_wc_product_download_directories Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup Data: 4.27MB + Index: 6.83MB + Engine InnoDB wp_wc_rate_limits Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock Data: 0.05MB + 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_woobe_history Data: 1.52MB + Index: 0.92MB + Engine InnoDB wp_woobe_history_bulk Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wpda_csv_uploads Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_csv_uploads_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_csv_uploads_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_csv_uploads_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpda_project_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_page Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpda_project_page_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_page_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_page_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_publisher Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpda_publisher_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_publisher_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_publisher_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpr_rocket_cache Data: 4.52MB + Index: 6.64MB + Engine InnoDB wp_wpr_rucss_used_css Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_yoast_indexable Data: 66.56MB + Index: 22.36MB + Engine InnoDB wp_yoast_indexable_hierarchy Data: 3.34MB + Index: 4.28MB + Engine InnoDB wp_yoast_migrations Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term Data: 1.52MB + Index: 0.92MB + Engine InnoDB wp_yoast_seo_links Data: 0.31MB + Index: 0.23MB + Engine InnoDB Post Type Counts acf-field 5 acf-field-group 4 attachment 38718 blocks 19 country_restriction 3 custom_css 1 nav_menu_item 921 oembed_cache 5 page 29 polylang_mo 2 post 105 product 16570 product_variation 3188 shop_order 1796 shop_order_refund 4 ux_template 3 we_voucher_job 88 wpcf7_contact_form 4 Security Secure connection (HTTPS): Hide errors from visitors Active plugins (30) Polylang Pro by WP SYNTEX – 3.2.2 ACS Voucher For WooCommerce by Web Expert – 1.0.50 Advanced Custom Fields by WP Engine – 6.0.3 Advanced Woo Search by ILLID – 2.65 All-in-One WP Migration by ServMask – 7.66 Category Editor by Kevin Heath – 3.8.3 Integration for Contact Form 7 and Mailchimp by CRM Perks. – 1.1.2 Classic Editor by WordPress Contributors – 1.6.2 Contact Form 7 by Takayuki Miyoshi – 5.6.4 Cookie Notice & Compliance for GDPR / CCPA by Hu-manity.co – 2.4.1 Duplicate Page by mndpsingh287 – 4.4.9 Facebook Chat Plugin - Live Chat Plugin for WordPress by Meta – 2.5 hCaptcha for WordPress by hCaptcha – 2.0.0 Health Check & Troubleshooting by The www.remarpro.com community – 1.5.0 Loco Translate by Tim Whitlock – 2.6.2 Polylang for WooCommerce by WP SYNTEX – 1.6.3 Product Open Pricing (Name Your Price) for WooCommerce by WP Wham – 1.7.0 PW WooCommerce Gift Cards by Pimwick, LLC – 1.219 Really Simple SSL by Really Simple Plugins – 5.3.5 Category Order and Taxonomy Terms Order by Nsp-Code – 1.7.3 Accessibility by UserWay by UserWay.org – 2.5.0 WooCommerce Weight Based Shipping by weightbasedshipping.com – 5.3.25 BEAR – Bulk Editor and Products Manager Professional for WooCommerce by realmag777 – 1.1.2 Eurobank WooCommerce Payment Gateway by Papaki – 1.8.7.1 WooCommerce Google Analytics Integration by WooCommerce – 1.5.15 WooCommerce by Automattic – 7.0.0 Yoast SEO by Team Yoast – 19.8 WP Crontrol by John Blackbourn & crontributors – 1.14.0 WP Rocket | Enforce Trailing Slash on URLs by WP Rocket Support Team – WP Rocket by WP Media – 3.12.2 Inactive plugins (8) Country Restrictions for WooCommerce by Addify – 1.1.0 Mailchimp for WooCommerce by Mailchimp – 2.7.5 ManageWP - Worker by GoDaddy – 4.9.14 Product Feed ELITE for WooCommerce by AdTribes.io – 3.8.6 Redirection by John Godley – 5.3.4 WooCommerce - Soft1 ERP Bridge by Web Expert – 1.0.0 WOOCS - WooCommerce Currency Switcher by realmag777 – 2.3.7.5 WP Data Access by Passionate Programmers B.V. – 5.2.7 Dropin Plugins (1) advanced-cache.php advanced-cache.php Must Use Plugins (1) Health Check Troubleshooting Mode by – 1.8.0 Settings API enabled: – Force SSL: – Currency EUR (€) Currency position right_space Thousand separator . Decimal separator , Number of decimals 2 Taxonomies: Product types simple (simple), grouped (grouped), variable (variable), external (external), pw gift card (pw-gift-card) Taxonomies: Product visibility exclude-from-search (exclude-from-search), exclude-from-catalog (exclude-from-catalog), 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: – Enforce Approved Product Download Directories: – WooCommerce pages Shop base: #10 - /shop/ Cart: #11 - /cart/ Checkout: #12 - /checkout/ My account: #13 - /my-account/ Terms and conditions: #3 - /conditions-of-use/ Theme Name: MyDomain Version: 3.0 Author URL: Child theme: Parent theme name: Flatsome Parent theme version: 3.16.1 Parent theme author URL: https://uxthemes.com WooCommerce support: Templates Overrides flatsome/woocommerce/archive-product.php, flatsome/woocommerce/cart/cart-empty.php, flatsome/woocommerce/cart/cart-shipping.php, flatsome/woocommerce/cart/cart.php, flatsome/woocommerce/checkout/form-checkout.php, flatsome/woocommerce/checkout/form-coupon.php, flatsome/woocommerce/checkout/terms.php, flatsome/woocommerce/checkout/thankyou.php, flatsome/woocommerce/content-product-cat.php, flatsome/woocommerce/content-product.php, flatsome/woocommerce/content-single-product.php, flatsome/woocommerce/content-widget-product.php, flatsome/woocommerce/global/breadcrumb.php, flatsome/woocommerce/global/quantity-input.php, flatsome/woocommerce/global/wrapper-end.php, flatsome/woocommerce/global/wrapper-start.php, flatsome/woocommerce/loop/loop-end.php, flatsome/woocommerce/loop/loop-start.php, flatsome/woocommerce/loop/pagination.php, flatsome/woocommerce/loop/rating.php, flatsome/woocommerce/loop/result-count.php, flatsome/woocommerce/loop/sale-flash.php, MyDomain/woocommerce/myaccount/form-login.php version 4.1.0 is out of date. The core version is 6.0.0, flatsome/woocommerce/myaccount/navigation.php, flatsome/woocommerce/notices/error.php, flatsome/woocommerce/notices/notice.php, flatsome/woocommerce/notices/success.php, flatsome/woocommerce/product-searchform.php, flatsome/woocommerce/single-product/photoswipe.php, flatsome/woocommerce/single-product/price.php, flatsome/woocommerce/single-product/product-image.php, flatsome/woocommerce/single-product/product-thumbnails.php, flatsome/woocommerce/single-product/rating.php, MyDomain/woocommerce/single-product/related.php, flatsome/woocommerce/single-product/review.php, flatsome/woocommerce/single-product/sale-flash.php, flatsome/woocommerce/single-product/share.php, flatsome/woocommerce/single-product/short-description.php, flatsome/woocommerce/single-product/tabs/tabs.php, flatsome/woocommerce/single-product/title.php, flatsome/woocommerce/single-product/up-sells.php, flatsome/woocommerce/single-product-reviews.php, flatsome/woocommerce/single-product.php, flatsome/woocommerce/content-product_cat.php Outdated templates: Learn how to update Product Open Pricing Settings Product Open Pricing (Name Your Price): yes Frontend template: Name Your Price %open_price_input% %currency_symbol% Input field position: woocommerce_before_add_to_cart_button Position priority.: 9999 Hide price: yes Disable quantity selector: yes Display on loop: no Frontend loop template: Name Your Price %open_price_input% %currency_symbol% Input field loop position: woocommerce_after_shop_loop_item Position priority.: 9 Hide price: yes Input style: width:75px;text-align:center; Input pattern: Enable step ticker: yes Price step: 0.01 Force number of decimals: no Number of decimals.: 2 Add To Cart button text: Message on empty price: Price is required! Message on price too low: Price is too low! Message on price too high: Price is too high! Add "Open Pricing" column: no Fix mini cart: no WooCommerce pages translations Shop base: Cart: Checkout: My account: Admin Enabled Features: activity-panels, analytics, coupons, customer-effort-score-tracks, experimental-products-task, experimental-import-products-task, experimental-fashion-sample-products, experimental-product-tour, shipping-smart-defaults, shipping-setting-tour, homescreen, marketing, multichannel-marketing, mobile-app-banner, navigation, onboarding, onboarding-tasks, remote-inbox-notifications, remote-free-extensions, payment-gateway-suggestions, shipping-label-banner, subscriptions, store-alerts, transient-notices, woo-mobile-welcome, wc-pay-promotion, wc-pay-welcome-page Disabled Features: minified-js, new-product-management-experience, settings Daily Cron: Next scheduled: 2022-10-27 08:03:22 +03:00 Options: Notes: 107 Onboarding: completed Action Scheduler Version: 3.5.2 Data store: ActionScheduler_HybridStore Action Status Count Oldest Scheduled Date Newest Scheduled Date Complete 149 2022-10-26 10:59:55 +0300 2022-10-26 11:59:35 +0300 Pending 1,288,624 -0001-11-30 01:34:52 +0134 2022-10-26 11:59:35 +0300 Failed 1 2022-10-21 12:29:23 +0300 2022-10-21 12:29:23 +0300 Status report information Generated at: 2022-10-26 11:59:56 +03:00Forum: Plugins
In reply to: [WooCommerce] ErrorsHello @babylon1999
Any thoughts?
Forum: Plugins
In reply to: [WooCommerce] ErrorsHello @babylon1999
Unfortunately, no changes on the errors, and my host is informing me that Cron is properly working. The pending Scheduled Actions have decreased slowly more and more each day but they are still at 1297520.There are many errors just for 1 day, thousands of lines i will post some just from today
[24-Oct-2022 00:16:48 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_actionscheduler_actions SET attempts = attempts+1, status='in-progress', last_attempt_gmt = '2022-10-24 00:16:48', last_attempt_local = '2022-10-24 03:16:48' WHERE action_id = 1690414 made by do_action('wp_ajax_nopriv_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_HybridStore->log_execution, ActionScheduler_DBStore->log_execution [24-Oct-2022 00:17:24 UTC] PHP Notice: Trying to get property 'query_vars' of non-object in /home/_______/public_html/wp-content/plugins/woocommerce/includes/class-wc-query.php on line 842 [24-Oct-2022 00:17:24 UTC] PHP Notice: Trying to get property 'query_vars' of non-object in /home/_______/public_html/wp-content/plugins/woocommerce/includes/class-wc-query.php on line 854 [24-Oct-2022 00:17:24 UTC] PHP Notice: Trying to get property 'post_count' of non-object in /home/_______/public_html/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-price-filter.php on line 80 [24-Oct-2022 00:17:24 UTC] PHP Notice: Trying to get property 'query_vars' of non-object in /home/_______/public_html/wp-content/plugins/woocommerce/includes/class-wc-query.php on line 842 [24-Oct-2022 00:17:24 UTC] PHP Notice: Trying to get property 'query_vars' of non-object in /home/_______/public_html/wp-content/plugins/woocommerce/includes/class-wc-query.php on line 854 [24-Oct-2022 00:17:24 UTC] PHP Notice: Trying to get property 'query_vars' of non-object in /home/_______/public_html/wp-content/plugins/woocommerce/includes/class-wc-query.php on line 842 [24-Oct-2022 00:17:24 UTC] PHP Notice: Trying to get property 'query_vars' of non-object in /home/_______/public_html/wp-content/plugins/woocommerce/includes/class-wc-query.php on line 854 [24-Oct-2022 00:24:00 UTC] WordPress database error 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 '( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT...' at line 6 for query SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM wp_wc_product_attributes_lookup LEFT JOIN wp_term_relationships ON (wp_wc_product_attributes_lookup.product_or_parent_id = wp_term_relationships.object_id) INNER JOIN wp_posts ON wp_posts.ID = wp_wc_product_attributes_lookup.product_or_parent_id WHERE wp_posts.post_type IN ( 'product' ) AND wp_posts.post_status = 'publish' ( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (6) ) wp_term_relationships.term_taxonomy_id IN (3825) ) AND wp_wc_product_attributes_lookup.taxonomy='pa_brand' AND wp_wc_product_attributes_lookup.term_id IN (40959,2114,2893,2146,3824,2958,3070,24606,3184,41723,3016,39803,3632,24115,39288,38417,3459,26675,29515,3467,3431,29519,35973,36468,36692,1614,30686,36263,39384,2009,27517,28059,3074,40438,26801,24651,1836,26697,42718,3449,1838,3473,24528,34922,43706,1822,3078,31064,3718,2897,3188,2940,2895,3816,3160,27169,40373,3757,41804,42430,29524,41110,3501,2972,27368,3046,3668,24087,26955,2956,2952,30535,24125,24536,1832,2833,27242,3082,2885,2966,41078,24572,3068,27563,42434,26893,3657,42140,3176,34909,35279,24442,33359,3006,2996,3128,2954,30796,3072,1828,1826,29444,43504,2821,3186,43600,29425,37288,3154,3164,32528,3116,37197,3507,3447,3340,39846,3022,29500,1834,3170,40685,2879,3166,3445,34927,24074,3475,3196,3453,24452,42656,3120,3471,30317,3818,3661,24103,3796,32658,3136,3372,3483,1824,2767,32411,3018,3168,43685,2909,35865,3463,1830,33145,3132,3336,37479,3503,3030,2158,3705,29592,3010,40708,40500,29005,24839,3094,2647,26908,24030,37276,2781,2124,24590,27910,3148,29286,3465,2982,2942,3666,24446,27993,40683,3180,29594,3004,3491,34422,1850,3487,34931,2891,28299,36290,29532,2911,3034,29455,29419,31323,32843,43449,24876,27088,2637,1536,24169,34380,2099,29415,2128,41084,41817,2590,2964,24119,29586,38864,40957,29411,2875,3126,24072,43594,42148,41453,41840,29538,28601,27616,24157,3080,33365,2259,26218,3798,43745,28195,3730,27360,24193,2970,3505,3178,43514,3008,37248,3198,2986,27845,42587,2901,36056,3118,2779,34704,3156,2938,3026,35671,29773,29318,38861,3719,35585,3457,2907,2960,3489,3731,37809,28079,36927,3797,3455,30154,3439,26613,35679,34168,3194,24113,3461,1840,42583,37265,28201,29528,2247,35085,3370,3795,3028,2771,24186,43506,29403,3020,2160,34937,38756,29409,2823,29553,40201,35751,27896,2803,3374,3338,3138,3084,2231,2980,3799,30236,2807,3044,2164,24646,35685,3477,35491,41832,3659,25849,30834,30176,34907,1842,2845,40990,1846,28311,3704,40098,29477,28354,3368,24034,29493,3479,29399,3433,40450,3800,24091,3014,38445,24123,43157,2948,41717,2645,2817,28087,1820,2039,29645,41797,3443,43679,2805,3602,3497,2887,35603,38451,3332,2799,3634,34546,2819,40921,43455,3048,36659,29540,34901,29363,29600,3054,36578,3066,42144,3726,2903,3481,24133,2827,3002,2118,3499,2998,3725,37280,1758,40139,2889,37258,32772,32594,29465,30186,24111,3190,27219,43498,3729) GROUP BY wp_wc_product_attributes_lookup.term_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/woocommerce/archive-product.php'), wc_get_template_part, load_template, require('/themes/_______/woocommerce/layouts/category.php'), dynamic_sidebar, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, WC_Widget_Layered_Nav->layered_nav_dropdown, WC_Widget_Layered_Nav->get_filtered_term_product_counts, Automattic\WooCommerce\Internal\ProductAttributesLookup\Filterer->get_filtered_term_product_counts [24-Oct-2022 00:24:00 UTC] WordPress database error 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 '( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT...' at line 6 for query SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM wp_wc_product_attributes_lookup LEFT JOIN wp_term_relationships ON (wp_wc_product_attributes_lookup.product_or_parent_id = wp_term_relationships.object_id) INNER JOIN wp_posts ON wp_posts.ID = wp_wc_product_attributes_lookup.product_or_parent_id WHERE wp_posts.post_type IN ( 'product' ) AND wp_posts.post_status = 'publish' ( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (6) ) wp_term_relationships.term_taxonomy_id IN (3825) ) AND wp_wc_product_attributes_lookup.taxonomy='pa_age-group' AND wp_wc_product_attributes_lookup.term_id IN (3728,2913,24046,24050,2944,24190,24165,24167,24161,3819,2946,24195,24159,3012,3687,2261) GROUP BY wp_wc_product_attributes_lookup.term_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/woocommerce/archive-product.php'), wc_get_template_part, load_template, require('/themes/_______/woocommerce/layouts/category.php'), dynamic_sidebar, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, WC_Widget_Layered_Nav->layered_nav_dropdown, WC_Widget_Layered_Nav->get_filtered_term_product_counts, Automattic\WooCommerce\Internal\ProductAttributesLookup\Filterer->get_filtered_term_product_counts [24-Oct-2022 00:24:00 UTC] WordPress database error 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 '( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT...' at line 6 for query SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM wp_wc_product_attributes_lookup LEFT JOIN wp_term_relationships ON (wp_wc_product_attributes_lookup.product_or_parent_id = wp_term_relationships.object_id) INNER JOIN wp_posts ON wp_posts.ID = wp_wc_product_attributes_lookup.product_or_parent_id WHERE wp_posts.post_type IN ( 'product' ) AND wp_posts.post_status = 'publish' ( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (6) ) wp_term_relationships.term_taxonomy_id IN (3825) ) AND wp_wc_product_attributes_lookup.taxonomy='pa_skin-type' AND wp_wc_product_attributes_lookup.term_id IN (3732,24083,3688,3734,24038,3722,30989,33013,2556,24032,3741,24058,24064,3733,3735,2552,3723,29741,2697,24062,24054,2554,25216,24060,25517,24052,3724,24089,3738) GROUP BY wp_wc_product_attributes_lookup.term_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/woocommerce/archive-product.php'), wc_get_template_part, load_template, require('/themes/_______/woocommerce/layouts/category.php'), dynamic_sidebar, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, WC_Widget_Layered_Nav->layered_nav_dropdown, WC_Widget_Layered_Nav->get_filtered_term_product_counts, Automattic\WooCommerce\Internal\ProductAttributesLookup\Filterer->get_filtered_term_product_counts [24-Oct-2022 03:14:11 UTC] PHP Fatal error: Uncaught RuntimeException: Unable to claim actions. Database error. in /home/_______/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:683 Stack trace: #0 /home/_______/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(597): ActionScheduler_DBStore->claim_actions(1307679, 25, NULL, Array, '') #1 /home/_______/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(221): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '') #2 /home/_______/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(153): ActionScheduler_HybridStore->stake_claim(25) #3 /home/_______/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch(25, 'Async Request') #4 /home/_______/public_ht in /home/_______/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 683 [24-Oct-2022 07:54:29 UTC] WordPress database error 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 '( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT...' at line 6 for query SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM wp_wc_product_attributes_lookup LEFT JOIN wp_term_relationships ON (wp_wc_product_attributes_lookup.product_or_parent_id = wp_term_relationships.object_id) INNER JOIN wp_posts ON wp_posts.ID = wp_wc_product_attributes_lookup.product_or_parent_id WHERE wp_posts.post_type IN ( 'product' ) AND wp_posts.post_status = 'publish' ( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (6) ) wp_term_relationships.term_taxonomy_id IN (3825) ) AND wp_wc_product_attributes_lookup.taxonomy='pa_brand' AND wp_wc_product_attributes_lookup.term_id IN (40959,2114,2893,2146,3824,2958,3070,24606,3184,41723,3016,39803,3632,24115,39288,38417,3459,26675,29515,3467,3431,29519,35973,36468,36692,1614,30686,36263,39384,2009,27517,28059,3074,40438,26801,24651,1836,26697,42718,3449,1838,3473,24528,34922,43706,1822,3078,31064,3718,2897,3188,2940,2895,3816,3160,27169,40373,3757,41804,42430,29524,41110,3501,2972,27368,3046,3668,24087,26955,2956,2952,30535,24125,24536,1832,2833,27242,3082,2885,2966,41078,24572,3068,27563,42434,26893,3657,42140,3176,34909,35279,24442,33359,3006,2996,3128,2954,30796,3072,1828,1826,29444,43504,2821,3186,43600,29425,37288,3154,3164,32528,3116,37197,3507,3447,3340,39846,3022,29500,1834,3170,40685,2879,3166,3445,34927,24074,3475,3196,3453,24452,42656,3120,3471,30317,3818,3661,24103,3796,32658,3136,3372,3483,1824,2767,32411,3018,3168,43685,2909,35865,3463,1830,33145,3132,3336,37479,3503,3030,2158,3705,29592,3010,40708,40500,29005,24839,3094,2647,26908,24030,37276,2781,2124,24590,27910,3148,29286,3465,2982,2942,3666,24446,27993,40683,3180,29594,3004,3491,34422,1850,3487,34931,2891,28299,36290,29532,2911,3034,29455,29419,31323,32843,43449,24876,27088,2637,1536,24169,34380,2099,29415,2128,41084,41817,2590,2964,24119,29586,38864,40957,29411,2875,3126,24072,43594,42148,41453,41840,29538,28601,27616,24157,3080,33365,2259,26218,3798,43745,28195,3730,27360,24193,2970,3505,3178,43514,3008,37248,3198,2986,27845,42587,2901,36056,3118,2779,34704,3156,2938,3026,35671,29773,29318,38861,3719,35585,3457,2907,2960,3489,3731,37809,28079,36927,3797,3455,30154,3439,26613,35679,34168,3194,24113,3461,1840,42583,37265,28201,29528,2247,35085,3370,3795,3028,2771,24186,43506,29403,3020,2160,34937,38756,29409,2823,29553,40201,35751,27896,2803,3374,3338,3138,3084,2231,2980,3799,30236,2807,3044,2164,24646,35685,3477,35491,41832,3659,25849,30834,30176,34907,1842,2845,40990,1846,28311,3704,40098,29477,28354,3368,24034,29493,3479,29399,3433,40450,3800,24091,3014,38445,24123,43157,2948,41717,2645,2817,28087,1820,2039,29645,41797,3443,43679,2805,3602,3497,2887,35603,38451,3332,2799,3634,34546,2819,40921,43455,3048,36659,29540,34901,29363,29600,3054,36578,3066,42144,3726,2903,3481,24133,2827,3002,2118,3499,2998,3725,37280,1758,43761,40139,2889,37258,32772,32594,29465,30186,24111,3190,27219,43498,3729) GROUP BY wp_wc_product_attributes_lookup.term_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/woocommerce/archive-product.php'), wc_get_template_part, load_template, require('/themes/_______/woocommerce/layouts/category.php'), dynamic_sidebar, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, WC_Widget_Layered_Nav->layered_nav_dropdown, WC_Widget_Layered_Nav->get_filtered_term_product_counts, Automattic\WooCommerce\Internal\ProductAttributesLookup\Filterer->get_filtered_term_product_counts [24-Oct-2022 07:54:29 UTC] WordPress database error 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 '( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT...' at line 6 for query SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM wp_wc_product_attributes_lookup LEFT JOIN wp_term_relationships ON (wp_wc_product_attributes_lookup.product_or_parent_id = wp_term_relationships.object_id) INNER JOIN wp_posts ON wp_posts.ID = wp_wc_product_attributes_lookup.product_or_parent_id WHERE wp_posts.post_type IN ( 'product' ) AND wp_posts.post_status = 'publish' ( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (6) ) wp_term_relationships.term_taxonomy_id IN (3825) ) AND wp_wc_product_attributes_lookup.taxonomy='pa_age-group' AND wp_wc_product_attributes_lookup.term_id IN (3728,2913,24046,24050,2944,24190,24165,24167,24161,3819,2946,24195,24159,3012,3687,2261) GROUP BY wp_wc_product_attributes_lookup.term_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/woocommerce/archive-product.php'), wc_get_template_part, load_template, require('/themes/_______/woocommerce/layouts/category.php'), dynamic_sidebar, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, WC_Widget_Layered_Nav->layered_nav_dropdown, WC_Widget_Layered_Nav->get_filtered_term_product_counts, Automattic\WooCommerce\Internal\ProductAttributesLookup\Filterer->get_filtered_term_product_counts [24-Oct-2022 07:54:29 UTC] WordPress database error 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 '( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT...' at line 6 for query SELECT COUNT(DISTINCT product_or_parent_id) as term_count, term_id as term_count_id FROM wp_wc_product_attributes_lookup LEFT JOIN wp_term_relationships ON (wp_wc_product_attributes_lookup.product_or_parent_id = wp_term_relationships.object_id) INNER JOIN wp_posts ON wp_posts.ID = wp_wc_product_attributes_lookup.product_or_parent_id WHERE wp_posts.post_type IN ( 'product' ) AND wp_posts.post_status = 'publish' ( wp_wc_product_attributes_lookup.product_or_parent_id NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (6) ) wp_term_relationships.term_taxonomy_id IN (3825) ) AND wp_wc_product_attributes_lookup.taxonomy='pa_skin-type' AND wp_wc_product_attributes_lookup.term_id IN (3732,24083,3688,3734,24038,3722,30989,33013,2556,24032,3741,24058,24064,3733,3735,2552,3723,29741,2697,24062,24054,2554,25216,24060,25517,24052,3724,24089,3738) GROUP BY wp_wc_product_attributes_lookup.term_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/woocommerce/archive-product.php'), wc_get_template_part, load_template, require('/themes/_______/woocommerce/layouts/category.php'), dynamic_sidebar, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, WC_Widget_Layered_Nav->layered_nav_dropdown, WC_Widget_Layered_Nav->get_filtered_term_product_counts, Automattic\WooCommerce\Internal\ProductAttributesLookup\Filterer->get_filtered_term_product_counts [24-Oct-2022 09:35:48 UTC] WordPress database error Unknown column 'wp_posts.ID' in 'on clause' for query SELECT COUNT(*) FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID INNER JOIN wp_term_relationships AS pll_tr ON pll_tr.object_id = wp_posts.ID WHERE ( ( comment_approved = '0' OR comment_approved = '1' ) ) AND user_id = 437 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' AND wp_posts_to_exclude_reviews.post_type NOT IN ('product') AND pll_tr.term_taxonomy_id IN ( 3825 ) ORDER BY wp_comments.comment_date_gmt DESC made by WP_List_Table->views, WP_Comments_List_Table->get_views, get_comments, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->get_comment_ids- This reply was modified 2 years, 4 months ago by Dionisis Bolanis.
Forum: Plugins
In reply to: [WooCommerce] ErrorsThank you so much !!
I have increased it.
Here is the status Report
WordPress address (URL): https://--------.com Site address (URL): https://_________.com WooCommerce version: 7.0.0 WooCommerce REST API package: 7.0.0 /home/_____/public_html/wp-content/plugins/woocommerce/includes WooCommerce Blocks package: 8.5.1 /home/_____/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/ Action Scheduler package: 3.4.0 /home/______/public_html/wp-content/plugins/woocommerce/packages/action-scheduler Log directory writable: /home/_______/public_html/wp-content/uploads/wc-logs/ WordPress version: 6.0.3 WordPress multisite: – WordPress memory limit: 2 GB WordPress debug mode: WordPress cron: Language: en_US External object cache: – Server environment Server info: Apache PHP version: 7.4.32 PHP post max size: 50 MB PHP time limit: 1000 PHP max input vars: 10000 cURL version: 7.85.0, OpenSSL/1.1.1q SUHOSIN installed: – MySQL version: 5.5.5-10.3.36-MariaDB Max upload size: 50 MB Default timezone is UTC: fsockopen/cURL: SoapClient: DOMDocument: GZip: Multibyte string: Remote post: Remote get: Database WooCommerce database version: 6.7.0 Database prefix wp_ Total Database Size 2308.00MB Database Data Size 1272.30MB Database Index Size 1035.70MB wp_woocommerce_sessions Data: 34.06MB + Index: 5.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.52MB + Index: 0.14MB + Engine InnoDB wp_woocommerce_order_itemmeta Data: 3.52MB + Index: 3.00MB + 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: 1.52MB + Index: 1.88MB + 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: 365.41MB + Index: 520.95MB + Engine InnoDB wp_actionscheduler_claims Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_actionscheduler_groups Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs Data: 119.16MB + Index: 70.16MB + Engine InnoDB wp_adtribes_my_conversions Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_aiowps_debug_log Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_events Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_failed_logins Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_aiowps_global_meta Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_activity Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_lockdown Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_permanent_block Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aws_cache Data: 0.30MB + Index: 0.00MB + Engine InnoDB wp_aws_index Data: 226.09MB + Index: 195.69MB + Engine InnoDB wp_commentmeta Data: 0.11MB + Index: 0.14MB + Engine InnoDB wp_comments Data: 2.52MB + Index: 1.36MB + Engine InnoDB wp_eurobank_transactions Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_links Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts Data: 4.20MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_options Data: 15.02MB + Index: 3.05MB + Engine InnoDB wp_pimwick_gift_card Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_pimwick_gift_card_activity Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_postmeta Data: 253.48MB + Index: 152.55MB + Engine InnoDB wp_posts Data: 109.16MB + Index: 15.02MB + Engine InnoDB wp_redirection_404 Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_redirection_groups Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_redirection_items Data: 0.31MB + Index: 0.34MB + Engine InnoDB wp_redirection_logs Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_termmeta Data: 1.48MB + Index: 0.72MB + Engine InnoDB wp_terms Data: 3.47MB + Index: 2.95MB + Engine InnoDB wp_term_relationships Data: 18.09MB + Index: 7.14MB + Engine InnoDB wp_term_taxonomy Data: 5.47MB + Index: 3.98MB + Engine InnoDB wp_usermeta Data: 16.06MB + Index: 5.11MB + Engine InnoDB wp_users Data: 0.41MB + Index: 0.36MB + Engine InnoDB wp_userway Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_vxcf_mailchimp Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_admin_notes Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup Data: 0.25MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup Data: 0.25MB + Index: 0.22MB + 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.41MB + Index: 0.36MB + Engine InnoDB wp_wc_order_stats Data: 0.23MB + Index: 0.22MB + Engine InnoDB wp_wc_order_tax_lookup Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup Data: 3.34MB + Index: 2.20MB + Engine InnoDB wp_wc_product_download_directories Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup Data: 4.27MB + Index: 6.83MB + Engine InnoDB wp_wc_rate_limits Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock Data: 0.05MB + 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_woobe_history Data: 1.52MB + Index: 0.92MB + Engine InnoDB wp_woobe_history_bulk Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wpda_csv_uploads Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_csv_uploads_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_csv_uploads_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_csv_uploads_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_logging_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_media_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_menus_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpda_project_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_page Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpda_project_page_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_page_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_page_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_project_table_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_publisher Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpda_publisher_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_publisher_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_publisher_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_design_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings_BACKUP_20220622101843 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings_BACKUP_20220714091535 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpda_table_settings_BACKUP_20221013063224 Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpr_rocket_cache Data: 4.52MB + Index: 6.64MB + Engine InnoDB wp_wpr_rucss_used_css Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_yoast_indexable Data: 66.56MB + Index: 22.36MB + Engine InnoDB wp_yoast_indexable_hierarchy Data: 3.34MB + Index: 4.28MB + Engine InnoDB wp_yoast_migrations Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term Data: 1.52MB + Index: 0.92MB + Engine InnoDB wp_yoast_seo_links Data: 0.31MB + Index: 0.23MB + Engine InnoDB Post Type Counts acf-field 5 acf-field-group 4 attachment 38642 blocks 19 country_restriction 3 custom_css 1 nav_menu_item 921 oembed_cache 5 page 29 polylang_mo 2 post 101 product 16553 product_variation 3178 revision 5 shop_order 1782 shop_order_refund 2 ux_template 3 we_voucher_job 86 wpcf7_contact_form 4 Security Secure connection (HTTPS): Hide errors from visitors Active plugins (29) Polylang Pro by WP SYNTEX – 3.2.2 ACS Voucher For WooCommerce by Web Expert – 1.0.50 Advanced Custom Fields by WP Engine – 6.0.3 Advanced Woo Search by ILLID – 2.65 All-in-One WP Migration by ServMask – 7.66 Category Editor by Kevin Heath – 3.8.3 Integration for Contact Form 7 and Mailchimp by CRM Perks. – 1.1.2 Classic Editor by WordPress Contributors – 1.6.2 Contact Form 7 by Takayuki Miyoshi – 5.6.3 Cookie Notice & Compliance for GDPR / CCPA by Hu-manity.co – 2.4.1 Duplicate Page by mndpsingh287 – 4.4.9 Facebook Chat Plugin - Live Chat Plugin for WordPress by Meta – 2.5 hCaptcha for Forms and More by hCaptcha – 1.19.0 Health Check & Troubleshooting by The www.remarpro.com community – 1.5.0 Loco Translate by Tim Whitlock – 2.6.2 Polylang for WooCommerce by WP SYNTEX – 1.6.3 Product Open Pricing (Name Your Price) for WooCommerce by WP Wham – 1.7.0 PW WooCommerce Gift Cards by Pimwick, LLC – 1.218 Really Simple SSL by Really Simple Plugins – 5.3.5 Category Order and Taxonomy Terms Order by Nsp-Code – 1.7.1 Accessibility by UserWay by UserWay.org – 2.5.0 WooCommerce Weight Based Shipping by weightbasedshipping.com – 5.3.24 BEAR – Bulk Editor and Products Manager Professional for WooCommerce by realmag777 – 1.1.2 Eurobank WooCommerce Payment Gateway by Papaki – 1.8.7.1 WooCommerce Google Analytics Integration by WooCommerce – 1.5.15 WooCommerce by Automattic – 7.0.0 Yoast SEO by Team Yoast – 19.8 WP Rocket | Enforce Trailing Slash on URLs by WP Rocket Support Team – WP Rocket by WP Media – 3.12.1.1 Inactive plugins (8) Country Restrictions for WooCommerce by Addify – 1.1.0 Mailchimp for WooCommerce by Mailchimp – 2.7.5 ManageWP - Worker by GoDaddy – 4.9.14 Product Feed ELITE for WooCommerce by AdTribes.io – 3.8.6 Redirection by John Godley – 5.3.4 WooCommerce - Soft1 ERP Bridge by Web Expert – 1.0.0 WOOCS - WooCommerce Currency Switcher by realmag777 – 2.3.7.5 WP Data Access by Passionate Programmers B.V. – 5.2.6 Dropin Plugins (1) advanced-cache.php advanced-cache.php Must Use Plugins (1) Health Check Troubleshooting Mode by – 1.8.0 Settings API enabled: – Force SSL: – Currency EUR (€) Currency position right_space Thousand separator . Decimal separator , Number of decimals 2 Taxonomies: Product types simple (simple), grouped (grouped), variable (variable), external (external), pw gift card (pw-gift-card) Taxonomies: Product visibility exclude-from-search (exclude-from-search), exclude-from-catalog (exclude-from-catalog), 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: – Enforce Approved Product Download Directories: – WooCommerce pages Shop base: #10 - /shop/ Cart: #11 - /cart/ Checkout: #12 - /checkout/ My account: #13 - /my-account/ Terms and conditions: #3 - /conditions-of-use/ Theme Name: ______________ Version: 3.0 Author URL: Child theme: Parent theme name: Flatsome Parent theme version: 3.16.1 Parent theme author URL: https://uxthemes.com WooCommerce support: Templates Overrides flatsome/woocommerce/archive-product.php, flatsome/woocommerce/cart/cart-empty.php, flatsome/woocommerce/cart/cart-shipping.php, flatsome/woocommerce/cart/cart.php, flatsome/woocommerce/checkout/form-checkout.php, flatsome/woocommerce/checkout/form-coupon.php, flatsome/woocommerce/checkout/terms.php, flatsome/woocommerce/checkout/thankyou.php, flatsome/woocommerce/content-product-cat.php, flatsome/woocommerce/content-product.php, flatsome/woocommerce/content-single-product.php, flatsome/woocommerce/content-widget-product.php, flatsome/woocommerce/global/breadcrumb.php, flatsome/woocommerce/global/quantity-input.php, flatsome/woocommerce/global/wrapper-end.php, flatsome/woocommerce/global/wrapper-start.php, flatsome/woocommerce/loop/loop-end.php, flatsome/woocommerce/loop/loop-start.php, flatsome/woocommerce/loop/pagination.php, flatsome/woocommerce/loop/rating.php, flatsome/woocommerce/loop/result-count.php, flatsome/woocommerce/loop/sale-flash.php, _________/woocommerce/myaccount/form-login.php version 4.1.0 is out of date. The core version is 6.0.0, flatsome/woocommerce/myaccount/navigation.php, flatsome/woocommerce/notices/error.php, flatsome/woocommerce/notices/notice.php, flatsome/woocommerce/notices/success.php, flatsome/woocommerce/product-searchform.php, flatsome/woocommerce/single-product/photoswipe.php, flatsome/woocommerce/single-product/price.php, flatsome/woocommerce/single-product/product-image.php, flatsome/woocommerce/single-product/product-thumbnails.php, flatsome/woocommerce/single-product/rating.php, _________/woocommerce/single-product/related.php, flatsome/woocommerce/single-product/review.php, flatsome/woocommerce/single-product/sale-flash.php, flatsome/woocommerce/single-product/share.php, flatsome/woocommerce/single-product/short-description.php, flatsome/woocommerce/single-product/tabs/tabs.php, flatsome/woocommerce/single-product/title.php, flatsome/woocommerce/single-product/up-sells.php, flatsome/woocommerce/single-product-reviews.php, flatsome/woocommerce/single-product.php, flatsome/woocommerce/content-product_cat.php Outdated templates: Learn how to update Product Open Pricing Settings Product Open Pricing (Name Your Price): yes Frontend template: Name Your Price %open_price_input% %currency_symbol% Input field position: woocommerce_before_add_to_cart_button Position priority.: 9999 Hide price: yes Disable quantity selector: yes Display on loop: no Frontend loop template: Name Your Price %open_price_input% %currency_symbol% Input field loop position: woocommerce_after_shop_loop_item Position priority.: 9 Hide price: yes Input style: width:75px;text-align:center; Input pattern: Enable step ticker: yes Price step: 0.01 Force number of decimals: no Number of decimals.: 2 Add To Cart button text: Message on empty price: Price is required! Message on price too low: Price is too low! Message on price too high: Price is too high! Add "Open Pricing" column: no Fix mini cart: no WooCommerce pages translations Shop base: Cart: Checkout: My account: Admin Enabled Features: activity-panels, analytics, coupons, customer-effort-score-tracks, experimental-products-task, experimental-import-products-task, experimental-fashion-sample-products, experimental-product-tour, shipping-smart-defaults, shipping-setting-tour, homescreen, marketing, multichannel-marketing, mobile-app-banner, navigation, onboarding, onboarding-tasks, remote-inbox-notifications, remote-free-extensions, payment-gateway-suggestions, shipping-label-banner, subscriptions, store-alerts, transient-notices, woo-mobile-welcome, wc-pay-promotion, wc-pay-welcome-page Disabled Features: minified-js, new-product-management-experience, settings Daily Cron: Next scheduled: 2022-10-24 08:03:22 +03:00 Options: Notes: 106 Onboarding: completed Action Scheduler Version: 3.4.0 Data store: ActionScheduler_HybridStore Action Status Count Oldest Scheduled Date Newest Scheduled Date Complete 153 2022-10-23 19:24:21 +0300 2022-10-23 20:23:49 +0300 Pending 1,300,930 -0001-11-30 01:34:52 +0134 2022-10-23 20:22:01 +0300 Failed 1 2022-10-21 12:29:23 +0300 2022-10-21 12:29:23 +0300 Status report information Generated at: 2022-10-23 20:24:26 +03:00`
Also while checking the debug log i found a lot of problems,
[13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): price_with_vat><manufacturer>Korres</manufacturer><availability/><g:availability in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): ^ in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): /home/fotoefi/public_html/wp-content/uploads/woo-product-feed-pro/xml/F10XgPPBNxPZbK9L5UMdvUfuWqPdVt7m_tmp.xml:2: namespace error : Namespace prefix g on link is not defined in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): t><product><name>Korres Wild Rose Illuminating Powder 4.5gr</name><link/><g:link in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): ^ in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): /home/fotoefi/public_html/wp-content/uploads/woo-product-feed-pro/xml/F10XgPPBNxPZbK9L5UMdvUfuWqPdVt7m_tmp.xml:2: namespace error : Namespace prefix g on image_link is not defined in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): t/korres-wild-rose-illuminating-powder-4-5gr/</g:link><image_link/><g:image_link in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): ^ in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): /home/fotoefi/public_html/wp-content/uploads/woo-product-feed-pro/xml/F10XgPPBNxPZbK9L5UMdvUfuWqPdVt7m_tmp.xml:2: namespace error : Namespace prefix g on availability is not defined in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): price_with_vat><manufacturer>Korres</manufacturer><availability/><g:availability in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): ^ in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): /home/fotoefi/public_html/wp-content/uploads/woo-product-feed-pro/xml/F10XgPPBNxPZbK9L5UMdvUfuWqPdVt7m_tmp.xml:2: namespace error : Namespace prefix g on link is not defined in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): uct><product><name>Korres Wild Rose Brightening Powder 10gr</name><link/><g:link in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): ^ in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): /home/fotoefi/public_html/wp-content/uploads/woo-product-feed-pro/xml/F10XgPPBNxPZbK9L5UMdvUfuWqPdVt7m_tmp.xml:2: namespace error : Namespace prefix g on image_link is not defined in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): uct/korres-wild-rose-brightening-powder-wrp2/</g:link><image_link/><g:image_link in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526 [13-Oct-2022 08:54:23 UTC] PHP Warning: simplexml_load_file(): ^ in /home/fotoefi/public_html/wp-content/plugins/woo-product-feed-elite/classes/class-get-products.php on line 1526But a lot of those
I did that and while it fixes the problem with the duplicates it gives me quite a lot:
This page contains the following errors:
error on line 2 at column 2365315: Namespace prefix g on the link is not defined
Below is a rendering of the page up to the first error.I have to regenerate the feed to fix it, BUT i wish this feed to generate hourly and me going to regenerate it kinda defeats the meaning of having automatic works.
Do you know why the problem above appears?
Unfortunately, i got the batch down to 300 and even tho it does not give me errors it still gets a lot of duplicates. Any ideas? No we are not using any external cron. Plus i dont see any fatal errors regarding Product feed ellite
Forum: Plugins
In reply to: [Pods - Custom Content Types and Fields] Pod extra Fields not workingGood Evening,
Do we have any news about the problem?
Thank you for your time.
Best Regards
DionisisForum: Plugins
In reply to: [Pods - Custom Content Types and Fields] Pod extra Fields not workingHello Paul,
Thank you for your fast responce!
I did what you sed and it fixed the file upload but not the date problem.
Thank you for your fast reply, i will go there
Wow Thank you it seems that this did the trick. May i ask why did this happen?
Hello
No no, we wish it to show the result only on the current language.
For example when we see the English part of the page to show only the English result and not both
Viewing 12 replies - 1 through 12 (of 12 total)