"table doesn't exist" error
Dubber Dan - November 9, 2009 - 18:05
| Project: | XML sitemap |
| Version: | 6.x-1.1 |
| Component: | xmlsitemap.module |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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?
#1
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.
#2
#3
Ok, so how do I fix it? (I don't have gallery or other languages installed btw)
#4
Only way would be to disable all XML sitemap modules via admin/build/modules, then uninstall them via admin/build/modules/uninstall.
#5
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?
#6
Did you disable all the modules first via admin/build/modules?