Upgraded PT3 to PT4, Multiple Basic Import Problems

[sdlsdlsd]

Yes. The 9.1.x line is known to have problems - we do not support it at this time because of these problems and strongly recommend not using it. The latest 8.3, 8.4 and 9.0 all work properly.

OK i installed psql 9.0.8 and successfully imported 889414 of 971231 hands (8% fail rate seems very high).

However, in the results and statistics it's still showing my old 9.1.4 database! I went and deleted it in DB management, closed PT4, and somehow it's *still* showing me the 9.1.4 database and stats! I set the new 9.0.8 db as default/active long ago, so what's going on here? Is it a port problem? I don't see anywhere to change the port PT4 loads psql with, aside when i created the new 9.0.8 DB, which worked properly.

[kraada]

If you send us some of the hands that fail we'll look into why they can't be imported. One of the affected files should be plenty - send it via our support system.

You can change the default port that PT4 uses by editing the PokerTracker.cfg file. To find that file click File -> Open User Data Folder in PT4 go into the Config folder and you can see PokerTracker.cfg there. The simplest thing to do is just to erase everything in the [Database] section then save the file and restart PT4. It'll start your database settings from scratch - you'll have to reconnect to your existing database but all you need to do there is click Browse when it goes to create a database, click on your database and click Connect.

[sdlsdlsd]

I did the above. When loading Results, i got an sql permissions error. I changed my psql folder settings to unset read-only for all files. That fixed the error. However, i am *still* getting the old 9.1.4 database. WTF is going on here? The correct 9.0.8 port (5431) and database name is shown in database management...

Oh god... I just went to try to re-add the old 9.1.4 db (in case something in the GUI is swapped) and it's not there (despite that its hands are being displayed). Please don't tell me that somehow PT4 deleted my new 1 million hand DB that took 12 hours to import? How could that happen? How can my 9.1.4 db somehow have magically transformed to 9.0.8? And my new 9.0.8 db now gone?

You can change the default port that PT4 uses by editing the PokerTracker.cfg file.

Sidenote, i was extremely surprised to see my db password in plain text in that file. This is a horrible idea from a security standpoint. Also note that the form that loads when you start the program should not display the password visibly as you type it, rather use ******** (stars) and have cut/copy/paste disabled. If you want users to know the default, you can display that on the side while still keeping the field secure.

[kraada]

The default PostgreSQL installation we use only installs PostgreSQL locally and, at the PostgreSQL level, does not allow connections from any other machine. As such, this password really doesn't matter much - if someone already has access to your machine and they want to look at your PokerTracker data there's going to be awfully little to stop them.

If your port is set properly for the database then you should be using 9.0 - you can check by logging in via PGAdminIII or psql command line and checking to see if the database is there. If the version you are looking at is in the Database Management window that string is set by the installation on the default port set in PT4 - it is not based on the version of PostgreSQL for the database you are currently connected to.

[sdlsdlsd]

The default PostgreSQL installation we use only installs PostgreSQL locally and, at the PostgreSQL level, does not allow connections from any other machine. As such, this password really doesn't matter much - if someone already has access to your machine and they want to look at your PokerTracker data there's going to be awfully little to stop them.

The reason it is never secure to display passwords in plain text, no matter how trivial of an app, is because unfortunately some users use the same password for everything, or at least for multiple programs. It's the same idea as the "peeking over the shoulder" issues of plain text passwords.

If your port is set properly for the database then you should be using 9.0 - you can check by logging in via PGAdminIII or psql command line and checking to see if the database is there. If the version you are looking at is in the Database Management window that string is set by the installation on the default port set in PT4 - it is not based on the version of PostgreSQL for the database you are currently connected to.

Despite being an ex-programmer, i'm unable to decipher that confusing last sentence. In any case, in pgAdminIII i correctly see:

9.1 - my old PT3 database
9.0 - my new PT4 database that theoretically contains the correctly imported 900k hands
9.0 - my new PT4 observed database

Hopefullly i'm doing this query right (on the 900k db):

SELECT
count(*)
FROM
public.cash_hand_histories;

returns 902651, which is roughly in line with my expectations of the correct data. However, PT4 is still displaying the 474k cash hands from the failed 9.1.4 import attempts, from a DB that was "deleted".

[kraada]

The reason it is never secure to display passwords in plain text, no matter how trivial of an app, is because unfortunately some users use the same password for everything, or at least for multiple programs. It's the same idea as the "peeking over the shoulder" issues of plain text passwords.

Don't use this password for anything else. If you install PostgreSQL with PokerTracker we'll use our default which is dbpass - if you install it yourself, I strongly recommend using something dedicated here which is not important to you.

