View Full Version : Report Error
jpalatt
08-28-2008, 02:29 PM
I keep receiving
"...ERROR: 42803: column "ph.netamountwon" must appear in GROUP BY clause or be used in an aggregate function" when I try to run my hole cards report.
Other reports still run fine. Advise?
morny
08-28-2008, 04:04 PM
Might be damaged try the attached file and put it in you reports folder and say yes when it asks do you want to replace it.
jpalatt
08-29-2008, 01:26 AM
Thanks, that worked, now the holecards report will run, but I get the same message with any of the "steal" filters, thanks again
Rvg72
08-29-2008, 01:57 AM
Thanks, that worked, now the holecards report will run, but I get the same message with any of the "steal" filters, thanks again
You need to keep the "$" amount as a stat in this report because that is the default sorting column. It's a bug but that is how you would avoid it
Roy
jpalatt
08-29-2008, 12:04 PM
easy fix, thanks
MindControl
12-29-2009, 05:43 AM
I tried to make my own report,but it gave the same error for the stat PH.FlopPlayerActionType_ID .Is there any way to make it work?
EDIT:fixed it somehow
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.