Hello,

I installed xmlsitemap module 6.x-1.1 and have been getting "user warning: Unknown column 'type' in 'where clause' query: SELECT * FROM xmlsitemap WHERE type = 'node' AND id = 1 LIMIT 0, 1 in /www2/qualitytestlabs.com/html/sites/all/modules/xmlsitemap/xmlsitemap.module on line 461." I then tried the 6.x-2.0-unstable5 version and got the same issue. Also tried 6.x-2.x-dev and same as above. When I tried the 6.x-2.0-unstable5 and the 6.x-2.x-dev versions I did delete all files in the /sites/all/modules/xmlsitemap directory and did run update.php. Thanks ahead of time for any help in resolving this.

- Joseph

Comments

dave reid’s picture

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

When you went from 6.x-1.1 to 6.x-2.x versions you missed the important step of actually disabling and uninstalling (admin/build/modules/uninstall) all the XML sitemap modules.

Anonymous’s picture

Anonymous (not verified) commented

Thanks, that seemed to take care of things. Funny how I've never used the Uninstall process before. I always uninstall a module by deleting the module's directory in /sites/all/modules/

- Joseph

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Fixed

Deleting the files doesn't take care of removing any of the module's variables, tables, or other stuff stored in the database.

Status: Fixed » Closed (fixed)

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