help with lost stats plzzzzz

[akcbr954]

short version: i saw i had 3 pt programs : 2.15, 2.16,2.17 so i uninstall 2.15. dummmmb. i log on 2 play and no pt icon, also gone from drop down. wtf??? install 2.17 again and no stats. im screwed right???

[ptrack pat]

Have you been backing up your database files? If not, go to the c:\program files\poker tracker v2 folder and see if you have 2 files there called ptrack_backup.mdb and hhcopy.mdb. Are they there?

[akcbr954]

yes i have both of those files. but they dont have .mdb(dont know if that matters)

[ptrack pat]

From the Windows Explorer menu select the Tools option and then select Folder Options.

Click on the View tab.

UNCHECK the box that says "Hide extensions for known files types" and click the Apply button.

Now, with PT CLOSED - rename the file ptrack.mdb to ptrack_X.mdb and hhdb.mdb to hhdb_X.mdb

Then rename ptrack_backup.mdb to ptrack.mdb and hhcopy.mdb to hhdb.mdb

Then start PT again. These files would have been made prior to the last time you compacted your databases so some data may still be missing depending on how long ago you did the compact.

[akcbr954]

tried that and then realized that EVREYTHING was reset. my posgreql isnt setup and im back 2 using the access db. since it took me 2 weeks to set this all up the first time ill just wait until pt3 come out and start over. i kinda dont feel like being on tilt for 2 weeks again. ne way when will pt3 the final product be ready? thx for ur help so far.

[akcbr954]

101-sqslate=08001 i keep getting this error when i try to do anything with the posgreql, any ideas?

[ptrack pat]

101-sqslate=08001 i keep getting this error when i try to do anything with the posgreql, any ideas?

You didn't say you were using PostgreSQL. In this case, you shouldn't have lost anything because uninstalling PT would not have touched PostgreSQL.

What is the EXACT error you are getting here? There must be more to the message than this.

[akcbr954]

sry forgot 2 metion that. the error message is:

uanable 2 connect 2 pstgresql(port#:5432) to get the list of db's.the error was:
101- sqlstate=08001
fatal: role "posgres" does not exist

this is most likely due to the fact the db server isnt running on this port.make sure the db is runningor, if the port is no longer being used open the utilities>postgresql setting window and remove the entry 4 port #5432 so u dont continue 2 get these error messages.

[ptrack pat]

Is the server running? Go to the Start menu and select Settings > Control Panel > Admin Tools Services.
Find PostgreSQL in the list. Does it say it's started? If not, try to start it.

[akcbr954]

it said it was started but i restarted anyway. and still same error message.