Add Alias Error

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Add Alias Error

Postby oracle3001 » Tue Apr 10, 2012 7:12 am

When I first set up PT4 many months ago, I added all my screen names I was playing on at that time with no problems. However, I have just tried to add another screen name to my "alias" list using v4.01.16, and I get the following error,

Unable to execute query: INSERT INTO cash_cache VALUES(29,1, 9, 9, 4, true, true, false, 201211, -13.00, 0.00, 0.00, -13.00, -1.30, -1.30, 0.00, 0.00, 0.00, 0.00, 0.02, 0.02, 0.18, 0.18, 0.06, 0.06, -1.30, -1.30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'USD', 0.00, 0.00, , , , 0.00);; Reason: Fatal Error (ERROR: syntax error at or near "," LINE 1: ..., 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 0, 0, 0,... ^ )
oracle3001
 
Posts: 851
Joined: Fri Jan 25, 2008 4:12 am

Re: Add Alias Error

Postby kraada » Tue Apr 10, 2012 11:19 am

This is a known issue - the only workaround we are currently aware of is creating a new database and reimporting your data into it. Once you've done that, you should be able to add aliases properly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Add Alias Error

Postby WhiteRider » Tue Apr 10, 2012 12:30 pm

This issue is fixed for the next release - once that is out and you've updated you'll be able to add your aliases in your existing database.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 35 guests