masternikos

I have cpanel and all privelege in user.

I think you have right.In local host work fine windows.
How fix this in site?

No.if a Permissionhow to fix?

Examble woocommerce tables not exist in back up

Not notice.I see all tables install run ok but not back up all db tables.

I try in 2 servers vps shared and local host.
Nothing.
I have stay in 3.3.0 version.
Trying my self to find differents from 3.3.1 but is difficult

Hi.Just try nothing.

please read above
TIME: 31543
what do you suggest?

SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
FROM wp_posts posts
LEFT JOIN wp_postmeta postmeta
ON posts.ID = postmeta.post_id
WHERE posts.post_type IN (‘product’,’product_variation’)
AND ( ( ( posts.post_title LIKE ‘%test%’)
OR ( posts.post_excerpt LIKE ‘%test%’)
OR ( posts.post_content LIKE ‘%test%’ )
OR ( postmeta.meta_key = ‘_sku’
AND postmeta.meta_value LIKE ‘%test%’ ) ))
ORDER BY posts.post_parent ASC, posts.post_title ASC

WP_Posts_List_Table->prepare_items()
wp-admin/includes/class-wp-posts-list-table.php:136
wp_edit_posts_query()
wp-admin/includes/post.php:1073
wp()
wp-includes/functions.php:960
WP->main()
wp-includes/class-wp.php:713
WP->parse_request()
wp-includes/class-wp.php:364
apply_filters(‘request’)
wp-includes/plugin.php:203
WC_Admin_List_Table->request_query()
wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php:118
WC_Admin_List_Table_Products->query_filters()
wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
WC_Data_Store->search_products()
wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
WC_Data_Store->__call()
wp-content/plugins/woocommerce/includes/class-wc-data-store.php:203
WC_Product_Data_Store_CPT->search_products()
wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:1426TIME: 31543
what do you suggest?

SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
FROM wp_posts posts
LEFT JOIN wp_postmeta postmeta
ON posts.ID = postmeta.post_id
WHERE posts.post_type IN (‘product’,’product_variation’)
AND ( ( ( posts.post_title LIKE ‘%test%’)
OR ( posts.post_excerpt LIKE ‘%test%’)
OR ( posts.post_content LIKE ‘%test%’ )
OR ( postmeta.meta_key = ‘_sku’
AND postmeta.meta_value LIKE ‘%test%’ ) ))
ORDER BY posts.post_parent ASC, posts.post_title ASC

WP_Posts_List_Table->prepare_items()
wp-admin/includes/class-wp-posts-list-table.php:136
wp_edit_posts_query()
wp-admin/includes/post.php:1073
wp()
wp-includes/functions.php:960
WP->main()
wp-includes/class-wp.php:713
WP->parse_request()
wp-includes/class-wp.php:364
apply_filters(‘request’)
wp-includes/plugin.php:203
WC_Admin_List_Table->request_query()
wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php:118
WC_Admin_List_Table_Products->query_filters()
wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
WC_Data_Store->search_products()
wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
WC_Data_Store->__call()
wp-content/plugins/woocommerce/includes/class-wc-data-store.php:203
WC_Product_Data_Store_CPT->search_products()
wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:1426

Just update 7 but nothing.It’s slow again.

