The site map is not being populated

You cannot find it because it has been set like duplicate of #376032: How to insert old nodes into the sitemap?. Both the reports are about an empty site map (that is implicit in the other report).

I cannot reproduce it in my web site.
I installed the last version, I went to /admin/reports/status where a warning of XML Sitemap told me the database needed to be updated, I clicked on the link reported, I clicked on the Next button; after I did that, the xmlsitemap table was still empty, so I forced the module to update the site map by visiting http://avpnet.org/sitemap.xml from a browser I didn't use to log in into my web site.

The result is that the site map of my web site is not empty, as you can verify.

The string you see (tags) is the array key used by Drupal for the vocabulary terms of tags type. That is what Drupal passes to hook_nodeapi(), and it's not what the module is expecting.
Like I reported on a task report I opened (see #376868: Change implementation of hook_nodeapi()), I am going to change that, and make possible for the module to handle the tags vocabulary terms too.

The procedure is half automated, as I am not able to make a batch operation start automatically after an update function is executed. I know there is the locale importing batch operation that starts automatically after a module is installed, but I really not know how that is implemented, nor if that is something possible to do for third party projects like XML Sitemap.

About making the database update automatic, I opened a task report (#380636: The update of the database should start in automatic). I will implement it in a few minutes.

I prefer to set it to fixed, so it will still be visible for the next 2 weeks, and this will avoid somebody else reports the same problem.

I've tried everything mentioned on these tickets, to no avail. My sitemap is always empty. I even tried uninstalling all xmlsitemap modules, which left my DB with no tables named "xmlsitemap*". After I added a bunch of nodes via /admin/content/node, I do see entries showing up in the xmlsitemap_node table, but the table named xmlsitemap has only one entry in it (for the "frontpage"). Fetching the XML via wget gives this:

loki (08:38) 271/0 $ curl http://www.ogre.com/sitemap.xml
<?xml version="1.0" encoding="UTF-8"?>
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">

If you are having problems with the site map being empty, then you are free to re-open the report.

Alright, yeah, I'm still having this problem :). I've tried all the suggestions here, and see my previous post on what I'm seeing in the DB (xmlsitemap has one entry, and xmlsitemap_node has one for each node in the sistemap. But, the xmlsitemap is always empty.

hi

same here ..new update...sitemap.xml is empty

Last updated: March 1, 2009 - 12:22
same

Same problem here : March 1, 2009 - 14:17

Same problem here - just updated to last version : March, 1st, 2009, 15:55 MEZ

same here with the 1 march version

same here w/mar 1st version.

ditto, sitemap.xml only gives

  <?xml version="1.0" encoding="UTF-8" ?> 
  <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd" /> 

I think the feb 28th one is where the problem appeared. using latest dev (march 1).

Uhmmm... Mine is almost empty.

<urlset xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">
<url>
<loc>http://avpnet.org/users/kiam</loc>
<lastmod>2009-03-01T13:08:41+00:00</lastmod>
<changefreq>monthly</changefreq>
<priority>0.5</priority>
</url>
</urlset>

I am lowering the priority, as the issue doesn't block Drupal or any third-party modules.

Same problem as listed in #17. The dev version from 2/20 worked fine. Once I updated to the 2/28 version, it stopped working, generating just a single node (like #17's listing). I had the same problem for the 3/1 version.

Note, I get the same problem when I uninstalled the 2/28 version, and re-installed a backup copy of the code from the 2/20 version. So, despite properly de-activating, uninstalling, re-installing, and running update.php, I can't get the 2/20 version working again after having tried the 2/28 and 3/1 versions.

I'm getting the same issue. Updated to recent dev version and sitemap.xml is only showing newly created nodes.

I did have over 12,000. But have created 8 new products. Now the sitemap shows only 8 url's

@AlexisWilke: Yes, there is a problem for the update flags; its content is not reset, but I would think that would give the opposite effect.

The project uses a Drupal variable that contains the name of the modules for which the links present in the xmlsitemap database table must be updated; each implementation of hook_xmlsitemap_links() verify if the list of modules that require to update their links includes the module the hook is defined in, or a module that is related to such module.
To make an example, xmlsitemap_node_xmlsitemap_links($modules) verifies that $modules contains a 'xmlsitemap', or 'xmlsitemap_node' key; if that is true, then it deletes all the links added from xmlsitemap_node.module from the xmlsitemap table.
The problem is that that Drupal variable is not reset to an empty array, after all the implementation of hook_xmlsitemap_links() are called.

I noticed it while I was re-writing the code which generates the cached content of the site map, and I cannot commit new code into CVS until I am not done with that.

i'm download new 2009-Mar-01 version install modules: XML Sitemap,XML Sitemap: Engines, XML Sitemap: Menu
my menu system based on taxonomy witch taxonomy_menu module
i'm run cron
but my sitemap.xml empty..
when i look in my datebase i find that table "xmlsitemap" contains full of my menu stucture witch rows like :
lid:3628, loc:category/2/739/749, module:category/2/739/749, type:menu, id:2322, sid:0, language:<EMPTY>, changed:0, changefreq:0, priority:0.5...etc.
but my sitemap.xml empty..

i've got the same problem too

@temp: May I ask you to report more of the content you see in your xmlsitemap table? I notice there is something wrong in that; the module field should not contain something like category/2/739/749, but it is supposed to contain values like xmlsitemap, xmlsitemap_node, etc... In other words, that should be the name of the module which inserted the link.
That field is used to select just the links inserted by modules that are enabled; if the content of the field is not the name of a XML Sitemap module, then the site map will surely not contain anything.

I checked the code contained in xmlsitemap_menu_xmlsitemap_links(), and the code is correct.
As you can see, the code sets the module field to the correct value (xmlsitemap_menu).

        $row = new stdClass();
        $row->module = 'xmlsitemap_menu';
        $row->type = 'menu';
        while ($mlid = db_result($result)) {
          $link = menu_link_load($mlid);
          // Avoid external links, or links to the front page;
          // both have $link['external'] set to 1.
          if (!$link['external'] && !$link['hidden'] && $link['access'] == 1) {
            $row->loc = $link['href'];
            $row->id = $mlid;
            $row->priority = min(max(round(($link['weight'] + 10) / 20, 1), 0.0), 1.0);
            if (db_result(db_query("SELECT loc FROM {xmlsitemap} WHERE loc = '%s'", $row->loc)) != $row->loc) {
              drupal_write_record('xmlsitemap', $row);
            }
          }
        }

sorry!! big sorry!!
i'm make mistake when paste, in my post, row from table
correctly it have look:
lid:3628, loc:category/2/739/749, module:xmlsitemap_menu, type:menu, id:2322, sid:0, language:<EMPTY>, changed:0, changefreq:0, priority:0.5...etc.

Actually, there is something new.
I changed the primary key of the xmlsitemap, and used an auto-incremental field (lid). Because the code that should have set the value of the new primary key in the existing rows didn't work, the xmlsitemap table has been emptied from the update function. This should not be a problem, as each XML Sitemap module has its own table to save the link data.

Same problem here. Fresh XML Sitemap revision 1.1.2.20 on fresh site (CVS DRUPAL-6--1 dev - is that bad? I do checkouts CVS on dev versions to make updates - and fixes to feed back - easier.)
Added my 'Primary Menu' and 'Nodes' (did not enable term, file or user)
No data.
Went into content, tried both 'add to sitemap' and 'change the priority' on all (only a dozen pages)
ran cron a few times.
no data.
Went into a few nodes, found they had an xml sitemap weight field. Saved them so they are tagged as 'updated'
no data
ran cron a few more times
no data.
Checked the status report - no warning. Ran module update script. No actions to be done.
Disabled them all. Uninstalled them all. ran update.php. re-enabled them. ran update.php.
re-enabled 'primary links'
ran cron.
no data

o_O

sorry!! big sorry!!
i'm make mistake when paste, in my post, row from table
correctly it look like this:

lid:3628, loc:category/2/739/749, module:xmlsitemap_menu, type:menu, id:2322, sid:0, language:<EMPTY>, changed:0, changefreq:0, priority:0.5
...etc.

There is nothing to be sorry, temp. I was worrying, if you would see such thing, because in that case it would have mean that some other module was messing with XML Sitemap database tables.

A question to all people having this issue. Did you visit the User settings page, and changed the value of User posts threshold? It would be better to change it for each users (in the user profile pages), but still that value should be changed for the users you trust.
That option has been introduced to avoid that a user who registers himself just to add spam would see his spam content grabbed by the search engines; it also avoids that a node created by error would be included in the site map (with Google Webmaster Tools complaining that it cannot find it anymore, once the node is removed).

The value shown in the User settings page is used when there isn't a value set for a specific user; if you already visited a user profile, and edited it, the value is not used anymore for that user.

Is there going to be an update to fix? or can you release a roll back until the issue is resolved?

i don't have "User posts threshold" item on my User settings page.
But i did not switch on module [XML Sitemap: User]

I'm not using the user module either.

Hi Kiam - changed "user posts threshold" to 1 - and we are back again - sitemap comes up - perfect!!!!

Ditto problems, my sitemaps are empty after this latest March update. Google Sitemap shows "Your Sitemap does not appear to be in a supported format. Please ensure it meets our Sitemap guidelines and resubmit."

just installed the 03/03/09 dev and still no better :(

Google Sitemap shows "Your Sitemap does not appear to be in a supported format. Please ensure it meets our Sitemap guidelines and resubmit."

Drupal 6.10
XML Sitemap 6.x-1.x-dev (2009-Mär-03)

.?xml version="1.0" encoding="UTF-8" ?.
.urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd" /.

thats all ..no nodes again

GUYS READ THE POSTS!!!!!

VISIT /admin/user/settings page and change the value of 'User posts threshold' to 1 - in words ONE - AND YOUR SITEMAP will be in PLACE AGAIN!!!!
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

i don't have this option on my /admin/user/settings

I had same problem as described in #28. Comments #30 and #38 doesn't solve it. Is any other suggestions?

@msiemens ....not working for me

i set it to ONE in

.user/1/edit?destination=admin%2Fuser%2Fuser
.admin/user/settings

clean cache and run cron---sitemap still empty

No nodes in my sitemap.xml. After enable terms into sitemap, the will appear in my sitemap.xml. Nodes still not!.

Solution #39 not works for me.

As a temporary fix, what tables can we populate to generate a default sitemap.xml?

I tried populating the xmlsitemap table with the following, and it seemed to work. Is this a safe work around?

insert into xmlsitemap (loc, `changed`, module, type, language, changefreq)
select concat("http://www.mywebsite.com/node/", nid) as nid,
`changed`,
"xmlsitemap",
"frontpage",
'',
1
from node

Note, populating xmlsitemap_node didn't change the output of sitemap.xml

Is it safe to manually populate the xmlsitemap table like this, or will it get overwritten at some frequency?
Does it matter what the values are for the module and type entries?

Debugging I trace the code and find xmlsitemap:

"lid";"loc";"module";"type";"id";"sid";"language";"changed";"changefreq";"priority"
"8";;"xmlsitemap";"frontpage";"0";"0";;"1236136385";"1";"1"
"14";"node/10";"xmlsitemap_menu";"menu";"171";"0";;"0";"0";"0.8"
"13";"node/8";"xmlsitemap_menu";"menu";"159";"0";;"0";"0";"0"
...

vs a Query that boils down to

SELECT xsm.loc, xsm.module, xsm.type, xsm.changed, xsm.changefreq, xsm.priority
FROM xmlsitemap xsm
INNER JOIN system s ON s.name = xsm.module
WHERE s.type = 'module'
AND s.status =1
AND xsm.loc <> ''
AND xsm.changefreq <>0
AND xsm.changed <>0
AND (
xsm.priority >=0
AND xsm.priority <=1
)
ORDER BY xsm.changed DESC , xsm.changefreq, xsm.priority DESC , xsm.loc

... so my problem is that neither AND xsm.changefreq or xsm.changed are getting set by anything I do to the nodes. The priority=0 is also a worry, as my node types should be setting that to at least .5 when I ran the updates.
Making a minor text edit I think was what got node/10 with a priority, but it still didn't list until I manually (through the DB) set 'changed' and 'changefreq' to something.

I tried to truncate the table and the results came back the same.
It seems that xmlsitemap_menu_xmlsitemap_links() doesn't even try to set a 'changed' or 'changefreq' when adding rows. Is there any place it gets updated later?

I experimented with turning off the menu version and just using nodes individually. They make it into xmlsitemap_node - but don't get transferred to xmlsitemap table (which I guess was supposed to happen? based on inspection of the chunk builder later.)

:-\
Maybe I can fix it on a dev site. Right now I'm hampered from breaking anything as it's a simple, but live site that I thought I could just install on.
I'm trying to help track it down here...
(And 'obsessively' hitting cron every time I make a change ;-)

---
In the meantime I added hard-coded values to to n xmlsitemap_menu_xmlsitemap_links()

        while ($mlid = db_result($result)) {
          $link = menu_link_load($mlid);
          // Avoid external links, or links to the front page;
          // both have $link['external'] set to 1.
          if (!$link['external'] && !$link['hidden'] && $link['access'] == 1) {
            $row->loc = $link['href'];
            $row->id = $mlid;
            $row->changefreq = 1;
            $row->changed = 1;
            $row->priority = min(max(round(($link['weight'] + 10) / 20, 1), 0.0), 1.0);
            if (db_result(db_query("SELECT loc FROM {xmlsitemap} WHERE loc = '%s'", $row->loc)) != $row->loc) {
              drupal_write_record('xmlsitemap', $row);
            }
          }
        }

... and I finally get results.

However, since you've just recently confirmed http://drupal.org/node/379854#comment-1310372 that that function is actually correct ... I must be doing something wrong.
Just WHERE does the required update to that table happen if not there?

Have tried the User Post set to 1 and still doesnt work.

I upgraded to 2009-03-03, set post and user threashold to 1. Still no result.

@dman:

Where did you put the code for it to work? I cannot find xmlsitemap_menu_xmlsitemap_links()

@Squidge:
The function is in xmlsitemap_menu.module inside the xmlsitemap_menu directory.

Replace the lines 47 to 59 with the code snippet from http://drupal.org/node/379854#comment-1315054.

Unfortunately this also doesn't work for me.

@farbkonstrukt:

Thank you. I'll give it a go and see if it works for me. Will update.

EDIT:
Didn't work for me either :(

same here... i set user_threshold to 1 but no nodes appear in my sitemap :-(

Maybe we should revert to an old code. What is the SVN command to fetch an older version?

Here's one from the 19th

Until DrupalCon is over (thats my guess on where Kiam is), I'm using the one from the 19th. It's working great for me. Haven't run a database update yet, but the sitemap shows up now. Nuked the files and re-uploaded; it works.
My Module settings are also only XMLSitemap, Engines and Nodes and the latest dev doesn't work. The one I posted above(http://drupal.org/node/379854#comment-1317792) should work for everyone.

I have removed the latest dev, and installed the 19 dev. But still not working for me :(

Google is still syaing there are errors:

Unsupported file format
Your Sitemap does not appear to be in a supported format. Please ensure it meets our Sitemap guidelines and resubmit.

Same here, no content in the sitemap.

The xmlsitemap table is still empty with the older dev version from Feb 19th.
Maybee an existing sitemap in the table is not affected, but drupal won't generate a new one.

UPDATE: I appear to now have content in my sitemap :)

I flushed the database tables for xmlsite map, then deleted them from MySQL.
Unticked the modules, ran updates, ran cron, removed the xmlsitemap module from /sites/all/modules.
Installed xmlsitemap from 19th, re ticked all areas, ran cron, ran updates. Error was presented by sitemap about updating tables. Ran that. And bingo

Have the same problem with latest dev version, have tried reinstalling, flushing, deleting tables, cron etc. to no avail.

@maximus007:

Flush the xml tables and remove from db. Uninstall from drupal. Run cron and updates. remove xmlsitemap from /modules.

then use http://drupal.org/node/379854#comment-1317792. Run cron and updates. Worked for me.

Also when you run the update, change all the xml site map versions, right back. For me it was v6000 or v6101.

>I flushed the database tables for xmlsite map, then deleted them from MySQL.
>Unticked the modules, ran updates, ran cron, removed the xmlsitemap module from /sites/all/modules.
>Installed xmlsitemap from 19th, re ticked all areas, ran cron, ran updates. Error was presented by sitemap about updating tables. Ran that. And bingo

I did the same and still nothing. This is hell.

Dont forget to change the versions:

change all the xml site map versions, right back. For me it was v6000 or v6101.

When you run the updates

Okay thanks. I am using advanced forum. Only the files that were modified recently appear in the sitemap. For example, forum files or pages. Should I run an SQL query to include all nodes?

I was able to get the newest XML Sitemap up and running by doing all the suggestions - including changing the number of required user postings from 500 back to 1, and running cron. I now get a full sitemap listing - with one exception. The sitemap does not list my main page (the home page of the domain)! In previous versions it did. I have checked the priorities, and all pages are at 0.5. The default for the main page is 1.0. But it is not in the sitemap.

Any ideas?

The same code, same actions but different results. I am not able to make the sitemap.xml to show the links for smokersassociation.org:
http://www.smokersassociation.org/sitemap.xml -> empty map
http://www.asociatiafumatorilor.ro/sitemap.xml -> this is ok

SOLVED!

Chunk size seems to be the problem. I have just red the last comment and changed the chunk size to 1 and then back to 200 .. and now it works. Strange :)

After I manually deleted every entry in the database where "xmlsitemap" was found, reinstalled the module, ran cron, resaved a few pages and ran cron again the sitemap came up again.

Just uninstalling the module didn't delete all related entries.

All done with the dev version from Feb 19th.

I've been deleting the module, reinstalling it, re-saving the topics, changing the chunk size, running cron and so, so, so, so on and on and all of it in any order that I could imagine, but my sitemap still doesn't contain my pages. It's non-production site yet with the two articles only, but, the Heaven, why? The module is 6.x-1.x-dev, dated March, 3, and Drupal is 6.10, the modules switched on are XML Sitemap, XML Sitemap: Engines and XML Sitemap: Node.

What I'm doing wrong? Where the records get to?

my `xmlsitemap_node` dump

INSERT INTO `xmlsitemap_node` VALUES (12,1236467300,1235952366,0,-2);
INSERT INTO `xmlsitemap_node` VALUES (3,1236467306,1232313982,0,-2);

but after running cron for 3-4 times I still get an empty `xmlsitemap` table and, of course, sitemap.xml is empty

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
  http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">

Can anybody explain the EXACT WAY how to get the sitemap working with all the pages included from scratch? I mean "from scratch" that I'm deleting all the XML Sitemap modules and tables.

By the way, once I could get some records in the `xmlsitemap` but I'm not able to repeat what I've been doing.

@mgearr Use this version (from feb 19th)
http://drupal.org/node/379854#comment-1317792

mikeytown2, thanks, but just the same non-working issue. The nodes are in the `xmlsitemap_node` but they don't get into `xmlsitemap` even after running cron 5 times.

The module worked fine some time ago, but I've decided to upgrade, and, of course, I've deleted the working version :) I wonder how it works today in somebody's hands, but not in mine.

May it all be because of the synonims? I have no other ideas.

@mgearr

Copy the Version from Feb 19th in your modules direktory, manualy delete all xmlsitemap* tables and all related entries in variable, system, menu_router and menu_links table, clear (not delete!) the cache tables. (Just do a search for "xmlsitemap" e.g. in phpmyadmin)

Then reinstall the module, read http://drupal.org/node/376032 and update (edit & save) e few nodes, run cron and i'm sure, your sitemap will come up again.

yes, it is back. I had to manually add pages to sitemap.

I don't know why, but the sitemap contains the pages now, while yesterday it didn't. Cron's been run repeatedly yesterday. I'm all at sea... However it's working now. Thank you

P.S. It seems like the records become visible some time after, not immediately and without reference to how much times you've run cron manually. So be patient and be waiting...

I'm struggling with an (almost) empty sitemap also. Tried all the suggested moves, completely removed xmlsitemap module and related database-content.

But, my sitemap only keeps showing the home-page, the 3 terms. But no nodes at all, none of the menu's, no users.

Can it be that the fact that my site is completely multilanguage has anything to do with it, and that this actually is the result of what is discussed in http://drupal.org/node/327273 ??

By the way, I'm running today's version (march 10th)

I too am using the latest dev version from March 10th, and the sitemap is completely empty. The tables look fine, and I've tried everything stated above (yes, everything), except waiting a day or two (I just installed this module today). Can anyone give a reason as to why simply waiting would work? I'm more than willing to wait, but I'd like to understand why that would work.

Also wanted to note that this is an issue with both new content as well as old content that is manually added from the content page. The nodes are added to the table, but never appear on the sitemap.

With the latest version from March 10th I get only the home page in the sitemap.
Updating content will put it in the sitemap.
I too have tried everything suggested here, so subscribing.

Latest Version (March 10th) - everything (!) tried - nothing works. Only an empty XML :( So many people have problems but nothing happens...

Well, an interesting observation was made by ikae in following bug-report: http://drupal.org/node/398072

Quote: "I found that only type "node" is not output to xml file."

If his English is correct and indeed that bug causes type "node" NOT to be output to the XML sitemap, it might clarify why the sitemaps turn up empty on so many sites.........

Tried #79 - XML still empty!

The answer to why the node links are not included in the site map has been already given. xmlsitemap_node.module has a setting to limit the nodes added to the site map; therefore the nodes will be added in the site map only when its author creates 100 nodes.
The default value of 100 nodes can be changed globally, or it can be changed for each users. That setting has been introduced so that, if you have some problematic users who keeps to add spam content, you can avoid his nodes get included in the site map.

@ #81: Sorry, your answer does not solves the problem. Also when all values (nodes created by user) set to 1 - the XML is emtpy!

Tried #81:

- found and adjusted the submission treshold for all users to 1
- updated a few nodes
- ran cron

No result. Sitemap still only contains the homepage and reference to the terms/categories. No nodes. No Menus, nothing usefull.

Then
- found the global treshold and adjusted to 1
- updated a few nodes
- ran cron

No result again. Same as above.

When checking through phpmyadmin, I do notice some thing that make me wonder:

- table xmlsitemap: contains homepage, terms, menus.
But: in the menu rows, fields /changed/ and /changefreq/ are empty (zero) -->> isn't this strange???
- table xmlsitemap_node: seems populated properly with all nodes
- table xmlsitemap_term: seems populated properly with all terms
- table xmlsitemap_node: seems populated properly with all nodes
- table xmlsitemap_user: seems populated properly with all users
- table xmlsitemap_user_role: empty

xmlsitemap_menu.module doesn't set any values for the changed, and changefreq fields because it's not able to give them a meaningful value.

My opinion: The bulk of this module(-thread) is waste.... I tried everything and nothing worked. I only feel frustration now ;) I hope for a solution :)

Subscribing, please keep the positive site and help the module owner to get this working!
I am not using the newest version yet, but awaiting results of this thread.

greetings,
Martijn

As result of fixing the issues listed in #398072: Errors in the code, the site map should now be populated with node links.
Wait 12 hours before the new archive get generated by Drupal, and you will get the fixed code.

I tried a direct CVS checkout of the DRUPAL-6--1 (dev) branch onto a totally new, separate site.
// $Id: xmlsitemap.module,v 1.1.2.48 2009/03/11 12:28:25 kiam Exp $

Set the user post threshold down
(- Isn't 100 really high?)
(- Can't we have posts by the admin override that by default?)

Used
XML Sitemap: Menu
XML Sitemap: Node
and the (new?)
XML Sitemap: Helper

Enabled the menu to be added
Ran cron etc. Just the front page :-(
As I reported above, some items appear in the xmlsitemap table, but they have both changed and changefreq set to 0. And this is what seemed to be preventing them from getting listed. However, touching those values in the DB now does NOT solve the problem like it did last time.

BUT adding some nodes via the content management screen DID get in! YAY!

On further testing, I found that I really really have to TRUNCATE cache often when testing, as it doesn't seem to get flushed when items are added or removed through the content admin, or when menu changes are added or removed from the sitemap.
I'd been using the devel.module 'flush cache' ... but that wasn't making a difference, meaning that most tests I've been trying may have had no effect due to over-aggressive caching and the results just not showing up.

Maybe a 'rebuild now' button may be a useful addition to the UI, because currently you have to manually flush cache, run cron, log out, sacrifice a chicken and turn around three times to get a 50:50 chance of seeing the sitemap as it should be.
Heck, do what menu.module did and just rebuild the cache in the background any time an admin visits the menu admin page. It can't hurt that much. I really think the cache is making testing impossible.

Still no menu items. Only nodes added from content management. Maybe I should try using a goat instead of a chicken.

Actually, the last commits changed the cache system used by the project code; therefore, flushing the Drupal cache doesn't have any effect on XML Sitemap.

I will open a report about the idea to use a permission that would allow a user role to by-pass the check on the authored posts (see #398452: Add a new permission to allow to by-pass the checking on the number of nodes authored).

First I had an error about an undefined function. I've finally gotten everything working (eg, admin/modules page doesn't crash, update.php will run), but I end up with blank sitemaps. I have all the modules enabled.

Rolling back to the previous release which was working... doesn't seem to be working anymore.

Seems like there needs to be a big step back to get things working again before we can add the new stuff we all want.

@dman: you can leave the goat at peace..... (at least for now)

In my case there is some progress:

Installed this mornings version (12th march):
During update.php, got following messages:
warning: array_merge() [function.array-merge]: Argument #2 is not an array in ....................../www/update.php on line 174.
warning: Invalid argument supplied for foreach() in ............................/www/update.php on line 339.

Have no idea if this is a problem causes by the sitemap installer, but after this update, my sitemap did start to get populated.
Huray!!!

However, still no menu's, and only part of the nodes appear:
- my NL and DE-language nodes do NOT appear at all,
- not all EN-language (the site's default) nodes are there.

hi,
The only way to make this module show all nodes is deleting it from database, e re-installing?
this fix is sure to work for ever or i will need to reinstall the module everytime i have new nodes?
thanks

I installed the download from late last week and still had the blank sitemap. I went home for the weekend and magically the most recently created node (and a term associated with it) magically appeared in the sitemap. Not sure why, as the node was created prior to the latest install of the sitemap module.

I had previously went to the content area and selected to add the nodes to my sitemap and set the user setting for post count back to 1. Guess I'll do it again and see what happens.

I'm using the dev version from the 14th and it seems to work. Wish we could get more info in the release notes. One day this thing works, and the next day it doesn't.

I've noticed on one of my sites hosted with the same installation, it all seems to be updated now. That particular site is the most "active" site though.

Yeah, I am scared to update again to any new version while this is sorta working.

As reported in another comment, the cause of the site map not being populated could be the line of code that verify if a database row with the same value for the loc field is already present.

For xmlsitemap_node.module the code is the following:

if (db_result(db_query("SELECT loc FROM {xmlsitemap} WHERE loc = '%s'", $row->loc)) != $row->loc) {

Similar code is present in all the modules.

For xmlsitemap_node.module the code can be removed, while for the other modules could be changed to

if (!db_result(db_query("SELECT COUNT(loc) FROM {xmlsitemap} WHERE loc = '%s'", $row->loc))) {

The code has been changed in CVS. For xmlsitemap_node.module and xmlsitemap_user.module the check has been removed; for the other modules, the code has been rewritten like

if (!db_result(db_query("SELECT COUNT(loc) FROM {xmlsitemap} WHERE loc = '%s'", $row->loc))) {

This should resolve the problem.

Didn't worked for me with the very last dev version
My sitemap is empty
I changed my threshold to 1

http://www.chourmovs.power-heberg.com/drupal/?q=sitemap.xml

... so i did it manually

I've the same problem.
My site map is empty with the version I've just downloaded.

With the previous version I was able to repair the sitemap for some sites by selecting "Add the selected posts to the XML site map" in Content management and clicking on update.
This will not realloy help with sites with about 50,000 nodes.
However this method no longer work with the newest version.

Drupal.org has not created the new tarball archive, yet.

Drupal.org has not created the new tarball archive, yet.

Drupal.org has not created the new tarball archive, yet.

Drupal.org has not created the new tarball archive, yet.

Drupal.org has not created the new tarball archive, yet.

Drupal.org has not created the new tarball archive, yet.

(Never add a comment using iPod Touch: it can create collateral effects)

If your nodes existed before you installed xmlsitemap, they will not be added until they are updated (edited and saved), or added to the sitemap using the checkboxes at /admin/content. I read this thread for way to long before I realized this was by design.

See http://drupal.org/node/376032

Still no joy at all using menus on brand new sites. Up-to-date checkout.

I'd love to help get this sorted out, but the many levels of caching and queuing are really confusing without explanations.

Even after I succeded in making sure I was able to force a rebuild on demand, I just can't see how the menu entries are expected to get in. I had to make all 4 changes just to make rows from menu items get in and get read out again.

I've gotta be missing something, but I can't understand the flow. I've been trying for hours, but I don't understand why a lot of things are done the way they are.
I can only help out testing and fixing code with a few more API docs. I mean, why is 'modules' an argument to this hook? What is $modules supposed to mean anyway?

/**
 * Implementation of hook_xmlsitmap_links().
 */
function xmlsitemap_menu_xmlsitemap_links($modules) {
#watchdog('xmlsitemap menu', "Fetching links ". print_r(get_defined_vars(),1));
  if (isset($modules['xmlsitemap']) || isset($modules['xmlsitemap_menu'])) {
    db_query("DELETE FROM {xmlsitemap} WHERE type ='menu'");
    $menus = variable_get('xmlsitemap_menu_menus', array());
    $mlid = 0;
    foreach ($menus as $menu) {
      if (is_string($menu)) {
        $result = db_query("SELECT ml.mlid
          FROM {menu_links} ml
          LEFT JOIN {menu_router} m ON m.path = ml.router_path
          WHERE  ml.menu_name = '%s'
            AND ml.mlid > %d
          ORDER BY ml.mlid ASC",
          $menu, $mlid
        );
        $row = new stdClass();
        $row->module = 'xmlsitemap_menu';
        $row->type = 'menu';
        while ($mlid = db_result($result)) {
          $link = menu_link_load($mlid);
          // Avoid external links, or links to the front page;
          // both have $link['external'] set to 1.
          if (!$link['external'] && !$link['hidden'] && $link['access'] == 1) {
            $row->loc = $link['href'];
            $row->id = $mlid;
            $row->priority = 1.0 - min(max(round(($link['weight'] + 10) / 20, 1), 0.0), 1.0);
##############################################
// That priority was just coming in at zero
// I think the above formula assumed menu weights were limited to +/- 10
// menu weight does NOT = priority. What's that about?
// menu *depth*, maybe.
            $row->priority = 0.1;

// Nothing happens with no dates - row goes in, but is basically 
// marked as 'ignore' by setting changefreq = 0, changed = 0
            $row->changefreq = 1;
            $row->changed = TRUE;

// What is this query doing?
// How can this ever be false?
// Is it just checking if row exists?
#            if (db_result(db_query("SELECT loc FROM {xmlsitemap} WHERE loc = '%s'", $row->loc)) != $row->loc) {
              drupal_write_record('xmlsitemap', $row);
#            }
##############################################
          }
        }
      }
    }
  }
}

I added more calls to xmlsitemap_helper_update_sitemap() which should force xmlsitemap.module to update the content of the site map when the nodes, the taxonomy terms, or the user data is changed.

I hope this resolve the issue.

Tip for anyone upgrading from the feb 19th dev to the latest one.
Disable this module first!

I think you got it

I got the same problem, when i install the latest version... it was error
So, installed the old version.

I do this step :
1. Remove all table xmlsitemap and clear cache
2. Install the old module
3. Run cron.php
4. Update same node (edit and save)

But my sitemap is still blank :(
This is my error warning that i got :

    * user warning: Unknown column 'lastmod' in 'field list' query: INSERT INTO ck_xmlsitemap (loc, lastmod, changefreq, priority) VALUES ('http://www.ckcybers.com/', 1238393092, 1, 1) in /home/ckcybers/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 469.
    * warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ckcybers/public_html/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 342.
    * user warning: Unknown column 'xn.previous_comment' in 'group statement' query: SELECT n.nid, n.type, n.promote, n.changed, xn.previously_changed, xn.priority_override, COALESCE(ua.dst) AS alias FROM ck_node n LEFT JOIN ck_node_comment_statistics s ON n.nid = s.nid LEFT JOIN ck_url_alias ua ON ua.src = CONCAT('node/', CAST(n.nid AS CHAR)) LEFT JOIN ck_xmlsitemap_node xn ON n.nid = xn.nid WHERE n.status > 0 AND (n.type NOT IN ('') AND xn.priority_override IS NULL OR xn.priority_override >= 0) AND n.nid <> 0 GROUP BY n.nid, n.type, n.promote, n.changed, xn.previously_changed, xn.priority_override, s.comment_count, s.last_comment_timestamp, xn.previous_comment in /home/ckcybers/public_html/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 342.
    * user warning: Unknown column 'lastmod' in 'order clause' query: SELECT * FROM ck_xmlsitemap ORDER BY lastmod DESC, changefreq, priority DESC, loc LIMIT 0, 50000 in /home/ckcybers/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 396.
    * user warning: Unknown column 'lastmod' in 'order clause' query: SELECT * FROM ck_xmlsitemap ORDER BY lastmod DESC, changefreq, priority DESC, loc LIMIT 0, 50000 in /home/ckcybers/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 396.
    * user warning: Unknown column 'lastmod' in 'order clause' query: SELECT * FROM ck_xmlsitemap ORDER BY lastmod DESC, changefreq, priority DESC, loc LIMIT 0, 50000 in /home/ckcybers/public_html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 396.

Please tell me the solutions.
Thanks

Sorry, i forgot to tell my site.
This is my site url : http://www.ckcybers.com/sitemap.xml

Thanks

I am changing the title to avoid duplicate reports.

Hello, any body know what the solutions ?
Thanks

@#116: It seems you are using an old version of the project modules, as the XSL style sheet is not used anymore in the last commits.
The error messages are caused by the fact you probably didn't run update.php.

It's not exact; the site map is not being populated means the site map is not being populated from links, whatever the type of link is, or whatever the link refers to old content. The two reports are different.

Hi Guys,

I have a lot of nodes as well 10 000 and I am getting php out of memory for the view bulk ops trick of adding all nodes to the sitemap. Could not this be managed form an sql script somehow instead of all these arrays? :)

It would be nice if xml sitemap would add old nodes at install, and just like pathauto we could configure that it should add x amount per cron run.

UPDATE: #61 seems to have worked for me.

Did the update, then followed the admin link, it warned me there that some updates are required. Followed the link, it showed that xmlsitemap db needs an update, followed the link, and was taken to xmlsitemap db update page which started inserting the records via batch api it seems :)

Seems my bug report belongs on this thread then, was: http://drupal.org/node/376032#comment-1404996

I installed xmlsitemap-6.x-1.x-dev, it showed 2009-Mar-23 as the last update. This is the first version of the module I have had installed on this copy of Drupal.

Table dumps, things tried, etc... are all in a couple of posts starting at the post linked to.

If anyone has suggestions of "what else to try" on a clean Drupal 6 install with a clean install of that build of this mod, please advise and I will test and report the results. Thanks!

#123 Did you install that older version in post #61?

I just followed those steps, but installed the "Mar 28 20:27 xmlsitemap-6.x-1.x-dev.tar.gz" version which cron alerted me was available. Did not fix the lack of nodes showing up.

Tried also going to content management and adding the four nodes to the sitemap. Tried the other xmlsitemap choice from the content management screen as well. Getting late, I best call it a day.

#125 yes, I used that older version! At the moment I am still struggling with term table which is empty. Might just write a freakin sql script to copy the things over from term tables :)

@119
@122
I have update the tabel on update.php, but it still not created on sitemap.xml
What the problems ?
Thanks

Dear Ernie,

Based on your instructions I can confirm, that my

1. node term was populated before logging out and visiting as anonymous, YEEAY :)

2. term table was not populated! and it is still empty.

3, sitemap.xml exists and can be loaded

The only thing not working for me is terms. Any ideas?

@earnie: Yes I have an extensive free tagging vocabulary that is accessible by anons and parsed by search engines. My sitemap term table had 22000 entries before uninstall (I have a backup) and now it is empty.

Also I notice, new terms are added fine to the table and sitemap.xml file as I create nodes with free tagging terms...Only old terms are missing.

Trying the steps in #128. Upon trying to uninstall the mod, I still get the following error with the build downloaded a day or two ago...

Fatal error: Call to undefined function xmlsitemap_helper_sitemap_query() in /homepages/35/d157794216/htdocs/sites/somesite.com/www/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap.module on line 596

Shall I log this as a separate / new bug?

@earnie Thanks, I went through the logs but nothing like it happened. An allowed memory error would be fatal, so probably the script would have stopped.
Re the nodes table, it has 10 000 entries so that is quite big but it processed that without any issues in a couple seconds :) Tthere was no memory issue during the node processing.

@128
Thanks , i am going on suggestion

@earnie: Thanks, but no luck. Even added a bit of error reporting. It just runs once but the table does not change. I can see new terms in there from nodes that were added after xmlsitemap install, but not the ones before the install. Am I the only one with this term issue? Does it work for you? Could the issue be with the xmlsitemap term module?

<?php
ini_set('error_reporting', 'E_ALL');
require './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
xmlsitemap_helper_update_sitemap('xmlsitemap_term');

echo ('OK');
?>

@128
Wow... thanks :) it was success for me :)

@earnie: Thanks, I double checked the error log file, nothing. Ran cron and called sitemap.xml anonymously but no help. I double checked my term data table and it is actually only 10 000 terms, which should not be a serious issue for a database...Will try to poke around more but at the moment it definitely seems to me it is not working.

Re: #137

Someone kindly solve the problem with a patch. I applied it to the version that was installed, got it uninstalled, then installed a version dated April 1.

Followed the steps in #128, additionally once the new files were unpacked on the server, I ran the update.php followed by cron.php. (I also applied the diff to the April 1 version)

Then followed the instructions exactly. I enabled:

1) XML Sitemap
2) XML Sitemap: Engines
3) XML Sitemap: Helper
4) XML Sitemap: Node

