Page 1 of 1

Allowed Stakes Exceeded

PostPosted: Tue Feb 02, 2021 10:49 pm
by Choven1218
I've searched the forum and googled the message. I have the small stakes version of PT4. The problem is that I haven't played higher than the limits allowed. However, I suspect that I mistyped the buyin for a SNG. Instead of typing 3 for buyin amount, I might have typed 33 or something like that. Is there a way to find the tourney and fix it? I looked in the Purge Hands utility, but the maximum stake that are being shown is 50NL (never played higher) and an $8 SNG (never played higher). Maybe I need to connect to my Postgresql DB and do it manually? Thanks...

Re: Allowed Stakes Exceeded

PostPosted: Wed Feb 03, 2021 6:58 am
by Flag_Hippo
If you've not used PGAdmin before you might want to backup your poker data before making any changes there as making database changes outside of PokerTracker 4 isn't supported. Close PokerTracker 4 and then you can access PGAdmin by clicking your Windows Start button then typing:

pgadmin

and then clicking on it when it appears. Double click on 'PostgreSQL x.y' (where x.y is your PostgreSQL version) and if your prompted for a password the default is 'dbpass' (without the quotes). Next double click on 'Databases -> YOUR_DATABASE_NAME -> Schemas -> Public -> Tables'. Right-click on the 'tourney_summary' table, choose 'View Data -> View All Rows', find the relevant tournament, edit the value in the 'amt_buyin' column and save the change (File -> Save'). If you have trouble finding the tournament you can sort by the 'amt_buyin' column using 'Tools -> Sort/Filter'.

Re: Allowed Stakes Exceeded

PostPosted: Thu Feb 04, 2021 1:32 am
by Choven1218
That did it. It wasn't a $3.30 tourney that I mistyped. It was my last $5.50 that I mistyped as a 50 buyin with 0.50 fee. I don't have many tourneys in my database, so it was easy to find. Thanks for helping me...

Re: Allowed Stakes Exceeded

PostPosted: Thu Feb 04, 2021 7:08 am
by Flag_Hippo
Pleased to hear you sorted it.