WordPress environment
Home URL: https://www..com
Site URL: https://www..com
WC version: 3.3.0
Log directory writable: /home/ucxwtbqy/public_html/wp-content/uploads/wc-logs/
WP version: 4.9.6
WP multisite: –
WP memory limit: 256 MB
WP debug mode: –
WP cron: –
Language: en_US
Server environment
Server info: Apache
PHP version: 5.6.36
PHP post max size: 70 MB
PHP time limit: 90
PHP max input vars: 1000
cURL version: 7.54.0, OpenSSL/1.0.2k
SUHOSIN installed: –
Max upload size: 50 MB
Default timezone is UTC:
fsockopen/cURL:
SoapClient:
DOMDocument:
GZip:
Multibyte string:
Remote post:
Remote get:
Database
WC database version: 3.3.0
Database prefix wp_
Total Database Size 537.98MB
Database Data Size 349.30MB
Database Index Size 188.68MB
wp_woocommerce_sessions Data: 0.87MB + Index: 0.04MB
wp_woocommerce_api_keys Data: 0.00MB + Index: 0.00MB
wp_woocommerce_attribute_taxonomies Data: 0.00MB + Index: 0.00MB
wp_woocommerce_downloadable_product_permissions Data: 0.86MB + Index: 0.93MB
wp_woocommerce_order_items Data: 1.53MB + Index: 0.66MB
wp_woocommerce_order_itemmeta Data: 15.56MB + Index: 5.37MB
wp_woocommerce_tax_rates Data: 0.00MB + Index: 0.00MB
wp_woocommerce_tax_rate_locations Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zones Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zone_methods Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokens Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokenmeta Data: 0.00MB + Index: 0.00MB
wp_woocommerce_log Data: 0.00MB + Index: 0.00MB
wp_aiosc_cron Data: 0.00MB + Index: 0.00MB
wp_aiosc_departments Data: 0.00MB + Index: 0.01MB
wp_aiosc_premades Data: 0.00MB + Index: 0.00MB
wp_aiosc_priorities Data: 0.00MB + Index: 0.01MB
wp_aiosc_replies Data: 0.02MB + Index: 0.01MB
wp_aiosc_tickets Data: 0.02MB + Index: 0.01MB
wp_aiosc_uploads Data: 0.00MB + Index: 0.00MB
wp_aiowps_events Data: 0.00MB + Index: 0.00MB
wp_aiowps_failed_logins Data: 0.00MB + Index: 0.00MB
wp_aiowps_global_meta Data: 0.00MB + Index: 0.00MB
wp_aiowps_login_activity Data: 0.08MB + Index: 0.02MB
wp_aiowps_login_lockdown Data: 0.00MB + Index: 0.00MB
wp_aiowps_permanent_block Data: 0.00MB + Index: 0.00MB
wp_asp_index Data: 0.02MB + Index: 0.04MB
wp_asp_synonyms Data: 0.00MB + Index: 0.00MB
wp_aws_index Data: 0.00MB + Index: 0.00MB
wp_commentmeta Data: 0.04MB + Index: 0.05MB
wp_comments Data: 2.77MB + Index: 1.42MB
wp_duplicator_pro_entities Data: 0.01MB + Index: 0.00MB
wp_duplicator_pro_packages Data: 0.00MB + Index: 0.00MB
wp_links Data: 0.00MB + Index: 0.00MB
wp_options Data: 23.09MB + Index: 4.02MB
wp_postmeta Data: 259.47MB + Index: 156.88MB
wp_posts Data: 34.11MB + Index: 8.35MB
wp_signups Data: 0.19MB + Index: 0.02MB
wp_sr_woo_abandoned_items Data: 0.01MB + Index: 0.01MB
wp_termmeta Data: 0.02MB + Index: 0.02MB
wp_terms Data: 2.20MB + Index: 2.31MB
wp_term_relationships Data: 1.72MB + Index: 3.55MB
wp_term_taxonomy Data: 1.46MB + Index: 2.29MB
wp_un_termmeta Data: 0.00MB + Index: 0.01MB
wp_usermeta Data: 3.47MB + Index: 2.02MB
wp_users Data: 0.29MB + Index: 0.23MB
wp_wc_comments_subscription Data: 0.00MB + Index: 0.00MB
wp_wc_download_log Data: 0.07MB + Index: 0.06MB
wp_wc_phrases Data: 0.00MB + Index: 0.00MB
wp_wc_users_voted Data: 0.00MB + Index: 0.00MB
wp_wc_webhooks Data: 0.00MB + Index: 0.00MB
wp_wlo_order_log Data: 0.11MB + Index: 0.00MB
wp_woocommerce_gpf_google_taxonomy Data: 0.95MB + Index: 0.00MB
wp_woocommerce_order_status_action Data: 0.00MB + Index: 0.00MB
wp_woocommerce_termmeta Data: 0.00MB + Index: 0.00MB
wp_wpcreviews Data: 0.01MB + Index: 0.00MB
wp_wpc_comments_subscription Data: 0.03MB + Index: 0.02MB
wp_wpc_phrases Data: 0.00MB + Index: 0.00MB
wp_wpc_users_voted Data: 0.00MB + Index: 0.01MB
wp_wpie_export_log Data: 0.00MB + Index: 0.00MB
wp_wpmelon_advbedit_temp Data: 0.00MB + Index: 0.00MB
wp_yoast_seo_links Data: 0.03MB + Index: 0.02MB
wp_yoast_seo_meta Data: 0.29MB + Index: 0.29MB
Post Type Counts
attachment 6786
customize_changeset 16
cx_offline_msg 1
documentation 1
dt_testimonials 3
export_template 2
gema75_wc_badge 1
mts_notification_bar 1
nav_menu_item 262
oembed_cache 128
page 20
paypal_ipn 2
post 18
postman_sent_mail 12
product 12429
product_variation 49375
revision 37
scheduled-action 250
searchford 2
shop_coupon 114
shop_order 8074
shop_subscription 3099
un_feedback 3
w4pl 2
wishlist 8
wpcr3_review 46
wpdiscuz_form 1
Security
Secure connection (HTTPS):
Hide errors from visitors
Active plugins (12)
All In One WP Security by Tips and Tricks HQ, Peter Petreski, Ruhul, Ivy – 4.3.3.1
Autoptimize by Frank Goossens (futtta) – 2.3.4
AIO Support Center by DiWave Coders – 2.21
Duplicator Pro by Snap Creek – 3.7.1.1
Toolset Access by OnTheGoSystems – 2.4.3.5
WooCommerce Advanced Bulk Edit by George Iron – 4.4.1
Woocommerce Limit Order by WP Friends – 2.6 – Not tested with the active version of WooCommerce
WooCommerce Smart Coupons by WooCommerce – 3.4.1 – 3.4.4 is available
WooCommerce Subscriptions by Prospress Inc. – 2.2.19 – 2.2.21 is available
WooCommerce by Automattic – 3.3.0 – 3.4.2 is available
Yoast SEO Premium by Team Yoast – 7.5
WP Super Cache by Automattic – 1.6.1
Settings
API enabled:
Force SSL:
Currency EUR (€)
Currency position left
Thousand separator ,
Decimal separator .
Number of decimals 2
Taxonomies: Product types external (external), grouped (grouped), simple (simple), subscription (subscription), variable (variable), variable subscription (variable-subscription)
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)
WC pages
Shop base: #25886 – /shop/
Cart: #4098 – /cart-2/
Checkout: #4099 – /checkout-2/
My account: #4100 – /my-account/
Terms and conditions: #2 – /terms-of-service/
Theme
Name: Flatsome
Version: 3.6.0
Author URL: https://www.uxthemes.com/
Child theme: – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce support:
Templates
Overrides flatsome/woocommerce/archive-product.php,
flatsome/woocommerce/cart/cart-empty.php,
flatsome/woocommerce/cart/cart.php,
flatsome/woocommerce/checkout/form-checkout.php,
flatsome/woocommerce/checkout/form-coupon.php,
flatsome/woocommerce/checkout/thankyou.php,
flatsome/woocommerce/content-product.php,
flatsome/woocommerce/content-product_cat.php,
flatsome/woocommerce/content-single-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/result-count.php,
flatsome/woocommerce/loop/sale-flash.php,
flatsome/woocommerce/myaccount/form-login.php,
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,
flatsome/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
Subscriptions
WCS_DEBUG: No
Subscriptions Mode: Live
Subscriptions Template Theme Overrides: –
Report Cache Enabled: Yes
Cache Update Failures: 0 failure