all at once.

Logged out, no nodes on the sitemap.

Logged back in, when to content administration, selected all nodes, picked Add to Sitemap, logged out, nadda
Logged back in, when to content administration, selected all nodes, picked Change Sitemap settings to default, logged out, nadda

Suggestions?

It's not clear to me why the patch includes a call to drupal_load('module', 'xmlsitemap_helper') when the required function is defined in the xmlsitemap_helper.install.inc file.

The batch operations can be only executed interactively, when a form is being submitted to Drupal; differently, batch operations could cause a PHP timeout, if the web site contains too much links to put in the module database tables.

An interactive batch operation should never cause a timeout, especially if the batch operation operates on single table rows like it happens with the XML Sitemap modules.

The batch operations have been introduced in Drupal 6 to avoid PHP timeouts on long operations executed during the update of Drupal modules. The functions that handle the batch operations have been coded to be generic enough to be used in many other situations where a module executes long operations as a result of data submitted from a form.

#144 / earnie: So why did my extra steps at the bottom of #143 not add the nodes to the sitemap? I thought surely doing so was the purpose of at least one of those steps...??? If not, then what are they suppose to do?

@earnie: Thanks for this patch, I tried uninstalling xmlsitemap terms, and reinstall it with the patch, but when it jumped to the batch op screen it was giving me Access Denied.

