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
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | recent_blocks_logout_fix.diff | 715 bytes | cotto |
| #2 | recent_content_logout_error_fix.diff | 715 bytes | cotto |
Comments
Comment #1
cotto commentedI'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.
Comment #2
cotto commentedThis 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.
Comment #3
cotto commentedPrevious patch was backwards.
Comment #4
frank ralf commentedNo maintenance anymore for Drupal 4.7.