Acegame888 login,How rare is it to be born on July 8th.Recharge Every day and Get Bonus up-to 50%!

This 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 orders

alinnz

(@alinnz)

6 months, 2 weeks ago

Thanks 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 orders

alinnz

(@alinnz)

6 months, 2 weeks ago

Thank 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 page

Thread Starter alinnz

(@alinnz)

6 months, 2 weeks ago

Thank for your help, Sir @olliejones

Forum: Plugins
In reply to: [Index WP MySQL For Speed] Order table sooo slow, I can’t edit orders

alinnz

(@alinnz)

6 months, 2 weeks ago

I 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 6 months, 2 weeks ago by alinnz.

Forum: Plugins
In reply to: [WooCommerce] Slow loading on order edit page

Thread Starter alinnz

(@alinnz)

6 months, 2 weeks ago

I 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 page

Thread Starter alinnz

(@alinnz)

6 months, 2 weeks ago

Here 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
`

Forum: Plugins
In reply to: [All-In-One Security (AIOS) – Security and Firewall] Cookie based brute force prevention and woocommerce logout problem

Thread Starter alinnz

(@alinnz)

9 months, 2 weeks ago

Update.

I have implemented woocommerce logout redirect to homepage but it redirects to error page in customer logout without cookie.

Forum: Plugins
In reply to: [Page Restrict for WooCommerce] Customize “Not Bought” Text on Restricted page

alinnz

(@alinnz)

1 year, 6 months ago

[prwc_restricted_pages_products]

Is it possible to set this short code to display associated product achrive like this?https://ibb.co/gM7TyHq

Viewing 13 replies - 1 through 13 (of 13 total)