Log Out Error
| Project: | Recent Blocks |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | needs review |
The module works flawlessly until I log out and then it displays this on the front page and in the error log:
Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid), n.title, n.uid, n.changed, l.last_comment_timestamp, GREATEST(n.changed, l.last_comment_timestamp) AS last_change, l.comment_count FROM node n, node_comment_statistics l 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 = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all'))) AND n.nid = l.nid AND n.status = 1 AND n.type IN ('content-homes') AND comment_count = 0 ORDER BY last_change DESC LIMIT 0, 5 in /mysite.com/includes/database.mysql.inc on line 120.
Dreamhost Server
MySQL 5.x
PHP 5.x
#1
I'm also having this problem. If there's a fix that doesn't involve learning how to write and debug the module myself, I'd sure like to know about it.
My server is Apache 2.0.58 running PHP 5.1.4 and MySQL 5.0.21 on Gentoo.
#2
This patch seems to fix the problem, but I'm not in a good position to evaluate whether it's the correct way to do so.
#3
Previous patch was backwards.