• Resolved hmseb

    (@hmseb)


    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)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database update hangs’ is closed to new replies.