I'm getting the following error crop up after editing most pages of a site:

Table 'userweb61610.xmlsitemap' doesn't exist query: SELECT COUNT(xsm.loc) FROM xmlsitemap xsm INNER JOIN system s ON s.name = xsm.module WHERE s.type = 'module' AND s.status = 1 AND xsm.changefreq <> 0 AND xsm.changed <> 0 AND (xsm.priority >= 0 AND xsm.priority <= 1) in /var/www/vhtdocs/userweb61610/html/sites/default/modules/xmlsitemap-6.x-1.1/xmlsitemap/xmlsitemap.module on line 283

I've tried deleting all the module files and then uploading a fresh but it's still happening.
My guess is it's aq problem with the database not having been created properly, but that is just a guess.

Any suggestions?

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Yes, it means the table did not get created. We've typically seen this when users have gallery.module installed and have other languages enabled, because of a major bug in the gallery code and setlocale() altering numbers like '0.5' to '0,5'. This then causes the insert table SQL to fail, since we have a column with a default value of 0.5, which when using '0,5' causes invalid SQL, and the table isn't installed.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: User warning problem » "table doesn't exist" error
Dubber Dan’s picture

Dubber Dan commented

Ok, so how do I fix it? (I don't have gallery or other languages installed btw)

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Only way would be to disable all XML sitemap modules via admin/build/modules, then uninstall them via admin/build/modules/uninstall.

Dubber Dan’s picture

Dubber Dan commented

The XML sitemap module isn't listed at /admin/build/modules/uninstall so can't be uninstalled that way.

Can anyone help with either stripping out the module so I can try re-installing it, or adding the missing database?

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Did you disable all the modules first via admin/build/modules?

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Postponed (maintainer needs more info)
Anonymous’s picture

Anonymous (not verified) commented
Status: Postponed (maintainer needs more info) » Fixed

No response from OP for more than 2 weeks.

Status: Fixed » Closed (fixed)

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