• Resolved dyayac

    (@dyayac)


    Hey to everyone who is reading this and thanks in advance for the help. I have successfully set up Woocommerce and linked it with Printify. I am able to add my products, but after a few additions the page automatically redirects to wp-admin/install.php. I have been searching through WordPress and Woocommerce threads with no luck. Would love some help! Report is below.

    
    ### WordPress Environment ###
    
    Home URL: https://www.yachtrockclothing.com
    Site URL: https://www.yachtrockclothing.com
    WC Version: 3.5.5
    Log Directory Writable: ?
    WP Version: 5.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2
    PHP Version: 7.1.1 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 20 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 1000
    cURL Version: 7.47.0
    GnuTLS/3.4.10
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.41-84.1-log
    Max Upload Size: 20 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 3.5.5
    WC Database Prefix: wp_lubn_
    MaxMind GeoIP Database: ?
    Total Database Size: 8.78MB
    Database Data Size: 4.80MB
    Database Index Size: 3.98MB
    wp_lubn_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB
    wp_lubn_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    wp_lubn_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
    wp_lubn_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
    wp_lubn_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
    wp_lubn_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB
    wp_lubn_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
    wp_lubn_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
    wp_lubn_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    wp_lubn_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
    wp_lubn_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    wp_lubn_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    wp_lubn_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    wp_lubn_woocommerce_log: Data: 0.02MB + Index: 0.02MB
    wp_lubn_commentmeta: Data: 0.02MB + Index: 0.03MB
    wp_lubn_comments: Data: 0.02MB + Index: 0.08MB
    wp_lubn_links: Data: 0.02MB + Index: 0.02MB
    wp_lubn_options: Data: 2.45MB + Index: 0.06MB
    wp_lubn_postmeta: Data: 1.52MB + Index: 3.00MB
    wp_lubn_posts: Data: 0.33MB + Index: 0.19MB
    wp_lubn_termmeta: Data: 0.02MB + Index: 0.03MB
    wp_lubn_terms: Data: 0.02MB + Index: 0.03MB
    wp_lubn_term_relationships: Data: 0.02MB + Index: 0.02MB
    wp_lubn_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    wp_lubn_usermeta: Data: 0.02MB + Index: 0.03MB
    wp_lubn_users: Data: 0.02MB + Index: 0.05MB
    wp_lubn_wc_download_log: Data: 0.02MB + Index: 0.03MB
    wp_lubn_wc_webhooks: Data: 0.02MB + Index: 0.02MB
    
    ### Post Type Counts ###
    
    attachment: 141
    customize_changeset: 1
    page: 8
    post: 2
    product: 16
    product_variation: 609
    revision: 5
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (2) ###
    
    Printify app: by  – 1.1
    WooCommerce: by Automattic – 3.5.5
    
    ### 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: #5 - /shop/
    Cart: #6 - /cart/
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Shopper
    Version: 1.3.6
    Author URL: https://shopperwp.io
    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: shopper/woocommerce/archive-product.php
    shopper/woocommerce/global/quantity-input.php
    shopper/woocommerce/single-product.php
    
    

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi, @dyayac!

    A few things you can check:

    a) Check if wp-config.php file exists in your installation
    b) Check the $table_prefix field in the wp-config file and make sure that it corresponds to table prefixes in your actual database
    c) Check your wp_options table and makes sure that both the siteurl and home are the same
    d) Check your root .htaccess file — try refreshing permalinks and loading the default WordPress directives

    See if any of these things help resolve the issue.

    Cheers!

    • This reply was modified 5 years, 9 months ago by Rynald0s.
    Thread Starter dyayac

    (@dyayac)

    Hey @rynald0s! Thank you sooo much for taking the time to help me out with this. I apologize for not being more clear, but I did find the steps you outlined above to resolve wordpress redirects with no luck. I am not sure if this helps, but I did check the php error logs and this came up:

    PHP Warning: mysqli_set_charset(): Error executing query in /hermes/bosnacweb04/bosnacweb04bd/b2884/ipg.dyayac07326/wp-includes/wp-db.php on line 806
    WordPress database error User ’21mA94Lt5Cs6q5t’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp\\_bykk\\_users’ made by display_setup_form
    20190223T225826: https://www.yachtrockclothing.com/wp-admin/index.php

    I am hoping this helps figure it out because I am stumped. Thanks again!!!

    • This reply was modified 5 years, 9 months ago by dyayac.
    Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi, @dyayac!

    It looks like your limit of 75, 000 SQL queries (max) are being reached within in an hour. I am not entirely sure why this triggers display_setup_form though, but it seems to boil down to a hosting issue (https://wordpress.stackexchange.com/questions/285768/wordpress-showing-install-screen-after-max-questions-error). See if your host can increase your max_questions resource limits and see if that helps resolve the issue

    Cheers!

    Thread Starter dyayac

    (@dyayac)

    Thanks so much! Any idea why the database it getting 75,000 queries in an hour? That seems like a crazy high amount, right?

    Thread Starter dyayac

    (@dyayac)

    In my error log I also see this error in about 95% of the report. Hope this helps.

    20190224T154331: https://www.yachtrockclothing.com/index.php
    PHP Warning: mysqli_set_charset(): Error executing query in /hermes/bosnacweb04/bosnacweb04bd/b2884/ipg.dyayac07326/wp-includes/wp-db.php on line 806

    Thread Starter dyayac

    (@dyayac)

    @rynald0s You left me in a great direction and it looks like my host sucks. I changed hosts and everything is super terrific. Thanks again for the help! You rock

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Woocommerce redirecting to install.php’ is closed to new replies.