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
Comment #1
mariano.barcia commentedThis 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} ....
Comment #2
davyvdb commentedFixed in CVS
Comment #3
davyvdb commented