Everytime that xmlsitemap.xml is created I have this php error in the log.

I am using last dev version of XMLSiteMap and Paging:
XMLSiteMap 5.x-2.x-dev 2008-Jun-19
Paging 5.x-1.x-dev 2008-May-28

user warning: Unknown column 'px.pages' in 'field list' query: SELECT n.nid, px.pages, n.type, n.promote, n.changed, xn.previously_changed, xn.priority_override, COALESCE(ua.dst) AS alias FROM node n LEFT JOIN url_alias ua ON ua.src = CONCAT('node/', CAST(n.nid AS CHAR)) LEFT JOIN xmlsitemap_node xn ON n.nid = xn.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = '****') OR (na.gid = 1 AND na.realm = '*****') OR (na.gid = 0 AND na.realm = '******') OR (na.gid = 0 AND na.realm = '******') OR (na.gid = 0 AND na.realm = '****') OR (na.gid = 0 AND na.realm = '****'))) AND ( n.status > 0 AND (n.type NOT IN (------ LIST of installed Modules -----) AND xn.priority_override IS NULL OR xn.priority_override >= 0) ) GROUP BY n.nid in /home/webapps/devel/current/includes/database.mysql.inc on line 172.

(I have deleted some internal realms and module names)

Comments

Gurpartap Singh’s picture

Gurpartap Singh commented
Status: Active » Closed (won't fix)

This would really be an issue with something else, possibly xmlsitemap. At least not with paging, since paging doesn't deal with databases at all.

toby_net’s picture

toby_net commented
Status: Closed (won't fix) » Needs review

Hi, I have same problems.
This is a patch for this issue. (not good enough to test)

diff -r 4fc284eb0a35 -r c88e0ce96761 sites/all/modules/paging/contrib/paging_xmlsitemap/paging_xmlsitemap.module
--- a/sites/all/modules/paging/contrib/paging_xmlsitemap/paging_xmlsitemap.module	Mon May 03 09:29:57 2010 +0900
+++ b/sites/all/modules/paging/contrib/paging_xmlsitemap/paging_xmlsitemap.module	Mon May 03 09:39:42 2010 +0900
@@ -22,7 +22,8 @@
     else {
       $query = "
         SELECT n.nid, px.pages, n.type, n.promote, n.changed, xn.previously_changed, xn.priority_override, COALESCE(ua.dst) AS alias
-        FROM {node} n";
+        FROM {node} n
+        INNER JOIN {paging_xmlsitemap} px ON n.nid = px.nid";
     }
     switch ($GLOBALS['db_type']) {
       case 'mysql':

Thanks.

jenlampton’s picture

jenlampton
she / her
commented
Project: Paging » XML sitemap
Component: XML site map integration » xmlsitemap.module

Reassigning issue to XMLsitemap module.

Anonymous’s picture

Anonymous (not verified) commented
Status: Needs review » Closed (won't fix)

5.x is no longer supported.