1600 columns / premium hud

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

1600 columns / premium hud

Postby bosow » Sun Nov 01, 2020 9:51 pm

Hello, I have a bunch of premium huds with a lot of stats.
Just reinstalled PT4 with PG 9.3 on my new computer and I have issues with the cache verification when creating a DB, as well when importing hands :
Error: partypoker: Unable to import hand (#20891359375). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: function update_tourney_custom_cache() does not exist LINE 1: SELECT update_tourney_cache();SELECT update_tourney_custom_c... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. )


So I think the issue is from the 1600 cached columns cap. How do I fix this ? (already tried unsuscribing one hud, but no answer yet from developer)
Thanks
bosow
 
Posts: 9
Joined: Fri Apr 19, 2013 11:18 pm

Re: 1600 columns / premium hud

Postby Flag_Hippo » Mon Nov 02, 2020 5:11 am

Possibly but if this is a new install then you may have custom statistics in your content which use additional tables that need to be added to the database outside of PokerTracker 4. You will need to contact your content provider(s) to find out what you need to do to your database for those stats to work. In the meantime you can also turn off your Premium HUD by disabling the "Configure -> Options -> Download Premium Content" option and then restarting PokerTracker 4. If you want to check how many custom columns you have click your Windows Start button then type the following:

pgadmin

and click 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 -> cash_custom_cache (and/or tourney custom cache for tournaments) and the number in brackets is the number of custom columns which should look like this.

If you need further assistance please open a Support Ticket with a PokerTracker4.log file that's recorded the trouble.
Flag_Hippo
Moderator
 
Posts: 17131
Joined: Tue Jan 31, 2012 7:50 am

Re: 1600 columns / premium hud

Postby bosow » Mon Nov 02, 2020 1:27 pm

I've tried disabling premium content, creating a new DB, reactivating premium content but rebuilding the cache doesn't work.
I didn't have to contact my hud provider in the past
Also my PT4 doesn't log any more in C:\Users\theme\AppData\Local\PokerTracker 4\Logs\Archive, only the notecaddy logs are up to date...
What should I do ?
bosow
 
Posts: 9
Joined: Fri Apr 19, 2013 11:18 pm

Re: 1600 columns / premium hud

Postby Flag_Hippo » Mon Nov 02, 2020 2:42 pm

bosow wrote:Also my PT4 doesn't log any more in C:\Users\theme\AppData\Local\PokerTracker 4\Logs\Archive, only the notecaddy logs are up to date...

Then you do not have logging enabled or if you have just enabled it without restarting PokerTracker 4 the log wouldn't have been archived yet and it would be here:

C:\Users\{Windows Login}\AppData\Local\PokerTracker 4\Logs\PokerTracker4.log

If logging isn't enabled click 'Configure -> Options' and if 'Logging Enabled' doesn't have a check mark, click it such that it does. Close/restart PokerTracker 4, reproduce the issue and send us your log file in a Support Ticket.
Flag_Hippo
Moderator
 
Posts: 17131
Joined: Tue Jan 31, 2012 7:50 am


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 1 guest