“Installation wizard” when syncing products

### WordPress Environment ###

Home URL: https://www.spoeteriet.no
Site URL: https://www.spoeteriet.no
WC Version: 3.4.3
Log Directory Writable: ?
WP Version: 4.9.7
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: nb_NO
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.25
PHP Version: 7.0.30-0+deb9u1 - Vi anbefaler ? bruke PHP versjon 7.2 eller nyere for st?rre ytelse og sikkerhet. Hvordan oppgradere PHP til nyere versjon
PHP Post Max Size: 128 MB
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 7.52.1
OpenSSL/1.0.2l

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.0.35-MariaDB-1~wheezy
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.3.5
WC Database Prefix: 7fs6m_
MaxMind GeoIP Database: ?
Total database st?rrelse: 38.80MB
Database data st?rrelse: 30.13MB
Database indeks st?rrelse: 8.67MB
7fs6m_woocommerce_sessions: Data: 2.02MB + Indeks: 0.02MB
7fs6m_woocommerce_api_keys: Data: 0.02MB + Indeks: 0.03MB
7fs6m_woocommerce_attribute_taxonomies: Data: 0.02MB + Indeks: 0.02MB
7fs6m_woocommerce_downloadable_product_permissions: Data: 0.02MB + Indeks: 0.05MB
7fs6m_woocommerce_order_items: Data: 0.02MB + Indeks: 0.02MB
7fs6m_woocommerce_order_itemmeta: Data: 0.06MB + Indeks: 0.03MB
7fs6m_woocommerce_tax_rates: Data: 0.02MB + Indeks: 0.06MB
7fs6m_woocommerce_tax_rate_locations: Data: 0.02MB + Indeks: 0.03MB
7fs6m_woocommerce_shipping_zones: Data: 0.02MB + Indeks: 0.00MB
7fs6m_woocommerce_shipping_zone_locations: Data: 0.02MB + Indeks: 0.03MB
7fs6m_woocommerce_shipping_zone_methods: Data: 0.02MB + Indeks: 0.00MB
7fs6m_woocommerce_payment_tokens: Data: 0.02MB + Indeks: 0.02MB
7fs6m_woocommerce_payment_tokenmeta: Data: 0.02MB + Indeks: 0.03MB
7fs6m_woocommerce_log: Data: 0.02MB + Indeks: 0.02MB
7fs6m_commentmeta: Data: 0.02MB + Indeks: 0.03MB
7fs6m_comments: Data: 0.02MB + Indeks: 0.09MB
7fs6m_ewwwio_images: Data: 0.36MB + Indeks: 0.38MB
7fs6m_failed_jobs: Data: 0.02MB + Indeks: 0.00MB
7fs6m_itsec_distributed_storage: Data: 0.02MB + Indeks: 0.02MB
7fs6m_itsec_lockouts: Data: 0.02MB + Indeks: 0.08MB
7fs6m_itsec_log: Data: 0.02MB + Indeks: 0.03MB
7fs6m_itsec_logs: Data: 0.02MB + Indeks: 0.09MB
7fs6m_itsec_temp: Data: 0.02MB + Indeks: 0.06MB
7fs6m_links: Data: 0.02MB + Indeks: 0.02MB
7fs6m_mailchimp_carts: Data: 0.02MB + Indeks: 0.00MB
7fs6m_options: Data: 9.03MB + Indeks: 1.13MB
7fs6m_postmeta: Data: 12.17MB + Indeks: 5.14MB
7fs6m_posts: Data: 3.20MB + Indeks: 0.73MB
7fs6m_queue: Data: 0.02MB + Indeks: 0.00MB
7fs6m_revslider_css: Data: 0.13MB + Indeks: 0.00MB
7fs6m_revslider_layer_animations: Data: 0.02MB + Indeks: 0.00MB
7fs6m_revslider_navigations: Data: 0.02MB + Indeks: 0.00MB
7fs6m_revslider_sliders: Data: 0.02MB + Indeks: 0.00MB
7fs6m_revslider_slides: Data: 0.02MB + Indeks: 0.00MB
7fs6m_revslider_static_slides: Data: 0.02MB + Indeks: 0.00MB
7fs6m_snippets: Data: 0.02MB + Indeks: 0.00MB
7fs6m_termmeta: Data: 0.02MB + Indeks: 0.03MB
7fs6m_terms: Data: 0.02MB + Indeks: 0.03MB
7fs6m_term_relationships: Data: 0.38MB + Indeks: 0.23MB
7fs6m_term_taxonomy: Data: 0.02MB + Indeks: 0.03MB
7fs6m_usermeta: Data: 2.02MB + Indeks: 0.03MB
7fs6m_users: Data: 0.02MB + Indeks: 0.05MB
7fs6m_wc_download_log: Data: 0.02MB + Indeks: 0.03MB
7fs6m_wc_webhooks: Data: 0.02MB + Indeks: 0.02MB
7fs6m_woocommerce_bundled_itemmeta: Data: 0.02MB + Indeks: 0.03MB
7fs6m_woocommerce_bundled_items: Data: 0.02MB + Indeks: 0.03MB
7fs6m_yikes_easy_mc_forms: Data: 0.02MB + Indeks: 0.00MB

