Re: [Helpmeict-discuss] Database error on Summary Generation

[Andy D. <and...@pc...>]

Your error is probably because of the duplication of vw_issues.site and 
vw_issues.sitename in both the SELECT and GROUP BY parts of the sql.

These are set by $_REQUEST['x'] and $_REQUEST['y'], and as nothing is 
specified they are both defaulting to the same thing.

Try running a summary where the x and y axes are different.

Andy


R J Thompson wrote:
> Hello
>
> We are receiving the following error when running the summary (reports 
> section), this happens no matter what options are selected:
>
> Fatal Error: Database Query Failed.
>
> SELECT COUNT(*) AS result, vw_issues.site, vw_issues.site, 
> vw_issues.sitename, vw_issues.sitename FROM vw_issues,
>            tbl_usersites WHERE tbl_Issues.domain = 2 AND 
> vw_issues.id=tbl_Issues.id AND tbl_UserSites.userid=135 AND
>        tbl_Issues.site=tbl_UserSites.site GROUP BY vw_issues.site, 
> vw_issues.site, vw_issues.sitename, vw_issues.sitename
>
>
> This could be because there is no valid connection, or because the query 
> is incorrect.
>
> DB Error: unknown error
>
> Not sure of the error, has anyone any idea?
>
> Many thanks
>
> Richard
>
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Helpmeict-discuss mailing list
> Hel...@li...
> https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss
>