PokerAce Hud Error! SQL Exception...

[psl86]

I recently suddenly got this error while using PA HUD on full tilt poker (and ONLY full tilt) with PT2:

PokerAce Hud Error!

SQL exception while trying to query player: Error executing "SELECT id_hand FROM holdem_hand_summary WHERE id_player=34289 ORDER BY id_player DESC LIMIT 5000": ERROR: column "id_player" does not exist; Error while executing the query


If i remove "only show stats from last XXXX hands" which I have set too 5000 this error goes away, but I get another similar one. Also the id_player=34289 changes each time i press "OK".. I have analyzed/compressed my PT2 database.. This error suddenly occured after I changed my hand filters for when PA updates the stats.. I changed 'em back but still nothing..

[APerfect10]

PokerTracker 3 does not support PokerAce Hud. It only works with PT2; PT3 has its own built-in HUD.

Best regards,

Derek

[psl86]

em...seriously...read the end of the first line once more :D

[psl86]

I fixed it..

[APerfect10]

I fixed it..

Was I right? ;) :mrgreen:

[psl86]

haha.. well, not excactly..
My question wasn't PT3 related, and your answer only stated the simply known fact that PAHUD doesnt work with PT3..However, the reason was the following:

In "preferences" in PAHUD under "databases" I had chosen my PT2 database "psl86". However, I also have a PT3 database called psl86, so it "auto-highlighted" that one too.. I had too delete the database from PT3 for this too work..

Basically, choosing one PT2 database with the same name as a PT3 database automatically also highlights the PT3 database..

[APerfect10]

Right. The error message you listed was due to it querying a PT3 database which is way I stated that PAH does not work with PT3...

I am glad that you were able to figure it out and get it resolved :)

Best regards,

Derek