• Resolved MisterPotatoHead

    (@misterpotatohead)


    My website has gone down several times in the past couple of months. When that happens, I’ve been unable to login, but my host has said it’s due to Woocommerce errors. I’ve deleted the Woocommerce folder and reinstalled it via ftp and it’s come back each time. Today, I updated just the Woocommerce plugin and the same thing happened. My host provided the following log errors. I haven’t disabled other plugins to see if there’s a conflict yet but will this time. Any suggestions?

    [Fri May 13 11:50:05.616541 2022] [access_compat:error] [pid 111820:tid
    3663388989184] [client 69.163.216.11:52760] AH01797: client denied by
    server configuration:
    /home/brettburd/happydogdna.com/wp-content/uploads/woocommerce_uploads/,
    referer:
    https://www.happydogdna.com/wp-content/uploads/woocommerce_uploads/
    
    [Fri May 13 11:50:10.981072 2022] [fcgid:warn] [pid 111820:tid
    3663944038144] [client 207.46.13.90:9408] mod_fcgid: stderr: WordPress
    database error Failed to open the referenced table
    'wp_tup8xp_woocommerce_downloadable_product_permissions' for query ALTER
    TABLE <code>wp_tup8xp_wc_download_log</code>
    
    [Fri May 13 11:50:10.981162 2022] [fcgid:warn] [pid 111820:tid
    3663944038144] [client 207.46.13.90:9408] mod_fcgid: stderr:
    \t\t\t\t\tADD CONSTRAINT <code>fk_wp_tup8xp_wc_download_log_permission_id</code>
    
    [Fri May 13 11:50:10.981179 2022] [fcgid:warn] [pid 111820:tid
    3663944038144] [client 207.46.13.90:9408] mod_fcgid: stderr:
    \t\t\t\t\tFOREIGN KEY (<code>permission_id</code>)
    
    [Fri May 13 11:50:10.981196 2022] [fcgid:warn] [pid 111820:tid
    3663944038144] [client 207.46.13.90:9408] mod_fcgid: stderr:
    \t\t\t\t\tREFERENCES
    <code>wp_tup8xp_woocommerce_downloadable_product_permissions</code>
    (<code>permission_id</code>) ON DELETE CASCADE; made by
    require('wp-blog-header.php'), require_once('wp-load.php'),
    require_once('wp-config.php'), require_once('wp-settings.php'),
    do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters,
    WC_Install::check_version, WC_Install::install, WC_Install::create_tables
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Rafy a11n

    (@nawaz0705)

    Hi @misterpotatohead

    Thank you for reaching out!

    Kindly note that WooCommerce Admin is now added as a part of WooCommerce in version 6.5.0, and it (WooCommerce Admin plugin) should not be active.

    Please deactivate WooCommerce Admin plugin and let us know if this resolves the error.

    Also, in order for us to get a better understanding of your site setup, could you please share a copy of your website’s System Status Report?

    You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

    Thank you!

    Thread Starter MisterPotatoHead

    (@misterpotatohead)

    Hi @nawaz0705 , thank you for the reply.

    I don’t have Woocommerce Admin plugin installed.

    The following is my system report.

    Thanks.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.happydogdna.com
    Site address (URL): https://www.happydogdna.com
    WC Version: 6.5.1
    REST API Version: ? 6.5.1
    WC Blocks Version: ? 7.4.3
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 5.9.3
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.15
    PHP Post Max Size: 505 MB
    PHP Time Limit: 500
    PHP Max Input Vars: 3000
    cURL Version: 7.58.0
    OpenSSL/1.1.1
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.28-0ubuntu0.20.04.3
    Max Upload Size: 500 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.5.1
    WC Database Prefix: wp_tup8xp_
    Total Database Size: 31.70MB
    Database Data Size: 26.22MB
    Database Index Size: 5.48MB
    wp_tup8xp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_order_items: Data: 0.09MB + Index: 0.04MB + Engine MyISAM
    wp_tup8xp_woocommerce_order_itemmeta: Data: 0.47MB + Index: 0.37MB + Engine MyISAM
    wp_tup8xp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_tup8xp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_actionscheduler_actions: Data: 0.06MB + Index: 0.13MB + Engine InnoDB
    wp_tup8xp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_commentmeta__20190827_155757: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_comments: Data: 0.19MB + Index: 0.10MB + Engine MyISAM
    wp_tup8xp_comments__20190827_155757: Data: 0.11MB + Index: 0.07MB + Engine MyISAM
    wp_tup8xp_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_links__20190827_155757: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_maxbuttons_collections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_maxbuttons_collections__20190827_155757: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_maxbuttons_collections_trans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_maxbuttons_collections_trans__20190827_155757: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_maxbuttonsv3: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_maxbuttonsv3__20190827_155757: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_options: Data: 4.33MB + Index: 0.09MB + Engine MyISAM
    wp_tup8xp_options__20190827_155757: Data: 0.30MB + Index: 0.04MB + Engine MyISAM
    wp_tup8xp_postmeta: Data: 2.95MB + Index: 1.27MB + Engine MyISAM
    wp_tup8xp_postmeta__20190827_155757: Data: 1.89MB + Index: 0.72MB + Engine MyISAM
    wp_tup8xp_posts: Data: 1.47MB + Index: 0.13MB + Engine MyISAM
    wp_tup8xp_posts__20190827_155757: Data: 0.94MB + Index: 0.08MB + Engine MyISAM
    wp_tup8xp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_smush_dir_images__20190827_155757: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_term_relationships__20190827_155757: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_term_taxonomy__20190827_155757: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_termmeta__20190827_155757: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_terms__20190827_155757: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_usermeta__20190827_155757: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_users__20190827_155757: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_wc_download_log__20190827_155757: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp_tup8xp_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    wp_tup8xp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_tup8xp_wc_product_meta_lookup__20190827_155757: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_tup8xp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wc_webhooks__20190827_155757: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wcpdf_invoice_number__20190827_155757: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_tup8xp_wfconfig: Data: 2.11MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wffilemods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wfhits: Data: 1.02MB + Index: 0.20MB + Engine InnoDB
    wp_tup8xp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_tup8xp_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wflogins: Data: 1.34MB + Index: 0.16MB + Engine InnoDB
    wp_tup8xp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wfnotifications: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_tup8xp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_tup8xp_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wp_tup8xp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_woocommerce_api_keys__20190827_155757: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_attribute_taxonomies__20190827_155757: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_downloadable_product_perm__20190827_155757: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_log__20190827_155757: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_woocommerce_order_itemmeta__20190827_155757: Data: 0.24MB + Index: 0.19MB + Engine MyISAM
    wp_tup8xp_woocommerce_order_items__20190827_155757: Data: 0.05MB + Index: 0.02MB + Engine MyISAM
    wp_tup8xp_woocommerce_payment_tokenmeta__20190827_155757: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_woocommerce_payment_tokens__20190827_155757: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_woocommerce_sessions__20190827_155757: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_woocommerce_shipping_zone_locations__20190827_155757: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_tup8xp_woocommerce_shipping_zone_methods__20190827_155757: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_woocommerce_shipping_zones__20190827_155757: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_woocommerce_tax_rate_locations__20190827_155757: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_tup8xp_woocommerce_tax_rates__20190827_155757: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_tup8xp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_wpml_mails: Data: 0.41MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_yoast_indexable: Data: 0.14MB + Index: 0.08MB + Engine InnoDB
    wp_tup8xp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_tup8xp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_tup8xp_yoast_seo_links__20190827_155757: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wp_tup8xp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_tup8xp_yoast_seo_meta__20190827_155757: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    amn_mi-lite: 3
    attachment: 140
    nav_menu_item: 7
    oembed_cache: 1
    optionsframework: 2
    page: 33
    post: 2
    product: 7
    question: 12
    revision: 220
    shop_coupon: 6
    shop_order: 675
    shop_order_refund: 39
    slide: 8
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (7) ###
    
    Avada Builder: by ThemeFusion – 3.7.1
    Avada Core: by ThemeFusion – 5.7.1
    Avada Custom Branding: by ThemeFusion – 1.2
    WooCommerce: by Automattic – 6.5.1
    Wordfence Security: by Wordfence – 7.5.9
    Yoast SEO: by Team Yoast – 18.8
    WP Super Cache: by Automattic – 1.7.7
    
    ### Inactive Plugins (12) ###
    
    Akismet Anti-Spam: by Automattic – 4.2.3
    Contact Form 7: by Takayuki Miyoshi – 5.5.6
    Custom Permalinks: by Sami Ahmed Siddiqui – 2.4.0
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.5.2
    Smush: by WPMU DEV – 3.9.9
    Velvet Blues Update URLs: by VelvetBlues.com – 3.2.10
    WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.14.5
    WordPress FAQ Manager: by Andrew Norcross – 1.331
    WP Edit: by Josh Lobe – 4.0.4
    WPForms Lite: by WPForms – 1.7.4.1
    WP Mail Logging: by Wysija – 1.10.4
    WP Mail SMTP: by WPForms – 3.4.0
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### 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)
    
    Connected to WooCommerce.com: –
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #23 - /shop/
    Cart: #24 - /cart/
    Checkout: #25 - /checkout/
    My account: ? Page visibility should be public
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Avada
    Version: 7.7.1
    Author URL: https://themeforest.net/user/ThemeFusion
    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: Avada/woocommerce/cart/cart.php
    Avada/woocommerce/checkout/form-pay.php
    Avada/woocommerce/checkout/review-order.php
    Avada/woocommerce/checkout/thankyou.php
    Avada/woocommerce/loop/loop-start.php
    Avada/woocommerce/single-product/add-to-cart/variable.php
    Avada/woocommerce/single-product/short-description.php
    Avada/woocommerce/single-product/tabs/additional-information.php
    Avada/woocommerce/single-product/tabs/description.php
    
    ### Action Scheduler ###
    
    Complete: 68
    Oldest: 2022-04-27 11:03:55 -0400
    Newest: 2022-05-16 17:06:01 -0400
    
    Pending: 3
    Oldest: 2022-05-16 19:23:07 -0400
    Newest: 2022-05-19 12:19:51 -0400
    
    ### Status report information ###
    
    Generated at: 2022-05-16 17:06:44 -04:00
    
    Plugin Support Rashed Ripon (a11n)

    (@rur165)

    Hello @misterpotatohead ,

    Since this is about core WooCommerce rather than WooCommerce Admin, it will be better if you post this to the core forum.

    However, from the log you got from your hosting, it seems there are some problems with some tables in the database: wp_tup8xp_wc_download_log, fk_wp_tup8xp_wc_download_log_permission_id

    Also, your server denied one of the requests to access the upload folder: /home/brettburd/happydogdna.com/wp-content/uploads/woocommerce_uploads/

    It will be best to communicate with your hosting provider to know if they have any specific configuration that denies the users to use of those folders.

    Also, you can try to reset those specific tables if possible. Please always keep a full backup of your database before making any changes.

    I’ll mark this thread as resolved here.

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Website Repeatedly Down’ is closed to new replies.