albertramsbottom

OK thanks, I have refreshed the token but no luck do will see if I can find it in ebay UK

But the error 37, we dont have a package type anywhere, there is a dropdown in the profile that is empty and our products have a shipping class which is set to Large Letter. There isnt a package type to fill in

I have refreshed the categories and account and token but there is no package type anywhere

Thanks

I think I need to come back to this

I got very fed up with the ebay business profiles and the 180 that I had over the years. So I opted out of them. Now I have got this error on all my 380 listings that are on ebay

eBay returned the following error(s):
Error: (90002)
soap-fault: Input data is invalid.
Error: (37)
Input data for tag <Item.ShippingDetails.ShippingType> is invalid or missing. Please check API documentation.

Now, all my listings on the ebay shipping options area are set with –use profile setting. When I check the profile for t-shirts there are no parts that are set to use profiles and I have done them all buy hand. they have always been like this as I have had issues with ebay business profiles before.

I have updated the account and refreshed what i could

I wonder what I would be missing

thanks

thanks, seems to have gone away

OK I seem to have fixed it. The template had chnaged

But……

When I expanded the bullet points to

100% Organic Cotton Canvas - 340gsm (10oz/yd2), Eco-Friendly, Premium heavyweight fabric, Can be carried by hand or over the shoulder, Dimensions: 38 x 42 cm, Capacity: 10 litres
SAVE NATURE: Go green with our Natural and Reusable Tote Bag. Avoid the pollution that plastic bags cause and Say no to paper or plastic bags and be easy on our environment and say yes to our Non-Toxic bags. Try them out today!
MACHINE WASHABLE: Your tote fell in the mud!? No problem. Our totes wash very well and the 20% polyester blend makes the totes wrinkle resistant so if it gets dirty or something spills on it all you have to do is throw it in the washing machine to get it clean again.
HEAVY DUTY & DURABLE: Made from 100% Organic Cotton We use a premium and thick 10 ounce fabric with precise heavyweight stitching throughout, including cross-stitching at the handles for maximum strength allowing the bag to hold up to 35 Pounds of weight.
Organic Earth Aware Tote Shopper Bag Save The Planet Eco-Friendly Reusable, Green, Cool Premium 

It fails to save with

Request-URI Too Long The requested URL’s length exceeds the capacity limit for this server.

This cannot be altered on Apache without recompiling the software. I believe that this happens for requests that are longer than 8000 characters and using the get method rather than post

The suggested methods are

Use POST with a form (or an hidden form and add onclick event at your link that submit it)
Use Session. When the server generates the link, store it in $_SESSION with an unique id (or RID, it can be md5 of complete URI) and pass it via GET.
Use Database or file storage (with the same procedure of session)

Cheers
PS I would assume that this is due to large template files with lots of fields

I have downloaded the template and added it with no luck. I have noticed that the browse node is the same as another category in Amazon.

We are brand registered and have GTIN exemption in the Luggage category but no in the other home category that I mentioned about

I now think it might be that Amazon have joined the two and we do not have permission to list without GTINs in the Home category

I will let you know, many thanks

No it doesnt so please stop it

I havent solved the problem and I am the OP ??

Yes, when disabled the plugin the errors went away now I have re-enabled I have other errors as well

