Add Alias Error

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Add Alias Error

Postby bertobato » Sun Feb 12, 2012 2:35 pm

I've been successful in adding aliases before. But since i primarily play euro games i decided to change *My Currency* to Euro. I removed all aliases to check on them individually but when I wanted to add aliases again i encountered this error:


Unable to execute query: INSERT INTO cash_cache VALUES(5091,1, 9, 2, 0, false, false, false, 201203, -1.00, 0.20, 0.20, -1.00, -0.20, -0.20, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, -0.20, -0.20, 2, 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, 2, 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, 2, 0, 0, 0, 0, 2, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 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, 2, 0, 2, 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, 'USD', 0.00, 0.00, 0.00, 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,... ^ )


I reverted to USD, restarted PT4 and reinstalled PT4. Nothing worked. What may have gone wrong?

Also, it takes soo long to convert between currencies. I was only working on 13k hands i think.
bertobato
 
Posts: 7
Joined: Tue Jun 22, 2010 3:25 pm

Re: Add Alias Error

Postby WhiteRider » Mon Feb 13, 2012 6:26 am

When did you add these aliases in the first place? There were issues with aliases in the first couple of betas so if they were added then you may have errors in your database, in which case you'd need to reimport. If the aliases were added in the last couple of betas that shouldn't apply, though.

Another possibility is that this is a database which wasn't properly updated - was this database created in v4.01.5 or earlier, and updated automatically when you ran v4.01.6 or later?
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Add Alias Error

Postby bertobato » Mon Feb 13, 2012 3:10 pm

it was created with 4.01.8.

Anyway, i made a new database and reimported the hands, and now i can add aliases again. i haven't tried converting my currency again though.
bertobato
 
Posts: 7
Joined: Tue Jun 22, 2010 3:25 pm

Re: Add Alias Error

Postby Dan_Jazz_Man » Sat Feb 25, 2012 12:20 am

I'm also getting this error when trying to create an alias in 4.01.8
Dan_Jazz_Man
 
Posts: 466
Joined: Sun Feb 03, 2008 5:58 pm

Re: Add Alias Error

Postby WhiteRider » Sat Feb 25, 2012 6:33 am

Is that in a new database created in 4.01.8?
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Add Alias Error

Postby Dan_Jazz_Man » Sat Feb 25, 2012 7:11 pm

WhiteRider wrote:Is that in a new database created in 4.01.8?

No, it's not a new database.
Dan_Jazz_Man
 
Posts: 466
Joined: Sun Feb 03, 2008 5:58 pm

Re: Add Alias Error

Postby WhiteRider » Sun Feb 26, 2012 6:16 am

Databases created in previous versions could have an error which prevents aliases being created. Can you add aliases in a new database?
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Add Alias Error

Postby Dan_Jazz_Man » Wed Mar 14, 2012 11:54 am

WhiteRider wrote:Databases created in previous versions could have an error which prevents aliases being created. Can you add aliases in a new database?

I can try on a new one but I won't be able to export and re-import the DB that I use since I will lose all my notes.
Dan_Jazz_Man
 
Posts: 466
Joined: Sun Feb 03, 2008 5:58 pm

Re: Add Alias Error

Postby kraada » Wed Mar 14, 2012 12:19 pm

Please do test at least so that we can make sure the problem is not related to your specific hands in some way.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Add Alias Error

Postby MaxWeiss » Sat Mar 17, 2012 2:10 am

kraada wrote:Please do test at least so that we can make sure the problem is not related to your specific hands in some way.


It's not! I jsut got this error myself when I just today got accepted for the beta, dl'd the latest version, imported some hands, and tried to alias my party and stars names.
MaxWeiss
 
Posts: 43
Joined: Sun Feb 10, 2008 10:40 pm

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 51 guests

cron
highfalutin