Reusing passwords in multiple places is bad practice anyway - I use KeypassX - if you haven't looked into a solution like that (I hear LastPass is also good), I recommend it.

Despite being an ex-programmer, i'm unable to decipher that confusing last sentence. In any case, in pgAdminIII i correctly see:

9.1 - my old PT3 database
9.0 - my new PT4 database that theoretically contains the correctly imported 900k hands
9.0 - my new PT4 observed database

Hopefullly i'm doing this query right (on the 900k db):

SELECT
count(*)
FROM
public.cash_hand_histories;

returns 902651, which is roughly in line with my expectations of the correct data. However, PT4 is still displaying the 474k cash hands from the failed 9.1.4 import attempts, from a DB that was "deleted".

Let me try again:

In the Database Management window in PT4 (and PT3 both), we display the version for whatever PostgreSQL server is set as the default in PokerTracker. It does not mean that your actual database is from that version of PostgreSQL. You can see the port your database is on in the PT4 database management window - if it says it's on the right port, I assure you, it is on the right port.

Which database were you running that query against? If you go to the graphs page do you see the right number of hands along the x axis (I specifically ask there because the graph is not a cached query)? Are you certain you don't have any filters set?

[sdlsdlsd]

Don't use this password for anything else.

Telling the user this after he points out the insecurity is ironic. A user who cares about security (such as myself) already knows the above. A user who does not know about security, will never see the above and never have any idea that one of his passwords is insecurely stored in plain text on his computer. My point is that you can help protect inadequate users from themselves, instead of make it easier to compromise them. Isn't that what every program does? Storing plain text passwords = bad. I thought that was inarguable heh.

If you go to the graphs page do you see the right number of hands along the x axis (I specifically ask there because the graph is not a cached query)?

I eventually had a light bulb moment. It's not showing all my hands because PT doesn't recognize aliases, but somehow recognized my PS alias. The hand count and $ was identical because all PS hands were identically imported in both the 9.1.4 and 9.0.8 dbs. The difference of hundreds of thousands of errors in 9.1.4 vs tens of thousands in 9.0.8 came exclusively from non-PS sites! Heezus Chraist.

[sdlsdlsd]

I found 2 show-stopping bugs during the Get Hands From Disk, where PT4 quietly sits there in an infinite loop (because of these you can't leave the bootstrap import on overnight, you have to sit there and babysit it). Since there's no "move to processed" for "Get Hands From Disk", every time you're forced to start over it slowly scans through an ungodly number of duplicate hands. Move to processed should be a setting possible (default even) for Get Hands From Disk.

1) A partypoker hand, i had to manually remove the "has left from table" line below to stop PT4 from choking:

***** Hand History for Game 1308071713 *****
Kid_Omaha has left the table.
1/2 TexasHTGameTable (Limit) - Thu Dec 16 10:18:16 EST 2004

2012/08/05 16:03:00.130 [00009]: [- Main -][ImportStatus (Error)] PartyGaming: Encountered unexpected end of hand history. (Hand #1308071713) (Line #17332)
2012/08/05 16:03:00.139 [00009]: [- Main -][ImportStatus (Error)] PartyGaming: Invalid date specified in hand history (Hand #1308071713) (Line #17332)
2012/08/05 16:03:00.148 [00009]: [- Main -][ImportStatus (Error)] PartyGaming: Unexpected beginning of hand history. (Hand #1308071713) (Line #17333)

[repeats that last error about 50 times then stops doing anything]


2) It also chokes on old PP omaha lines:

Error: PartyGaming: Invalid line encountered: 5/10 OmahaHiLoGameTable (Limit) - Wed Oct 06 17:13:31 EDT 2004 Table Superman (Real Money) -- Seat 4 is the button (Line #1945)
Error: PartyGaming: Unexpected beginning of hand history. (Line #1946)

[repeats that last error many times then stops doing anything]


The fact you don't have a pause button on what is version FOUR of this amazing software is frankly mind-boggling! On a relatively powerful machine 1M hands took over 12 hours - i'd like to be able to pause it sometimes without having to start over and rescan all the duplicates for 2 hours.

[sdlsdlsd]

On to the next problem. It's refusing to import my PT3 huds. "unable to import profile. reason: no stats found in import file"

[sdlsdlsd]

Also, shouldn't it be showing some sort of default/simple hud on a fresh install so you can see if it's working? When i'm observing and importing hands on Party, no hud or icon is visible, despite the hud being active (i can tell it is from the menus, since it allows me to stop/restart it).