alinnz
Forum Replies Created
-
I tried to deactivate all other plugins and changed to WordPress default theme and browser cache was cleared. But the problem still exists.
I have another website which is 90% similar to this one. It wasn’t updated the plugins and WordPress core nor added new ones for about 4-5 months. I tested there and wolf work well so I tried to update WordPress and the wolf drop down filter function was gone.
But filter function is still working and categories are still selectable. Just drop down and pre selelected function are gone. So as you said, it might be js or css problem. But I still don’t know where is the problem. Also, Bear the product bulk editor was facing the same problem.
Anyway, thank you for your help, Sir! Although I have to do extra effort, it is still working for me. So I will search the culprit later.
- This reply was modified 6 months, 2 weeks ago by alinnz.
Thank you very much, Sir!
Thank you very much for your answer and great plugins. Wishing you all the happiness and health!
Forum: Plugins
In reply to: [PWA] Caching StrategiesThank you, Sir!
Thank for your suggestion, Sir. I will try to follow your advice.
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Order table sooo slow, I can’t edit ordersThank you for your help and great support Sir @olliejones
Forum: Plugins
In reply to: [WooCommerce] Slow loading on order edit pageThank you, Sir@olliejones
I will try your plugin.
Forum: Plugins
In reply to: [WooCommerce] Slow loading on order edit pageThis issue has been reported in github (https://github.com/woocommerce/woocommerce/issues/47212) and it is known to be fixed in next update. So I will mark this post as resolved.
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Order table sooo slow, I can’t edit ordersThanks for your information @probablynotphil
Glad to know it will be fixed in upcoming update ☺️
And very much thanks for your help Sir @olliejones !
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Order table sooo slow, I can’t edit ordersThank for your help, Sir @olliejones !
It is varchar (255) and I tried to change 191 but it didn’t show any difference. I will try your suggestion.
This query run when I open an order to edit. Caller is here.
Automattic\WooCommerce\Internal\DataStores\CustomMetaDataStore->get_meta_keys Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->order_meta_keys_autofill Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->render_meta_form Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->render_custom_meta_form Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->output Automattic\WooCommerce\Internal\Admin\Orders\Edit->render_custom_meta_box do_meta_boxes Automattic\WooCommerce\Internal\Admin\Orders\Edit->render_meta_boxes Automattic\WooCommerce\Internal\Admin\Orders\Edit->display Automattic\WooCommerce\Internal\Admin\Orders\PageController->output do_action('woocommerce_page_wc-orders')Forum: Plugins
In reply to: [WooCommerce] Slow loading on order edit pageThank for your help, Sir @olliejones
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Order table sooo slow, I can’t edit ordersI have facing the same problem after updating woo 8.8.3. When I tried to open order edit page, it loads about 50-60 sec and query monitor shows one slow query on wc_order_meta table lasting about 50sec. I have tested plugin and theme conflict test. It is database query problem and it occurs on sites with large order meta database.
- This reply was modified 2 years ago by alinnz.
Forum: Plugins
In reply to: [WooCommerce] Slow loading on order edit pageI forgot the caller of above mentioned slow query.
Automattic\WooCommerce\Internal\DataStores\CustomMetaDataStore->get_meta_keys Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->order_meta_keys_autofill Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->render_meta_form Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->render_custom_meta_form Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->output Automattic\WooCommerce\Internal\Admin\Orders\Edit->render_custom_meta_box do_meta_boxes Automattic\WooCommerce\Internal\Admin\Orders\Edit->render_meta_boxes Automattic\WooCommerce\Internal\Admin\Orders\Edit->display Automattic\WooCommerce\Internal\Admin\Orders\PageController->output do_action('woocommerce_page_wc-orders')Forum: Plugins
In reply to: [WooCommerce] Slow loading on order edit pageHere is system status.
` ### WordPress Environment ### WordPress address (URL): https://mmxianxia.com Site address (URL): https://mmxianxia.com WC Version: 8.8.3 REST API Version: ✔ 8.8.3 Action Scheduler Version: ✔ 3.7.4 Log Directory Writable: ✔ WP Version: 6.5.3 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: – Language: en_US External object cache: ✔ ### Server Environment ### Server Info: nginx/1.25.3 PHP Version: 7.4.33 PHP Post Max Size: 256 MB PHP Time Limit: 3597 PHP Max Input Vars: 9996 cURL Version: 7.81.0 OpenSSL/3.0.2 SUHOSIN Installed: – MySQL Version: 5.5.5-10.6.17-MariaDB-1:10.6.17+maria~ubu2204 Max Upload Size: 256 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 8.8.3 WC Database Prefix: rtw6u9s9d9_ Total Database Size: 3363.52MB Database Data Size: 2668.67MB Database Index Size: 694.85MB rtw6u9s9d9_woocommerce_sessions: Data: 0.20MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB rtw6u9s9d9_woocommerce_order_items: Data: 14.52MB + Index: 2.52MB + Engine InnoDB rtw6u9s9d9_woocommerce_order_itemmeta: Data: 64.59MB + Index: 54.14MB + Engine InnoDB rtw6u9s9d9_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB rtw6u9s9d9_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB rtw6u9s9d9_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB rtw6u9s9d9_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB rtw6u9s9d9_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_actionscheduler_actions: Data: 0.06MB + Index: 0.11MB + Engine InnoDB rtw6u9s9d9_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_actionscheduler_logs: Data: 0.05MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_commentmeta: Data: 4.52MB + Index: 5.03MB + Engine InnoDB rtw6u9s9d9_comments: Data: 40.56MB + Index: 33.61MB + Engine InnoDB rtw6u9s9d9_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_myCRED_log: Data: 13.52MB + Index: 12.09MB + Engine InnoDB rtw6u9s9d9_options: Data: 2.44MB + Index: 0.31MB + Engine InnoDB rtw6u9s9d9_postmeta: Data: 265.81MB + Index: 215.47MB + Engine InnoDB rtw6u9s9d9_posts: Data: 1960.56MB + Index: 22.11MB + Engine InnoDB rtw6u9s9d9_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_terms: Data: 0.09MB + Index: 0.09MB + Engine InnoDB rtw6u9s9d9_term_relationships: Data: 3.52MB + Index: 1.52MB + Engine InnoDB rtw6u9s9d9_term_taxonomy: Data: 0.08MB + Index: 0.09MB + Engine InnoDB rtw6u9s9d9_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_usermeta: Data: 38.56MB + Index: 14.03MB + Engine InnoDB rtw6u9s9d9_users: Data: 1.52MB + Index: 0.80MB + Engine InnoDB rtw6u9s9d9_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB rtw6u9s9d9_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB rtw6u9s9d9_wc_customer_lookup: Data: 0.44MB + Index: 0.31MB + Engine InnoDB rtw6u9s9d9_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_wc_orders: Data: 29.56MB + Index: 23.61MB + Engine InnoDB rtw6u9s9d9_wc_orders_meta: Data: 187.72MB + Index: 269.88MB + Engine InnoDB rtw6u9s9d9_wc_order_addresses: Data: 12.52MB + Index: 20.06MB + Engine InnoDB rtw6u9s9d9_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_wc_order_operational_data: Data: 16.55MB + Index: 7.03MB + Engine InnoDB rtw6u9s9d9_wc_order_product_lookup: Data: 5.52MB + Index: 6.06MB + Engine InnoDB rtw6u9s9d9_wc_order_stats: Data: 4.52MB + Index: 4.55MB + Engine InnoDB rtw6u9s9d9_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_wc_product_meta_lookup: Data: 0.19MB + Index: 0.33MB + Engine InnoDB rtw6u9s9d9_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB rtw6u9s9d9_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB rtw6u9s9d9_woobe_history: Data: 0.09MB + Index: 0.11MB + Engine InnoDB rtw6u9s9d9_woobe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_wpbe_history: Data: 0.25MB + Index: 0.17MB + Engine InnoDB rtw6u9s9d9_wpbe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB rtw6u9s9d9_wpmailsmtp_emails_queue: Data: 0.02MB + Index: 0.03MB + Engine InnoDB rtw6u9s9d9_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 396 bitforms: 5 custom_css: 2 itsec-dash-card: 10 itsec-dashboard: 2 mycred_rank: 8 nav_menu_item: 4 page: 18 post: 48595 product: 1809 series: 94 shop_coupon: 1 shop_order: 48719 shop_order_placehold: 35789 wp_navigation: 1 wp_template: 2 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (26) ### Query Monitor: by John Blackbourn – 3.16.2 Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2 Autoptimize: by Frank Goossens (futtta) – 3.1.11 WOLF - WordPress Posts Bulk Editor and Manager Professional: by realmag777 – 1.0.8.3 Classic Editor: by WordPress Contributors – 1.6.3 Cost of Goods for WooCommerce: by WPFactory – 3.4.0 Dinger Payment Prebuild Form Gateway: by Insight Web Studio – 1.0 FastCredit for WooCommerce (Premium): by FastFlow – 2.0.16 Frontend Reports for WooCommerce: by WP Zone – 1.0.13 Product Sales Report Pro for WooCommerce: by WP Zone – 2.2.47 Meta Box: by MetaBox.io – 5.9.8 myCred Level Cred: by myCred – 1.2.1 myCred: by myCred – 2.6.5 Open Graph: by Will Norris – 1.11.2 Progressive WordPress (PWA): by Nico Martin – 2.1.13 RunCloud Hub: by RunCloud – 1.4.4 Use Any Font: by Dnesscarkey – 6.3.05 User Switching: by John Blackbourn & contributors – 1.7.3 BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 1.1.4.4 WooCommerce Custom My Account Page: by Wbcom Designs – 1.3.5 Booster for WooCommerce: by Pluggabl LLC – 7.1.9 Pay For Post with WooCommerce: by Pramadillo – 3.1.17 WooCommerce: by Automattic – 8.8.3 WP Crontrol: by John Blackbourn – 1.16.3 WP Mail SMTP: by WP Mail SMTP – 4.0.1 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.3.2 ### Inactive Plugins (0) ### ### Dropin Plugins () ### object-cache.php: object-cache.php ### Settings ### API Enabled: – Force SSL: – Currency: MMK (Ks) Currency Position: right_space 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: – Enforce Approved Product Download Directories: ✔ HPOS feature screen enabled: ✔ HPOS feature enabled: ✔ Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: – ### Logging ### Enabled: ✔ Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 days Level threshold: – Log directory size: 359 B ### WC Pages ### Shop base: #8 - /shop/ Cart: #9 - /cart/ Checkout: #10 - /checkout/ My account: #11 - /my-account/ Terms and conditions: #5076 - /term-of-service/ ### Theme ### Name: LightNovel Child Version: 1.0.1 Author URL: https://themesia.com Child Theme: ✔ Parent Theme Name: LightNovel Parent Theme Version: 1.1.5 Parent Theme Author URL: https://themesia.com WooCommerce Support: ❌ Not declared ### Templates ### Overrides: /home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/checkout/thankyou.php /home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/emails/email-order-details.php /home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/emails/email-order-items.php /home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/myaccount/orders.php version 7.8.0 is out of date. The core version is 8.5.0 /home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/order/order-details-item.php /home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/order/order-details.php version 7.8.0 is out of date. The core version is 8.5.0 Outdated Templates: ❌ Learn how to update ### Admin ### Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customize-store customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management product-virtual-downloadable product-external-affiliate product-grouped product-linked product-pre-publish-modal 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 product-custom-fields settings async-product-editor-category-field launch-your-store Daily Cron: ✔ Next scheduled: 2024-05-10 06:20:59 +06:30 Options: ✔ Notes: 41 Onboarding: completed ### Action Scheduler ### Complete: 129 Oldest: 2024-05-03 04:40:02 +0000 Newest: 2024-05-10 02:00:02 +0000 Pending: 4 Oldest: 2024-05-10 06:10:02 +0000 Newest: 2024-05-11 02:00:02 +0000 ### Status report information ### Generated at: 2024-05-10 08:31:02 +06:30 `Update.
I have implemented woocommerce logout redirect to homepage but it redirects to error page in customer logout without cookie.