Forum Replies Created

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter tommy4

    (@tommy4)

    Unfortunately, that one website uses the Google XML Sitemap plugin for XML Sitemaps.

    Anyway, the problem is present on multiple of our network websites and probably shows up when there are more than 1000 (or 2000) pages defined in WordPress. I also see the code in YoastSEO Pro for the sitemap generation is the same.

    Regarding the missing dates – we do not have missing dates in particular sitemaps – we have missing dates in the sitemap index (list of sitemaps). And this is not related to custom types.

    • This reply was modified 5 years, 3 months ago by tommy4.
    Thread Starter tommy4

    (@tommy4)

    Here is what happens when running the query in database:

    
    mysql> SELECT post_modified_gmt FROM ( SELECT @rownum:=0 ) init JOIN wp_2_posts USE INDEX( type_status_date ) WHERE post_status IN ('publish') AND post_type = 'page' AND ( @rownum:=@rownum+1 ) % 1000 = 0 ORDER BY post_modified_gmt ASC;
    Empty set, 2 warnings (0.00 sec)
    
    mysql> show warnings;
    +---------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Level   | Code | Message                                                                                                                                                                                              |
    +---------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Warning | 1287 | Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: 'SET variable=expression, ...', or 'SELECT expression(s) INTO variables(s)'. |
    | Warning | 1287 | Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: 'SET variable=expression, ...', or 'SELECT expression(s) INTO variables(s)'. |
    +---------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    2 rows in set (0.00 sec)
    

    And here is the result of modified query with deleted @rownum variables:

    
    SELECT post_modified_gmt FROM  wp_2_posts WHERE post_status IN ('publish') AND post_type = 'page' ORDER BY post_modified_gmt ASC;
    

    https://pastebin.com/KLHNMV4y

    The data seems to be ok.

    • This reply was modified 5 years, 3 months ago by tommy4.
    Thread Starter tommy4

    (@tommy4)

    Thank you for your quick response.

    1. Yes, we are running WordPress 5.6.2.
    2. Yes, we have wp-cli updating our plugins daily and also our employee checks all plugin versions weekly (as some plugins wp-cli have troubles updating like YoastSEO Pro πŸ™‚
    3. We have multi-site installation and we have two plugins installed: YoastSEO and YoastSEO Pro, both with version 15.9. The plugins are not network active. Some websites have YoastSEO active (majority) and we have one website with YoastSEO Pro active because the owner of the domain paid for it, so we keep unpaid version for other domains and paid version for that one.
    4. Server version: 8.0.23-0ubuntu0.20.04.1 (Ubuntu)
    5. Please see screenshot in my first post – these are normal post and pages. When I click on specific sitemap all of the items have modified time present.
    6. No, it doesn’t resolve.
    7. No, clearing the Cloudflare cache (we do that via API during deployment), browser cache (CTRL+F5, incognito, another browser), and clearing our memcached server doesn’t help
    8. It appears on our error log, we have made custom error handling, but without it, it would appear on debug.log or on the page itself if we had display_errors on and error_reporting that includes E_NOTICE.
    9. No, it appears on production so we do not have DEBUG mode on.
    10. They show up every time we or someone access the file /sitemap_index.xml

    Thread Starter tommy4

    (@tommy4)

    After deactivating and activating everthing works OK.

    Thread Starter tommy4

    (@tommy4)

    Hello, do you understand this difference or should I elaborate more? Are you 100% convinced for totally removing v2? You asked in some threads for real reasons for v2 – I gave you the reason here – v3 is not intended to be integrated alone, but with some support anti-bot solutions.

    This is described here:
    https://developers.google.com/recaptcha/docs/v3#score

    “reCAPTCHA v3 returns a score (1.0 is very likely a good interaction, 0.0 is very likely a bot). Based on the score, you can take variable action in the context of your site.”

    Thread Starter tommy4

    (@tommy4)

    The option to delete old thumbnails would be cool. Thank you for the plugin though.

    Thread Starter tommy4

    (@tommy4)

    Thanks,
    I found out that Invisible reCaptcha disables the HTML5 form client-side browser validation, which I don’t like so I’m not using it anyway.

    Thread Starter tommy4

    (@tommy4)

    Marking as resolved.

    Thread Starter tommy4

    (@tommy4)

    Ok, I installed VC14 dist x86+x64, Apache 2.4 x64, PHP 7.0.6 TS x64 and MySQL 5.7 from scratch and first time plugin activation was unsuccessful, however it throwed me an error max_execution_time exceeded, so I increased it to 120 and it is activated.

    Thank you for your assist.

    Thread Starter tommy4

    (@tommy4)

    Thank you for the reply. I found some logs in Apache directory, after some googling it seems that the problem is WAMP related and somewhere PHP is crashing. Maybe I will try to upgrade WAMP server or I will just test it on the Linux server before going to production.

    [Mon May 02 22:47:08.580071 2016] [mpm_winnt:notice] [pid 2604:tid 760] AH00428: Parent: child process 6268 exited with status 255 — Restarting.

    I will update to the latest 32-bit version and let you know.

Viewing 10 replies - 1 through 10 (of 10 total)