Error with Organic Groups
| Project: | Weekly Archive by Node Type |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Prometheus6 |
| Status: | closed |
Jump to:
WinXP Pro SP2
Xampp 1.5.1
Apache 2.2.0
PHP 5.1.1
MySQL 5.0.18
Drupal 4.7.0 clean install
Organic Groups 4.7.0 v1.110.2.84 2006/05/17
Week 4.7.0 v1.14 2006/03/09
Receive the following error when the page containing the Weekly node listing block refreshes:
user warning: Unknown column 'node.nid' in 'on clause' query: SELECT YEARWEEK(FROM_UNIXTIME(changed),0) AS weekno FROM node n INNER JOIN node_access na ON na.nid = node.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.type IN ('page','story') GROUP BY weekno ORDER BY weekno DESC LIMIT 13 in C:\Internet\xampp\htdocs\drupal2\includes\database.mysql.inc on line 120.
Not sure if this a problem with Week or OG but disabling either module eliminates the error.
#1
Let's say it's me. I used db_rewrite_sql() the wrong way. It's fixed in HEAD, but apparently I forgot to patch 4.7.
I just corrected that. Let me know if it's okay.
#2
Downloaded and installed the new version. Everything works correctly now, no error. Thanks for the quick response and fix for this very neat and useful module.
#3