Troubleshooting Common 'XML Sitemap Generator for Google' Errors and Warnings
Content
If you use the 'XML Sitemap Generator for Google' plugin, you might occasionally run into confusing error messages, warnings from security plugins, or unexpected behavior. This guide compiles the most common issues reported by users and provides steps to diagnose and resolve them.
1. False "Blocking Search Engines" Warning
The Problem: The plugin displays a warning that "Your site is currently blocking search engines!" even though your WordPress Reading Settings are correctly configured to allow search engine indexing.
Why It Happens: This is a known bug that has appeared in several plugin versions. The plugin's check against the blog_public WordPress option is not functioning as intended.
The Solution: This issue is typically resolved in subsequent plugin updates. Ensure your plugin is updated to the latest version. If the problem persists after updating, it is generally safe to ignore the warning as long as your actual WordPress settings are correct.
2. Wordfence "Suspected Malware URL" Alert
The Problem: Security plugins like Wordfence flag the file sitemap-core.php for containing a suspected malware URL: http://www.google-analytics.com/collect.
Why It Happens: This URL is part of the plugin's optional, anonymous usage statistics tracking feature. Wordfence's blacklist has incorrectly classified the non-HTTPS version of this legitimate Google Analytics endpoint.
The Solution: This is a false positive. You can safely ignore the warning in Wordfence. The 'XML Sitemap Generator for Google' team has addressed this in newer versions, but the alert may still trigger. If you are concerned, you can disable the anonymous data sharing option in the plugin's settings.
3. "There was a problem while notifying Google/Bing"
The Problem: The ping test or automatic notification to search engines fails, often accompanied by a debug log message.
Why It Happens: This can be caused by several factors:
- Bing's API Change: Bing has discontinued its instant ping feature. The plugin has since removed this functionality.
- DNS or Connection Issues: A temporary problem with your server's ability to connect to external services.
- Debug Mode: The error message might be obscured if
WP_DEBUG</code is disabled on your site.
The Solution:
- For Bing, no action is needed. Bing will automatically crawl your sitemap without manual pinging.
- For Google, try using the "Notify search engines now" button manually. If it works, the automatic ping will likely resolve itself.
- Check your server's error logs for more specific connection-related errors.
4. Database Error: "Unknown column 'post' in 'where clause'"
The Problem: A PHP error appears in your logs referencing an unknown column 'post' in a SQL query generated by the plugin.
Why It Happens: The error occurs when a post_type value in a SQL query is not wrapped in quotes, causing it to be interpreted as a database column name instead of a string value.
The Solution: This is a bug that the plugin's developers have fixed in an update. Updating the plugin to the latest version should resolve this error immediately.
5. Excessive Calls to Google/Bing
The Problem: Your server is making an extremely high number of calls to ping search engines, sometimes dozens per minute.
Why It Happens: This happens when the "Notify search engines about updates" option is enabled. The plugin is designed to ping them every time a post or page is published or updated. On a busy site with frequent changes, this can create many requests.
The Solution: If the volume of requests is problematic, you can disable the automatic notification feature. You can then manually submit your sitemap to Google Search Console and Bing Webmaster Tools, which is often more efficient.
General Troubleshooting Tips
- Update First: Always ensure you are running the latest version of the plugin, as many reported bugs are fixed in subsequent releases.
- Check Logs: Server error logs (often found in your hosting control panel) provide more detailed information than generic WordPress warnings.
- Conflict Test: If problems are unexplained, temporarily disable other plugins to test for a conflict.
Most issues with the 'XML Sitemap Generator for Google' plugin are minor and resolved through updates. By following these steps, you can quickly get your sitemap back on track.
Related Support Threads Support
-
search engine notification issuehttps://wordpress.org/support/topic/search-engine-notification-issue/
-
Blacklisted by GoDaddyhttps://wordpress.org/support/topic/blacklisted-by-godaddy/
-
error on line 2 at column 1: Extra content at the end of the documenthttps://wordpress.org/support/topic/error-on-line-2-at-column-1-extra-content-at-the-end-of-the-document-1/
-
Google-sitemap-generator flagged with XSS vulnerabilityhttps://wordpress.org/support/topic/google-sitemap-generator-flagged-with-xss-vulnerability/
-
User log-in and eMail assignedhttps://wordpress.org/support/topic/user-log-in-and-email-assigned/
-
Error Unknown Column ‘Post’ ……https://wordpress.org/support/topic/error-unknown-column-post/
-
Unable to login to admin dashboard, Google Sitemap Generator plugin errorhttps://wordpress.org/support/topic/unable-to-login-to-admin-dashboard-google-sitemap-generator-plugin-error/
-
Strange errorhttps://wordpress.org/support/topic/strange-error-39/
-
Failed to ping $service_idhttps://wordpress.org/support/topic/failed-to-ping-service_id/
-
PHP Notice: Failed to ping $service_id: success inhttps://wordpress.org/support/topic/php-notice-failed-to-ping-service_id-success-in/
-
WordPress flagging latest update on file sitemap-core.phphttps://wordpress.org/support/topic/wordpress-flagging-latest-update-on-file-sitemap-core-php/
-
Sitemap DB Error Messagehttps://wordpress.org/support/topic/sitemap-db-error-message/
-
Problem while notifying Binghttps://wordpress.org/support/topic/problem-while-notifying-bing/
-
Latest update resulted in a google met tag hackhttps://wordpress.org/support/topic/latest-update-resulted-in-a-google-met-tag-hack/
-
error log since yesterdayhttps://wordpress.org/support/topic/error-log-since-yesterday/
-
my site is hacked sitehttps://wordpress.org/support/topic/my-site-is-hacked-site/
-
Error with custom mysql portshttps://wordpress.org/support/topic/error-with-custom-mysql-ports/
-
“There was a problem while notifying Google (and Bing)”https://wordpress.org/support/topic/there-was-a-problem-while-notifying-google-and-bing/
-
NOT blocking search engineshttps://wordpress.org/support/topic/not-blocking-search-engines-2/
-
There was a problem while notifying Google.https://wordpress.org/support/topic/there-was-a-problem-while-notifying-google-7/
-
This plugin might have been hackedhttps://wordpress.org/support/topic/this-plugin-might-have-been-hacked/
-
Bing Bot 404’shttps://wordpress.org/support/topic/bing-bot-404s/
-
Sitemap conflict with Wordfencehttps://wordpress.org/support/topic/sitemap-conflict-with-wordfence/
-
Wordfence Errorhttps://wordpress.org/support/topic/wordfence-error-6/
-
Missing file in latest updatehttps://wordpress.org/support/topic/missing-file-in-latest-update/
-
Wordfence Security » Suspected malware URLhttps://wordpress.org/support/topic/wordfence-security-suspected-malware-url/
-
one big error in debug functionhttps://wordpress.org/support/topic/one-big-error-in-debug-function/
-
Error en el sitemap en Search Consolehttps://wordpress.org/support/topic/error-en-el-sitemap-en-search-console/
-
. tmp fileshttps://wordpress.org/support/topic/tmp-files-2/
-
XML ERROR Priority 2.0https://wordpress.org/support/topic/priority-2-0/
-
Error when connecting to Bing/ Googlehttps://wordpress.org/support/topic/error-when-connecting-to-bing-google/
-
Wordfence Problems foundhttps://wordpress.org/support/topic/wordfence-alert-problems-found-3/
-
Uninstalled plugin but error remainshttps://wordpress.org/support/topic/uninstalled-plugin-but-error-remains/
-
WP Site Guardian Found a Vulnerabilityhttps://wordpress.org/support/topic/wp-site-guardian-found-a-vulnerability/
-
There was a problem while notifying Googlehttps://wordpress.org/support/topic/there-was-a-problem-while-notifying-google-5/
-
PHP Notice: Failed to ping $service_id: error:InvalidApiKey in /home/wcipporg/puhttps://wordpress.org/support/topic/php-notice-failed-to-ping-service_id-errorinvalidapikey-in-home-wcipporg-pu/
-
fatal errors when using Query Monitorhttps://wordpress.org/support/topic/fatal-errors-when-using-query-monitor/
-
Zlib and GZhandlerhttps://wordpress.org/support/topic/zlib-and-gzhandler-3/
-
Plugin removed from repositoryhttps://wordpress.org/support/topic/plugin-removed-from-repository-10/
-
Trying to Deactivate Google XML Sitemap plugin, get 500 internal errorhttps://wordpress.org/support/topic/trying-to-deactivate-google-xml-sitemap-plugin-get-500-internal-error/
-
Lot of Calls to other siteshttps://wordpress.org/support/topic/lot-of-calls-to-other-sites/
-
PHP Warning: filemtime(): stat failedhttps://wordpress.org/support/topic/php-warning-filemtime-stat-failed/
-
Query noticehttps://wordpress.org/support/topic/query-notice/
-
Blocking search engineshttps://wordpress.org/support/topic/blocking-search-engines-2/
-
There was a problem while notifying Googlehttps://wordpress.org/support/topic/there-was-a-problem-while-notifying-google-4/
-
undefined constant ddsg_languagehttps://wordpress.org/support/topic/undefined-constant-ddsg_language-2/
-
There was a problem while notifying Google.https://wordpress.org/support/topic/there-was-a-problem-while-notifying-google-6/
-
Not A Good First Impressionhttps://wordpress.org/support/topic/not-a-good-first-impression-2/