I added the drupal_load('module', 'xmlsitemap_helper') line to be sure the module would be loaded during the updating of the project modules; as xmlsitemap_helper.module didn't exist before that update, it's rather impossible it was already enabled before the update.

The same code is not required during installation because the administrator must select xmlsitemap_helper.module, in order to enable and install the other modules of the XML Sitemap project.

@#152: It's not required to enable xmlsitemap_helper.module during the installation because the module need to be enabled, in order to be able to install the other modules; as the other modules declare their dependency from that module, Drupal doesn't allow you to enable (and install), i.e., xmlsitemap_node.module without to enable (and install) xmlsitemap_helper.module.

It seems that the report is missing its original topic that should be the site map not being populated. Is the site map still not populated, with the last code commits?

Obviously, I was missing the point. The code has been changed to populate the database module tables during the installation phase.

The committed code will be available in the tarball archive Drupal.org generates between 9 hours. With the new code, is the issue still present?

I just pulled down the April 6 build, installed / tested it per #143, same results.

What further details could I provide to assist in solving this problem?

#158 earnie: OK, please someone update this thread when I should try again. Thanks!

The development snapshot tarballs are generated at 12:00 AM, and 12:00 PM GMT; this mean that now Drupal.org has already generated the new tarball archive.

#160 Thanks, I pulled it down. This build seems to be dated: Apr 7 20:29

