Title: Database update hangs Last modified: April 7, 2017 --- # Database update hangs * Resolved [hmseb](https://wordpress.org/support/users/hmseb/) * (@hmseb) * [9 years, 1 month ago](https://wordpress.org/support/topic/database-update-hangs/) * SO I currently run the last verison of WP and the last version of Woocommerce, but the database update just wont go thru. * Site is pinuts.ca * I’m no expert, but here’s what I was able to get from my Debug file(sorry there’s french text): * SELECT * FROM wp_options WHERE option_name LIKE ‘wp_wc_updater_batch_%’ ORDER BY option_id ASC LIMIT 1 faite par do_action_ref_array, WP_Hook->do_action, WP_Hook- >apply_filters, WC_Background_Updater->handle_cron_healthcheck, WP_Background_Process- >handle, WP_Background_Process->get_batch [07-Apr-2017 13:53:34 UTC] PHP Notice: Trying to get property of non-object in /var/www/pinuts.ca/wp-content/plugins/ woocommerce/includes/libraries/wp-background-process.php on line 281 [07-Apr- 2017 13:53:34 UTC] PHP Notice: Trying to get property of non-object in /var/www/ pinuts.ca/wp-content/plugins/woocommerce/includes/libraries/wp-background-process. php on line 282 [07-Apr-2017 13:53:34 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/pinuts.ca/wp-content/plugins/woocommerce/includes/libraries/ wp-background-process.php on line 299 [07-Apr-2017 13:53:34 UTC] PHP Warning: mysqli_query(): (HY000/1194): Table ‘wp_options’ is marked as crashed and should be repaired in /var/www/pinuts.ca/wp-includes/wp-db.php on line 1877 [07-Apr- 2017 13:53:34 UTC] Erreur de la base de données WordPress Table ‘wp_options’ is marked as crashed and should be repaired pour la requête * Here is my Woocommerce status report: * ``` ### WordPress Environment ### Home URL: https://pinuts.ca Site URL: https://pinuts.ca WC Version: 3.0.1 Log Directory Writable: ✔ WP Version: 4.7.3 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: ✔ WP Cron: ✔ Language: fr_FR ### Server Environment ### Server Info: nginx/1.10.3 PHP Version: 7.0.17-1~dotdeb+8.1 PHP Post Max Size: 8 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.38.0 OpenSSL/1.0.1t SUHOSIN Installed: – Max Upload Size: 8 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ❌ Votre serveur n’a pas la classe SoapClient activée - certaines extensions de passerelle utilisant SOAP peuvent ne pas fonctionner correctement. DOMDocument: ✔ GZip: ✔ Multibyte String: ❌ Votre serveur ne supporte pas la fonction mbstring - celle-ci est obligatoire pour un meilleur encodage des caractères. Certaines alternatives seront utilisées pour cela. Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 2.6.14 WC Database Prefix: wp_ woocommerce_sessions: ✔ woocommerce_api_keys: ✔ woocommerce_attribute_taxonomies: ✔ woocommerce_downloadable_product_permissions: ✔ woocommerce_order_items: ✔ woocommerce_order_itemmeta: ✔ woocommerce_tax_rates: ✔ woocommerce_tax_rate_locations: ✔ woocommerce_shipping_zones: ✔ woocommerce_shipping_zone_locations: ✔ woocommerce_shipping_zone_methods: ✔ woocommerce_payment_tokens: ✔ woocommerce_payment_tokenmeta: ✔ MaxMind GeoIP Database: ✔ ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (23) ### Query Monitor: par John Blackbourn – 2.13.4 AfterShip - WooCommerce Tracking: par AfterShip – 1.6.8 Akismet Anti-Spam: par Automattic – 3.3 Beaver Builder Plugin (Agency Version): par The Beaver Builder Team – 1.9.5.3 iThemes Security: par iThemes – 6.2.1 Contact Form 7: par Takayuki Miyoshi – 4.7 Duplicator: par Snap Creek – 1.2.2 EWWW Image Optimizer: par Shane Bishop – 3.2.7 Product Sales Report Pro for WooCommerce: par Potent Plugins – 2.0.5 iThemes Sync: par iThemes – 1.8.3 Jetpack par WordPress.com: par Automattic – 4.8.1 Log Deprecated Notices: par Andrew Nacin – 0.4 Mobile Assistant Connector: par eMagicOne – 1.3.7 P3 (Plugin Performance Profiler): par GoDaddy.com – 1.5.3.9 Postman SMTP: par Jason Hendriks – 1.7.2 WooCommerce Product Filter: par Mihajlovic Nenad – 5.7.2 Responsive WordPress Slider - Soliloquy Lite: par Soliloquy Team – 2.5.1.3 UpdraftPlus - Sauvegarde/Restauration: par UpdraftPlus.Com DavidAnderson – 1.12.40 Video Thumbnails: par Sutherland Boswell – 2.12.3 Woocommerce Advanced Bulk Edit: par George Iron – 3.9.2 WooCommerce MailChimp: par Saint Systems – 2.0.20 WooCommerce: par Automattic – 3.0.1 Yoast SEO: par L’équipe Yoast – 4.5 ### Settings ### API Enabled: ✔ Force SSL: – Currency: CAD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) ### WC Pages ### Base boutique: #65 - /boutique/ Panier: #66 - /panier/ Commande: #67 - /commande/ Mon compte: #68 - /mon-compte/ ### Theme ### Name: Beaver Builder Child Theme Version: 1.0 Author URL: http://www.fastlinemedia.com Child Theme: ✔ Parent Theme Name: Beaver Builder Theme Parent Theme Version: 1.5.4 Parent Theme Author URL: http://www.wpbeaverbuilder.com/?utm_medium=bb-pro&utm_source=bb-theme&utm_campaign=themes-admin-page WooCommerce Support: ✔ ### Templates ### Overrides: – ``` * I’ve also tried deactivating my Woocommerce plugin and reactivate, but that didn’t change anything. The server was also restarted and it didn’t help. * Any clue on where to start? Viewing 2 replies - 1 through 2 (of 2 total) * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [9 years, 1 month ago](https://wordpress.org/support/topic/database-update-hangs/#post-9006332) * Go into your hosting control panel, PHPMyAdmin, and repair your options table. * This is for posts, but same thing applies [https://wptavern.com/how-to-repair-a-crashed-wordpress-posts-table](https://wptavern.com/how-to-repair-a-crashed-wordpress-posts-table) * Thread Starter [hmseb](https://wordpress.org/support/users/hmseb/) * (@hmseb) * [9 years, 1 month ago](https://wordpress.org/support/topic/database-update-hangs/#post-9006438) * Thanks for the quick reply, it worked. Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Database update hangs’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [update](https://wordpress.org/support/topic-tag/update/) * 2 replies * 2 participants * Last reply from: [hmseb](https://wordpress.org/support/users/hmseb/) * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/database-update-hangs/#post-9006438) * Status: resolved