I am getting the following error when /sitemap.xml gets accessed. This started happening right after I updated to the latest 6.x-1.x-dev (datestamp 1226967380):
user warning: Table 'db.xmlsitemap' doesn't exist query: SELECT * FROM xmlsitemap ORDER BY lastmod DESC, changefreq, priority DESC, loc LIMIT 0, 50000 in /.../sites/all/modules/xmlsitemap/xmlsitemap.module on line 474.
I don't see a definition for this table (db.xmlsitemap) in xmlsitemap.install, nor any SQL write queries against that table. The end result is that /sitemap.xml is truncated after </urlset>
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | xmlsitemap.install.patch | 535 bytes | claudiu.cristea |
Comments
Comment #1
avpadernoIn the code, the table is being referred like {xmlsitemap}, and effectively it is not being installed from 6.x-1.x-dev.
The code is being ported from 5.x-2.x, and could present some problems, at the moment.
I will fix this as soon as possible.
Comment #2
sfranchi commentedSame issue.
Comment #3
avpadernoFixed. Wait for the next 12 hours, before the new download will be available.
Comment #4
beedaddy commentedI'm not sure if I really got the new version (but it is from Nov 20). I'm getting a similar (but not exactly the same) error as adzio:
user warning: Table 'drupal_xmlsitemap' doesn't exist query: SELECT COUNT(*) FROM drupal_xmlsitemap in /[...]/drupal/sites/all/modules/xmlsitemap/xmlsitemap.module on line 283.Comment #5
claudiu.cristeaThis happens because of an error in
xmlsitemap_update_6000()function fromxmlsitemap.install. Thedb_create_table()function is called without the second argument which is the table name ("xmlsitemap").Attached you can find a patch to fix this issue. Apply the patch and run update.php.
Comment #6
beedaddy commentedThanks a lot. That worked.
Comment #7
avpadernoThe code has been changed.
I implementated
xmlsitemap_update_6101()differently, as I need that the same code is executed also for who updates the module from the version for Drupal 5.You will find the new release in the next 12 hours.
I can say that now the module works fine.
Comment #8
Vinno commentedJust downloaded xmlsitemap again it now works but only have 1 url on the sitemap.xml and thats the main site. Do i have to somehow regenerate all the sitemaps again?
Comment #9
avpadernoThat is how the module works now; xmlsitemap_node must still be ported from 5.x-2.x code, so actually it doesn't do anything.
There is also another issue with the dates that seem to refer all to January 1, 1970 (the epoch time for unix time stamps).
Comment #10
wdrupal100 commentedthanks! i look forward to the next build
Comment #11
avpadernoTake in mind that the next build can be an intermediate building, as the porting is made in steps.
Comment #13
avolve commentedI am posting here, as my issue might be similar/a duplicate and I have not managed to resolve it.
It is on a site upgrade from D5. I first installed the 6.x-1 version, with repeated errors, then installed the 6.x-0 version with the following error on admin/settings/xmlsitemap/additional
I received fatal errors on attempting to uninstall the 6.x-1 version. I have tried dropping all xmlsitemap tables, though have noted that the details for specific search engines (authorisation codes) seem to be saved in another table as they are retained in the dbase.
On attempting to update to the 6.x-1 version from the 6.x-0, i note the following in the log error
on deleting the 6.x-0 module, and replacing with the 6.x-1 version, followed by running update.php (no errors logged), I get this warning when i enable 'xml sitemap' (after the helper module), not any other other sub-modules
I have tried to workaround this many ways, including following what others have posted...