Followed the same steps as in #143, same results.

I will note, each time after the two extra steps:

Logged back in, when to content administration, selected all nodes, picked Add to Sitemap, logged out, nadda
Logged back in, when to content administration, selected all nodes, picked Change Sitemap settings to default, logged out, nadda

I ran cron before I logged out and checked.

Also I (using FF) held down the shift key while pressing the reload button to make sure the browser cache was not coming into play.

Still no nodes. Suggestions? Do you need me to check something in the DB?

Let us see if somebody has still this problem; differently, we can declare the report fixed.

Thanks Earnie, I just installed the latest, and it seems to be working fine. Terms are added, nodes are added for me as per the steps you gave at #128. Those steps are even worthy to be posted on the frontpage :)

UPDATE: Umm, I just checked the tables but it seems only a fraction of the terms were added. Investigating now why. Probably will open a new ticket for that :)

UPDATE2:Yes, so it seems I was calling success a bit early. those tables were the old ones, somehow they were not deleted at uninstall. So I started a blank install now, with no tables, and when the install takes me to the update.php batch screen I get an access denied message with admin user, number 1.

It's not clear what you exactly mean saying that you get an access denied message when you visit the update.php page.
If I understand correctly what you mean, then that is not an issue caused by XML Sitemap.

Hi Guys,

