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

kikke’s picture

The module doesn't use the tableprefixes in some queries.

davyvdb’s picture

Assigned: Unassigned » davyvdb
Status: Active » Closed (fixed)

Fixed in CVS