Unable to rebuild cache ERROR: invalid input syntax for inte

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny

Unable to rebuild cache ERROR: invalid input syntax for inte

Postby braveslice » Tue Feb 24, 2015 4:20 pm

"Unable to rebuild cache.

Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: invalid input syntax for integer: "" CONTEXT: PL/pgSQL function update_cash_custom_cache_playerrange(integer,integer) line 13 at FOR over SELECT rows )"

I have a new version of propokerhud, could it be the reason?

What next?
braveslice
 
Posts: 35
Joined: Tue May 22, 2012 5:54 pm

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby kraada » Tue Feb 24, 2015 4:29 pm

I'm not aware of any problems with their product though it is possible. Have you added any other new custom stats recently?
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby PropokerHUDs » Tue Feb 24, 2015 4:41 pm

Try creating a new empty DB, set it to active and do a rebuild custom cache on that. If that is successful, it means that your existing DB has become corrupted in some way.

Have you updated PT or PostgresSQL and cancelled it during an operation? What version of PT / PostgreSQL are you running etc.

If you drop us an email to our support email address, one of our team will be more than happy to help you out.
PropokerHUDs
ProPokerHuds Forum Moderator
 
Posts: 328
Joined: Fri Apr 19, 2013 11:28 am

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby braveslice » Tue Feb 24, 2015 5:27 pm

Ok testing.
braveslice
 
Posts: 35
Joined: Tue May 22, 2012 5:54 pm

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby PropokerHUDs » Tue Feb 24, 2015 7:12 pm

BTW, we do have our own official support thread on PokerTracker.com, down below the main set of categories.
PropokerHUDs
ProPokerHuds Forum Moderator
 
Posts: 328
Joined: Fri Apr 19, 2013 11:28 am

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby braveslice » Wed Feb 25, 2015 12:37 pm

Ok I had some custom stuff (old stuff, deleted those). No difference.

Created new database, set active, rebuild custom ok.

My database and PT are located at external hard disk, this creates some problems with notebook pc.

I go to prohud topic to ask uninstallation instruction, and maybe also contact pt4 support.
braveslice
 
Posts: 35
Joined: Tue May 22, 2012 5:54 pm

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby braveslice » Wed Feb 25, 2015 1:41 pm

After deleting prohud and all custom stats, I still fail to rebuild cache. Both rebuild cache and custom cache.

postgreSQL 9.4.0
braveslice
 
Posts: 35
Joined: Tue May 22, 2012 5:54 pm

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby kraada » Wed Feb 25, 2015 2:00 pm

Try backing up your database, uninstalling 9.4 and installing 9.3.5 and that might help. We haven't confirmed yet if there are any 9.4 problems so while we're not aware of any it's possible you're running into something new with 9.4 that we haven't accounted for.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby PropokerHUDs » Wed Feb 25, 2015 2:51 pm

Just a note, unless you have got our support team to remove your PT HUD or gone to configure -> Option -> [untick] Download Premium Content, the custom columns will still be continuously added to your system. Running an uninstall of the resource pack etc, wont remove that.
PropokerHUDs
ProPokerHuds Forum Moderator
 
Posts: 328
Joined: Fri Apr 19, 2013 11:28 am

Re: Unable to rebuild cache ERROR: invalid input syntax for

Postby braveslice » Wed Feb 25, 2015 5:10 pm

Thx!

"[untick] Download Premium Content" - worked and rebuild goes smoothly.

I will write to prohud support.
braveslice
 
Posts: 35
Joined: Tue May 22, 2012 5:54 pm


Return to PokerTracker 4

Who is online

Users browsing this forum: Google [Bot] and 9 guests

cron
highfalutin