Now just return in 3.3.0
and try a second server but nothing.
Thanks.

Ok.I install query monitor and i found this is slow in search products
TIME: 31543
what do you suggest?

SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
FROM wp_posts posts
LEFT JOIN wp_postmeta postmeta
ON posts.ID = postmeta.post_id
WHERE posts.post_type IN (‘product’,’product_variation’)
AND ( ( ( posts.post_title LIKE ‘%test%’)
OR ( posts.post_excerpt LIKE ‘%test%’)
OR ( posts.post_content LIKE ‘%test%’ )
OR ( postmeta.meta_key = ‘_sku’
AND postmeta.meta_value LIKE ‘%test%’ ) ))
ORDER BY posts.post_parent ASC, posts.post_title ASC

WP_Posts_List_Table->prepare_items()
wp-admin/includes/class-wp-posts-list-table.php:136
wp_edit_posts_query()
wp-admin/includes/post.php:1073
wp()
wp-includes/functions.php:960
WP->main()
wp-includes/class-wp.php:713
WP->parse_request()
wp-includes/class-wp.php:364
apply_filters(‘request’)
wp-includes/plugin.php:203
WC_Admin_List_Table->request_query()
wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php:118
WC_Admin_List_Table_Products->query_filters()
wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
WC_Data_Store->search_products()
wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
WC_Data_Store->__call()
wp-content/plugins/woocommerce/includes/class-wc-data-store.php:203
WC_Product_Data_Store_CPT->search_products()
wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:1426

wp-content/plugins/wp-support-plus-responsive-ticket-system/asset/images/[email protected]
load Continuity this icon and i can’t see tickets list

Hi.all orders still pending.Paypal complete but woocommerce still pending.Only work fine in wordpress 4.6.2
If update in new version wordpress still pending orders.I have try all methonds but no help.Anyone to help please?
Thanks

Ok work

[05-May-2015 13:20:43 UTC] PHP Warning: include_once(): Failed opening ‘/home/mysite/public_html/wp-content/plugins/smart-manager-for-wp-e-commerce/sm/.php’ for inclusion (include_path=’/home/mysite/public_html/wp-content/plugins/sabai/lib:.:/usr/php/54/usr/lib64:/usr/php/54/usr/share/pear’) in /home/mysite/public_html/wp-content/plugins/smart-manager-for-wp-e-commerce/smart-manager.php on line 244