Site map chunks get created even when not needed

I think it worked because you forced Drupal to rebuild the menus; in that way Drupal added the new menu callbacks that before it didn't know there were.
This happens because the implementation of hook_menu(), which is the responsible to make you see the content at http://www.magenbrot.net/sitemap0.xml, and http://www.magenbrot.net/sitemap1.xml, is called in few occasions by Drupal.

I think it's enough to make a call to menu_rebuild() to make it all work.
I will investigate on this later.

I added the call to menu_rebuild(). I fixed it internally, and the fix will be available to the next commit I do.

Actually, the simple call to menu_rebuild() doesn't resolve the issue.
The number of site map chunks produced changes with the number of links present in the site map. To call menu_rebuild() every time the number of links changes is not the solution.

I will look for a better solution.

Hi,

Can I add another URL to this discussion. I am afraid I am a bit of a novice so any advice on how to fix this would be appreciated. Happy to wait to the next upgrade if thats easier!

http://www.lomondmc.com/?q=sitemap.xml

Cheers
Matt

How much Drupal nodes do you have? It doesn't seem that your web site should have 50000 links in the site map, so I guess you changed the settings.
What are the actual XML Sitemap settings for your web site?

Hi,

I think I have about 40 drupal nodes, not sure how to find this out. I certainly haven't created 50,000 links. I have installed Gallery2 which generates its own sitemap.

My settings are:
Chunk size: 50000
Front Page priority: 1.0
Menus included Primary/ Secondary / XML / members

Search engine submit is turned off as I thought that might be the problem. I haven't put anything in the XML site map directory.

I am still building and testing the site so it is changing quite quickly, again I thought this might be an issue.

Any help much appreciated.

Matt

That is the reason I am asking.
If you didn't change the settings and you have less than 50,000 links, then XML Sitemap should not generate site map chunks.

I am testing the module on a local web site, and I have never got this issue. I will need to investigate on this more, to see if it's something that I cannot reproduce on a Mac for some reasons.

I change the report title as it seems the module is creating site map chunks even when it should not. I am not able to see the behavior on the test site I am using, so I will need to understand better why that happens.

I would need also to know on which PHP version the issue has been noticed, and other configuration settings (like the database engine being used, etc...).

Kiam,

Humm, getting a bit techie now, I am using MySQL, and I think it is PHP5 that is being used, but I am really not too sure. The hosting is with dream host and their wiki is at:http://wiki.dreamhost.com/

If you can give me a definative list of questions, I can submit it to the support team.

Thanks
Matt

http://www.magenbrot.net/admin/reports/status/php should give all necessary information (exact PHP, MySQL ... versions) if you're logged in as site administrator.

That is true for every Drupal-powered site; in /admin/report/status it's reported the version of PHP, database type, database version, and platform where Drupal is running.

The more I know, the more I can do to resolve the issue, which I cannot reproduce in my test site.

Hi Kiam,

Hope this helps. I think the HTTP issue is to do with an RSS feed on the site. If you want me to delete it for this test, I can do that.

Drupal 6.6
Access to update.php Protected
Configuration file Protected
Cron maintenance tasks Last run 59 min 41 sec ago
You can run cron manually.
Database updates Up to date
Drupal core update status No update data available
No information is available about potential new releases for currently installed modules and themes. To check for updates, you may need to run cron or you can check manually. Please note that checking for available updates can take a long time, so please be patient.
File system Writable (public download method)
GD library bundled (2.0.34 compatible)
HTTP request status Fails
Your system or network configuration does not allow Drupal to access web pages, resulting in reduced functionality. This could be due to your webserver configuration or PHP settings, and should be resolved in order to download information about available updates, fetch aggregator feeds, sign in via OpenID, or use other network-dependent services.
MySQL database 5.0.67
MySQL database for event module 5.0.67
PHP 5.2.6
PHP memory limit 90M
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Update notifications Enabled
Web server Apache/2.2.9 (Unix) PHP/4.4.9 mod_ssl/2.2.9 OpenSSL/0.9.8c mod_fastcgi/2.4.6 DAV/2 SVN/1.4.2

Cheers
Matt

That is what I needed to know. Actually, your configuration is not different from mine, so I don't understand why you have the issue, and I don't.

Hi,

I have installed the 16th Dec (6.x-1.) update, it still creates 2 chunks but under http://www.lomondmc.com/?q=sitemap0.xml
I get the following error message:

Page not found
user warning: Table 'lomonddrupal.xmlsitemap_files' doesn't exist query: SELECT n.nid, n.type, n.promote, f.fid, f.filepath, s.comment_count, xn.priority_override, xf.changed, xf.previously_changed FROM node n INNER JOIN xmlsitemap_files xf ON n.nid = xf.nid LEFT JOIN node_comment_statistics s ON n.nid = s.nid LEFT JOIN xmlsitemap_node xn ON n.nid = xn.nid LEFT JOIN file f ON f.fid = xf.fid WHERE n.status > 0 AND (n.type NOT IN ('21') AND xn.priority_override IS NULL OR xn.priority_override >= 0) AND f.filepath <> '' AND r.list = 1 GROUP BY n.nid, n.type, n.promote, f.fid, f.filepath, s.comment_count, xn.priority_override, xf.changed, xf.previously_changed in /home/lomondmc/lomondmc.com/modules/xmlsitemap/xmlsitemap_file/xmlsitemap_file.module on line 98.

Does that shed any light?
Cheers
Matt

hi

maybe this is interest. i see this error by google..

Starting side › administration › reports

Details
Typ PHP
Datum Mittwoch, 17. Dezember 2008 - 17:40
Benutzer guest
Ort ..../sitemap.xml
Referrer
Nachricht Table 'name.db_xmlsitemap_files' doesn't exist query: SELECT n.nid, n.type, n.promote, f.fid, f.filepath, s.comment_count, xn.priority_override, xf.changed, xf.previously_changed FROM db_node n INNER JOIN db_xmlsitemap_files xf ON n.nid = xf.nid LEFT JOIN db_node_comment_statistics s ON n.nid = s.nid LEFT JOIN db_xmlsitemap_node xn ON n.nid = xn.nid LEFT JOIN db_file f ON f.fid = xf.fid WHERE n.status > 0 AND (n.type NOT IN ('21') AND xn.priority_override IS NULL OR xn.priority_override >= 0) AND f.filepath <> '' AND r.list = 1 GROUP BY n.nid, n.type, n.promote, f.fid, f.filepath, s.comment_count, xn.priority_override, xf.changed, xf.previously_changed in ..../modules/xmlsitemap/xmlsitemap_file/xmlsitemap_file.module in Zeile 98.
Schweregrad Fehler
Hostadresse 66.249.71.241 < OrgName: Google Inc.

I fixed that, but that it was not what caused the module to output a chunk when it should not.

@mattbridgestock: Uninstall, and reinstall all the modules of the project.
I checked the code, and I don't see any reason you should get two site map chunks with just 40 nodes. I would also enable the clean URLs, and see if that changes anything. The fix for the previous issue will be available in the next 12 hours.

Anyway, as the number of links are counted with an SQL query, I would check the xmlsitemap database table. If the module thinks there are more than 50000, then that can be just caused by a wrong value returned by that SQL query.

Create a new content of type page, set the input format to PHP code, and enter the following code (<?php included)

 print (integer) db_result(db_query("SELECT COUNT(*) FROM {xmlsitemap}"));

Tell me what the page outputs after you save it.

The code simply counts the rows present in the database table used by xmlsitemap.module, and it's not harmful.

I am settings this like fixed, as it didn't get any feedback for more than a month.