Yes this definitely looks like something else.

I can confirm that the module handles perfectly well the nodes.

When it comes to terms (I tried to separately uninstall terms module and reinstall) I Am taken to
http://mydrupalsite/batch?op=start&id=62
and it is giving access denied. So this seems like something else, thanks for all your help, I will troubleshoot now this. I have seen such issues elsewhere reported in Drupal forums...I am sure it is not related to xmlsitemap but to Drupal in general.

UPDATE: Thanks Earnie for the cache and session tips, I have probably an overly hacked Firefox from Foxyproxy to Live HTTP Headers and Tab Mix Plus, so what I did was went to Internet Explorer, and ran the update.php there only for Sitemap Terms 6100 update, and now it is nicely populating the term table. phew :D weird, but it works.

Thanks again for all your efforts.

@#162 earnie

1) Yes to install / uninstall I am logged in as UID 1
2) Yes, while not logged in using FF I can view nodes
3) Yes, I uninstalled all of the submodules prior to upgrading. I used to get an error so I opened a separate bug and that has now been resolved. (So on this copy of Drupal, a couple of upgrades to this mod had been done not uninstalling the one submod that was getting the error.)
4) Here is a dump of the table is question:

nid changed previously_changed comment_ratio priority_override
1 1238117185 1231767477 0 -2
2 1238117243 1236036855 0 -2
3 1238117216 1236696093 0 -2
4 1238117260 1236701944 0 -2