### Post Type Counts ###

attachment: 2661
custom_css: 1
customize_changeset: 17
jetpack_migration: 2
jp_img_sitemap: 4
jp_img_sitemap_index: 2
jp_sitemap: 2
jp_sitemap_master: 2
la_block: 1
la_team_member: 4
nav_menu_item: 98
page: 21
post: 3
product: 1964
revision: 100
shop_coupon: 1
shop_order: 78
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (25) ###

Add From Server: av Dion Hulse – 3.3.3
Akismet Anti-Spam: av Automattic – 4.0.8
iThemes Security: av iThemes – 7.0.4
Code Snippets: av Shea Bunge – 2.10.1.1
Contact Form 7: av Takayuki Miyoshi – 5.0.2
Customizer Export/Import: av The Beaver Builder Team – 0.7
Enhanced Media Library: av wpUXsolutions – 2.6.4
Instagram Feed: av Smash Balloon – 1.9.1
WPBakery Page Builder: av Michael M - WPBakery.com – 5.4.7
Klarna Checkout for WooCommerce: av Krokedil – 1.5.2
Klarna Order Management for WooCommerce: av klarna
krokedil
automattic – 1.2.4 – Ikke testet med den aktive versjonen av WooCommerce

Lapa Package Demo Data: av LA Studio – 1.0.0
LA-Studio Core: av LA-Studio – 1.0.0
Loco Translate: av Tim Whitlock – 2.1.4
MailChimp for WooCommerce: av MailChimp – 2.1.9 – Ikke testet med den aktive versjonen av WooCommerce
Slider Revolution: av ThemePunch – 5.4.7.2
Under Construction: av WebFactory Ltd – 3.10
Widgets Control: av itthinx – 2.0.3
Woo Checkout Field Editor Pro: av ThemeHiGH – 1.2.7
WooCommerce Composite Products: av SomewhereWarm – 3.13.10 – 3.13.11 er tilgjengelig
WooCommerce Email Test: av RaiserWeb – 1.10 – Ikke testet med den aktive versjonen av WooCommerce
WooCommerce Product Bundles - Min/Max Items: av SomewhereWarm – 1.3.2 – Ikke testet med den aktive versjonen av WooCommerce
WooCommerce Product Bundles: av SomewhereWarm – 5.7.10 – 5.7.11 er tilgjengelig
WooCommerce: av Automattic – 3.4.3
WP Super Cache: av Automattic – 1.6.2

### Settings ###

API Enabled: ?
Force SSL: –
Currency: NOK (kr)
Currency Position: left_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: bundle (bundle)
composite (composite)
external (external)
grouped (grouped)
simple (simple)
variable (variable)
woosb (woosb)

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 ###

Butikkbase: #2055 - /nettbutikk/
Handlekurv: #1837 - /handlekurv/
Til kassen: #6 - /kasse/
Min konto: #1839 - /min-konto/
Vilk?r og betingelser: #2069 - /kjopsbetingelser/

### Theme ###

Name: Lapa extension
Version: 0.1
Author URL: https://www.linkedin.com/in/j?rgen-hovden-230bb5116
Child Theme: ?
Parent Theme Name: Lapa
Parent Theme Version: 1.0.0
Parent Theme Author URL: https://themeforest.net/user/LA-Studio?ref=LA-Studio
WooCommerce Support: ?

### Templates ###

Overrides: lapa/woocommerce/archive-product.php versjon 3.3.0 er utdatert. Kjerneversjonen er 3.4.0
lapa/woocommerce/cart/cross-sells.php
lapa/woocommerce/content-product.php versjon 3.0.0 er utdatert. Kjerneversjonen er 3.4.0
lapa/woocommerce/content-single-product.php versjon 3.0.0 er utdatert. Kjerneversjonen er 3.4.0
lapa/woocommerce/emails/customer-processing-order.php versjon - er utdatert. Kjerneversjonen er 2.5.0
lapa/woocommerce/global/quantity-input.php versjon 3.3.0 er utdatert. Kjerneversjonen er 3.4.0
lapa/woocommerce/loop/loop-end.php
lapa/woocommerce/loop/loop-start.php
lapa/woocommerce/loop/orderby.php
lapa/woocommerce/loop/pagination.php
lapa/woocommerce/loop/sale-flash.php
lapa/woocommerce/myaccount/form-login.php versjon 3.3.0 er utdatert. Kjerneversjonen er 3.4.0
lapa/woocommerce/product-searchform.php
lapa/woocommerce/single-product/price.php
lapa/woocommerce/single-product/product-image.php
lapa/woocommerce/single-product/related.php
lapa/woocommerce/single-product/tabs/tabs.php
lapa/woocommerce/single-product/up-sells.php

Outdated Templates: ?
					
					
						L?r hvordan ? oppdatere

### Composite Products ###

Database Version: 3.13.10
Template Overrides: –

### Product Bundles ###

Database Version: 5.7.10
Template Overrides: –

### Klarna Checkout ###

