I was seeing php errors from XMLsitemap in the logs ("unknown column") so ran a database repair. Now whenever I run a cron job the logs say I'm missing three tables ... xmlsitemap_additional, xmlsitemap_node and xmlsitemap_term. The sitemap itself is now just one link to the homepage. When I go to phpmyadmin the only xmlsitemap tables that are in the DB are xmlsitemap_file, xmlsitemap_user and xmlsitemap_user_role. Uninstalling the module, reinstalling and running the upgrade script doesn't help. I've tried the release version and some of the dev versions. Any ideas? Thanks.

CommentFileSizeAuthor
#2 xmlsitemap1.jpg216.19 KBd_hall

Comments

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Active » Closed (duplicate)

This is a duplicate of #316034: Table 'xmlsitemap_additional' doesn't exist.

d_hall’s picture

d_hall commented
StatusFileSize
new xmlsitemap1.jpg216.19 KB

Except I'm missing three tables, not one. And the sitemap itself is not getting built.

d_hall’s picture

d_hall commented

An update. The answer for me was to create a dummy site using the same version of Drupal, install XMLsitemap, then export the needed SQL tables and import them into the database on the live site. Then run a cron job to populate the tables. It seems like installing the same module on the live site would create the needed tables, but for some reason it didn't.