I setup the dodge module and it starts working very well. Thanks for that. But lately there comes an error message at the userprofile node whitch says:
user warning: Unknown table 'n' in on clause query: SELECT d.uid, u.name, d.dodge, d.time FROM dodge d INNER JOIN users u ON u.uid = d.uid 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'))) AND ( u.uid = 7 ) ORDER BY time DESC LIMIT 0, 5 in .../includes/database.mysql.inc on line 172.
Anyone knows what does that mean? Or better how to fix that?
Version: Drupal 5.x
Dodge Module: http://drupal.org/project/dodge
Nodeprofile: http://shellmultimedia.com/tutorials/user-profiles-version-2
Thanks a lot in advance...
Comments
Comment #1
kikke commentedThe module doesn't use the tableprefixes in some queries.
Comment #2
davyvdb commentedFixed in CVS