5) 6.10 presently

@#171 earnie: I just ran through those steps uninstalling / reinstalling the Apr 7 build.

In PHPMyAdmin, once I had completed the uninstall of the mods, I find the following:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.6633 sec)
SQL query: 
SELECT *
FROM `information_schema`.`TABLES`
WHERE TABLE_NAME LIKE 'xmlsitemap%'
LIMIT 0 , 30

I went through the steps, plus did the two Content Management / XML Sitemap specific operations and once those operations were completed ran Cron. Nadda.

The xmlsitemap_node table currently has the following records:

nid   	  changed   	  previously_changed   	  comment_ratio   	  priority_override
1 	1238117185 	1231767477 	0 	0.5
2 	1238117243 	1236036855 	0 	0.5
3 	1238117216 	1236696093 	0 	0.5
4 	1238117260 	1236701944 	0 	0.5

The sitemap only shows the following:

<urlset xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9   http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">
−
<url>
<loc>http://www.client-domain-abcdefg.com/</loc>
<lastmod>2009-04-09T22:26:22+00:00</lastmod>
<changefreq>hourly</changefreq>
<priority>1.0</priority>
</url>
</urlset>

I do have the following modules enabled related to xmlsitemap:

1. XML Sitemap
2. XML Sitemap: Engines
3. XML Sitemap: Helper
4. XML Sitemap: Node