Orders created via API callback: 4% (2 of 48) of all orders payed via Klarna Checkout was created via API callback during the last month. This is a fallback order creation feature. You should aim for 0%.

In the logs of the plugins, this shows up;
“2018-07-13T13:02:50+00:00 ERROR product_sync.error :: addStoreProduct :: 7508 :: Resource Not Found :: The requested resource could not be found. on 1432 in /home/2/s/spoeteriet/www/wp-content/plugins/mailchimp-for-woocommerce/includes/api/class-mailchimp-api.php”

• This reply was modified 6 years, 7 months ago by eivron. Reason: Added quote from log of the plugin

Hi @eivron, thanks for reaching out and providing the information. On the surface, this sounds like it may be a caching issue. Do you happen to have any plugins or a server-side caching service e.g. Cloudflare running on your site?

Thanks,
Kyle

I have WP Super Cache running. I will try to disable it and update this post on what happens. Thanks for the answer!

Edit: I have disabled WP Super Cache and tried to resync, but the problem is still there, the wizard still pops up regularly. What’s most annoying is that when it happens I’m stuck and can’t do ANYTHING on my site, which obviously is very very frustrating.

• This reply was modified 6 years, 7 months ago by eivron. Reason: Tested disabling the plugin

Any news on this? If I don’t get it sorted within a few days (before we go live) I would just have to disable and delete the whole plugin. I can’t risk setting it up after we go live if it keeps taking the whole site down for tens of minutes at a time.

@eivron sorry for the radio silence on this topic but I have a question for you. When you say “the wizard still pops up regularly” – are you referring to the screenshot that has the WordPress Install screen you originally showed?

That sounds more like a load balancing issue to me – do you have anything like that configured for your server(s)? Do you have multiple servers?

Have you deleted the MailChimp plugin – and checked to see if this issue has gone away?

are you referring to the screenshot that has the WordPress Install screen you originally showed?

Yes, that is correct.

That sounds more like a load balancing issue to me – do you have anything like that configured for your server(s)? Do you have multiple servers?

And no on both counts (unfortunately).

I have tried deleting the MailChimp plugin, and things works perfectly then. The issue about the wizard is only present when the sync is ongoing.

@eivron There must be a reason that the screen shows up. I’m going to take a guess that your MySQL database just might be having trouble processing the jobs in the queue – and possibly that’s why the install screen shows up ( because wordpress thinks the DB is not connected ). Are you on a shared host, a dedicated host?

Have you talked with your host about why this page shows up? I’m sure that they would be able to provide some metrics or limitations that would give us a clue on how and when this happens. Maybe they have a max number of queries per second, or per minute or per day etc that could be getting in the way? It’s hard to say – so please ask them if this is a normal issue.

Also – one other thing we can try is to disable the web based queue and use the CLI version to see if that calms things down. If you have SSH access we should give that a shot too – it’s certainly worth the effort. ( let us know if you do and we will provide instructions ).

So, I have talked to my host – I’m on a shared host. The max number of updates per hour are 36 000, which according to them should be more than enough, and if a plugin is trying to do more than these 36 000 something is very wrong about the plugin.

Other numbers;

max user connections: 500
max connections per hour: 36 000
max queries per hour: 360 000

I do have ssh access, so we could try that as well.

@eivron when you say ‘max number of updates’ what exactly do you mean there?

Yes since you have SSH access – lets give the CLI version a try. I can’t say for sure if this will solve your issue – but it’s certainly worth a try if your host is limiting you in any way.

1. You must have WP-CLI installed on your server.

2. You must have a php constant is set in your wp-config file of:
define("DISABLE_WP_HTTP_WORKER", true);

3. SSH into your machine – then run:
/usr/bin/wp --url=$YOUR_DOMAIN_URL --path=/path/to/domain_root/ queue listen

If you’ve done everything correctly – this process will just run for a while and log things to the console as the jobs get processed. If you see this processing jobs correctly – you’re then clear to set this exact command up as a cron job every minute to assure that it’s running at all times. Not WP-CRON, but a REAL cron job on the server.

*** one thing to note, is that when you commit to using the CLI version, the jobs will not process unless that command is running – so please make sure the command is working first before adding the cron schedule.

@eivron just pinging you back on this one – were you able to get everything handled? Do you have another update for us or should we close out this ticket?

Hi Ryan,

Sorry about the late reply, and thank you for your very good help this far. It seems to be working reasonably well (the plugin) at the moment, however, I haven’t tried to sync more times. Would I need to sync again in the foreseeable future (thinking here especially about plugin updates etc)? If that’s not the case then it’s most tempting to leave things as they are now. I do not think that I have enough knowledge to try and do what you wrote over here with SSH.

@eivron no – you should not have to sync again – unless there was trouble with your data getting into MailChimp the first time – which would be the orders, products, customers etc.

The original question you had posted here sounded very much like a database load issue or really even a site load issue that typically would not have anything to do with the plugin itself – but it’s really difficult to say what was causing that.

If you’re not experiencing this anymore – and the plugin is currently on, and syncing your data ( please check your logs for this in the plugin )… I would say we’re good ??

Feel free to re-open the ticket if you feel that we’re needing to look into anything further.