Forum Replies Created

Viewing 15 replies - 1 through 15 (of 19 total)
  • Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    Cloudways support responded via a support ticket with the following

    It might be possible that the plugin would be making requests to a PHP file directly on your server due to which it is failing to connect.
    You are requested to enable Direct PHP Access for your applications using the following guide and then check and revert if the issue persists.
    https://support.cloudways.com/restrict-direct-access-to-wordpress-php-files/

    This setting has always been disabled anyway, so I can’t see how that would have suddenly started causing issues.

    Regardless, when I logged in to a couple of WordPress sites on this server, the Site Kit dashboard was working!

    I checked a website where I enabled the above setting and the Site Kit dashboard was working normally, and I checked a website where I did NOT enable that setting and Site Kit dashboard was working there too.

    I then disabled the setting again on the first website, and Site Kit is still working, so it must not be that setting that is affecting things.

    I also checked several WordPress installs on my other server, and those are now all working too, without me making any changes to that server or those WordPress files.

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    Hi James,

    I am based in New Zealand, and the server is hosted in Sydney, Australia. I’m not aware of any Google Services issues in these countries.

    Despite these errors occurring, Site Kit is obviously still reporting data to Google as all websites on the server still have Google Analytics data showing, even real time traffic.

    Cloudways don’t provide a huge amount of control over the server level security settings, and when I contacted their live support they kept telling me it was a CMS/plugin issue, not a server one.

    Though we’ve proven this not to be the case with a brand new clean WP install.

    Below are the security settings viewable on the Cloudways dashboard:

    Let me know if there are any specific settings you’d like to me check via SSH

    Services:
    Apache – Running
    Memcached – Running
    MySQL – Running
    New Relic – Stopped
    Nginx – Running
    PHP FPM – Running
    Redis – Running
    Varnish – Stopped

    Settings & Packages:
    Execution Limit: 60
    Upload Size: 200MB
    Memory Limit: 256MB
    Display Error: No
    Error Reporting: Default – [E_ALL & ~E_DEPRECATED & ~E_STRICT]
    PHP Timezone: Blank

    PHP:
    Max Input variables: 2500
    Max Input Time: 60
    APC Memory: 32
    OPCACHE Memory: 64
    Short Open Tag: Off
    XDebug: Disabled

    `MYSQL

    TIMEZONE Blank
    ENCODING US ASCII
    MAX CONNECTIONS LIMIT 150
    BUFFER POOL SIZE Default
    KEY BUFFER SIZE Default
    LOCK WAIT TIMEOUT Default
    WAIT TIMEOUT Default

    Apache
    ACCESS APPLICATION VIA IP Disabled

    NGINX
    DEFAULT APPLICATION None
    STATIC CACHE EXPIRY 43200
    WAF MODULE Disable
    TLS VERSIONS 1.0, 1.1, 1.2, 1.3

    System:
    Locales: Blank

    Varnish:
    Cache lifetime: 4 hours

    Misc:
    PHP 7.4
    MySQL MariaDB 10.1
    Elasticsearch Disabled
    Redis Installed
    Supervisord Not Installed!

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    Hi James,

    I set up a brand new WordPress install on my server and when I installed/activated the Site Kit plugin, I was shown

    Congratulations, the Site Kit plugin is now activated.
    Your site may not be ready for Site Kit
    Looks like your site is having a technical issue with requesting data from Google services.
    To get more help, ask a question on our support forum and include the text of the original error message:
    google_api_connection_fail

    .htaccess for the new install is just:

    # BEGIN WordPress
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ - [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    </IfModule>
    
    # END WordPress
    

    Site Health

    
    ### wp-core ###
    
    version: 5.7.2
    site_language: en_US
    user_language: en_US
    timezone: +00:00
    permalink: /index.php/%year%/%monthnum%/%day%/%postname%/
    https_status: true
    multisite: false
    user_registration: 0
    blog_public: 1
    default_comment_status: open
    environment_type: production
    user_count: 1
    dotorg_communication: true
    
    ### wp-paths-sizes ###
    
    wordpress_path: /home/XXXXX.cloudwaysapps.com/chmnrktaba/public_html
    wordpress_size: 43.71 MB (45835835 bytes)
    uploads_path: /home/XXXXX.cloudwaysapps.com/chmnrktaba/public_html/wp-content/uploads
    uploads_size: 0.00 B (0 bytes)
    themes_path: /home/XXXXX.cloudwaysapps.com/chmnrktaba/public_html/wp-content/themes
    themes_size: 6.44 MB (6754604 bytes)
    plugins_path: /home/XXXXX.cloudwaysapps.com/chmnrktaba/public_html/wp-content/plugins
    plugins_size: 8.80 MB (9228743 bytes)
    database_size: 2.11 MB (2211840 bytes)
    total_size: 61.06 MB (64031022 bytes)
    
    ### wp-active-theme ###
    
    name: Twenty Twenty-One (twentytwentyone)
    version: 1.2 (latest version: 1.3)
    author: the WordPress team
    author_website: https://www.ads-software.com/
    parent_theme: none
    theme_features: core-block-patterns, automatic-feed-links, title-tag, post-formats, post-thumbnails, menus, html5, custom-logo, customize-selective-refresh-widgets, wp-block-styles, align-wide, editor-styles, editor-style, editor-font-sizes, custom-background, editor-color-palette, editor-gradient-presets, responsive-embeds, custom-line-height, experimental-link-color, custom-spacing, custom-units, widgets
    theme_path: /home/XXXXX.cloudwaysapps.com/chmnrktaba/public_html/wp-content/themes/twentytwentyone
    auto_update: Disabled
    
    ### wp-themes-inactive (2) ###
    
    Twenty Nineteen: version: 2.0, author: the WordPress team, Auto-updates disabled
    Twenty Twenty: version: 1.7, author: the WordPress team, Auto-updates disabled
    
    ### wp-plugins-active (1) ###
    
    Site Kit by Google: version: 1.32.0, author: Google, Auto-updates disabled
    
    ### wp-media ###
    
    image_editor: WP_Image_Editor_Imagick
    imagick_module_version: 1687
    imagemagick_version: ImageMagick 6.9.7-4 Q16 x86_64 20170114 https://www.imagemagick.org
    file_uploads: File uploads is turned off
    post_max_size: 200M
    upload_max_filesize: 200M
    max_effective_size: 200 MB
    max_file_uploads: 20
    imagick_limits: 
    	imagick::RESOURCETYPE_AREA: 4 GB
    	imagick::RESOURCETYPE_DISK: 1.844674407371E+19
    	imagick::RESOURCETYPE_FILE: 768
    	imagick::RESOURCETYPE_MAP: 4 GB
    	imagick::RESOURCETYPE_MEMORY: 2 GB
    	imagick::RESOURCETYPE_THREAD: 1
    gd_version: 2.2.5
    ghostscript_version: 9.26
    
    ### wp-server ###
    
    server_architecture: Linux 5.11.13-x86_64-linode143 x86_64
    httpd_software: Apache/2.4.25 (Debian)
    php_version: 7.4.16 64bit
    php_sapi: fpm-fcgi
    max_input_variables: 2500
    time_limit: 60
    memory_limit: 256M
    max_input_time: 60
    upload_max_filesize: 200M
    php_post_max_size: 200M
    curl_version: 7.52.1 OpenSSL/1.0.2u
    suhosin: false
    imagick_availability: true
    pretty_permalinks: true
    htaccess_extra_rules: false
    
    ### wp-database ###
    
    extension: mysqli
    server_version: 10.1.48-MariaDB-1~stretch
    client_version: mysqlnd 7.4.16
    
    ### wp-constants ###
    
    WP_HOME: undefined
    WP_SITEURL: undefined
    WP_CONTENT_DIR: /home/XXXXX.cloudwaysapps.com/chmnrktaba/public_html/wp-content
    WP_PLUGIN_DIR: /home/XXXXX.cloudwaysapps.com/chmnrktaba/public_html/wp-content/plugins
    WP_MEMORY_LIMIT: 40M
    WP_MAX_MEMORY_LIMIT: 256M
    WP_DEBUG: false
    WP_DEBUG_DISPLAY: true
    WP_DEBUG_LOG: false
    SCRIPT_DEBUG: false
    WP_CACHE: false
    CONCATENATE_SCRIPTS: undefined
    COMPRESS_SCRIPTS: undefined
    COMPRESS_CSS: undefined
    WP_LOCAL_DEV: undefined
    DB_CHARSET: utf8
    DB_COLLATE: undefined
    
    ### wp-filesystem ###
    
    wordpress: writable
    wp-content: writable
    uploads: writable
    plugins: writable
    themes: writable
    
    ### google-site-kit ###
    
    version: 1.32.0
    php_version: 7.4.16
    wp_version: 5.7.2
    reference_url: https://XXXXX.cloudwaysapps.com
    amp_mode: no
    site_status: not-connected
    user_status: not authenticated
    connected_user_count: none
    active_modules: site-verification, search-console
    required_scopes: 
    	openid: ?
    	https://www.googleapis.com/auth/userinfo.profile: ?
    	https://www.googleapis.com/auth/userinfo.email: ?
    	https://www.googleapis.com/auth/siteverification: ?
    	https://www.googleapis.com/auth/webmasters: ?
    capabilities: 
    	googlesitekit_authenticate: ?
    	googlesitekit_setup: ?
    	googlesitekit_view_posts_insights: ?
    	googlesitekit_view_dashboard: ?
    	googlesitekit_view_module_details: ?
    	googlesitekit_manage_options: ?
    enabled_features: 
    	ga4setup: ?
    	helpVisibility: ?
    	ideaHubModule: ?
    	serviceSetupV2: ?
    	storeErrorNotifications: ?
    	userInput: ?
    	widgets.dashboard: ?
    	widgets.pageDashboard: ?
    	widgets.moduleScreens: ?
    search_console_property: none
    
    
    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    Hi James,

    Yes when I rebooted the server, it seemed to work fine, however when I checked a couple of days later it went back to showing the json error.

    I’ve just checked my other Cloudways server and now all WordPress installations on that one are having the same issue too.

    Running wp-cli on the .com WP install directory we’ve been discussing above resulted in the following:

    [master_XXXXXXXXX]:public_html$ wp eval 'print_r(wp_remote_head("https://sitekit.withgoogle.com"));'
    Array                                                                                                                                                                                                              
    (                                                                                                                                                                                                                  
        [headers] => Requests_Utility_CaseInsensitiveDictionary Object                                                                                                                                                 
            (                                                                                                                                                                                                          
                [data:protected] => Array                                                                                                                                                                              
                    (                                                                                                                                                                                                  
                        [content-type] => text/html; charset=utf-8                                                                                                                                                     
                        [vary] => Accept-Encoding                                                                                                                                                                      
                        [content-encoding] => gzip                                                                                                                                                                     
                        [x-cloud-trace-context] => ca2c5188042cca358084c72f3090b444                                                                                                                                    
                        [date] => Wed, 19 May 2021 22:34:32 GMT                                                                                                                                                        
                        [server] => Google Frontend                                                                                                                                                                    
                        [cache-control] => private                                                                                                                                                                     
                        [alt-svc] => h3-29=":443"; ma=2592000,h3-T051=":443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43"           
                    )                                                                                                                                                                                                  
                                                                                                                                                                                                                       
            )                                                                                                                                                                                                          
                                                                                                                                                                                                                       
        [body] =>                                                                                                                                                                                                      
        [response] => Array                                                                                                                                                                                            
            (                                                                                                                                                                                                          
                [code] => 200                                                                                                                                                                                          
                [message] => OK                                                                                                                                                                                        
            )                                                                                                                                                                                                          
                                                                                                                                                                                                                       
        [cookies] => Array                                                                                                                                                                                             
            (                                                                                                                                                                                                          
            )                                                                                                                                                                                                          
                                                                                                                                                                                                                       
        [filename] =>                                                                                                                                                                                                  
        [http_response] => WP_HTTP_Requests_Response Object                                                                                                                                                            
            (                                                                                                                                                                                                          
                [response:protected] => Requests_Response Object                                                                                                                                                       
                    (                                                                                                                                                                                                  
                        [body] =>                                                                                                                                                                                      
                        [raw] => HTTP/1.1 200 OK                                                                                                                                                                       
    Content-Type: text/html; charset=utf-8                                                                                                                                                                             
    Vary: Accept-Encoding                                                                                                                                                                                              
    Content-Encoding: gzip                                                                                                                                                                                             
    X-Cloud-Trace-Context: ca2c5188042cca358084c72f3090b444                                                                                                                                                            
    Date: Wed, 19 May 2021 22:34:32 GMT                                                                                                                                                                                
    Server: Google Frontend                                                                                                                                                                                            
    Cache-Control: private                                                                                                                                                                                             
    Transfer-Encoding: chunked                                                                                                                                                                                         
    Alt-Svc: h3-29=":443"; ma=2592000,h3-T051=":443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43"                                   
    Connection: close                                                                                                                                                                                                  
                                                                                                                                                                                                                       
                                                                                                                                                                                                                       
                        [headers] => Requests_Response_Headers Object                                                                                                                                                  
                            (                                                                                                                                                                                          
                                [data:protected] => Array                                                                                                                                                              
                                    (                                                                                                                                                                                  
                                        [content-type] => Array                                                                                                                                                        
                                            (                                                                                                                                                                          
                                                [0] => text/html; charset=utf-8                                                                                                                                        
                                            )
                                                                                                                                                                                                                       
                                        [vary] => Array                                                                                                                                                                
                                            (                                                                                                                                                                          
                                                [0] => Accept-Encoding                                                                                                                                                 
                                            )                                                                                                                                                                          
                                                                                                                                                                                                                       
                                        [content-encoding] => Array                                                                                                                                                    
                                            (                                                                                                                                                                          
                                                [0] => gzip                                                                                                                                                            
                                            )                                                                                                                                                                          
                                                                                                                                                                                                                       
                                        [x-cloud-trace-context] => Array                                                                                                                                               
                                            (                                                                                                                                                                          
                                                [0] => ca2c5188042cca358084c72f3090b444                                                                                                                                
                                            )                                                                                                                                                                          
                                                                                                                                                                                                                       
                                        [date] => Array                                                                                                                                                                
                                            (                                                                                                                                                                          
                                                [0] => Wed, 19 May 2021 22:34:32 GMT                                                                                                                                   
                                            )                                                                                                                                                                          
                                                                                                                                                                                                                       
                                        [server] => Array                                                                                                                                                              
                                            (                                                                                                                                                                          
                                                [0] => Google Frontend                                                                                                                                                 
                                            )                                                                                                                                                                          
                                                                                                                                                                                                                       
                                        [cache-control] => Array                                                                                                                                                       
                                            (                                                                                                                                                                          
                                                [0] => private                                                                                                                                                         
                                            )                                                                                                                                                                          
                                                                                                                                                                                                                       
                                        [alt-svc] => Array                                                                                                                                                             
                                            (                                                                                                                                                                          
                                                [0] => h3-29=":443"; ma=2592000,h3-T051=":443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v=
    "46,43"                                                                                                                                                                                                            
                                            )                                                                                                                                                                          
                                                                                                                                                                                                                       
                                    )                                                                                                                                                                                  
                                                                                                                                                                                                                       
                            )                                                                                                                                                                                          
                                                                                                                                                                                                                       
                        [status_code] => 200                                                                                                                                                                           
                        [protocol_version] => 1.1                                                                                                                                                                      
                        [success] => 1                                                                                                                                                                                 
                        [redirects] => 0                                                                                                                                                                               
                        [url] => https://sitekit.withgoogle.com/                                                                                                                                                       
                        [history] => Array                                                                                                                                                                             
                            (
                            )                                                                                                                                                                                          
                                                                                                                                                                                                                       
                        [cookies] => Requests_Cookie_Jar Object                                                                                                                                                        
                            (                                                                                                                                                                                          
                                [cookies:protected] => Array                                                                                                                                                           
                                    (                                                                                                                                                                                  
                                    )                                                                                                                                                                                  
                                                                                                                                                                                                                       
                            )                                                                                                                                                                                          
                                                                                                                                                                                                                       
                    )                                                                                                                                                                                                  
                                                                                                                                                                                                                       
                [filename:protected] =>                                                                                                                                                                                
                [data] =>                                                                                                                                                                                              
                [headers] =>                                                                                                                                                                                           
                [status] =>                                                                                                                                                                                            
            )                                                                                                                                                                                                          
                                                                                                                                                                                                                       
    ) 

    I am assuming the

                        [status_code] => 200                                                                                                                                                                           
                        [protocol_version] => 1.1                                                                                                                                                                      
                        [success] => 1                                                                                                                                                                                 
                        [redirects] => 0                                                                                                                                                                               
                        [url] => https://sitekit.withgoogle.com/                                                                                                                                                       
                        [history] => Array   

    Part means it was able to connect fine (200)?

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    Hi Jason,

    My mistake, I didn’t realise I was reporting a different domain, however all websites on this server (both the previous .co.nz and the .com now) are having this issue which leads me to believe it is a hosting problem too.

    Interestingly, I have an identical server with Cloudways that hosts about 10 websites and those are fine, and the settings between them are the same.

    I’ve just submitted a fresh form submission with this .com website I’ve been messaging you about yesterday/today.

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    @jamesosborne

    I spoke to soon as the error is now appearing again on those websites.

    Data error in Search Console Invalid JSON response

    Yes this still displays in troubleshooting mode inside incognito with all ad blockers/privacy trackers disabled.

    Yes I can see errors in the console when viewing my Sitekit dashboard (/wp-admin/admin.php?page=googlesitekit-dashboard).

    These errors are: https://i.imgur.com/1Y0r0gQ.png

    The errors seem to be identical even when troubleshoot mode is on for just this plugin.

    I deactivated and removed the plugin and reinstalled it from the WP repo and when reinstalling it am shown this error:

    Your site may not be ready for Site Kit
    Looks like your site is having a technical issue with requesting data from Google services.
    To get more help, ask a question on our support forum and include the text of the original error message:
    google_api_connection_fail
    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    @jamesosborne

    Strangely after rebooting my server instance, I was able to set up the plugin without issue.

    However now when I view the plugin dashboard, I get the following error:

    View post on imgur.com

    But if I view the Search Console page within the plugin, I see graphs and search terms like normal. And same for the Analytics page – that works fine too.

    The other websites on my server are now no longer showing the error either.

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    @jamesosborne thanks for your reply.

    I installed the Health Check & Troubleshooting plugin and ran the setup with the same error occurring. No notices were generated on the troubleshoot page.

    I’ve submitted my site health info report through that link.

    Interestingly I’ve noticed that the issue is now occurring on all other websites hosted on this server instance. So that would suggest it is a server issue. It is a VPS hosted by Cloudways.

    The VPS is set up as follows:

    2GB RAM
    1 Core CPU
    PHP 7.4
    MariaDB 10.1
    Redis – Enabled

    Execution limit: 60
    Upload size: 200
    Memory limit: 256
    Max input variables 2500
    Max input time: 60
    APC memory: 32
    OPCACHE memory: 64
    Max MYSQL connections: 1150
    WAF Module: disable
    TLS Versions: 1.0, 1.1, 1.2, 1.3

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    I tried several different SMTP providers, using an SMTP plugin within WordPress, and none of them were able to fix the problem.

    I also tried a competing plugin Post SMTP Mailer/Email Log using several different SMTP providers and none of them were able to fix the issue.

    I did however manage to solve this by setting up an SMTP send at my server level, rather than WordPress/CMS level.

    As soon as I did that, the timeout on the WooCommerce checkout page went away and emails were successfully delivered in bulk to the purchaser.

    So there’s obviously some kind of issue with WordPress/WooCommerece/third party SMTP plugins when dealing with large quantities of downloadable/virtual items being ordered, since virtual items send an email to the customer for each item ordered.

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    I tried several different SMTP providers, using an SMTP plugin within WordPress, and none of them were able to fix the problem.

    I also tried a competing plugin WP Mail SMTP by WPForms using several different providers and none of them were able to fix the issue.

    I did however manage to solve this by setting up an SMTP send at my server level, rather than WordPress/CMS level.

    As soon as I did that, the timeout on the WooCommerce checkout page went away and emails were successfully delivered in bulk to the purchaser.

    So there’s obviously some kind of issue with WordPress/WooCommerece/third party SMTP plugins when dealing with large quantities of downloadable/virtual items being ordered, since virtual items send an email to the customer for each item ordered.

    @vialactea

    If you’re not comfortable editing your database, it may be worth either getting your website host or a developer to do so, as deleting the wrong thing or accidentally making wrong changes to your database can cause significant issues. Take a backup before you do anything too, so you can restore things if necessary.

    To delete those tables, navigate to your database using PHPMyAdmin

    Look for the tables that will likely have a prefix XXX_ prior to their name:

    wp_actionscheduler_actions
    wp_actionscheduler_claims
    wp_actionscheduler_groups
    wp_actionscheduler_logs

    View post on imgur.com

    Click on the “Drop” button to delete the databases.

    Log in to your WordPress site and visit
    WooCommerce > Status > Tools > Update Database

    It will say something about required tables are missing, click here to generate. Do that, then run your WooCommerce database update and it should be fixed.

    @vialactea after much Googling I came across this post: https://github.com/woocommerce/woocommerce/issues/25987#issuecomment-605388627

    I deleted/dropped those tables from my database, made WooCommerce regenerate them and the issue was instantly fixed.

    The tables are:

    wp_actionscheduler_actions
    wp_actionscheduler_claims
    wp_actionscheduler_groups
    wp_actionscheduler_logs

    I suggest you take a backup of your database and do the same.

    The other consequence I noticed from this bug is that it was causing extremely high CPU usage on my VPS for this WordPress instance, the second I dropped the tables it was fixed.

    @vialactea

    Did you resolve this? I am having the exact same issue.

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    Hi RK,

    I am not talking about the accordion widget on the left, I am talking about the main area on the page displaying the category and child products.

    Thread Starter bluebirdwebdev

    (@bluebirdwebdev)

    I’ll ask Paymark to look at their plugin, but I doubt they will update it given they haven’t maintained it to date…

    In the meantime I’ve set up the BCC functionality, which is successfully delivering the customer’s confirmed order email with attachment.

    Just seems odd that it was working, and then all of a sudden wasn’t. Must have been a WooCommerce update that broke things, given the Paymark plugin is that old.

    Anyhow, thanks Ewout for your prompt support, very professional as always and most appreciated.

Viewing 15 replies - 1 through 15 (of 19 total)