The dodge admin settings page is empty. There doesn't seem to be a way to activate the module beyond the checkbox on the module admin page (no user access settings possible, etc.). Also, there's no block to give users a form field or something like that to enable them entering a status - maybe I oversee something?

Activating the blocks to the right sidebar in garland, I get this

user warning: Invalid use of group function query: SELECT dodge, count(uid) as count FROM dodge WHERE age = 0 GROUP BY dodge ORDER BY count(uid), min(time) DESC LIMIT 0, 5 in /httpd/www.mysite.de/includes/database.mysql.inc on line 172.

and

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') OR (na.gid = 6 AND na.realm = 'og_subscriber'))) AND ( u.uid = 10 ) ORDER BY time DESC LIMIT 0, 5 in /httpd/www.mysite.de/includes/database.mysql.inc on line 172.
user warning: Unknown table 'n' in on clause query: SELECT dodge, count(uid) as count FROM dodge 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 = 6 AND na.realm = 'og_subscriber'))) AND ( age = 0 ) GROUP BY dodge ORDER BY count(uid), min(time) DESC LIMIT 0, 5 in /httpd/www.mysite.de/includes/database.mysql.inc on line 172.
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') OR (na.gid = 6 AND na.realm = 'og_subscriber'))) AND ( d.age = 0 ) ORDER BY time DESC LIMIT 0, 5 in /httpd/www.mysite.de/includes/database.mysql.inc on line 172.

Comments

mariano.barcia’s picture

Priority: Normal » Critical

This is a bug, brackets are missing in several FROM clauses. If you have a prefix for your database it won't work.
Please make the correction in the module code, like this

SELECT ...... FROM {dodge} ....

SELECT ...... FROM {dodge_options} ....

davyvdb’s picture

Fixed in CVS

davyvdb’s picture

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