PluginDBreport error
I'm trying to use the DBreport plugin and I keep getting an error that doesn't make sense. Here is the code:
{DBREPORT(db=>"tracks",debug=>true)} SQL { SELECT `projects`.`name`,`projects`.`description`,`projects`.`state`,`todos`.`description`,`todos`.`due`,`todos`.`state` FROM `projects`,`todos` WHERE `todos`.`project_id` = `projects`.`id` } GROUP [projects.name] "Project name:[name]" :H1 {DBREPORT}
The error is "The Field 'projects.name' was not returned by the SQL query." It has something to do with the GROUP line. When I delete it, it works, but without the grouping. I don't think it has to do with the quotes. Even if I use the single quotes
GROUP [`projects`.`name`] "Project name:[name]" :H1
it still gives the error.
I have also uncommented the adodb line in /db/local.php and that doesn't help. BTW, it that still necessary? The docs for PluginSQL say it was fixed in v5.0; does that fix also apply to PluginDBreport?
I'm using PluginDBreport because I need more formatting than PluginSQL gives. I haven't tried downloading the WikiPluginsDB stuff yet.