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

[Chris P. <cpu...@gm...>]

Hi

Can you let us know which version you are running?

Cheers

Chris P

On 17/12/2007, R J Thompson <jul...@bl...> 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
>


-- 
My employers website: http://thehumanjourney.net - opinions in this
email are however very much my own and may not reflect that of my
current employer, past employers, associates, friends, family, pets etc..

Documents attached to this email may be in ISO 26300 format:
http://iso26300.info