Since installing and enabling the XML Sitemap module, I continue receiving the following error, regardless of what I do:

user warning: Table 'webbscou_countryhound.xmlsitemap_additional' doesn't exist query: SELECT xa.*, ua.dst AS alias FROM xmlsitemap_additional xa LEFT JOIN url_alias ua ON xa.pid = ua.pid in /home/webbscou/public_html/includes/database.mysql.inc on line 172.

Regardless of whether I create/edit pages, stories, or images, I get the error. The changes I make to what I am working on save just fine, but the error message shows.

I looked in phpMyAdmin to see if the supposedly missing table was indeed missing. The table does not exist. Is it supposed to?

What do I need to do to stop seeing the error message?

By the way, I submitted the xml sitemap to google and it does not report any errors.

Comments

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: xmlsitemap_additional warning » xmlsitemap_additional doesn't exist
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: xmlsitemap_additional doesn't exist » Table 'xmlsitemap_additional' doesn't exist
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Active » Postponed
bartezz’s picture

bartezz commented
Component: xmlsitemap » Code 
CREATE TABLE IF NOT EXISTS `PREFIXHERExmlsitemap_additional` (
  `path` varchar(128) character set utf8 NOT NULL,
  `pid` int(11) NOT NULL,
  `last_changed` int(11) NOT NULL,
  `previously_changed` int(11) NOT NULL,
  `priority` float NOT NULL,
  PRIMARY KEY  (`path`)
)

Same issue, I added it via phpmyadmin with above query.... don't forget to change PREFIXHERE to your db prefix if applicable...

Cheers

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

5.x-1.6 doesn't get any code fixes, or other code changes.
xmlsitemap_additional.module has been replaced from xmlsitemap_menu.module in 5.x-2.x-dev.

I am setting the status to fixed to make the report close automatically after 2 weeks.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Postponed » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.