Drupal 7 xmlsitemap problems solved

Did you get a nasty error from your Drupal 7 sitemap module that looked like this:

PDOException: SQLSTATE[42S02]: Base table or view not found: 
1146 Table 'itassistance.xmlsitemap_sitemap' doesn't exist: 
SELECT smid FROM {xmlsitemap_sitemap}; Array ( ) in xmlsitemap_regenerate_batch() 
(line 250 of /home/barnettech/barnettech.com/public/sites/all/modules/contrib/xmlsitemap/xmlsitemap.generate.inc).

If you forgot to upgrade xmlsitemap before upgrading to drupal 7 shame on you.... (and me). If you don't upgrade all your modules before a major drupal upgrade (like from drupal 6 to drupal 7) you will have troubles:

I was plagued by problems with xmlsitemap module:

Here is the solution:

Drop the xmlsitemap and xmlsitemap_sitemap tables
Get rid of all records in the system table that has xmlsitemap in it
Get rid of all records in the menu_links table that has xmlsitemap in it

I found all the records in one table like this;

SELECT * FROM `menu_links` WHERE link_path like '%xml%'

I did a similar query with the system table.

Make sure you delete the right records, it will be obvious, they will mention xmlsitemap in the database field.

And congrats you now wont get any errors for xmlsitemap.

Here's a linkback to this blogger who showed me the light: http://www.kobashicomputing.com/getting-drupal-xml-sitemap-to-work