Jump to:
| Project: | Paging |
| Version: | 5.x-1.x-dev |
| Component: | XML site map integration |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs review |
Issue Summary
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
#1
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.
#2
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.