Error: Unable to execute query, invalid input syntax

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Error: Unable to execute query, invalid input syntax

Postby asseral » Thu Dec 10, 2020 8:11 pm

Hi guys,

I installed PT4 on a new machine and get the following error when importing GG (Natural8) poker hands:


Code: Select all
Error: GG Poker:       Unable to import hand. Reason: Error: Unable to execute query: Fatal Error; Reason: Error:  (ERROR:  invalid input syntax for integer: "" CONTEXT:  PL/pgSQL function update_cash_custom_cache() line 9 at FOR over SELECT rows )


I am running windows 10, PT4 4.15.27 (latest one as of writing this) and postgresql 9.6.
I also tried it with postgresql 9.3 without success.

Can anyone point me in the right direction as to what is going on please?


Thanks and regards
Julius
asseral
 
Posts: 22
Joined: Sat May 12, 2012 2:04 pm

Re: Error: Unable to execute query, invalid input syntax

Postby Flag_Hippo » Fri Dec 11, 2020 7:15 am

That looks like an issue with a custom statistic(s). If you are using third party content such as ProPokerHUDs make sure you have setup your database correctly otherwise contact the support of your premium provider and they should be able to provide you with instructions on what you need to do. You can also turn off that content if you are not currently using it by disabling the 'Configure -> Options -> Download Premium Content' option and then restarting PokerTracker 4. If you are not using premium content or have set that up correctly then please send us a log file that has recorded the problem to us in a Support Ticket:

Guide: How to Create & Submit a PokerTracker4.log File
Flag_Hippo
Moderator
 
Posts: 17132
Joined: Tue Jan 31, 2012 7:50 am


Return to PokerTracker 4

Who is online

Users browsing this forum: Imperiium and 1 guest