WC Database update 3.5.1 -> 3.6.4
-
Dear team,
I have a problem with wc database update. It was not fired automatically.
Status:
WordPress version: 5.2.1
WooCommerce version: 3.6.4
WooCommerce database version: 3.5.1I tried it manually, it wrote that the upgrade will be done on the background. But after several hours the version is still the same.
I don’t see any errors in log and there are no pending tasks on Scheduled Actions.Please advise how to make it consistent. I hope that a few days in such state will not generate problems. I have it on the production site. I made the upgrade on my stage few weeks ago without problems. The difference is that meanwhile you released version 3.6.4. So on the successful stage upgrade was from 3.5.1 to 3.6.3.
Thanks in advance
Michal### WordPress Environment ### WordPress address (URL): https://www.klbkovlny.sk Site address (URL): https://www.klbkovlny.sk WC Version: 3.6.4 Log Directory Writable: ? WP Version: 5.2.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ? Language: sk_SK External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.2.16 PHP Post Max Size: 48 MB PHP Time Limit: 0 PHP Max Input Vars: 2000 cURL Version: 7.47.0 OpenSSL/1.0.2g SUHOSIN Installed: – MySQL Version: 5.5.45-MariaDB-log Max Upload Size: 48 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 3.5.1 WC Database Prefix: qnggzr_ Total Database Size: 457.39MB Database Data Size: 287.38MB Database Index Size: 170.01MB qnggzr_woocommerce_sessions: Data: 27.56MB + Index: 0.50MB qnggzr_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB qnggzr_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB qnggzr_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB qnggzr_woocommerce_order_items: Data: 4.52MB + Index: 1.52MB qnggzr_woocommerce_order_itemmeta: Data: 27.56MB + Index: 31.09MB qnggzr_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB qnggzr_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB qnggzr_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB qnggzr_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB qnggzr_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB qnggzr_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB qnggzr_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB qnggzr_woocommerce_log: Data: 0.02MB + Index: 0.02MB qnggzr_commentmeta: Data: 0.23MB + Index: 0.27MB qnggzr_comments: Data: 17.55MB + Index: 16.09MB qnggzr_duplicator_packages: Data: 0.06MB + Index: 0.02MB qnggzr_hustle_modules: Data: 0.02MB + Index: 0.03MB qnggzr_hustle_modules_meta: Data: 0.02MB + Index: 0.03MB qnggzr_layerslider: Data: 0.52MB + Index: 0.00MB qnggzr_layerslider_revisions: Data: 0.02MB + Index: 0.00MB qnggzr_links: Data: 0.02MB + Index: 0.02MB qnggzr_options: Data: 26.56MB + Index: 4.52MB qnggzr_pmxe_exports: Data: 0.50MB + Index: 0.00MB qnggzr_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB qnggzr_pmxe_posts: Data: 6.52MB + Index: 0.00MB qnggzr_pmxe_templates: Data: 0.14MB + Index: 0.00MB qnggzr_pmxi_files: Data: 0.02MB + Index: 0.00MB qnggzr_pmxi_history: Data: 0.02MB + Index: 0.00MB qnggzr_pmxi_images: Data: 0.08MB + Index: 0.00MB qnggzr_pmxi_imports: Data: 2.52MB + Index: 0.00MB qnggzr_pmxi_posts: Data: 7.52MB + Index: 7.03MB qnggzr_pmxi_templates: Data: 0.17MB + Index: 0.00MB qnggzr_postmeta: Data: 111.66MB + Index: 71.20MB qnggzr_posts: Data: 16.52MB + Index: 8.05MB qnggzr_redirection_404: Data: 1.38MB + Index: 0.84MB qnggzr_redirection_groups: Data: 0.02MB + Index: 0.03MB qnggzr_redirection_items: Data: 0.02MB + Index: 0.09MB qnggzr_redirection_logs: Data: 1.44MB + Index: 0.31MB qnggzr_smush_dir_images: Data: 0.02MB + Index: 0.03MB qnggzr_termmeta: Data: 0.09MB + Index: 0.11MB qnggzr_terms: Data: 0.02MB + Index: 0.03MB qnggzr_term_relationships: Data: 1.52MB + Index: 1.52MB qnggzr_term_taxonomy: Data: 0.05MB + Index: 0.03MB qnggzr_tm_taskmeta: Data: 0.02MB + Index: 0.03MB qnggzr_tm_tasks: Data: 0.02MB + Index: 0.02MB qnggzr_usermeta: Data: 19.55MB + Index: 22.06MB qnggzr_users: Data: 1.52MB + Index: 1.09MB qnggzr_wc_download_log: Data: 0.02MB + Index: 0.03MB qnggzr_wc_points_rewards_user_points: Data: 0.47MB + Index: 0.53MB qnggzr_wc_points_rewards_user_points_log: Data: 1.52MB + Index: 0.91MB qnggzr_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB qnggzr_wc_webhooks: Data: 0.02MB + Index: 0.02MB qnggzr_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB qnggzr_wfBlocks7: Data: 0.02MB + Index: 0.05MB qnggzr_wfConfig: Data: 0.44MB + Index: 0.00MB qnggzr_wfCrawlers: Data: 0.02MB + Index: 0.00MB qnggzr_wfFileChanges: Data: 0.02MB + Index: 0.00MB qnggzr_wfFileMods: Data: 3.52MB + Index: 0.00MB qnggzr_wfHits: Data: 1.52MB + Index: 0.23MB qnggzr_wfHoover: Data: 0.02MB + Index: 0.02MB qnggzr_wfIssues: Data: 0.06MB + Index: 0.06MB qnggzr_wfKnownFileList: Data: 1.52MB + Index: 0.00MB qnggzr_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB qnggzr_wfLocs: Data: 0.02MB + Index: 0.00MB qnggzr_wfLogins: Data: 0.17MB + Index: 0.06MB qnggzr_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB qnggzr_wfls_settings: Data: 0.02MB + Index: 0.00MB qnggzr_wfNotifications: Data: 0.02MB + Index: 0.00MB qnggzr_wfPendingIssues: Data: 0.02MB + Index: 0.13MB qnggzr_wfReverseCache: Data: 0.02MB + Index: 0.00MB qnggzr_wfSNIPCache: Data: 0.02MB + Index: 0.05MB qnggzr_wfStatus: Data: 0.13MB + Index: 0.09MB qnggzr_wfTrafficRates: Data: 0.02MB + Index: 0.00MB qnggzr_wsluserscontacts: Data: 0.02MB + Index: 0.02MB qnggzr_wslusersprofiles: Data: 0.06MB + Index: 0.03MB qnggzr_yith_wcwl: Data: 0.30MB + Index: 0.28MB qnggzr_yith_wcwl_lists: Data: 0.16MB + Index: 0.36MB qnggzr_yith_ywpar_points_log: Data: 0.02MB + Index: 0.00MB qnggzr_yoast_seo_links: Data: 0.23MB + Index: 0.11MB qnggzr_yoast_seo_meta: Data: 0.25MB + Index: 0.00MB tmp_grouped_products: Data: 0.02MB + Index: 0.00MB ### Post Type Counts ### acf: 2 acf-field: 2 acf-field-group: 2 attachment: 8587 logos: 13 mc4wp-form: 1 nav_menu_item: 128 page: 54 popup: 1 popup_theme: 6 post: 113 product: 4827 product_variation: 1807 revision: 209 shop_coupon: 54 shop_order: 10663 shop_order_refund: 8 shopannouncements: 2 testimonials: 2 user_request: 1 wpcf7_contact_form: 2 yith-wccos-ostatus: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (51) ### LayerSlider WP: by Kreatura Media – 6.4.0 Advanced Custom Fields: by Elliot Condon – 5.8.0 Advanced Sidebar Menu: by Mat Lipe – 7.5.4 Akismet Anti-Spam: by Automattic – 4.1.2 All-in-One WP Migration: by ServMask – 6.96 BJ Lazy Load: by Bj?rn Johansen Aron Tornberg angrycreative – 1.0.9 Breadcrumb NavXT: by John Havlik – 6.3.0 ?eské slu?by pro WordPress: by Pavel Hejn – 0.5 CommerceGurus Toolkit: by CommerceGurus – 1.8.2 Contact Form 7: by Takayuki Miyoshi – 5.1.3 Duplicator: by Snap Creek – 1.3.14 Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.1 Ecomail: by Ecomail.cz s.r.o. – 1.0 Fast Velocity Minify: by Raul Peixoto – 2.6.5 Giftable for WooCommerce: by Decom – 1.0.4 – Not tested with the active version of WooCommerce HTML Javascript Adder: by Aakash Chakravarthy – 3.9 Image Cleanup: by Robbert Langezaal Simon Duduica – 1.9.2 WPBakery Page Builder: by Michael M - WPBakery.com – 6.0.2 Mailchimp for WordPress: by ibericode – 4.5.2 Really Simple SSL: by Rogier Lankhorst Mark Wolters – 3.1.5 Redirection: by John Godley – 4.2.3 Redux Framework: by Team Redux – 3.6.15 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.1 SI Captcha Anti-Spam: by fastsecure – 3.0.3 – Not tested with the active version of WooCommerce Simple Tags: by Amaury BALMER – 2.5.4 TemplatesNext ToolKit: by TemplatesNext – 3.1.8 Under Construction: by WebFactory Ltd – 3.45 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.14 Klbko vlny libs for WordPress: by Michal Sopcak – 0.8 Besteron Payment Gateway: by Besteron – 1.0.16 – Not tested with the active version of WooCommerce WooCommerce Email Test: by RaiserWeb – 1.8 – Not tested with the active version of WooCommerce WooCommerce Google Analytics Integration: by WooCommerce – 1.4.9 WooCommerce Payment Fees Lite: by Pinch Of Code – 1.5.2 – Not tested with the active version of WooCommerce WooCommerce Quantity Increment: by Automattic WooThemes – 1.1.0 – Not tested with the active version of WooCommerce WooCommerce Stock Manager: by Vladislav Musílek – 1.2.6 – Not tested with the active version of WooCommerce WooCommerce Stock Synchronization: by Pronamic – 2.3.0 – Not tested with the active version of WooCommerce WP All Import - WooCommerce Add-On: by Soflyy – 1.4.1 WooCommerce: by Automattic – 3.6.4 WooSidebars: by WooCommerce – 1.4.5 Wordfence Security: by Wordfence – 7.3.2 Hustle: by WPMU DEV – 6.0.8.1 Yoast SEO: by Team Yoast – 11.3 – Not tested with the active version of WooCommerce WordPress Social Login: by Miled – 2.3.3 WP All Export: by Soflyy – 1.2.3 WP All Import: by Soflyy – 3.5.0 WP-Optimize: by David Anderson Ruhani Rabin Team Updraft – 2.3.3 Smush: by WPMU DEV – 3.2.0.1 WP Super Cache: by Automattic – 1.6.5 YITH WooCommerce Ajax Product Filter: by YITH – 3.6.3 YITH WooCommerce Custom Order Status: by YITHEMES – 1.1.5 – Not tested with the active version of WooCommerce YITH WooCommerce Wishlist: by YITH – 2.2.10 ### Inactive Plugins (2) ### WooCommerce Cash On Pickup: by Marian Kadanka – 1.5 – Not tested with the active version of WooCommerce WooCommerce Points and Rewards: by WooThemes – 1.5.10 – Not tested with the active version of WooCommerce ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: ? Force SSL: – Currency: EUR (€) Currency Position: right_space 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-4 (rated-4-2) rated-5 (rated-5) Connected to WooCommerce.com: – ### WC Pages ### Shop base: #1288 - /produkty-vlny-na-predaj/ Cart: #75065 - /cart/ Checkout: #75067 - /checkout/ My account: #1291 - /my-account/ Terms and conditions: ? Page not set ### Theme ### Name: Storesy Child Version: 1.7.2 Author URL: https://www.commercegurus.com Child Theme: ? Parent Theme Name: Storesy Parent Theme Version: 1.7.2 Parent Theme Author URL: https://www.commercegurus.com WooCommerce Support: ? ### Templates ### Overrides: storesy/woocommerce/archive-product.php storesy/woocommerce/checkout/form-checkout.php storesy-child/woocommerce/checkout/review-order.php storesy/woocommerce/content-product.php storesy/woocommerce/content-product_cat.php storesy/woocommerce/content-single-product.php storesy-child/woocommerce/emails/customer-new-account.php version 3.5.0 is out of date. The core version is 3.5.2 storesy-child/woocommerce/emails/customer-on-hold-order.php storesy-child/woocommerce/emails/customer-processing-order.php version 3.5.0 is out of date. The core version is 3.5.4 storesy/woocommerce/global/wrapper-end.php storesy/woocommerce/global/wrapper-start.php storesy/woocommerce/loop/loop-end.php storesy/woocommerce/loop/loop-start.php storesy/woocommerce/loop/orderby.php storesy/woocommerce/loop/pagination.php storesy/woocommerce/loop/sale-flash.php storesy/woocommerce/single-product/meta.php storesy-child/woocommerce/single-product/product-image.php storesy-child/woocommerce/single-product/product-thumbnails.php storesy/woocommerce/single-product/sale-flash.php storesy/woocommerce/single-product/share.php storesy-child/woocommerce/single-product/short-description.php storesy/woocommerce/single-product/tabs/tabs.php storesy/woocommerce/single-product/up-sells.php storesy/woocommerce/single-product-reviews.php storesy/woocommerce/single-product.php Outdated Templates: ? Learn how to update ### Action Scheduler ### Complete: 0 Oldest: – Newest: – Pending: 0 Oldest: – Newest: – Canceled: 0 Oldest: – Newest: – In-progress: 0 Oldest: – Newest: – Failed: 0 Oldest: – Newest: –The page I need help with: [log in to see the link]
-
Hi there,
Can you try going to WooCommerce>>Status>>Tools and use the
Update Databasetool
Link to image: https://cld.wthms.co/jcQNbzIf that doesn’t work, another suggestion would be to deactivate and then reactivate the WooCommerce plugin.
Hope this helps.
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.0I 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
- The topic ‘WC Database update 3.5.1 -> 3.6.4’ is closed to new replies.
