Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By Boua on
Hey, I'm getting the following warning in the modules section. What does it mean? I searched the interent for this but I didn't find what this actually meant.
user warning: Unknown column 'access' in 'where clause' query: SELECT COUNT(id) FROM xmlsitemap WHERE access = 1 AND status = 1 in /home/****/public_html/modules/xmlsitemap/xmlsitemap.module on line 276.
Comments
when I go to
when I go to admin/settings/xmlsitemap
I get the following error, Its really strange because I didn't have this before
* user warning: Unknown column 'access' in 'where clause' query: SELECT COUNT(id) FROM xmlsitemap WHERE type = 'menu' AND access = 1 AND status = 1 in /home/dakairo/public_html/modules/xmlsitemap/xmlsitemap.admin.inc on line 296.
* user warning: Unknown column 'access' in 'where clause' query: SELECT COUNT(id) FROM xmlsitemap WHERE type = 'node' AND access = 1 AND status = 1 in /home/dakairo/public_html/modules/xmlsitemap/xmlsitemap.admin.inc on line 296.
* user warning: Unknown column 'access' in 'where clause' query: SELECT COUNT(id) FROM xmlsitemap WHERE type = 'taxonomy' AND access = 1 AND status = 1 in /home/dakairo/public_html/modules/xmlsitemap/xmlsitemap.admin.inc on line 296.
* user warning: Unknown column 'access' in 'where clause' query: SELECT COUNT(id) FROM xmlsitemap WHERE access = 1 AND status = 1 in /home/dakairo/public_html/modules/xmlsitemap/xmlsitemap.module on line 276.
Try uninstall it then
Try uninstall it then re-install and run update.php. Working fine for me here.
This sounds like you are
This sounds like you are using the 6.x-2.x branch right? Make sure you did not upgrade from the 1.x versions because there is *not* currently any upgrade path and it will horribly break if you did. See the release notes.
I reïnstalled the entire
I reïnstalled the entire website, had to many modules installed anyway. Learning the hard way :p