Suggestions please...

@#174 earnie:

Other modules: captcha and nodewords

Node type: All of the Drupal core "Page" type

I will contract you via your email address in a couple of hours to provide a link to a full MySQL 5 backup file.

Thanks! :-)

Works as follows:

Step 1
--------
Enable XML Sitemap:
- creates xmlsitemap table; xmlsitemap table is empty. OK
- creates xmlsitemap folder; xmlsitemap folder is empty. OK

Step 2
------------
Enable XML Sitemap User:
- creates xmlsitemap_user table; xmlsitemap_user is populated OK
- creates xmlsitemap_user_role table; xmlsitemap_user_role is empty (?)

Step 3
-------------
Enable XML Sitemap Node:
- creates xmlsitemap_node table; xmlsitemap_node is populated.
- Message: Processing 0-100% OK ... fast

Step 4
---------------
Enable XML Sitemap Term
- creates xmlsitemap_term table; xmlsitemap_term is populated.
- Message: processing 0-100% OK.
- Note: Wait until process is finished! ... slow ?
- xmlsitemap folder is removed after activating XML Sitemap Term (?) (not sure)

Step 5
---------------
Enable XML Sitemap Menu
- No table created OK

Step 6
------------
Home » Administer » Site configuration » XML Sitemap - Save configuration
- folder sites/default/files/xmlsitemap is created. (empty) OK

Step 7
---------
Logout.

Step 8
------------------
Visit http://sample.com/sitemap.xml in your browser. (Anonymous)
- xmlsitemap table is populated. (OK)
- xmlsitemap folder is populated. (OK)
- xmlsitemap_user_role table is empty (empty) (?)

EDIT
------
@ earnie (#179):
Table: users_roles: 53
Comment ratio weight - users: 0.2 (default did not change)

@#176 earnie: Meta tags 6.x-1.0 / Image CAPTCHA 6.x-1.0-rc2

Should be the latest available for both of them.

Database tables are created and populated but there is no sitemap.xml file.

@#183 earnie: For me, the cache directory setting is correct / valid. The xml file in there has the site header tags only... exactly what viewing /sitemap.xml as anonymous shows.

@#185 earnie: I apologize, I missed that response.

So you are saying that the xmlsitemap now has a requirement of creating an alias for every node on the site, else it will not list the node in the sitemap?!!?!?

It used to at least list the node as "node/##" in the sitemap. In fact some a while ago on D5 were still showing "node/##" on nodes that really had a valid alias. I found those, resaved the nodes, then the xmlsitmap changed to advertising the alias name.

The nodes have always been in published status as long as I have been trying to get the sitemap to work.

	Title	Type	Author	Status	Operations
	News new	Page	userid	published	edit
	Services updated	Page	userid	published	edit
	Projects updated	Page	userid	published	edit
	Welcome to XYZ 	Page	userid	published	edit

So I am still confused... hhhmmm....

A point of clarification: It seems we already had a url alias on the home page node. We added two more, so now only one remains without, I ran cron, still no nodes show up on the sitemap. Earnie, since you know the domain name, feel free to check.

Was the logic bug you found not satisfied unless all nodes had a url alias?

Do you mean that you have more than one path alias for the home page node?
If this is the case, one node appears in the site map only once, indipendently from the number of aliases it has.

Then, the module saves the relative URL of a node in the node/<nid> form in the database table; only when the site map content is generated a path alias is looked for.

@#189 Kiam@avpnet.org: No, just when earnie in #177 stated that it was due to not having URL aliases on the nodes, one node already had a URL alias. He must have not see that the one node already had an alias. We added two additional ones, so three nodes with URL Aliases, one left without. No nodes show up in the sitemap, however.

Thus the query problem he thought was to blame 1) is not the entire problem or 2) EVERY node on the site must have a URL Alias to satisfy it, perhaps?

Better?

Tried the latest dev version with following result:

Step 1
--------
Enable XML Sitemap Helper:

Step 2
--------
Enable XML Sitemap:
- creates xmlsitemap table; xmlsitemap table is empty.

Step 3
------------
Home » Administer » Site configuration » XML Sitemap - Save configuration
- creates xmlsitemap folder; xmlsitemap folder is empty.

Step 4
------------
Enable XML Sitemap User:
- creates xmlsitemap_user table; xmlsitemap_user is empty
- creates xmlsitemap_user_role table; xmlsitemap_user_role is empty

Step 5
-------------
Enable XML Sitemap Node:
- creates xmlsitemap_node table; xmlsitemap_node is empty.