[28-Feb-2020 17:15:05 UTC] WordPress database error ALTER command denied to user 'user'@'localhost' for table 'wp_wc_order_stats' for query ALTER TABLE wp_wc_order_stats CHANGE COLUMNreturning_customerreturning_customer boolean DEFAULT NULL made by do_action_ref_array('generate_category_lookup_table'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\CategoryLookup->regenerate, Automattic\WooCommerce\Admin\Install::create_tables, dbDelta

My MySQL user has been granted all privileges

I can do without this plugin, but its worrying that my DB user cannot ALTER or DROP MySQL tables according to the errors

Its also interesting that you say that it is from the woocommerce admin plugin. If I go to woocommerce > Dashboard, there no orders in any setting. But there are orders, maybe 60 or 70 this month

Odd

But thanks, perhaps I should disable the woocommerce admin plugin?

I am seeing these errors in my wordpress log as I have enabled it in my wp-config

I use the flatsome theme, which I dont believe has any plugins to alter the checkout process??

### WordPress Environment ###

WordPress address (URL): https://streetdecals.co.uk
Site address (URL): https://streetdecals.co.uk
WC Version: 3.9.2
REST API Version: ? 1.0.7
Log Directory Writable: ?
WP Version: 5.3.2
WP Multisite: ?
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.29 (Ubuntu)
PHP Version: 7.2.27-1+ubuntu18.04.1+deb.sury.org+1
PHP Post Max Size: 1,000 MB
PHP Time Limit: 6000
PHP Max Input Vars: 5000
cURL Version: 7.58.0
OpenSSL/1.1.1

SUHOSIN Installed: –
MySQL Version: 5.7.29-0ubuntu0.18.04.1
Max Upload Size: 5 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.9.2
WC Database Prefix: wp_
Total Database Size: 1862.68MB
Database Data Size: 1393.08MB
Database Index Size: 469.60MB
wp_woocommerce_sessions: Data: 4.02MB + Index: 0.13MB + 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.05MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.23MB + Index: 0.17MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_1_bad_behavior: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_1_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_actionscheduler_actions: Data: 0.27MB + Index: 0.16MB + Engine InnoDB
wp_2_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_actionscheduler_logs: Data: 0.19MB + Index: 0.14MB + Engine InnoDB
wp_2_androapp_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ariadminer_connections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_bad_behavior: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_2_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_ebay_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ebay_auctions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_2_ebay_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_ebay_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ebay_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_ebay_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ebay_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ebay_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ebay_shipping: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ebay_sites: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ebay_store_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_ebay_transactions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_ewwwio_images: Data: 0.23MB + Index: 0.30MB + Engine InnoDB
wp_2_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_mail_bank_logs: Data: 3.70MB + Index: 0.03MB + Engine MyISAM
wp_2_mail_bank_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_options: Data: 6.22MB + Index: 1.06MB + Engine InnoDB
wp_2_postmeta: Data: 277.70MB + Index: 197.72MB + Engine InnoDB
wp_2_posts: Data: 23.55MB + Index: 12.25MB + Engine InnoDB
wp_2_pw_gcmusers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_soo_wishlists: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_soo_wishlists_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_2_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_term_relationships: Data: 1.50MB + Index: 0.36MB + Engine InnoDB
wp_2_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_product_meta_lookup: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_2_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_yith_wcwl_lists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_yoast_seo_links: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
wp_2_yoast_seo_meta: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
wp_3_ewwwio_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_3_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_3_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_actionscheduler_actions: Data: 0.19MB + Index: 0.11MB + Engine InnoDB
wp_4_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_actionscheduler_logs: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_4_androapp_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_bad_behavior: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_comments: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
wp_4_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_ewwwio_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_4_mail_bank_logs: Data: 0.80MB + Index: 0.01MB + Engine MyISAM
wp_4_mail_bank_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_4_options: Data: 4.13MB + Index: 0.08MB + Engine InnoDB
wp_4_postmeta: Data: 6.28MB + Index: 4.34MB + Engine InnoDB
wp_4_posts: Data: 1.39MB + Index: 0.27MB + Engine InnoDB
wp_4_pw_gcmusers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_sliders: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_sliders_bkp: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_slides: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_slides_bkp: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_soo_wishlists: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_soo_wishlists_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_4_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_4_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_4_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_4_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_4_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_4_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_4_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_4_yith_wcwl_lists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_4_yoast_seo_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_4_yoast_seo_meta: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_5_ewwwio_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_5_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_5_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_5_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_actionscheduler_actions: Data: 58.20MB + Index: 31.42MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 27.16MB + Index: 23.13MB + Engine InnoDB
wp_amazon_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_amazon_btg: Data: 4.52MB + Index: 3.70MB + Engine InnoDB
wp_amazon_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_amazon_feeds: Data: 101.02MB + Index: 0.00MB + Engine InnoDB
wp_amazon_feed_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_amazon_feed_tpl_data: Data: 1.02MB + Index: 0.19MB + Engine InnoDB
wp_amazon_feed_tpl_values: Data: 3.02MB + Index: 2.08MB + Engine InnoDB
wp_amazon_jobs: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_amazon_listings: Data: 11.44MB + Index: 9.11MB + Engine InnoDB
wp_amazon_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_amazon_markets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_amazon_orders: Data: 65.56MB + Index: 0.56MB + Engine InnoDB
wp_amazon_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_amazon_profiles: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_amazon_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_amazon_shipping: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_amazon_stock_log: Data: 11.52MB + Index: 0.00MB + Engine InnoDB
wp_androapp_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ariadminer_connections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bad_behavior: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
wp_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_blog_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 2.09MB + Index: 0.63MB + Engine InnoDB
wp_ebay_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_auctions: Data: 62.02MB + Index: 0.27MB + Engine InnoDB
wp_ebay_categories: Data: 1.52MB + Index: 3.03MB + Engine InnoDB
wp_ebay_jobs: Data: 0.50MB + Index: 0.00MB + Engine InnoDB
wp_ebay_log: Data: 192.02MB + Index: 0.73MB + Engine InnoDB
wp_ebay_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_orders: Data: 105.52MB + Index: 0.30MB + Engine InnoDB
wp_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_profiles: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_ebay_shipping: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_ebay_sites: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_ebay_stocks_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ebay_store_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ebay_transactions: Data: 64.52MB + Index: 0.44MB + Engine InnoDB
wp_ewwwio_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_failed_jobs: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
wp_image_compression_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mail_bank_logs: Data: 21.34MB + Index: 0.04MB + Engine MyISAM
wp_mail_bank_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_field_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 37.09MB + Index: 6.31MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 167.66MB + Index: 122.23MB + Engine InnoDB
wp_posts: Data: 42.55MB + Index: 21.88MB + Engine InnoDB
wp_pw_gcmusers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sitemeta: Data: 2.52MB + Index: 0.03MB + Engine InnoDB
wp_smush_dir_images: Data: 19.52MB + Index: 7.03MB + Engine InnoDB
wp_sm_advanced_search_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_soo_wishlists: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_soo_wishlists_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 3.48MB + Index: 1.50MB + Engine InnoDB
wp_term_taxonomy: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_tinvwl_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_tinvwl_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tinvwl_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 0.30MB + Index: 0.19MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 6.45MB + Index: 10.08MB + 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_wfBadLeechers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfBlockedCommentLog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfBlockedIPLog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wfBlocks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfBlocksAdv: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfConfig: Data: 2.28MB + Index: 0.00MB + Engine InnoDB
wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileMods: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_wfHits: Data: 2.02MB + Index: 0.27MB + Engine InnoDB
wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfKnownFileList: Data: 25.55MB + Index: 0.00MB + Engine InnoDB
wp_wfLeechers: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfLockedOut: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfLogins: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfNet404s: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfNotifications: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfScanners: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfStatus: Data: 1.02MB + Index: 2.03MB + Engine InnoDB
wp_wfThrottleLog: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfVulnScanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woobe_history: Data: 1.52MB + Index: 0.09MB + Engine InnoDB
wp_woobe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wpimage: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wp_optimisation_sizes_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wtc_notification: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wtc_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wtc_social: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.27MB + Index: 0.08MB + Engine InnoDB
wp_yoast_seo_meta: Data: 3.47MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_exact-metrics: 1
attachment: 8991
attribute_group: 1
blocks: 21
custom_css: 3
customize_changeset: 35
featured_item: 8
mc4wp-form: 2
nav_menu_item: 76
page: 136
popup: 1
popup_theme: 6
portfolio: 15
post: 28
product: 1136
product_variation: 35059
revision: 209
scheduled-action: 908
shop_coupon: 3
shop_order: 113
sidebar: 1
woo_product_tab: 2
wpcf7_contact_form: 7

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (44) ###

YITH WooCommerce Wishlist: by YITH – 3.0.6 – Not tested with the active version of WooCommerce
WP-Lister Lite for Amazon: by WP Lab – 1.2.1
WP-Lister Lite for eBay: by WP Lab – 2.4.2
WooCommerce: by Automattic – 3.9.2
Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.19.50
Bad Behavior: by Michael Hampton – 2.2.24
Booster for WooCommerce: by Algoritmika Ltd – 4.7.1 – Not tested with the active version of WooCommerce
Contact Form 7: by Takayuki Miyoshi – 5.1.6
Contact Form 7 Captcha: by 247wd – 0.0.3
Heartbeat Control by WP Rocket: by WP Rocket – 2.0
Import from eBay to WooCommerce: by WP Lab – 1.7.1 – Not tested with the active version of WooCommerce
Meta Box: by MetaBox.io – 5.2.7
Nextend Social Login: by Nextendweb – 3.0.20
Redis Object Cache: by Till Krüss – 1.5.6
Redux Framework: by Team Redux – 3.6.17
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3
Slider Revolution: by ThemePunch – 6.1.7
Sober Addons: by UIX Themes – 1.4.1
Social Login: by OneAll Social Login  – 5.6
Soo Product Filter: by UIX Themes – 1.0.8 – Not tested with the active version of WooCommerce
Soo Wishlist: by UIX Themes – 1.1.2 – Not tested with the active version of WooCommerce
TinyMCE Advanced: by Andrew Ozz – 5.3.0
Variation Swatcher for WooCommerce: by ThemeAlien – 1.0.6 – Not tested with the active version of WooCommerce
WooCommerce Admin: by WooCommerce – 0.26.1 – Not tested with the active version of WooCommerce
WooCommerce Multisite Duplicate: by weLaunch – 1.1.3 – Not tested with the active version of WooCommerce
WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.20 – Not tested with the active version of WooCommerce
WooCommerce PayPal Pro: by wp.insider – 2.9.1 – Not tested with the active version of WooCommerce
WooCommerce PDF Invoices: by Bas Elbers – 3.0.11 – Not tested with the active version of WooCommerce
WooCommerce Product SKU Generator: by SkyVerge – 2.4.3 – Not tested with the active version of WooCommerce
WOOCS - WooCommerce Currency Switcher: by realmag777 – 1.3.0 – Not tested with the active version of WooCommerce
WooSidebars: by WooCommerce – 1.4.5
Wordfence Security: by Wordfence – 7.4.6
WP Better Emails: by Nicolas Lemoine – 0.3
WP Instagram Widget: by Scott Evans – 2.0.3
WP Mail SMTP Plugin by Mail Bank: by Tech Banker – 4.0.10
WPBakery Page Builder: by Michael M - WPBakery.com – 6.0.3
WPvivid Backup Plugin: by WPvivid Team – 0.9.34
YITH Essential Kit for WooCommerce #1: by YITH – 2.1.2 – Not tested with the active version of WooCommerce
YITH WooCommerce Ajax Search: by YITH – 1.7.4 – Not tested with the active version of WooCommerce
Yoast SEO: by Team Yoast – 13.1
Smush: by WPMU DEV – 3.4.2
Speed Booster Pack: by Optimocha – 3.8.5
Async JavaScript: by Frank Goossens (futtta) – 2.20.02.27
Widget Options: by Widget Options Team – 3.7.4

### Inactive Plugins (4) ###

Kirki Customizer Framework: by Ari Stathopoulos (@aristath) – 3.0.45
MC4WP: Mailchimp for WordPress: by ibericode – 4.7.5
Multisite Robots.txt Manager | MS Robots.txt: by tribalNerd
Chris Winters – 2.1.0

YITH WooCommerce Best Sellers: by YITH – 1.1.17 – Not tested with the active version of WooCommerce

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: GBP (￡)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #6 - /shop/
Basket: #23968 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #23992 - /contact-and-help/

### Theme ###

Name: Flatsome
Version: 3.10.4
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-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.php
flatsome/woocommerce/content-product_cat.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/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

### Action Scheduler ###

Complete: 907
Oldest: 2020-02-28 05:54:26 +0000
Newest: 2020-02-28 16:55:37 +0000

Pending: 1
Oldest: 2020-02-28 16:55:42 +0000
Newest: 2020-02-28 16:55:42 +0000

Canceled: 0
Oldest: –
Newest: –

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –

Cheers

Yeap, the errors have gone so may have been an issue with having them both installed

Sorry and thanks

I will disable the plugin for woo-commerce and enable yours and see what is happening

Thanks

Well when I disable your plugin the errors stop. In fact in order for me to copy the error, I had to enable your plugin and then wait for the error and then disable it. Now the errors have stopped

The plugin i am disabling is:
MC4WP: Mailchimp for WordPress

Just so we are not getting confused

Thanks and odd

[27-Feb-2020 17:25:30 UTC] WordPress database error ALTER command denied to user 'user'@'localhost' for table 'wp_mailchimp_carts' for query ALTER TABLE wp_mailchimp_carts ADD PRIMARY KEY (email); made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, MailChimp_WooCommerce_Admin->options_update, MailChimp_WooCommerce_Admin->update_db_check

Version 4.75

thanks

Yes please we need this -please, please