Menu
▾
▴
helpmeict-discuss
|
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
|
|
From: Chris P. <cpu...@gm...> - 2007-12-17 10:47:22
|
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 |
|
From: Andy D. <and...@pc...> - 2007-12-17 13:32:11
|
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 > |
|
From: R J T. <jul...@bl...> - 2008-01-07 11:15:35
|
Thanks for the replies, it is v0.9.9 and I will try that suggestion ! Regards Richard Andy Deakin wrote: > 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 >> > > > ------------------------------------------------------------------------- > 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 |
|
From: R J T. <jul...@bl...> - 2008-01-08 11:19:18
|
Hi Chris/Dan Have tried the suggestion, I still receive the same error, as a side point, the summary appeared to work fine previously (I think before I upgraded to 0.9.9). Regards Richard R J Thompson wrote: > Thanks for the replies, it is v0.9.9 and I will try that suggestion ! > > Regards > > Richard > > Andy Deakin wrote: >> 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 >>> >> >> ------------------------------------------------------------------------- >> 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 > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Helpmeict-discuss mailing list > Hel...@li... > https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss |
|
From: R J T. <jul...@bl...> - 2008-01-08 11:24:11
|
Hi Chris/Andy Have tried the suggestion, I still receive the same error, as a side point, the summary appeared to work fine previously (I think before I upgraded to 0.9.9). Regards Richard R J Thompson wrote: > Hi Chris/Dan > > Have tried the suggestion, I still receive the same error, as a side > point, the summary appeared to work fine previously (I think before I > upgraded to 0.9.9). > > Regards > > Richard > > R J Thompson wrote: >> Thanks for the replies, it is v0.9.9 and I will try that suggestion ! >> >> Regards >> >> Richard >> >> Andy Deakin wrote: >>> 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 >>>> >>> ------------------------------------------------------------------------- >>> 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 >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2005. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> Helpmeict-discuss mailing list >> Hel...@li... >> https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss > > > ------------------------------------------------------------------------- > 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X