Step 6
---------------
Enable XML Sitemap Term
- creates xmlsitemap_term table; xmlsitemap_term is empty.

Step 7
---------------
Enable XML Sitemap Menu
- No table created OK

Step 8
------------------
Visit http://sample.com/sitemap.xml in your browser. (Anonymous)

Result
------------------
xmlsitemap has 1 row
xmlsitemap_node is empty
xmlsitemap_term is empty
xmlsitemap_user is empty
xmlsitemap_user_role is empty s

- xmlsitemap folder has one file: xsm-10014638.xml.

Note: the previous dev version worked per post #178.

?
That's actually a pretty helpful set of steps to repeat the problem. Above average as bug reports go. Most of the time issues die because they can't be repeated on the developers machine. This illustrates what is going wrong, and hopefully that can illuminate to someone - *where* the current problem is.

I don't know the answer myself, I've looked at the code, several times now, but can't understand enough of what it's trying to do to help with what it's not doing. I want to, need to, help everyone patch this, but the current code is just not clear enough to my limited capacities. And I've not been able to find or receive any roadmap or documentation or clarification that would help me to help the team.

I Know this particular thread is now much too long to get good resolution on, but if the symptoms have been narrowed down enough to define a new issue to track ... which is it? I don't see it in http://drupal.org/project/issues/xmlsitemap
So the thread is still alive.

Currently there is a big elephant in the room called "the site map is not being populated". Posting here is the only way to avoid further "xmlsitemap doesn't work" threads being called duplicates. Subscribing to all other unrelated issues is not currently a solution to solving this big one.

I'd love to know there was a fix in the works. but if it's not in this list already .. where can we subscribe?

I followed the steps as instructed in Post #128 and stated the results obtained.
Post #195 is stating that module is broken at the moment.

My answer can depend on the particular moment the question is being asked.

webchick is helping right now, and as you can see there has not been a ceremonial for her investiture on the rank of person helping in the developing of the project.
Also earnie is helping in the developing of the project.
Everybody can help in the same way they are doing.

Alexis,

Can you upload the 6.x ver. that works for you? I can use until a stable dev is released. Thanks.

@Kiam@avpnet.org / earnie: Could you please give this thread an update of "please test again" when ever you have uploaded a new build you would like us to test to see if it makes a difference? Otherwise I will ignore the "me too's" and not update. Thanks.

The Apr. 27 dev seems to have this issue, also. I followed the instructions in #128 and set the user posts to 1.

Got just the first post I've published in the sitemap.
Everything else is missing.

http://soulfulbits.com/sitemap.xml

I'm using 6.x-1.x-dev 2009-Apr-28
Where can I find a stable version ?

The version in #201 works, but you have to add nodes to the sitemap through the admin/content/node page (unless there's another way that I missed).

The version officially developed uses cron maintenance tasks to populate the site map. It's up to you what version to use, but if you don't use the officially developed one, then you should not ask for support here.

Sorry, I was just replying to #204, since according to stillcut's testing the Apr. 28th dev version wasn't working. I understand that the latest dev version is intended to use the cron to populate the site map, but if it isn't working (b/c of webchick's on-going review, etc.), then we have to look to other options, such as the earlier version of the module posted in #201.

#204 - Have this same issue, but yours appears to be working now... what did you do?

Thanks, earnie. Now that I see issues #447912: Change the default value for the cron limit and #448000: Big, Over-Arching Sitemap Architecture Discussion (tm), I feel much better about how this module's doing. I promise I'll stop posting in this issue now :)

@#212 earnie: Applied via the usual steps, no nodes on the site map. :-( Sorry! (shrug)

Reporting that I had same issues as above and your latest dev ($Id: CHANGELOG.txt,v 1.1.4.172 2009/04/29 12:25:49 kiam Exp $) works for me. I uninstalled other version, cleaned out tables per #72 above (I only had entries in system table) and reinstalled. Don't forget to go to admin/user/settings and set user threshold to 1.

@#219 earnie: So were the nodes in a "strange" state that usually nodes would not be in? They looked fine to us. (shrug)

@mdlueck: Basically, there was an option in XML Sitemap Node where nodes would be rejected from the sitemap unless their authors had already written more than 100 nodes. For those of us with smaller sites or wanting to test out the module, none of our content is going to show sitemap. We are changing the default value of this setting so that all content should show up by default.

@#222 earnie: Thanks for the concise explanation.

Fixed! Now the site has nodes! :-)

Latest Dev version as of May 07 results in page not found + get priority errors on install.
Fixing typos still results in page not found.
admin/user/settings does not contain a threshold setting as well.

The cache IS being created however I had created in a public place..... and reset to defaults, finally got it going..
Perhaps the next dev version may work tomorrow

And it's good it doesn't contain it: it has been removed to put it in a completely different module. :-)

Frazzle Razzle! I just updated my build to "6.x-1.0-beta3 2009-May-13" via the steps in #128 and I see a couple of issues:

1) Sitemap has no longer has nodes.

I went to /admin/content/node trying to flag nodes as needed to be added to the sitemap and would cron after that...

2) Gone are the Sitemap options @ /admin/content/node

So I chose "Publish" and all nodes, did that, ran cron, Nodes did not come back to the sitemap.

<><><><>

On a side topic, it is really silly to require a complete dump of the sitemap data when updating the module. Can there be a way around a COMPLETE uninstall?

For the problems with the beta releases of the project there is already an issue open (see #458546: Cache files are not created). This is an old issue that has nothing to share with the beta3, or any other beta release.

Oh, by switching to the beta version, did I somehow end up with older code than what I had been trying with the -dev version?

I assumed since the date was newer, said "beta3" now, that surly everyting in the -dev version I had finally had success with would be there. No?

I simply mean that for the beta3 version you must follow #458546: Cache files are not created.

I'm finding that the xmlsitemap node (300+ rows), term (300+ rows) and user (1 row, for me) tables are populated, but the sitemap.xml file is empty. I've reviewed the suggestions above and still no sitemap. I'm currently using 6.x-1.x-dev.

The user threshold seems like it may be a cause, but I'm not finding any way to set it anywhere in my admin pages.

If you would have checked the last comment I posted, which is actually the one before yours, you should have noticed I already gave an answer.

The user threshold feature has been removed from the code; therefore, you are not using the latest 6.x-1.x-dev. Normally, a project doesn't give support to who uses a 6.x-1.x-dev version dated 1 week ago, when there is a newer 6.x-1.x-dev version.

EDIT: See #456430: Remove unnecessary features from xmlsitemap_node, which is declared fixed on May 9th. This means you are using a version dated before that day, but not the latest version, which is dated May 16th.

Hi,

I just installed XML sitemap 6.x-2.0-beta1 and Sitemap is not populated, and after reading 1 millions posts here i still wonder if there is a solution ?!

What can i do ?

Thanks for help.

solution is very very easy. just go to /admin/content/node-type/ set Inclusion: included

than go to /admin/settings/xmlsitemap/settings

click rebuild links

its done! you have a full sitemap now!

it will solve everything.

Sorry i just had the same problem and I do not see INCLUSION at this page:

admin/content/node-type/

Maybe things have changed after so long time ?

Thank you.