PDA

View Full Version : Holecards error message



Ulyss
10-29-2009, 12:32 AM
I get an error when i try to view my holecards report in the Pluggin Leaks: Article 2. The error reads:

The following error occurred when running this report: ERROR:42803: column "ph.netamountwon" must appear in the GROUP BY clause or be used in an aggregate function.

The instructions I am attempting to follow are:

Pocket Pairs

Now load the "Pocket Pairs" filter and choose the "Holecards" report. Make sure bb/100 is one of the stats in the report so you can see your results and you need to also include VPIP, PFR and 3Bet%.

Every time I select the holecards report I get the error. Any fixes? suggestions?

fozzy71
10-29-2009, 01:03 AM
You can try to fix that specific index: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Or you can try to reindex the whole DB > start > programs > postgresql > pgadmin > connect > right-click > maintenance > reindex.


If that doesnt work, trya new DB.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, and export/import the hands from the old DB, and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21