osimiso

Hi Zach,

WP Super Cache – I deleted cached files and set Caching Off.
WooCommerce > Status >Tools and use the Update Database
Message:
Database upgrade routine has been scheduled to run in the background.
But as before nothing happens.
WooCommerce database version: 3.6.0

I run CLI then:
uid45109@shellserver:~/klbkovlny.sk/web$ php wp-cli.phar –info
OS: Linux 4.4.0-148-generic #174-Ubuntu SMP Tue May 7 12:20:14 UTC 2019 x86_64
Shell: /bin/bash
PHP binary: /usr/bin/php7.3
PHP version: 7.3.4-1+ubuntu16.04.1+deb.sury.org+3
php.ini used: /etc/php/7.3/cli/php.ini
WP-CLI root dir: phar://wp-cli.phar/vendor/wp-cli/wp-cli
WP-CLI vendor dir: phar://wp-cli.phar/vendor
WP_CLI phar path: /home/klbkovlny.sk/web
WP-CLI packages dir:
WP-CLI global config:
WP-CLI project config:
WP-CLI version: 2.2.0
uid45109@shellserver:~/klbkovlny.sk/web$ wp wc update
PHP Notice: Undefined index: HTTP_X_WP_TEMPORARY in phar:///home/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1169) : eval()’d code on line 77
PHP Notice: Undefined index: HTTP_X_WP_TEMPORARY in phar:///home/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1169) : eval()’d code on line 78
PHP Warning: include(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php): failed to open stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
Warning: include(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php): failed toopen stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
PHP Warning: include(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
Warning: include(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
PHP Warning: include_once(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php): failed to open stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 119
Warning: include_once(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php): failed to open stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 119
PHP Warning: include_once(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 119
Warning: include_once(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 119
Success: There are no updates needed. Database version is 3.6.4

WooCommerce database version: 3.6.4

Thanks for your support
Michal

Thanks for responses.

1. option by @amandasjackson
Can you try going to WooCommerce>>Status>>Tools and use the Update Database tool
– this doesn’t do anything, it wrote that database will be updated in the background, but after several hours the version remains the same.

2. wp wc update
With some changes in wp-config.php it works. DB version is 3.6.0. (I hope that it is correct as wc is 3.6.4)
Please see CLI output as there was some warnings.
uid45109@shellserver:~/klbkovlny.sk/web$ php wp-cli.phar –info
OS: Linux 4.4.0-148-generic #174-Ubuntu SMP Tue May 7 12:20:14 UTC 2019 x86_64
Shell: /bin/bash
PHP binary: /usr/bin/php7.3
PHP version: 7.3.4-1+ubuntu16.04.1+deb.sury.org+3
php.ini used: /etc/php/7.3/cli/php.ini
WP-CLI root dir: phar://wp-cli.phar/vendor/wp-cli/wp-cli
WP-CLI vendor dir: phar://wp-cli.phar/vendor
WP_CLI phar path: /home/klbkovlny.sk/web
WP-CLI packages dir:
WP-CLI global config:
WP-CLI project config:
WP-CLI version: 2.2.0
uid45109@shellserver:~/klbkovlny.sk/web$ wp cli update
Success: WP-CLI is at the latest version.
uid45109@shellserver:~/klbkovlny.sk/web$ wp wc update
PHP Notice: Undefined index: HTTP_X_WP_TEMPORARY in phar:///home/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1169) : eval()’dcode on line 77
PHP Notice: Undefined index: HTTP_X_WP_TEMPORARY in phar:///home/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1169) : eval()’dcode on line 78
PHP Warning: include(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php): failed to open stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
Warning: include(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php): failed to open stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
PHP Warning: include(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
Warning: include(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache-base.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 95
PHP Warning: include_once(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php): failed to open stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.phpon line 119
Warning: include_once(/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php): failed to open stream: No such file or directory in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 119
PHP Warning: include_once(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 119
Warning: include_once(): Failed opening ‘/nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/ossdl-cdn.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/klbkovlny.sk/web/wp-content/plugins/wp-super-cache/wp-cache.php on line 119
Found 7 updates (wc_update_352_drop_download_log_fk, wc_update_354_modify_shop_manager_caps, wc_update_354_db_version, wc_update_360_product_lookup_tables, wc_update_360_term_meta, wc_update_360_downloadable_product_permissions_index, wc_update_360_db_version)
Aktualizujem databázu 100% [===============================================================================================] 0:06 / 0:11
Success: 7 aktualizácia kompletná. Verzia databázy je 3.6.0

I made an update of wp-config.php
/** MySQL hostname *
if ( defined( ‘WP_CLI’ ) ) {
define( ‘DB_HOST’, ‘mariadb55.websupport.sk:3310’ );
}
else {
define(‘DB_HOST’, ‘:/tmp/mariadb55.sock’);
}

Lets do some testing now ??

Have a nice day
Michal

• This reply was modified 5 years, 9 months ago by osimiso.

Hi Nastia,

thanks for answer.
My setting are already :
define(‘WP_MEMORY_LIMIT’, ‘256M’);
memory_limit 256M (max)
max_execution_time 600s (max)

If I create staging environment from scratch all works. If it is a clone I see the error.
The second solution to remove Woocommerce on production site is out of option. This too dangerous.

I would like to know what part of the Hustle code runs out the memory. This could identify the conflict with woo. Is there some debugging options in Hustle?

Best regards
Michal

Hi Dimitris,
is there anything I can do?
There is still the same error:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /nfsmnt/hosting1_2/9/0/90c758fc-430d-4abc-be6c-296031b54077/klbkovlny.sk/sub/ttt/wp-includes/wp-db.php on line 1889

Hustle Version 6.0.5
WooCommerce Version 3.5.2

Best regards
Michal

Hi Dimitris,
Thanks for answer.
I did what you wrote.
But I have white screen again.

These are the values of option table after fresh install:
hustle_20_migrated 1 yes
hustle_color_index 0 yes
hustle_database_version 3.0.5 no
hustle_popup_migrated 1 yes

Best regards
Michal

Thanks for super fast response.
Yes increase of memory limit solved the issue. In DB I can see that the query takes more than 5s.
Query_time: 5.497520 Lock_time: 0.484138 Rows_sent: 841 Rows_examined: 47158
It is option table.
postmeta is even larger: 433 541 rows

I think my woocommerce get fat ??

Thanks, have a good luck
Michal

Hi Destac,
Thanks for quick response. But it didn’t work.

I put my main theme css “/wp-content/themes/storesy/css/commercegurus.css” to “Never minify the following CSS files:” section. I can see that the css is no longer minified.
The same with Layerslider – /wp-content/plugins/LayerSlider/static/css/layerslider.css

Fonts remains corrupted.

I’m using google fonts only.

Michal