Support » Fixing WordPress » Database updater error

  • After running the Woocommerce database updater the products in my store no longer appear. Here is a link to the page I am referring to: http://www.cupcakeinternational.com/product-category/new-arrivals/

    I don’t recall which version I updated from but it was a couple of years old so it was 2.something

    Here is the system status report

    
    ### WordPress Environment ###
    
    Home URL: http://www.cupcakeinternational.com
    Site URL: http://www.cupcakeinternational.com
    WC Version: 3.1.2
    Log Directory Writable: ✔
    WP Version: 4.8.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: ❌ 5.4.45 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
    PHP Post Max Size: 48 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 1000
    cURL Version: 7.38.0
    OpenSSL/1.0.1e
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.35
    Max Upload Size: 32 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.1.2
    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): ❌Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (16) ###
    
    Advanced Post Types Order: by Nsp Code – 3.9.8.2
    Dropbox Backup & Restore: by  – 1.5.1.4
    Envato WordPress Toolkit: by Envato – 1.7.3
    WPBakery Visual Composer: by Michael M - WPBakery.com – 4.7.4
    MailChimp for WordPress: by ibericode – 3.1.6
    Meta Box: by MetaBox.io – 4.12.3
    Nav Menu Roles: by Kathy Darling – 1.8.6
    Go Daddy Quick Setup: by GoDaddy.com
    LLC – 1.04
    
    Slider Revolution: by ThemePunch – 5.1.4
    Smart Passworded Pages: by Brian Layman – 2.0.0
    Widget Logic: by wpchefgadget
    alanft – 5.8.2
    
    WooCommerce Catalog Visibility Options: by Lucas Stark – 2.7.0 – 3.0.2 is available
    WooCommerce: by Automattic – 3.1.2
    Wordfence Security: by Wordfence – 6.3.17
    XMenu - The Ultimate WordPress Mega Menu: by G5Theme – 1.0.0.0
    Zorka Shortcode: by g5plus – 1.0
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    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-5 (rated-5)
    
    ### WC Pages ###
    
    Shop base: #135 - /pass/catalog/
    Cart: ❌ Page not set
    Checkout: ❌ Page not set
    My account: #138 - /my-account/
    
    ### Theme ###
    
    Name: Zorka
    Version: 1.2.6
    Author URL: http://g5plus.net/
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: zorka/woocommerce/archive-product.php
    zorka/woocommerce/cart/cart-totals.php
    zorka/woocommerce/cart/cross-sells.php
    zorka/woocommerce/cart/mini-cart.php
    zorka/woocommerce/checkout/form-billing.php
    zorka/woocommerce/checkout/form-checkout.php
    zorka/woocommerce/checkout/form-coupon.php
    zorka/woocommerce/checkout/form-login.php
    zorka/woocommerce/checkout/payment-method.php
    zorka/woocommerce/content-product.php
    zorka/woocommerce/content-product_cat.php
    zorka/woocommerce/content-single-product.php
    zorka/woocommerce/global/quantity-input.php
    zorka/woocommerce/loop/loop-end.php
    zorka/woocommerce/loop/loop-start.php
    zorka/woocommerce/loop/pagination.php
    zorka/woocommerce/loop/price.php
    zorka/woocommerce/loop/sale-flash.php
    zorka/woocommerce/myaccount/my-address.php
    zorka/woocommerce/product-searchform.php
    zorka/woocommerce/single-product/meta.php
    zorka/woocommerce/single-product/product-image.php
    zorka/woocommerce/single-product/related.php
    zorka/woocommerce/single-product/sale-flash.php
    zorka/woocommerce/single-product/share.php
    zorka/woocommerce/single-product/short-description.php
    zorka/woocommerce/single-product/up-sells.php
    zorka/woocommerce/single-product.php
    
    

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Goto PhpMyAdmin, find your database and make sure your tables are not marked as corrupted or crashed. Nevertheless, I recommend you to select all tables and click repair from the drop down menu.

    The page displays the following message: “No products were found matching your selection.”

    I am currently doing a restore to get it back up and running working correctly till I can find out a solution so the link above may work correctly again upon viewing it.

    I will take a look at that mcfreder. TY

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.