From: R J T. <jul...@bl...> - 2007-12-17 10:37:44
|
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 |